Sample Header Ad - 728x90

max_binlog_files on MySQL Server?

4 votes
2 answers
2725 views
I read recently about a setting in Percona Server called max_binlog_files which restricts the total number of binlog files. This is exactly what I need. My binlog_expire_logs_seconds is currently set to 3 days, which works great 99% of the time. However, I'm currently engaged in project which runs a massive amount of queries and the binlogs grew to consume over 70GB in just a few hours. In this case, I really need to limit the number of files. Is there any native setting with MySQL to achieve this? What is the best way to restrict total disk space consumed by binlogs?
Asked by You Old Fool (790 rep)
Oct 23, 2023, 02:46 PM
Last activity: Oct 23, 2023, 04:17 PM