Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
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
add comment

1 Answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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