mysync icon indicating copy to clipboard operation
mysync copied to clipboard

Under heavy load It is possible to overflow binlog counter

Open ostinru opened this issue 1 year ago • 0 comments

In MySQL, if you rotate your binlogs every minutes, you will have problems after a little less than 2 years of uptime, more about this in the verified bug below. 1 of N https://bugs.mysql.com/115861

Rational: there are 1,051,200 minutes in 2 years, and this bug triggers at binlog number 1M. 2 of N

source: https://x.com/jfg956/status/1826243621450137917

I think, that mysync can reset counter for this case / touch emergefile

screen

IMAGE 2024-08-21 23:02:47

ostinru avatar Aug 21 '24 18:08 ostinru