it's just an idea... maybe a user function could solve your problem, get_lock don't work with tables, it just use mysql server memory i think it's not 'crash fail', if you kill the mysql process all 'locks' are released and i think it use mutex and locks to only execute 1 lock for each 'str' variable, must check the source code 2013/5/15 Gordan Bobic <gordan@bobich.net>
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
How would the function avoid the race condition? Is it actually possible to have user-defined global variables?
Gordan
-- Roberto Spadim SPAEmpresarial