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.
Subject
Views
Written By
Posted
2497
April 21, 2006 04:02AM
Re: Using "optimize table"
1727
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.