BestHub
search
Sign in
Tag

row locks

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
May 22, 2024 · Databases

Understanding InnoDB Row Locks: Shared, Exclusive, Gap, Next‑Key, and Insert‑Intention Locks

This article explains the different types of InnoDB row locks—including shared, exclusive, gap, next‑key, and insert‑intention locks—by showing preparation steps, SQL examples, lock‑mode details, and how they interact under repeatable‑read isolation in MySQL 8.0.32.

InnoDBSQLTransaction Isolation
0 likes · 12 min read
Understanding InnoDB Row Locks: Shared, Exclusive, Gap, Next‑Key, and Insert‑Intention Locks
Architect
Architect
Jun 22, 2016 · Databases

Introduction to InnoDB Row Locks, Splitting, Inheritance, and Migration

This article explains InnoDB row lock types, including shared and exclusive locks and GAP variants, describes how locks split, inherit, and migrate during B‑tree operations, provides code examples and SQL demonstrations, and discusses related bugs and lock compatibility.

B-TreeDatabase InternalsInnoDB
0 likes · 8 min read
Introduction to InnoDB Row Locks, Splitting, Inheritance, and Migration