Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 1 to 1 of 1 « Previous | Next »
Displaying posts with tag: ANALYZE TABLE (reset)
Mar
27
2018
ANALYZE TABLE Is No Longer a Blocking Operation
Posted by Sveta Smirnova of MySQL Performance Blog on Tue 27 Mar 2018 19:35 UTC
Tags:

In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents 

ANALYZE TABLE

 from blocking all subsequent queries on the same table.

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 …
[Read more]