Bug #25412 Patch for microseconds in slow-log

• Submitted: 4 Jan 2007 12:32
• Modified: 5 Nov 2007 16:46
• Reporter: Vadim TKACHENKO
• Status: Closed
• 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?