2013 年 2月 26 日随笔档案 - zuoxingyu

2013年2月26日

摘要：原文链接：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 阅读全文

posted @ 2013-02-26 17:40 zuoxingyu 阅读(1010) 评论(0) 推荐(0)

Innodb vs MySQL index counts

摘要：原文链接：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 阅读全文

posted @ 2013-02-26 15:04 zuoxingyu 阅读(649) 评论(0) 推荐(0)

天堂