MariaDB Enterprise Server InnoDB Schema Changes with the INPLACE Algorithm
Changes in enterprise databases and applications are inevitable. Schema changes often block other workloads, incur unique production situations that cannot be fully simulated for testing, and may have unpredictable execution times.
MariaDB Enterprise Server includes the In-place ALTER functionality for the InnoDB storage engine, such that:
When possible, schema change operations are performed
INPLACE, minimizing impact on other workloads.
alter_algorithmsystem variable is set to
INPLACE, schema change operations will not run unless they can be performed
INPLACE, minimizing the risk of unpredictable behavior.
Information on this topic may be found in the MariaDB Public KB.