Updating stats

from the Artful MySQL Tips List


Since MySQL 5.6 InnoDB has supported persistent index statistics but MySQL may under some circumstances never get around to update the index statistics. -- https://mysql.wisborg.dk/2021/08/22/automatic-update-of-innodb-persistent-statistics-never-triggers/

There are no guarantees as to when the query optimiser will see statistics refreshed by InnoDB, so you need to regularly run ANALYZE TABLE. --http://oysteing.blogspot.com/2021/09/run-analyze-table-do-not-rely-on.html

Last updated 8 Sep 2021


Return to the Artful MySQL Tips page