Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.9Mb
PDF (A4) - 38.0Mb
PDF (RPM) - 36.6Mb
HTML Download (TGZ) - 9.9Mb
HTML Download (Zip) - 9.9Mb
HTML Download (RPM) - 8.7Mb
Man Pages (TGZ) - 207.1Kb
Man Pages (Zip) - 315.5Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  The InnoDB Storage Engine  /  InnoDB and Online DDL

14.13 InnoDB and Online DDL

The InnoDB online DDL feature permits in-place table alterations or concurrent DML, or both. Benefits of this feature include:

  • Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or hours is not practical.

  • The ability to adjust the balance between performance and concurrency during a DDL operations using the LOCK clause.

    • LOCK=EXCLUSIVE blocks access to the table entirely.

    • LOCK=SHARED allows queries but not DML.

    • LOCK=NONE allows full query and DML access to the table.

    • LOCK=DEFAULT or omitting the LOCK clause permits as much concurrency as possible depending on the type of DDL operation.

  • Avoidance of disk space usage and I/O overhead associated with copying the table and reconstructing secondary indexes.

User Comments
Sign Up Login You must be logged in to post a comment.