Not the answer you need?
Register and ask your own question!

pt-online-schema-change add ANALYZE TABLE

benjaminlin1019benjaminlin1019 EntrantCurrent User Role Beginner
I found that after table swapping, new table key distribution remain NULL. It would be nice to add an 'ANALYZE' before table swapping on new table for next version. :)

Thanks!!!

Comments

  • revinrevin Contributor Current User Role Beginner
    Did you somehow have innodb_stats_on_metadata=OFF during the ALTER?
  • benjaminlin1019benjaminlin1019 Entrant Current User Role Beginner
    I am using MyISAM. :cool: But now I am kind of hesitating to add that into a 'must-do' process, instead maybe to add that as an option. ANALYZE table on the newly created table will lock the table, so during analyzing table, any activities from trigger which set on the original table will be blocked and need to wait until the table lock release. It may be a problem of replication delay and also an interruption of the original table activities.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.