root@0root:~# cat blog.conf

0ROOT Blog

Real infrastructure cases, failures, fixes and lessons from production.

2026-09-13

MySQL DELETE removed millions of rows, but the .ibd file didn't shrink

We cleaned millions of old rows from a large MySQL table. The data was gone, but the disk space wasn't. OPTIMIZE TABLE returned about 200 GB to the filesystem.

#mysql #innodb #production