Bug #17193 Long lock time in slow query log
Submitted: 7 Feb 2006 15:51 Modified: 7 Mar 2006 12:17
Reporter: Olaf van der Spek (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:* OS:Any (*)
Assigned to: CPU Architecture:Any

[7 Feb 2006 15:51] Olaf van der Spek
Description:
Could an option be added such that queries can be written to the log based on lock time, execution time or total time?

> When started with the --log-slow-queries[=file_name]  option, mysqld writes a log file containing all SQL statements that took more than long_query_time seconds to execute. The time to acquire the initial table locks is not counted as execution time. The minimum value of long_query_time is 1.

How to repeat:
-
[7 Mar 2006 12:17] Valeriy Kravchuk
Thank you for a reasonable feature request. Do not expact this exact way, but developers are already working on some way to give you information about lock waits for slow queries.
[20 Aug 2012 20:17] Kevin Benton
Can we please get an update on this? We really need this capability.