MySQL / MariaDB DBA

Online Schema Changes & Partitioning

Question

Instant versus in-place online DDL: how do they differ, and when should each be used?

Answer

Instant changes metadata without rebuilding table data. In-place avoids a table copy but may rebuild internal structures. Prefer instant where supported; otherwise require a permitted in-place plan for write-sensitive tables. Applies to MySQL and MariaDB.

This is 15 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples