摘要：原文链接：http://www.mysqlperformanceblog.com/2007/12/09/be-careful-rotating-mysql-logs/If you enable logging of all queries as “slow queries” using thepatchor MySQL 5.1 you can get log file to grow huge. Same may happen with general log file. In some cases we’ve got log file sizes of 100G or more which 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/01/25/how-to-recover-a-single-innodb-table-from-a-full-backup/Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tabl 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/03/27/innodbs-gap-locks/One of the most important features of InnoDB is the row level locking. This feature provides better concurrency under heavy write load but needs additional precautions to avoid phantom reads and to get a consistent Statement based 阅读全文

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/09/11/how-to-find-mysql-queries-worth-optimizing/One question I often get is how one can find out queries which should be optimized. By looking at pt-query-digest report it is easy to find slow queries or queries which cause the large portion of the load 阅读全文