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
Last activity: Oct 23, 2023, 04:17 PM