MySQL InnoDB’s Instant Schema Changes: What DBAs Should Know
![](https://i0.wp.com/lefred.be/wp-content/uploads/2024/03/mysql_instant_ddl.png?fit=768%2C432&ssl=1)
In MySQL 8.0.12, we introduced a new algorithm for DDLs that won’t block the table when changing its definition. The first instant operation was adding a column at the end of a table, this was a contribution from Tencent Games.…