Tencent Database Technology
May 11, 2022 · Databases
In-depth Analysis of InnoDB File Structure and Page Organization
This article provides a comprehensive examination of InnoDB's physical file layout, detailing page components such as the file header, page header, record storage formats, variable‑length and NULL handling, free space, page directory, file trailer, external storage pages, and the differences among row formats and compression techniques, illustrated with concrete hexdump examples and SQL statements.
Database InternalsInnoDBMySQL
0 likes · 27 min read