MySQL Bugs: #49098: add an option expire_logs_number analogous to expire_logs

Bug #49098	add an option expire_logs_number analogous to expire_logs_days
Submitted:	25 Nov 2009 13:06
Reporter:	Axel Schwenke	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S4 (Feature request)
Version:	all	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
expire_logs_days is nice, but it does not look on the most important factor: the disk space consumed by the binlogs. Depending on database activity, the amount of binlogs written during one day can differ greatly.

I ask to add an option expire_logs_number=N (the name is just a suggestion) to limit the number of binlog files to at most N. With the already existing option max_binlog_size, this gives an effective way to limit the total disk space occupied by binlogs.

How to repeat:
n/a