ALTER TABLE Improvements in MariaDB Server

  • Marko Mäkelä, Lead Developer InnoDB at MariaDB
Session Abstract

MariaDB Server 10.3 introduced ALGORITHM=NOCOPY, allowing columns to be added in an instant because adding columns no longer required rebuilding a table. In MariaDB Server 10.4, we’re taking this a step further with instant DROP COLUMN and instant ALTER TABLE to support many more instant schema changes. In this session, Marko Mäkelä explains how instant schema changes work and how MariaDB is eliminating table rebuilds.

View Presentation Slides