mysql 5.6 ddl 锁表_MySQL数据库之MySQL5.6 Online DDL 是否锁表、rebuild表、inplace的说明...

本文主要向大家介绍了MySQL数据库之MySQL5.6 Online DDL 是否锁表、rebuild表、inplace的说明 ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。

Operation

In-Place?

Rebuilds Table?

Permits Concurrent DML?

Only Modifies Metadata?

Notes

CREATE INDEX, ADD INDEX    Yes*    No*    Yes    No    Restrictions apply for FULLTEXT indexes; see next row.

ADD FULLTEXT INDEX    Yes*    No*    No    No    Adding the first FULLTEXT index rebuilds the table if there is no user-defined FTS_DOC_ID column. Subsequent FULLTEXT indexes may be added on the same table without rebuilding the table.

DROP INDEX    Yes    No    Yes    Yes    Only modifies table metadata.

OPTIMIZE TABLE    Yes*    Yes    Yes    No    Performed in-place as of MySQL 5.6.17. In-place operation is not supported for tables withFULLTEXT indexes.

Set column default value    Yes    No    Yes    Yes    Only modifies table metadata.

<