PDA

View Full Version : [ubuntu] How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed



THPubs
August 27th, 2012, 02:50 PM
I just switched my Wordpress databases to InnoDB. When using MyISAM, I used to run Optimize and Repair table. But it InnoDB, it won't work.

I manually ran OPTIMIZE TABLE and the suggested ALTER TABLE but non of them removed the overhead. I ran mysqltuner on my server and it showed that there are 14 fragmented tables (I have a total of 14 tables). Even after running optimize and alter tables, still all the 14 tables are fragmented! How can I properly OPTIMIZE and REPAIR InnoDB tables?