Skip to content

samlambert/pt-online-schema-change-analyze

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 

Repository files navigation

pt-online-schema-change-analyze

Analyze a MySQL table before swapping it in place at the end of a migration.

In certain cases it is recommended not to allow MySQL to recalculate table statistics automatically as it can cause a drift in query plans. More info here and here.

This can cause a problems when using pt-online-schema-change as the statistics might not be correct on the new table. This plugin analyzes the table right before the swap is done which allows MySQL to recalculate the statistics and avoids slow queries.

To use the plugin just add:

--plugin /path/to/plugin/pt-online-schema-change-analyze.pl

to your pt-online-schema-change command.

About

Analyze a MySQL table before swapping it in place.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages