Aikesheng Open Source Community

Oct 19, 2020 · Databases

Investigation and Resolution of MySQL Temporary Tablespace Disk‑Full Issue

This article details a real‑world case where an RDS MySQL instance ran out of disk space due to an oversized temporary tablespace, explains the root‑cause analysis of a massive Cartesian‑product query, and provides step‑by‑step remediation and preventive measures for both MySQL 5.7 and 8.0.