mys?qldumpslow求解
老師，請問一下，我執(zhí)行mysqldumpslow -s t -t 10 /var/localhost-slow.log時，怎么顯示出來的結(jié)果中，Time,Lock,Rows的值都是0.0，已經(jīng)確認sql是能查到數(shù)據(jù)的。到底什么情況？
慕粉18312537527
2016-05-30
1 回答
舉報
0/150
提交
取消
2016-05-30
例如，查詢結(jié)果是這樣的：
Count: 1? Time=0.00s (0s)? Lock=0.00s (0s)? Rows=0.0 (0), root[root]@localhost
? # Schema: test? Last_errno: N? Killed: N
? # Query_time: N.N? Lock_time: N.N? Rows_sent: N? Rows_examined: N? Rows_affected: N
? # Bytes_sent: N
? use test;
? SET timestamp=N;
? set global slow_query_log = on
Count: 1? Time=0.00s (0s)? Lock=0.00s (0s)? Rows=0.0 (0), root[root]@localhost
? # Schema:?? Last_errno: N? Killed: N
? # Query_time: N.N? Lock_time: N.N? Rows_sent: N? Rows_examined: N? Rows_affected: N
? # Bytes_sent: N
? SET timestamp=N;
? select sleep(N)
Count: 1? Time=0.00s (0s)? Lock=0.00s (0s)? Rows=0.0 (0), root[root]@localhost
? # Schema: test? Last_errno: N? Killed: N
? # Query_time: N.N? Lock_time: N.N? Rows_sent: N? Rows_examined: N? Rows_affected: N
? # Bytes_sent: N
? SET timestamp=N;
? select * from test100w where id > (select id from test100w where id = N) limit N