MySQL Forums
Forum List  »  InnoDB

does innodb table need 'optimize table'?
Posted by: justin ux
Date: July 18, 2011 10:44PM


I'm using mysql 5.0.90 innodb tables and I started the Mysql Innodb with 'innodb_file_per_table' option. applications frequently update ,insert ,delete the tables.
Do I need to do the 'optimize table' periodically to reduce the fragments in table files?
And will innodb engine remove the fragments automatically?

And When I use 'optimize table' ,it locks the table over 10 minutes, this is cause the application timeout error. is there a better way to reduce the fragment by 'optimize table' ?


Options: ReplyQuote

Written By
does innodb table need 'optimize table'?
July 18, 2011 10:44PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.