BestHub
Sign in
Tag

Table Locks

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 12, 2024 · Databases

Understanding InnoDB Table Lock Acquisition in MySQL 8.0.32

This article explains how InnoDB determines whether a transaction already holds a table lock, acquires a mutex token, checks for blocking locks, and creates or reuses lock structures, detailing the complete table‑lock acquisition workflow in MySQL 8.0.32.

InnoDBLocking MechanismMySQL
0 likes · 15 min read
Understanding InnoDB Table Lock Acquisition in MySQL 8.0.32
Aikesheng Open Source Community
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
Understanding InnoDB Table Locks, Intent Locks, and AUTO‑INC Locks in MySQL 8.0