MySQL InnoDB的即时架构变更:DBA需要了解的内容
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...
MySQL 8.0.12引入了DDL的新算法,不会在更改表定义时阻塞表。默认算法是INSTANT,但有64次更改限制。建议始终指定算法,并监控表的即时更改次数。达到限制后需要重建表。
