摘要：
原文链接：http://www.mysqlperformanceblog.com/2010/12/09/thinking-about-running-optimize-on-your-innodb-table-stop/Innodb/XtraDB tables do benefit from being reorganized often. You can get data physically laid out in primary key order as well as get better feel for primary key and index pages and so usin 阅读全文
摘要：
原文链接：http://www.mysqlperformanceblog.com/2011/11/29/innodb-vs-mysql-index-counts/I had a customer recently who a few strange errors in their mysqld.err log:最近在一个客户的错误日志里面发现一些奇怪的错误[ERROR] Table database_name/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 阅读全文