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.
root@0root:~# find /blog -tag "innodb"
#Innodb
Articles tagged with Innodb.