maria-developers team mailing list archive

[Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx>]

Roberto Spadim <roberto@xxxxxxxxxxxxx> writes:

> hum, lets think about 10 years, maybe less
> what happen after 2^64 value of the last digit on gtid?
> 1-1-2^64
> it will go back to 0?

It will (and things will break), but to do 2^64 transactions in 10 years, you
need to do 58 billion transactions per second ...

Of course, since binlog files are <name>.NNNNNN, and limited to 1GB per file,
you will reach the limit of max. 10^15 bytes worth of binlog much sooner ...

 - Kristian.