Bug #25412 Patch for microseconds in slow-log
Submitted: 4 Jan 2007 12:32 Modified: 5 Nov 2007 16:46
Reporter: Vadim TKACHENKO Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: Michael Widenius CPU Architecture:Any
Tags: Contribution, slow log, tuning

[4 Jan 2007 12:32] Vadim TKACHENKO
Description:
We propose to include a patch to enable microseconds granularity in slow log in Community server.
It is very helpful to tuning queries especially in Web enviroment.
More info:
http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools

The patch is available here:
http://www.mysqlperformanceblog.com/files/patches/patch.slow-micro.5.0.26.diff

The patch also allows to set 
long_query_time with microsec or to 0.

How to repeat:
long_query_time=0
long_query_time=0.5
[4 Jan 2007 12:42] Valeriy Kravchuk
Thank you for a patch.
[6 Jul 2007 12:38] [ name withheld ]
Is there a timeline for inclusion into official releases?
[4 Oct 2007 16:40] Michael Widenius
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, (at least 5.1.21 and above)

Note that for the moment this is not a full-fledged feature as MySQL only
prints microseconds in the slow-query log when you log to files. Support for microseconds when logging to tables will be added at the same time we extend the time type to also be able to handle micorseconds.
[5 Nov 2007 16:46] Jon Stephens
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

Documented feature change in 5.1.21 and 6.0.4 changelogs.
[1 Sep 2010 16:52] Rajesh Matkar
How to apply this patch on MySQL Binaries?