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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org