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 <gor...@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
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
