Turns out MySQL’s InnoDB engine isn’t (by default) very enthusiastic to give back disk space if after mass deletions (say, a DELETE * or a TRUNCATE TABLE). The fix is a little unsettling, but it’s also simple (and with a modestly size db – fast). Back up the db (you should doing this anyway, but …
Continue reading “How to Reclaim Disk Space After Deleting Lots of MySQL Records”