This article explains the 20-million-row rule of thumb for MySQL InnoDB tables by analyzing B+ tree index structure, 16KB page size, and fan-out calculations, showing how row size and tree depth affect query performance.
The article analyzes Spring Data JPA's Page and Slice pagination options, explains the hidden COUNT(*) overhead of Page, demonstrates both approaches with code examples, compares performance and UX impacts, and provides guidance on when to choose Slice for large‑scale or infinite‑scroll scenarios.
This article explains how InnoDB stores data on disk, describing tablespaces, segments, extents, pages, row formats, record headers, page directories, B+‑tree indexes, and the differences between clustered and secondary indexes, with examples and diagrams to illustrate each component.
This article explains where MySQL keeps its data files, how InnoDB organizes tablespaces into segments, extents, pages and rows, details the Compact row format—including variable‑length field length lists, NULL‑value lists, and hidden fields—and clarifies the limits of VARCHAR and row‑overflow handling.
