MySQL Forums
Forum List  »  InnoDB

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

Hi,

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' ?

Thanks
Justin

Options: ReplyQuote


Subject
Views
Written By
Posted
does innodb table need 'optimize table'?
2927
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.