DZone Database Zone
ANALYZE TABLE Is No Longer a Blocking Operation
In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503) created by Laurynas Biveinis. The fix, included with Percona Server for MySQL since versions 5.6.38-83.0 and 5.7.20-18, stops ANALYZE TABLE from invalidating query and table definition cache content for supported storage engines (InnoDB, TokuDB, and MyRocks).
Why Is This Important?In short, it is now safe to run ANALYZE TABLE in production environments because it won't trigger a situation where all queries on the same table stack are in the state "Waiting for table flush." Check this post for details on how this situation can happen.
No comments:
Post a Comment