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?