Optimize Table without downtime
I have a question for the group. I can't quite figure out why MySQL needs to lock the entire table for OPTIMIZE TABLE requests. I understand why it would be the fastest way to do this, but it seems to me that it is better to not lock the table and take longer. Is there any reason that more than row locks is needed? Can anyone clue me in?
Subject
Written By
Posted
Optimize Table without downtime
October 06, 2010 11:41AM
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.