MySQL Forums
Forum List  »  Optimizer & Parser

Re: Using "optimize table"
Posted by: Apachez
Date: April 21, 2006 04:26AM

The problem is that OPTIMIZE TABLE locks the whole table (for MyISAM, for InnoDB it is instead mapped to ANALYZE TABLE which will just sort the index) so the other queries will be queued until OPTIMIZE TABLE is complete.

If your optimize table takes like a second or two then it shouldnt be any problem (of course depending on how many queries/sec you have against this table). But if it will take like a minute or so then queries will/might be lost because the backlog will fill up with pending queries.

Options: ReplyQuote

Written By
April 21, 2006 04:02AM
Re: Using "optimize table"
April 21, 2006 04:26AM

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.