InnoDB Storage Formats, System Pages, IO Subsystem, and Buffer Pool Management in MySQL 5.7

This article explains MySQL 5.7 InnoDB's traditional compressed storage format, system page structures, external storage pages, encrypted and R‑TREE pages, the IO subsystem including asynchronous AIO handling and read‑ahead strategies, as well as buffer pool initialization, management, and concurrency control.

IO SubsystemInnoDBMySQL 5.7

0 likes · 25 min read

InnoDB Storage Formats, System Pages, IO Subsystem, and Buffer Pool Management in MySQL 5.7

Architect

Mar 1, 2016 · Databases

In-depth Overview of MySQL InnoDB Page Types, Compression, IO Subsystem, and Buffer Pool Management

This article provides a comprehensive technical overview of MySQL InnoDB's internal page structures—including compressed, system, external, encrypted, and R‑TREE pages—along with detailed explanations of the IO subsystem, double‑write buffer, temporary tablespaces, and buffer pool memory management mechanisms.

Database InternalsIO SubsystemInnoDB

0 likes · 25 min read

In-depth Overview of MySQL InnoDB Page Types, Compression, IO Subsystem, and Buffer Pool Management