optimizing innodb?

[gavpeds]

Hi all so i have recently noticed after updating mysql that my databases now us innodb it seems that i can not longer repair or optimize these table. Is there another way to do this or why does innodb not allow it? I am new to innodb so any help would be great.

 

[Adam Howard]

innodb does not support the optimizing table function, because it's argue that its not needed.

Although it is suggest that you can run recreate + analyze in it's place.

 

[Adam Howard]

innodb does not support the optimizing table function, because it's argue that its not needed.

Although it is suggest that you can run recreate + analyze in it's place.

BACKUP !!

You can optimize the InnoDB tables by using this.

ALTER TABLE table.name ENGINE='InnoDB';

This will create a copy of the original table, and drop the original table, and replace to the original place.
Although this is safe, I suggest you do backup and test first before doing this.