mysql慢查询单位,MySQL的慢查询日志中的时间单位是什么？

I'm looking at the slow query log from a drupal-based webapp, and have lines that look like this:

# Query_time: 3257 Lock_time: 0 Rows_sent: 272 Rows_examined: 272

# Query_time: 1654 Lock_time: 0 Rows_sent: 222 Rows_examined: 222

# Query_time: 3292 Lock_time: 0 Rows_sent: 269 Rows_examined: 269

# Query_time: 1029 Lock_time: 0 Rows_sent: 172 Rows_examined: 172

# Query_time: 2126 Lock_time: 0 Rows_sent: 251 Rows_examined: 251

# Query_time: 1731 Lock_time: 0 Rows_sent: 229 Rows_examined: 229

Are these times indicating that the associated queries took between 1 and 3+ seconds (slow but not terrible) to execute, or between 1,000 and 3,000+ seconds (completely unacceptable)? I understand that the long_query_time option is specified in seconds, but do the log messages follow this same convention, or do they use milliseconds instead?

Edit: this is with MySQL version 5.0.45.

解决方案

It's in seconds. The 'resolution of microseconds' means, that you can have up to microsecond precision after a decimal (although AFAIK it need a patch to actually write with such precision)