Tagged articles

Lock Time

2 articles · Page 1 of 1

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

Understanding MySQL lock_time: How Table and Row Lock Wait Times Are Calculated

Aikesheng Open Source Community

Oct 22, 2019 · Databases

Deep Dive into MySQL Slow Query Log: Time, Lock, and Detailed Output Explanation

This article analyzes the MySQL slow query log in Percona 5.7, explaining how timestamps, execution time, lock time, and various log fields are derived from the source code, and clarifies the meaning of each output component for accurate performance debugging.

Lock TimeMySQLPercona

0 likes · 19 min read

Deep Dive into MySQL Slow Query Log: Time, Lock, and Detailed Output Explanation