20 May
2013
20 May
'13
12:38 p.m.
Hi!
"Gordan" == Gordan Bobic <gordan@bobich.net> writes:
Gordan> On 05/15/2013 09:24 PM, Roberto Spadim wrote:
hum, maybe a 'global variable' + a 'counter' function could do the job?
select add_and_return(@global_var,1) could return old global_var value +1, and set the global_var to +1
just a idea.. like GET_LOCK(str,timeout) do, but without timeout
Gordan> How would the function avoid the race condition? By using atomic auto increments supported by the cpu. If you make this a two fold number: 32_bit_timestamp << 32 + auto_increment Then this would even be safe in regards for server crashes. Gordan> Is it actually possible to have user-defined global variables? With a plugin, yes. Regards, Monty