• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

optimizing innodb?

gavpeds

Active member
#1
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

Well-known member
#2
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

Well-known member
#3
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.