Introduction to InnoDB Transaction Lock System in MySQL

This article provides a comprehensive overview of InnoDB's transaction lock subsystem in MySQL, explaining row‑level and table‑level lock types, their internal implementations, lock‑compatibility rules, practical SQL examples, and common deadlock scenarios with detailed code illustrations.

InnoDBRow-Level LockingTable-level Locking

0 likes · 29 min read

Introduction to InnoDB Transaction Lock System in MySQL

Qunar Tech Salon

Mar 13, 2016 · Databases

Introduction to InnoDB Transaction Lock System

This article provides a comprehensive overview of MySQL InnoDB's transaction lock system, covering row‑level and table‑level lock types, their flags, isolation‑level behavior, deadlock detection, and illustrative examples with SQL and source‑code snippets.

InnoDBIsolation LevelsLock Types

0 likes · 28 min read

Introduction to InnoDB Transaction Lock System

Architect

Feb 6, 2016 · Databases

Introduction to InnoDB Transaction Lock System

This article provides a comprehensive overview of InnoDB's transaction lock mechanisms, covering row‑level lock types, table‑level locks, lock management procedures, deadlock detection, and practical examples, all based on MySQL 5.7.10.

Database InternalsInnoDBTransaction Locks

0 likes · 30 min read