Home / server / Questions / 148927
In Process
Chase Seibert
Asked: 2010-06-08 07:09:45 +0800 CST

Can the mysql slow query log show milliseconds?

  • 772

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?

mysql

1 Answers

    • 1