maria-developers team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

ok it's a very big number :) no problem at all
in other words if we get 2^64 maybe we will change to 2^128

this could be put in manual just as an information of why use 64bits on
gtid, it is interesting


2013/5/7 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.
>



-- 
Roberto Spadim
SPAEmpresarial