2014年2月20日

innodb_stats_on_metadata and slow queries on INFORMATION_SCHEMA

摘要： INFORMATION_SCHEMA is usually the place to go when you want to get facts about a system (how many tables do we have? what are the 10 largest tables? What is data size and index size for table t?, etc). However it is also quite common that such queries are very slow and create lots of I/O load. Here 阅读全文

posted @ 2014-02-20 00:19 Still water run deep 阅读(671) 评论(0) 推荐(0)

导航