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

未完待续