Disable binlog feature

ℹ️ Support
1

Hi,

I’m using NC 24.0.2 with MySQL and having some issues with binlog. It generates lots of entries and fills the disk space. I would like to disable it, but I’m not sure how. I’ve found a Git issue but i don’t really understand how to disable it permanently.

Can somebody give me a hint on how to do it? I’ve little to no MySQL knowledge.
Thanks

2

If you open a console to your server (ie Putty, ssh …) and edit the configuration file of your database (mysql, mariadb. In my case it is /etc/mysql/mariadb.cnf), go check for the [mysqld] section and under this, insert the line “skip-log-bin” without the ".

Then restart your mysql/mariadb service with “sudo service mariadb restart” and check if it is back up and running with “sudo service mariadb status”. That stops the bin logs.

After this, you could (!) safely delete the /var/log/mysql/mariadb-bin00* files.
But better make a backup of all conf and log files before you proceed :slight_smile:

2 Likes
3

@flow-axel Thanks a lot for your hints. Issue appears to be fixed.

The following did the job for me with MySQL
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

at the end of the config file add
skip-log-bin

then
sudo service mysql restart

let it run for a few minutes and verify that the latest binlog file in /var/lib/mysql is not updated anymore (time/minutes doesn’t change)

I did purge/delete the binglog files with sql before
sudo mysql -uroot -p


PURGE BINARY LOGS TO 'binlog.000XXX';

replacing the XXX with the corresponding number (highest) in /var/lib/mysql

2 Likes