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

Re: [Maria-developers] MariaDB GTID first impression

2013-05-15 Thread Pavel Ivanov
On Wed, May 15, 2013 at 1:11 AM, Kristian Nielsen wrote: > Pavel Ivanov writes: > >> We reaching consistency in the backup by shutting down the server. I > > So thinking about this again ... > > So if we shut down the server gracefully, copy over everything to a new > server, delete all binlogs (

[Maria-developers] Feature Request - Working auto_increment on BlackHole Engine

2013-05-15 Thread Gordan Bobic
How difficult would be be to implement working auto-increment functionality on the BlackHole engine? This would be really useful for what I'm trying to do at the moment. Since it is not available and there are no sequences in MariaDB and MySQL, I have to resort to a hack such as a single-int-fiel

Re: [Maria-developers] MariaDB GTID first impression

2013-05-15 Thread Kristian Nielsen
Pavel Ivanov writes: > We reaching consistency in the backup by shutting down the server. I So thinking about this again ... So if we shut down the server gracefully, copy over everything to a new server, delete all binlogs (or omit binlogs from the copy), restart the server - then it could act