Alex,
- Original Message -
From: ""Zeltser, Alex"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, January 21, 2004 10:28 PM
Subject: RE: InnoDB locking 'non-existence' of a row
> Hello Heikki,
>
> Thank you for y
,
Alex Zeltser
List: MySQL General Discussion < Previous MessageNext Message >
From: Heikki Tuuri Date: January 21 2004 4:32am
Subject: Re: InnoDB locking 'non-existence' of a row
Alex,
diagram:
record1 'gap' record2
(User A holds a next-key
e with a separate lock table, and may still do just =
> that, but first wanted to
> see if I can accomplish the same thing with some clever DB manipulation.
>
> Thanks!
>
> Alex
>
> -----Original Message-
> From: Joe Shear [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 20,
iginal Message-
From: Joe Shear [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 11:00 AM
To: Zeltser, Alex
Cc: [EMAIL PROTECTED]
Subject: RE: InnoDB locking 'non-existence' of a row
hi,
Selecting a non-existent row won't acquire any locks that prevents inserts from
hap
re any way to make the second session block when both it and the first one are
> 'locking'
> non-existence of a row?
>
> Thanks in advance,
>
> Alex
>
> -Original Message-
> From: Chris Nolan [mailto:[EMAIL PROTECTED]
> Sent: Friday, Janua
day, January 16, 2004 4:55 PM
To: Zeltser, Alex
Cc: [EMAIL PROTECTED]
Subject: Re: InnoDB locking 'non-existence' of a row
Hi Alex!
On Sat, 2004-01-17 at 05:50, Zeltser, Alex wrote:
> Hi,
>
> I wanted to take advantage of the InnoDB 'gap' locking to lock
> '
Hi Alex!
On Sat, 2004-01-17 at 05:50, Zeltser, Alex wrote:
> Hi,
>
> I wanted to take advantage of the InnoDB 'gap' locking to lock 'non-existence' of a
> row, the way the
> manual recommends. I tried to do this by using 'select ... for update', using the
> 'mysql' client
> from two separate s
