List:General Discussion« Previous MessageNext Message »
From:Jochem van Dieten Date:September 2 2011 11:15am
Subject:Re: locked non-existent row
View as plain text  
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/
Thread
locked non-existent rowPeter Brawley31 Aug
  • Re: locked non-existent rowRik Wasmus31 Aug
    • Re: locked non-existent rowPeter Brawley31 Aug
      • Re: locked non-existent rowRik Wasmus | GRIB1 Sep
      • RE: locked non-existent rowJerry Schwartz1 Sep
        • Re: locked non-existent rowRik Wasmus1 Sep
          • Re: locked non-existent rowPeter Brawley1 Sep
          • RE: locked non-existent rowJerry Schwartz1 Sep
        • Re: locked non-existent rowPeter Brawley2 Sep
  • Re: locked non-existent rowJochem van Dieten2 Sep
    • Re: locked non-existent rowPeter Brawley2 Sep