mysql logs filling up root drive

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Post Reply
fdeyso
Posts: 3
Joined: Mon Jun 16, 2025 9:19 am

mysql logs filling up root drive

Post by fdeyso »

Hi all,

we have just over 20GB of the logfiles.

--- /var/lib/mysql -------------------------------------------------------------------------------------------------------------------------------------------------
/..
1.0 GiB [#######################] binlog.000018
1.0 GiB [###################### ] binlog.000023
1.0 GiB [###################### ] binlog.000007
1.0 GiB [###################### ] binlog.000016
1.0 GiB [###################### ] binlog.000009
1.0 GiB [###################### ] binlog.000022
1.0 GiB [###################### ] binlog.000024
1.0 GiB [###################### ] binlog.000020
1.0 GiB [###################### ] binlog.000014
1.0 GiB [###################### ] binlog.000015
1.0 GiB [###################### ] binlog.000017
1.0 GiB [###################### ] binlog.000013
1.0 GiB [###################### ] binlog.000012
1.0 GiB [###################### ] binlog.000010
1.0 GiB [###################### ] binlog.000011
1.0 GiB [###################### ] binlog.000005
1.0 GiB [###################### ] binlog.000004
1.0 GiB [###################### ] binlog.000019
1.0 GiB [###################### ] binlog.000006
1.0 GiB [###################### ] binlog.000021
1.0 GiB [###################### ] binlog.000008



I added the below line to /etc/my.cnf.d/mysql-server.cnf as it was suggested previously viewtopic.php?t=60647
binlog_expire_logs_seconds=86400


Would it clear these logs or do I have to purge these manually?

I don't have a great deal of recent mysql knowledge so I'd appreciate some guidance.
kg2857
Posts: 490
Joined: Wed Apr 12, 2023 5:48 pm

Re: mysql logs filling up root drive

Post by kg2857 »

You could read the logs and figure out why it's logging.
fdeyso
Posts: 3
Joined: Mon Jun 16, 2025 9:19 am

Re: mysql logs filling up root drive

Post by fdeyso »

It was the default behaviour of the downloaded ISO, after I restarted the MySQL daemon it cleaned up the disk space and it seems to be removing logs after they age, I'll monitor it, but I think we're fine.
Post Reply