Re: [Maria-developers] Feature Request - Working auto_inc rement on BlackHole Engine

2013-05-20 Thread Michael Widenius
Hi! > "Gordan" == Gordan Bobic 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 >> >> ju

Re: [Maria-developers] Feature Request - Working auto_inc rement on BlackHole Engine

2013-05-15 Thread Gordan Bobic
On 05/15/2013 11:27 PM, Jocelyn Fournier wrote: Hi Gordan, Le 15/05/13 22:18, Gordan Bobic a écrit : On 05/15/2013 09:06 PM, Michael Widenius wrote: Hi! "Gordan" == Gordan Bobic writes: Gordan> How difficult would be be to implement working Gordan> auto-increment functionality on the

Re: [Maria-developers] Feature Request - Working auto_inc rement on BlackHole Engine

2013-05-15 Thread Roberto Spadim
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' variab

Re: [Maria-developers] Feature Request - Working auto_inc rement on BlackHole Engine

2013-05-15 Thread Gordan Bobic
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 wo

Re: [Maria-developers] Feature Request - Working auto_inc rement on BlackHole Engine

2013-05-15 Thread Roberto Spadim
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 2013/5/15 Gordan Bobic > On 05/15/2013 09:06 PM, Mic

Re: [Maria-developers] Feature Request - Working auto_inc rement on BlackHole Engine

2013-05-15 Thread Gordan Bobic
On 05/15/2013 09:06 PM, Michael Widenius wrote: Hi! "Gordan" == Gordan Bobic writes: Gordan> How difficult would be be to implement working Gordan> auto-increment functionality on the BlackHole engine? Gordan> This would be really useful for what I'm trying to do at Gordan> the moment.

Re: [Maria-developers] Feature Request - Working auto_inc rement on BlackHole Engine

2013-05-15 Thread Michael Widenius
Hi! > "Gordan" == Gordan Bobic writes: Gordan> How difficult would be be to implement working Gordan> auto-increment functionality on the BlackHole engine? Gordan> This would be really useful for what I'm trying to do at Gordan> the moment. Since it is not available and there are no Go