Aikesheng Open Source Community
May 15, 2024 · Databases
Understanding InnoDB Table Locks, Intent Locks, and AUTO‑INC Locks in MySQL 8.0
This article explains the architecture of MySQL's InnoDB storage engine locks, covering server‑level metadata locks, table‑level shared and exclusive locks, intent locks, and the three modes of AUTO‑INC locks, with practical SQL examples and performance‑schema queries.
Database InternalsInnoDBIntent Locks
0 likes · 16 min read