MySQL Bugs: #17193: Long lock time in slow query log

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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:
-

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.

Can we please get an update on this? We really need this capability.