Skip to content
Tagged articles

data page

7 articles · Page 1 of 1
Dabaoshi
Dabaoshi
Jul 23, 2026 · Databases

Understanding MySQL InnoDB Storage: From Data Pages to Tablespaces

This article walks through MySQL InnoDB's five‑level storage hierarchy—record, page, extent, segment, tablespace—explaining page internals, record chaining, page directories, headers, trailers, extent and segment management, and the system tablespace and data dictionary across MySQL 5.7 and 8.0.

InnoDBMySQLdata page
0 likes · 24 min read
Understanding MySQL InnoDB Storage: From Data Pages to Tablespaces
dbaplus Community
dbaplus Community
Feb 5, 2024 · Databases

Inside InnoDB: How MySQL Stores Data, Row Formats, Pages, and Indexes

This article explains MySQL's InnoDB storage engine, covering where data files are kept, the different row formats (compact, redundant, dynamic, compressed), the internal 16 KB page layout, record header fields, overflow handling, and how B‑Tree indexes (clustered and secondary) are built and accessed.

B+TreeDatabase StorageIndexing
0 likes · 22 min read
Inside InnoDB: How MySQL Stores Data, Row Formats, Pages, and Indexes