Re: locked non-existent row

[Jochem van Dieten]

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 called "gap locking":
http://dev.mysql.com/doc/refman/5.5/en/innodb-record-level-locks.html
http://dev.mysql.com/doc/refman/5.5/en/innodb-next-key-locking.html

Jochem

--
Jochem van Dieten
http://jochem.vandieten.net/