I’m trying to use the more accurate query time logging available in percona server (5.1.47-rel11.2-log (Percona Server (GPL), 11.2 , Revision 53)). However, the slow query log often contains entries like this:
Time: 100810 7:55:04# User@Host: db[db] @ [172.30.2.30]# Thread_id: 28056 Schema: mydb Last_errno: 0 Killed: 0# Query_time: 18446744073709.550781 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 1# Bytes_sent: 11 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0# No InnoDB statistics available for this querySET timestamp=1281423304;SET autocommit=0;
That query duration looks like 2^64, so it’s probably really 0, so this query shouldn’t be logged at all. I’ve done a little searching and all I’ve found is others having the same problem. Where is this bug?