Master-class: Hands-on with Online ALTER TABLE: what’s under the hood?

Date and time

  • Saturday 3 February, 11:00 – 11:30 EET (UTC+3)

Presentation materials

PDF Online alter under the hood

Abstract

Online Schema Change is a new way of how ALTER TABLE works under the COPY algorithm.

We will study how it makes concurrent DML possible, potential caveats, run some queries, learn how to track the new ALTER TABLE progress.

We will also take a look at potential improvements that can be made in the engine for a smoother process and better performance.

Nikita Malyavin, MariaDB

For the last 5 years I work as a MariaDB Server developer and also hold a few courses in the FEFU university.

I specialize in system programming, algorithms and SQL language Implementation, and my new passion is concurrent algorithms and data structures.