-
·
Reclaim Disk Space from InnoDB with MySQL
After writing the article yesterday about removing a slave from a MySQL replication setup. I was digging around the mysql data directory and noticed that the innodb 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…
-
·
Remove A MySQL Replication Slave
There might be a time that you no longer need a MySQL slave in your replication setup. You can remove a mysql replication slave using the following instructions. Log in to your mysql slave and make sure that nothing is accessing the slave database. Run the following commands. Note: There is a space between the…
