Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 34.6Mb
PDF (A4) - 34.6Mb
PDF (RPM) - 32.3Mb
HTML Download (TGZ) - 8.2Mb
HTML Download (Zip) - 8.2Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 147.5Kb
Man Pages (Zip) - 208.8Kb
Info (Gzip) - 3.1Mb
Info (Zip) - 3.2Mb

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

Pre-General Availability Draft: 2017-12-15

15.12 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.