up vote 2 down vote favorite
share [g+] share [fb]

The mysql slow query log shows query time in whole integers. 

# Query_time: 0  Lock_time: 0  Rows_sent: 177  Rows_examined: 177
SELECT ...
# Query_time: 1  Lock_time: 0  Rows_sent: 56  Rows_examined: 208
SELECT ...

There was a microsecond patch to allow mysql to be configured to log queries that take longer than X microseconds to run. But is there a way to have the log output the query time in either milliseconds or microseconds?

link|improve this question
50% accept rate
what version of mysql? This is built into 5.1.21 and above, and is logged as microseconds. I just confirmed it is working on my 5.1.40 instance. – MattB Jun 8 '10 at 15:20
feedback

1 Answer

up vote 1 down vote

try this: Slow Query Log Extended Statistics

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.