Assume the bin-log file format is: something-bin-log.000122. With each file has a maximum of 1GB size before rotating, and with cap on the number of old binary log files - say 14 days.

What will be the next file when the current one is something-bin-log.999999 and it is about to get rotated?

Will the next binary log file be something-bin-log.000001? If so, how to prevent this from happening and use a bigger numeric extension instead?

  • That should take a long time. Are you somehow racing to the limit?
    – Rick James
    Sep 12, 2018 at 12:49

1 Answer 1


An error is generated when the numbers run out:

source code reference


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.