Thinking about running OPTIMIZE on your Innodb Table ? Stop!


Thinking about running OPTIMIZE on your Innodb Table ? Stop! | MySQL Performance Blog

Innodb/XtraDB tables do benefit from being reorganized often. You can get data physically laid out in primary key order as well as get better feel for primary key and index pages and so using less space,
it is just OPTIMIZE TABLE might not be best way to do it.

Related Posts