Primary Key Fragmentation and Page Splits

The physical overhead caused by non-sequential primary key insertions.

When using UUIDs or random keys, InnoDB must split B-tree nodes to insert rows in the middle of a range, leading to fragmented pages and lower density.