Re: Could you explain about ALGORITHM=INPLACE?
Posted by:
Rick James
Date: March 25, 2016 06:49PM
It's all in
http://dev.mysql.com/doc/refman/5.7/en/alter-table.html and related pages.
Roughly, speaking,...
COPY creates an empty new table with the changes, then copies all the data into it, rebuilds the indexes, drops the old table, and renames the new table to the old.
INPLACE avoids the copy, drop, and rename. Instead it modifies the existing table. But it does it in such a way that it does not interfere with other operations.
INPLACE is almost always better. However, there are cases where INPLACE is 'impossible', so COPY must be used.
Before 5.6(?), the only option was COPY. (And the ALGORITHM syntax did not exist.)
Subject
Views
Written By
Posted
1920
March 24, 2016 12:29AM
Re: Could you explain about ALGORITHM=INPLACE?
1167
March 25, 2016 06:49PM
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.