Analyzing InnoDB Locking Behavior under REPEATABLE‑READ and READ‑COMMITTED Isolation Levels

This article demonstrates how InnoDB acquires and releases row‑level locks for a sample table under REPEATABLE‑READ and READ‑COMMITTED isolation levels, showing the SQL statements used, the lock types observed in the performance_schema, and the reasons behind the observed locking patterns.

InnoDBRow Lockingmysql

0 likes · 10 min read

Analyzing InnoDB Locking Behavior under REPEATABLE‑READ and READ‑COMMITTED Isolation Levels

Aikesheng Open Source Community

Jun 26, 2024 · Databases

Slow Locking Logic in MySQL InnoDB

This article explains the slow‑path row‑locking algorithm used by InnoDB in MySQL 8.0.32, detailing how the engine checks whether a transaction already holds a lock, determines if it must wait, reuses existing lock structures, and allocates new ones when necessary.

Concurrency ControlDatabase InternalsInnoDB

0 likes · 15 min read