BestHub
Sign in
ITPUB
ITPUB
Feb 9, 2023 · Databases

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

This article breaks down MySQL's InnoDB storage engine, detailing where data files reside, 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 searched.

B+TreeDatabase StorageIndexing
0 likes · 24 min read
Inside InnoDB: How MySQL Stores Data, Row Formats, and Indexes Explained
Architect's Journey
Architect's Journey
Aug 26, 2021 · Databases

Peeling Back MySQL InnoDB: A Deep Dive into Its Storage Engine

This article dissects MySQL's InnoDB storage engine by first exposing the internal page layout, then explaining the clustered index organization, and finally detailing the slot mechanism used for intra‑page queries, while illustrating insertion strategies and space‑reclamation techniques.

Clustered IndexDatabase InternalsInnoDB
0 likes · 11 min read
Peeling Back MySQL InnoDB: A Deep Dive into Its Storage Engine