Details
-
Type:
Task
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Fix Version/s: 10.2
-
Component/s: None
-
Labels:None
Description
Feature Request:
I would like to please request a new binary log removal option, similar to --expire-logs-days (expire_logs_days), but it would be --expire-logs-count=N, where one could specify the actual # of binary logs to keep. This would purge binlog files when the count exceeds N.
There are multiple advantages to this new option:
1. You can more accurately account for space requirements this way (i.e., since one would already knwo the max binary log size and now the total number of binary logs that would exist).
2. You avoid the "Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'" problem that occurs for those who use --expire-logs-days and use a backup older than --expire-logs-days (i.e., if you do that, which can be common in certain situations, your binary logs will be deleted immediately followed by the above error, and replication breaking.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Hi, yes, 5.5 would be perfect. I almost chose "Tasks" - I will next time for a feature request. 
The initial report mentioned affected version 5.5.29, so I guess the request is to implement it in 5.5.
('Affects version' gets removed automatically when a record is moved from Bugs to Tasks).