Re: fragmentation in innodb index
This is what MySQL does behind the scenes if you run ‘optimize table’ on an InnoDB table. It will result in a read lock, but not a full table lock. How long it takes is completely dependent on the amount of data in the table . If you have a table with a high volume of deletes or updates, you may want to run this monthly, or even weekly.
Subject
Written By
Posted
Re: fragmentation in innodb index
September 17, 2014 04:06AM
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.