InnoDB tables support online DDL, which permits concurrent DML and uses optimizations to avoid unnecessary table copying.
| Title | Description |
|---|---|
| InnoDB Online DDL Overview | All about online DDL operations with InnoDB. |
| InnoDB Online DDL Operations with the INPLACE Alter Algorithm | These DDL operations can be done in-place with InnoDB. |
| InnoDB Online DDL Operations with the NOCOPY Alter Algorithm | These DDL operations can be done without copying the table with InnoDB. |
| InnoDB Online DDL Operations with the INSTANT Alter Algorithm | These DDL operations can be done instantly with InnoDB. |
| Instant ADD COLUMN for InnoDB | Instantly add a new column to a table |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/innodb-online-ddl/