Aikesheng Open Source Community
Jun 15, 2023 · Databases
How to Shrink the InnoDB System Tablespace (ibdata1) in MySQL
This article explains the different types of InnoDB tablespaces, why the ibdata1 file can grow uncontrollably, and provides a step‑by‑step procedure—including full backup, instance recreation, and configuration of UNDO and file‑per‑table settings—to safely reduce its size in MySQL environments.
InnoDBMySQLPerformance
0 likes · 13 min read