Nov 24, 2022 · Backend Development

Why MySQL Tables Slow Down After 20 Million Rows and How to Estimate Safe Limits

This article explores MySQL InnoDB table size limits, explains how page and B+ tree structures affect performance, provides scripts for generating massive test data, and derives a practical recommendation of around 20 million rows based on storage and index calculations.

B+TreeInnoDBlarge dataset

0 likes · 14 min read

Why MySQL Tables Slow Down After 20 Million Rows and How to Estimate Safe Limits

Tencent Database Technology

May 11, 2022 · Databases

In-depth Analysis of InnoDB File Structure and Page Organization

This article provides a comprehensive examination of InnoDB's physical file layout, detailing page components such as the file header, page header, record storage formats, variable‑length and NULL handling, free space, page directory, file trailer, external storage pages, and the differences among row formats and compression techniques, illustrated with concrete hexdump examples and SQL statements.

InnoDBblob storagecompression

0 likes · 27 min read

In-depth Analysis of InnoDB File Structure and Page Organization