Page 1 of 1

mysql logs filling up root drive

Posted: Mon Jul 07, 2025 9:12 am
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.

Re: mysql logs filling up root drive

Posted: Mon Jul 07, 2025 11:55 pm
by kg2857
You could read the logs and figure out why it's logging.

Re: mysql logs filling up root drive

Posted: Tue Jul 08, 2025 3:32 am
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.