MySQL BinLog Eating up Disk Space

Got Disk Usage Alarms for 3 days in a row - even I have deleted some files.

Run find / -printf '%s %p\n'| sort -nr | head -10 to find out the 10 largest file and it turns out there are the bin logs used by mysql server.

Login to MYSQL server:
and delete log files older than 3 days

PURGE BINARY LOGS BEFORE DATE(NOW() - INTERVAL 3 DAY) + INTERVAL 0 SECOND;

Set binlog to auto rotated (keep 3 days):

SET GLOBAL binlog_expire_logs_seconds = 86400*3;

then add this to /etc/my.cnf

[mysqld]
expire_logs_days=3

https://helloacm.com