dbaplus Community

Feb 10, 2022 · Databases

Why MySQL Delete Doesn’t Free Space and How InnoDB Reclaims It

This article explains why MySQL’s DELETE only sets a delete‑mark, how InnoDB’s MVCC and purge thread reuse freed pages, the impact of B+‑tree storage on I/O, page merge and split mechanisms, and the proper way to rebuild tables to recover space.