Nov 5, 2017

NEW ALTER TABLE OPTIONS for MySQL 5.6+

ALGORITHM [=] {DEFAULT|INPLACE|COPY}
LOCK [=] {DEFAULT|NONE|SHARED|EXCLUSIVE}
In case you are not sure if an ALTER TABLE will copy and/or block the table, and you want to make sure your DDL statement won’t cause such problems, you can add new alter specifications to the statement: ALGORITHM and LOCK.

ALTER TABLE i88ca ENGINE=InnoDB, LOCK=NONE;
Post a Comment

Featured Post

Datasets

Google Tables helps you search thousands of public Fusion Tables, or millions of public tables from around the web you can import to Fusio...