MySQL Forums :: InnoDB :: does innodb table need 'optimize table'?


Advanced Search

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'? 2877 justin ux 07/18/2011 10:44PM
Re: does innodb table need 'optimize table'? 2053 Rick James 07/20/2011 09:25AM


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.