MySQL Bugs: #25412: Patch for microseconds in slow-log

Bug #25412	Patch for microseconds in slow-log
Submitted:	4 Jan 2007 13:32	Modified:	5 Nov 2007 17:46
Reporter:	Vadim Tkachenko
Status:	Closed
Category:	Server: Logging	Severity:	S4 (Feature request)
Version:	5.0	OS:	Any
Assigned to:	Michael Widenius	Target Version:
Tags:	tuning, slow log, Contribution
Triage:	D5 (Feature request)

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

Thank you for a patch.

Is there a timeline for inclusion into official releases?

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.

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.