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– Rick James2018年09月12日 12:49:02 +00:00Commented Sep 12, 2018 at 12:49
1 Answer 1
An error is generated when the numbers run out:
answered Aug 24, 2018 at 4:15
-
To add more info, MySQL will not stop on 999,999 as it's merely a formatting thing. The limit for the numeric extension is actually 0x7FFFFFFF or 2147483647. Sources: adamcscott.blogspot.com/2014/06/… github.com/mysql/mysql-server/blob/8.0/sql/binlog.cc#L3471Ahmed Jolani– Ahmed Jolani2018年08月25日 00:42:51 +00:00Commented Aug 25, 2018 at 0:42
lang-sql