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.