MySQL中的锁

MySQL的InnoDB中主要有8种锁（来自MySQL 8.0）

• Shared and Exclusive Locks 读锁和写锁
• Intention Locks 意向锁
• Record Locks 行锁
• Gap Locks 间隙锁
• Next-Key Locks 行锁+间隙锁
• Insert Intention Locks
• AUTO-INC Locks
• Predicate Locks for Spatial Indexes

未完待续