MySQL Shared and Exclusive Locks

exclusive lock

A kind of lock that prevents any other transaction from locking the same row. Depending on the transaction isolation level, this kind of lock might block other transactions from writing to the same row, or might also block other transactions from reading the same row. The default InnoDB isolation level, REPEATABLE READ, enables higher concurrency by allowing transactions to read rows that have exclusive locks, a technique known as consistent read.

MySQL Shared and Exclusive Locks

标签：isolation   iter   led   pes   imm   known   events   enable   ant