14.2.13 InnoDB Table and Index Structures

14.2.13.1 Role of the .frm File for InnoDB Tables
14.2.13.2 Clustered and Secondary Indexes
14.2.13.3 FULLTEXT Indexes
14.2.13.4 Physical Structure of an InnoDB Index
14.2.13.5 Insert Buffering
14.2.13.6 Adaptive Hash Indexes
14.2.13.7 Physical Row Structure

This section describes how InnoDB tables, indexes, and their associated metadata is represented at the physical level. This information is primarily useful for performance tuning and troubleshooting.