Leave a Reply

2 Comments on "MySQL: How Query Optimizer Read and Update the Index Statistics"

Notify of
avatar
Sort by:   newest | oldest | most voted
Øystein Grøvlen
Guest

Note that persistent statistics was added to InnoDB in MySQL 5.6. innodb_stats_on_metadata does not have any effect on persistent statistics. The documentation has now been updated to reflect that.

wpDiscuz