NOTE
InnoDB Pages
Page-based B+tree storage, records, free space, page splits, and locality.
This is a historical learning note and may contain outdated or incomplete understanding.
InnoDB stores indexes and rows in fixed-size pages. B+tree pages hold records plus metadata and free-space structures; adjacent logical key ranges are connected through the tree/leaf-page organization.
Insert patterns influence locality and page splits. A monotonic primary key often produces predictable append-like behavior, while random keys can create more scattered page activity. The impact still depends on workload, cache, page fill, and storage.