Perhaps one of the most important InnoDB changes coming in MariaDB Server 10.3 is Instant ADD COLUMN for InnoDB tables. Normally, adding a column to a table requires the full table to be rebuilt. With instant
ADD COLUMN, all that is needed is a special kind of an
UPDATE of table metadata. For a large table, instead of taking several hours, the operation would be completed in the blink of an eye.