intention lock — 2 Technical Articles

Nov 8, 2023 · Databases

Beyond Row and Table Locks: Uncovering MySQL’s Hidden Lock Types

This article examines MySQL's comprehensive lock taxonomy, starting from common row and table locks, then delving into lesser‑known mechanisms such as global locks, intention locks, auto‑increment locks, and Latch, while explaining their commands, use‑cases, and performance implications for developers and DBAs.

InnoDBLocksMySQL

0 likes · 10 min read

Beyond Row and Table Locks: Uncovering MySQL’s Hidden Lock Types

Youzan Coder

Apr 10, 2019 · Databases

Why Does MySQL Hold Locks Until Commit? A Deep Dive into InnoDB Locking

This article explains why MySQL acquires row locks that persist until a transaction commits, using analogies with multithreading, detailed transaction scenarios, the role of intention locks, and how isolation levels affect lock behavior, all illustrated with code examples and diagrams.

InnoDBMySQLdatabase

0 likes · 7 min read

Why Does MySQL Hold Locks Until Commit? A Deep Dive into InnoDB Locking