MySQL binlog files

gdev · April 9

Only Sendy is using MySQL but there are a lot of binlog files taking up over 3.6GB of space, can these be safely deleted? I'm not quite sure what they are used for. I'm hosting on AWS:

-rw-r----- 1 mysql mysql 21M Mar 12 00:00 /var/lib/mysql/binlog.001237
-rw-r----- 1 mysql mysql 29M Mar 13 00:00 /var/lib/mysql/binlog.001238
-rw-r----- 1 mysql mysql 69M Mar 14 00:00 /var/lib/mysql/binlog.001239
-rw-r----- 1 mysql mysql 41M Mar 14 15:02 /var/lib/mysql/binlog.001240
-rw-r----- 1 mysql mysql 37M Mar 15 00:00 /var/lib/mysql/binlog.001241
-rw-r----- 1 mysql mysql 76M Mar 16 00:00 /var/lib/mysql/binlog.001242
-rw-r----- 1 mysql mysql 5.5K Mar 16 01:11 /var/lib/mysql/binlog.001243
-rw-r----- 1 mysql mysql 44M Mar 17 00:00 /var/lib/mysql/binlog.001244
-rw-r----- 1 mysql mysql 52M Mar 18 00:00 /var/lib/mysql/binlog.001245
-rw-r----- 1 mysql mysql 57M Mar 19 00:00 /var/lib/mysql/binlog.001246
.
.
.

Ben · April 9

Hi,

I've done some research and here's what I found:

With MySQL8, they have turned on binary logging by default and the default purge (expiry/deletion) of binary logs is set to 30days.

For more information, please see → https://askubuntu.com/questions/1322041/how-to-solve-increasing-size-of-mysql-binlog-files-problem

You can also try the answer from here → https://serverfault.com/questions/1100963/mysql-constantly-writing-to-binlog-rapidly-using-up-disk-space

Thanks.

Best regards,
Ben

MySQL binlog files

Comments