InnoDB的七种锁

(1)自增锁(Auto-inc Locks) (2)共享/排它锁(Shared and Exclusive Locks) (3)意向锁(Intention Locks) (4)插入意向锁(Insert Intention Locks) (5)记录锁(Record Locks) (6)间隙锁(Gap Locks) (7)临键锁(Next-key Locks)