InnoDB : Deep dive into Dynamic Redo logging and Instant DDL (Dimitri Kravtchuk, Oracle/MySQL)

Description:
Modern MySQL workloads require high performance and operational flexibility, yet core database mechanisms like static REDO log sizing and costly schema changes often become bottlenecks.

This session presents the design and implementation of two advanced MySQL features that address these challenges:

Dynamic REDO Logging, which enables on-the-fly resizing of REDO logs based on workload demands.

Instant ADD/DROP Column, which allows columns to be added or dropped instantly, regardless of table size, without data copy or long-running locks.

The talk explores the internal architecture, key data structures, and execution flows behind these features, highlighting the engineering trade-offs required to ensure performance, correctness, and crash safety. Designed for MySQL Developers, DBAs, enthusiasts, and students, this session provides a deeper understanding of how MySQL evolves to support zero-downtime, scalable workloads.