{"id":198,"date":"2013-08-07T03:47:46","date_gmt":"2013-08-07T03:47:46","guid":{"rendered":"https:\/\/digitalchild.info\/?p=198"},"modified":"2013-08-07T03:47:46","modified_gmt":"2013-08-07T03:47:46","slug":"reclaim-disk-space-from-innodb-with-mysql","status":"publish","type":"post","link":"https:\/\/randomadult.local\/reclaim-disk-space-from-innodb-with-mysql\/","title":{"rendered":"Reclaim Disk Space from InnoDB with MySQL"},"content":{"rendered":"
After writing the article yesterday about removing a slave from a MySQL replication setup<\/a>. I was digging around the mysql data directory and noticed that the innodb<\/em> data file hadn’t reduced in size after I dropped the database. There is a reason for this. MySQL will not garbage collect the old data as it’s all one container. You need to change how MySQL handles the storage of database data files and to do that you have to hit the big reset button on your MySQL server.<\/p>\n