Full-Stack Internet Architecture

Aug 29, 2019 · Databases

Understanding InnoDB Delete Behavior and Space Reclamation with OPTIMIZE TABLE

This article explains how MySQL's InnoDB engine marks rows as deleted without freeing disk space, demonstrates the issue with 100,000 rows, and shows how the OPTIMIZE TABLE or ALTER TABLE commands can rebuild the table to reclaim space and improve performance.