How to remove bin logs and turn it off

Updated: 19th December 2022
Tags: mysql

If your mysql eats enormous amount of space, check if binary logging is on

Check if binlog creating is on

show variables like 'log_bin';

If it is on it will create lots of bin log files on mysql/data folder.

If you have only simple mysql database without master / slaves / replication stuff, you have opportunity to get free space and block creating bin logs in the future.

Purge existing bin logs

PURGE BINARY LOGS TO 'mysql-bin.010';
PURGE BINARY LOGS BEFORE '2019-04-02 22:46:26';

Block creating binlogs

// /etc/mysql/my.cnf
[mysqld]
disable_log_bin

and restart mysql server