14.2.11 InnoDB and Online DDL

14.2.11.1 Overview of Online DDL
14.2.11.2 Performance and Concurrency Considerations for Online DDL
14.2.11.3 SQL Syntax for Online DDL
14.2.11.4 Combining or Separating DDL Statements
14.2.11.5 Examples of Online DDL
14.2.11.6 Implementation Details of Online DDL
14.2.11.7 How Crash Recovery Works with Online DDL
14.2.11.8 Online DDL for Partitioned InnoDB Tables
14.2.11.9 Limitations of Online DDL

You can perform several kinds of online DDL operations on InnoDB tables: that is, allowing DML operations and queries on the table while the DDL is in progress, performing the operation in-place without rebuilding the entire table, or both. This enhancement has the following benefits:

MySQL Cluster's NDB storage engine also supports online table schema changes, but uses its own syntax that is not compatible with that used for InnoDB online operations. For more information, see Section 13.1.7.2, “ALTER TABLE Online Operations in MySQL Cluster”.