InnoDB: A journey to the core
InnoDB is the storage engine behind most busy MySQL databases in the world. How does it store data? How does it track free space? How does it retrieve rows? This presentation dissects InnoDB's storage formats and digs into the physical structure of tablespace files, extents, pages, records, indexes, and free space management. How many bytes would it take to store rows in a particular schema? How does indexing affect storage? What expected and unexpected inefficiencies might you run into? All of these questions and more will be answered.