MySQL InnoDB Row‑Level Locking: Architecture Note for OLTP Concurrency
A concise architecture note covering requirements, minimal design, trust boundaries, operational checks, failure modes, and when to revisit the locking design for InnoDB row‑level locks in OLTP workloads.