Spec-Zone .ru
спецификации, руководства, описания, API

5.5. Online DDL for InnoDB Tables

5.5.1. Overview of Online DDL
5.5.2. Performance and Concurrency Considerations for Online DDL
5.5.3. SQL Syntax for Online DDL
5.5.4. Combining or Separating DDL Statements
5.5.5. Examples of Online DDL
5.5.6. Implementation Details of Online DDL
5.5.7. How Crash Recovery Works with Online DDL
5.5.8. DDL for Partitioned Tables
5.5.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".