you can see which queries may be the cause and get detailed metrics for them。这是一个慢查询日...
# Query_time: 8.477847 Lock_time: 0.000056 Rows_sent: 1 Rows_examined: 2 SET timestamp=1323239916; select * from ores where adviseurid=5 and tctabelid=244 and single='1' order by datum asc; As you can see the rows send and rows examined are low, the lock time is also low. ...
Re: Query time of over 8 secs while rows_sent: 1 and rows_examined: 2? 1190 Stelios Doulakis December 08, 2011 03:46AM Re: Query time of over 8 secs while rows_sent: 1 and rows_examined: 2? 1522 Matthew Montgomery December 11, 2011 11:20PM ...