We had a wonderful time during the Sept. 25 webinar, “MySQL 5.6 Configuration Optimization,” and I got a lot more questions than I could answer during the hour. So here is a followup with answers to the most interesting questions you guys asked. (You can also watch a recording of entire webinar here.)
Q: What is the impact of having innodb_stats_on_metadata=off in terms of seeing actual table size in information schema ?
A: In MySQL 5.6 this option if off by default. If you disable it in earlier version you will still see the actual table and index sizes as …[Read more]