GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Optimize table

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Optimize table

    Hi, I would like to run optimize table on some table with around 60M rows. How would this work with the Percona cluster? So far just altering the tables has worked fine, but is there anything I need to know about how optimize table would work?

    Thanks!
    Vito

  • #2
    For InnoDB tables optimize is de facto null ALTER, which does copy entire table into a fresh table space (if innodb_file_per_table enabled) and then drops the old one. So it will need at most as much free disk space as original table now takes.
    For XtraDB cluster there are three different ways you can do such alter, those described here: http://www.codership.com/wiki/doku.p...schema_upgrade
    and also you can use pt-online-schema-change.

    Comment

    Working...
    X