Tag

Row-level Lock

0 views collected around this technical thread.

New Oriental Technology

Jun 13, 2024 · Databases

Understanding InnoDB Row-Level Locks and Locking Rules in MySQL

This article explains the types of InnoDB row‑level locks—record lock, gap lock, and next‑key lock—describes how MySQL determines lock ranges based on indexing, outlines the two fundamental locking principles with associated optimizations, and provides concrete examples for primary‑key and ordinary indexes.

Gap LockInnoDBMySQL

0 likes · 11 min read

Understanding InnoDB Row-Level Locks and Locking Rules in MySQL

Architecture Digest

Jun 26, 2020 · Databases

Understanding MySQL Lock Mechanisms: Row‑Level, Page‑Level, Table‑Level Locks and Optimistic vs Pessimistic Concurrency Control

This article explains MySQL's lock mechanisms—including row‑level, page‑level and table‑level locks, their shared and exclusive modes, the differences between optimistic and pessimistic concurrency control, and practical tips for avoiding deadlocks in InnoDB.

DatabaseLocksMySQL

0 likes · 12 min read

Understanding MySQL Lock Mechanisms: Row‑Level, Page‑Level, Table‑Level Locks and Optimistic vs Pessimistic Concurrency Control