Bug #42095 Slow Log to print time waiting to obtain locks & other extra info
Submitted: 13 Jan 2009 23:42 Modified: 14 Jan 2009 15:07
Reporter: Adam Dixon Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any

[13 Jan 2009 23:42] Adam Dixon 
Description:
The slow query time should include the time it takes to get any locks that the query is going to use. This way we'll be able to tell if a query is taking too long because it is waiting for locks. If you need to make it backward compatible with the current behavior, then you can have this as a new option that can be enabled (include lock time).

It would also be great if there was some way to tell it to include the time it took to get the query off the wire, and write the results back onto the wire. This would give the actual time the query took to perform as far as MySQL is concerned, since it includes everything from the point MySQL started to receive the query, obtained any locks, performed the query, and wrote the query back onto the wire. This could also be enabled through a new option to provide backward compatibility.

How to repeat:
N/A

Suggested fix:
Add extra information to slow log via extra variable option.
[20 Aug 2012 20:50] Kevin Benton 
Count me in too... Is bug 65139 a dupe of this one?