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

optimizing innodb?

Discussion in 'Server Configuration and Hosting' started by gavpeds, Jun 11, 2014.

  1. gavpeds

    gavpeds Active Member

    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.
  2. Adam Howard

    Adam Howard Well-Known Member

    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.
  3. Adam Howard

    Adam Howard Well-Known Member

    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.

Share This Page