mysql logs filling up root drive
Posted: Mon Jul 07, 2025 9:12 am
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.
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.