[RSS Feed/News] Schema changes for large tables should support MySQL/MariaDB "instant add" columns

[XenForo]

Modern versions of MySQL and MariaDB support "instant add" columns, but this have restrictions.

Generally only if the columns are appended to the table, and limitations on if it is nullable or not.

One limitation is you need to add indexes separately from the columns which can be "instantly added".

Ref;

MySQL :: MySQL 8.0 Reference Manual :: 13.1.9 ALTER TABLE Statement ​

dev.mysql.com

MySQL :: MySQL 8.0 Reference Manual :: 15.12.1 Online DDL Operations ​

dev.mysql.com
...

Read more

ادامه مطلب...