This page has been moved, the new location is Precise Slow Query Log Time.

Patch: microseconds_in_slow_query_log

Slow query log contain output format like this:

# Time: 090402 9:23:36 # User@Host: XXX @ XXX [10.X.X.X]

This patch allow change format like this:

# Time: 090402 9:23:36.123456 # User@Host: XXX @ XXX [10.X.X.X]

This patch is included as part of Patch: slow_extended.

Version-Specific Information

Variables Provided

slow_query_log_microseconds_timestamp

TypeSystem and command-line variable
ScopeGlobal
DynamicYes
Default0

Switch between microseconds precision in slow query (slow_query_log_microseconds_timestamp=ON) log and typical seconds precision (slow_query_log_microseconds_timestamp=OFF).

Related Reading

https://blueprints.launchpad.net/percona-server/+spec/microseconds-in-query-log