14.2.11 InnoDB and Online DDL Overview of Online DDL Performance and Concurrency Considerations for Online DDL SQL Syntax for Online DDL Combining or Separating DDL Statements Examples of Online DDL Implementation Details of Online DDL How Crash Recovery Works with Online DDL Online DDL for Partitioned InnoDB Tables 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, “ALTER TABLE Online Operations in MySQL Cluster”.