Aikesheng Open Source Community
May 23, 2023 · Databases
Understanding MySQL lock_time: How Table and Row Lock Wait Times Are Calculated
This article explains how MySQL's lock_time metric is calculated by summing table‑level and row‑level lock wait times, details the InnoDB implementation, shows source‑code paths and functions involved, and clarifies why lock_time may appear small even when query execution is long.
Database PerformanceInnoDBLock Time
0 likes · 16 min read