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@knielsen-hq.org>
Roberto Spadim <roberto@spadim.com.br> 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