                        課程
                    
                        /數(shù)據(jù)庫(kù)
                        
                            /MySQL
                        
                        /性能優(yōu)化之MySQL優(yōu)化

mys?qldumpslow求解

老師，請(qǐng)問一下，我執(zhí)行mysqldumpslow -s t -t 10 /var/localhost-slow.log時(shí)，怎么顯示出來的結(jié)果中，Time,Lock,Rows的值都是0.0，已經(jīng)確認(rèn)sql是能查到數(shù)據(jù)的。到底什么情況？

慕粉18312537527

2016-05-30

源自：性能優(yōu)化之MySQL優(yōu)化

關(guān)注問題我要回答

1158

操作

收起

1 回答

慕粉18312537527 提問者
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