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.