MySQL Disable Bin Logging

One of the MySQL servers was running out of space, it turned out to be over 7GB of bin logs filling up the hard drive rather quickly. Since this server is not replicating, then a few modifications to the my.ini or my.cnf file will disable this “feature”.

Edit the my.cnf file. Yours may be somewhere so search for it with find.

find / -type f -name "my.cnf" -exec ls -Atlr '{}' \;

Once found, for example, /etc/mycql/my.cnf, open it and comment out the following lines or ensure that they don’t exist. Not all of them may be present.

vim /etc/my.cnf

Restart MySQL

service mysql restart