MySQL Forums
Forum List  »  InnoDB

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.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Could you explain about ALGORITHM=INPLACE?
662
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.