pt-online-schema-change add ANALYZE TABLE

  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-online-schema-change add ANALYZE TABLE

    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.


  • #2
    Did you somehow have innodb_stats_on_metadata=OFF during the ALTER?
    Our documentation has a lot of answers about common questions on Percona software, have you checked there before posting that question here? http://www.percona.com/forums/core/i...lies/smile.png

    Join us at the annual Percona Live MySQL Users Conference - http://www.percona.com/live/mysql-conference-2014/


    • #3
      I am using MyISAM. 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.