01 2014 档案
Locks Set by Different SQL Statements in InnoDB
摘要：A locking read, anUPDATE, or aDELETEgenerally set record locks on every index record that is scanned in the processing of the SQL statement. It does not matter whether there areWHEREconditions in the statement that would exclude the row.InnoDBdoes not remember the exactWHEREcondition, but only knows
阅读全文
InnoDB Record, Gap, and Next-Key Locks
摘要：InnoDBhas several types of record-level locks including record locks, gap locks, and next-key locks. For information about shared locks, exclusive locks, and intention locks, seeSection14.3.5.3, “InnoDBLock Modes”.InnoDB有几种行级锁类型, 包括 record 锁, gap 锁, next-key锁.Record lock: This is a lock on an index
阅读全文
MySQL 锁模式
摘要：InnoDBimplements standard row-level locking where there are two types of locks,shared (S) locksandexclusive (X) locks. For information about record, gap, and next-key lock types, seeSection14.3.5.6, “InnoDBRecord, Gap, and Next-Key Locks”.InnoDB 实现了标准行级锁, 他又两种锁, 共享(S)锁和排他(X)锁. 需要看record, gap, next-k
阅读全文
