MySQL Binlog files count is increasing day by day and their size is increasing in gigabytes. How can I stop the increasing size of binlog files? They are fulling the disc space.
If you do not need to keep those binary logs, you can “trim” them within MySQL like this:
mysql> PURGE BINARY LOGS BEFORE '2021-01-01 00:00:00';
Of course, you can change the date to whenever you would like. If you would like to trim to a specific binary log file, you can do it like this:
mysql> PURGE BINARY LOGS TO 'mysql-bin.12345';
Be sure to specify the actual file you are trimming to.
IMPORTANT: Do not simply delete the files from the file system. MySQL will complain at some time in the future in a terrible fashion. Save yourself the unnecessary downtime by using PURGE BINARY LOGS command from within MySQL.
