Optimize table

[Vito_Botta]

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

[przemek]

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.php?id=rolling_schema_upgrade
and also you can use pt-online-schema-change.