… discovered etc. You should not think … non-checked tables fail with table does …you enable this option – globally, for table or for set of statements (by using LOCK TABLES/UNLOCK TABLES) be careful…of crash your index and data will likely be very much out of sync and if you do not repair the table you…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…index_creation feature, as I just wrote this option can help creating tables a lot faster. You…you go over normal upgrade checks you should be fine. Q: What are the…check out our Documentation to get most our of your Percona Server install. Thank you for your questions and for attending. See you…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
…your backup of choice on a node and optionally keep the node out of production rotation while doing so. Whatever method you use should not take the…carefully. There was a question about availability of Nagios or other monitoring plugins, and I misspoke: The Percona Monitoring Plugins have a check…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…the index can be used to satisfy order by, index however will not be helpful to check c=5 (unless it is index covered query). Index…index usage for order by. Sort by column in leading table if you have JOIN with ORDER BY … LIMIT you should…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…of other nasty problems especially for database server. Second. The question comes to what you care the most – Do you care about consistency or availability ? Are you…check functions for your data partition and just check it manually as needed, same as you would every so often check MySQL tables…
Post: Is it query which needs to be optimized ?
March 6, 2007 By 9 Comments
…care. In some cases you can avoid COUNT completely by storing count values in the tables, in others you can but you at least should…of troubles. So designing schema make sure for queries you‘re going to run ORDER BY .. LIMIT can be performed using the index…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…table `test`.`autoinc` trx id 83B lock mode IX RECORD LOCKS space id 0 page no 823 n bits 72 index `PRIMARY` of table…your system is purely application-dependent, but if you‘re not sure, I’d say you should…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…the start but rather take the difference in these counters every 5 minutes or other interval of your…should give you these numbers. The less intrusive process which can be done in production (especially if you…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…table contained some 25 millions of rows and no indexes there defined – Sphinx does not support explicit indexes and it is clear when you…check is the “early block reject” which should allow to quickly throw away large blocks of…you should be able to scan through 100M+ rows on the…
Post: Living with backups
November 6, 2008 By 28 Comments
…indexes, while the actual data is always read from disk. The active portions of tables will likely be placed by the…you can change in at runtime anyway. To check what is the current setting you need to query your block devices. In case of the…
