Skip to main content

Tablespaces, Data Pages & Index Pages

Learn Tablespaces, Data Pages & Index Pages (InnoDB Internals, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction InnoDB stores data in tablespaces (files). A tablespace is divided into extents (1 MB) of pages (16 KB by default). Each table's rows live in the leaf pages of its clustered index (data pages); each secondary index has its own B+tree of index pages.

More lessons in InnoDB Internals