On Wed, Aug 31, 2011 at 4:10 AM, Peter Brawley wrote:
While a transaction in one thread tries to update a non-existent InnoDB row
with a given key value, an attempt to insert that value in another thread is
locked out. Does anyone know where this behaviour is documented?
In the manual it is
On 9/1/2011 9:06 AM, Jerry Schwartz wrote:
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: Wednesday, August 31, 2011 10:40 AM
To: r...@grib.nl; mysql@lists.mysql.com
Subject: Re: locked non-existent row
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While
On 9/2/2011 6:15 AM, Jochem van Dieten wrote:
On Wed, Aug 31, 2011 at 4:10 AM, Peter Brawley wrote:
While a transaction in one thread tries to update a non-existent InnoDB row
with a given key value, an attempt to insert that value in another thread is
locked out. Does anyone know where this
On Wednesday 31 August 2011 16:39:52 Peter Brawley wrote:
While a transaction in one thread tries to update a non-existent InnoDB
row with a given key value, an attempt to insert that value in another
thread is locked out. Does anyone know where this behaviour is
documented?
--
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: Wednesday, August 31, 2011 10:40 AM
To: r...@grib.nl; mysql@lists.mysql.com
Subject: Re: locked non-existent row
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While a transaction in one thread tries to update
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: Wednesday, August 31, 2011 10:40 AM
To: r...@grib.nl; mysql@lists.mysql.com
Subject: Re: locked non-existent row
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While a transaction in one thread tries
On 9/1/2011 9:46 AM, Rik Wasmus wrote:
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: Wednesday, August 31, 2011 10:40 AM
To: r...@grib.nl; mysql@lists.mysql.com
Subject: Re: locked non-existent row
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While
The ability to lock non-existent records is critical.
I concur, although this is just a transaction consisting of 1 statement :).
--
[JS] As the Three Musketeers used to say, One for all and all for one!
Peter, I couldn't even //understand// that paragraph about key gaps. The
document writers
While a transaction in one thread tries to update a non-existent InnoDB
row with a given key value, an attempt to insert that value in another
thread is locked out. Does anyone know where this behaviour is documented?
-- connection 1
drop table if exists t;
create table t( lockid char(3),
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While a transaction in one thread tries to update a non-existent InnoDB
row with a given key value, an attempt to insert that value in another
thread is locked out. Does anyone know where this behaviour is documented?
-- connection 1
drop table if exists
While a transaction in one thread tries to update a non-existent InnoDB
row with a given key value, an attempt to insert that value in another
thread is locked out. Does anyone know where this behaviour is documented?
-- connection 1
drop table if exists t;
create table t( lockid char(3),
11 matches
Mail list logo