Lobster Programming
Lobster Programming
Aug 6, 2025 · Databases

Understanding MySQL Row Overflow and InnoDB Row Formats

This article explains why MySQL row overflow occurs, compares the four InnoDB row formats, shows how overflow data is stored, discusses performance and space impacts, and offers practical tips to prevent overflow by optimizing schema and page size settings.

InnoDBMySQLRow Overflow
0 likes · 4 min read
Understanding MySQL Row Overflow and InnoDB Row Formats
dbaplus Community
dbaplus Community
Dec 22, 2015 · Databases

Unveiling SQL Server Row Overflow: How Data Spills Across Pages

This article explains when SQL Server row overflow occurs, details the exact on‑disk pointer and data structures that store overflowed variable‑length columns across multiple pages, and highlights the performance impact and mitigation strategies for large tables.

Database StorageHeap PagePerformance
0 likes · 9 min read
Unveiling SQL Server Row Overflow: How Data Spills Across Pages