如何按照时间段打印mysql的慢日志

viato

请教大家，如何按照时间段打印mysql的慢日志，比如打印下面15:13分到18点前的日志

1. # Time: 130924 14:30:13
   
2. # User@Host: test[test] @ localhost []
   
3. # Query_time: 19.286527  Lock_time: 0.000025 Rows_sent: 0  Rows_examined: 1
   
4. SET timestamp=1380007813;
   
5. DELETE FROM functions WHERE  (triggerid IN (15632));
   
6. # Time: 130924 15:13:08
   
7. # User@Host: test[test] @ localhost []
   
8. # Query_time: 19.069534  Lock_time: 0.000064 Rows_sent: 0  Rows_examined: 1
   
9. SET timestamp=1380007813;
   
10. update items set lastclock=1380007790,prevorgvalue='105201685955.000000',prevvalue=lastvalue,lastvalue='16795.633333' where itemid=18440;
    
11. # Time: 130924 17:16:34
    
12. # User@Host: test[test] @ localhost []
    
13. # Query_time: 3.956485  Lock_time: 0.000031 Rows_sent: 0  Rows_examined: 500
    
14. SET timestamp=1380014014;
    
15. delete from trends where itemid=31165 limit 500;
    
16. # User@Host: test[test] @ localhost []
    
17. # Query_time: 9.649595  Lock_time: 0.000051 Rows_sent: 0  Rows_examined: 1
    
18. SET timestamp=1380007813;
    
19. UPDATE sessions SET lastaccess=1380007803 WHERE sessionid='11a6a446e80b9b559c555959f4ca5487';
    
20. # User@Host: test[test] @ localhost []
    
21. # Query_time: 9.193245  Lock_time: 0.000049 Rows_sent: 0  Rows_examined: 0
    
22. use test;
    
23. SET timestamp=1380007813;
    
24. REPLACE INTO settings (name,value) VALUES ('poller_lastrun',1380007803);
    
25. # Time: 130924 16:13:08
    
26. # User@Host: test[test] @ localhost []
    
27. # Query_time: 7.538226  Lock_time: 0.000025 Rows_sent: 0  Rows_examined: 500
    
28. use test;
    
29. SET timestamp=1380010388;
    
30. delete from trends where itemid=24804 limit 500;
    
31. # Time: 130924 17:13:34
    
32. # User@Host: test[test] @ localhost []
    
33. # Query_time: 3.956485  Lock_time: 0.000031 Rows_sent: 0  Rows_examined: 500
    
34. SET timestamp=1380014014;
    
35. delete from trends where itemid=31165 limit 500;
    
36. # Time: 130924 18:13:51
    
37. # User@Host: test[test] @ localhost []
    
38. # Query_time: 3.552062  Lock_time: 0.000019 Rows_sent: 0  Rows_examined: 120
    
39. SET timestamp=1380017631;
    
40. delete from history_uint where itemid=26171 and clock<1379412820;
    
41. # Time: 130924 19:14:15
    
42. # User@Host: test[test] @ localhost []
    
43. # Query_time: 3.631823  Lock_time: 0.000029 Rows_sent: 0  Rows_examined: 77
    
44. SET timestamp=1380021255;
    

复制代码

jiaogeshahaone

按时间排序

viato

就是不知道用 awk怎么去排里面的时间，

jason680

回复 1# viato

How about this

$ awk -vs="15:13:00" -ve="18:00:00" '/^# Time:/{if(s<$NF&&$NF<e)P=1;else P=0}P' FILE

viato

回复 4# jason680


    膜拜呀，可以请教一下，里面的Ｐ是什么意思吗，这个Ｐ没有看懂

Shell_HAT

回复 5# viato


    一个普通的自定义变量。通过它的值是零还是非零来决定是否输出。

jason680

回复 5# viato

there is simple rule "CONDITION{ACTIONS}" for awk

default ACTIONS is "print $0"
default CONDITION is "TRUE"

the last one P will be the same function: P{print $0}


--------------------
and there is simple way to set P value
$ awk -vs="15:13:00" -ve="18:00:00" '/^# Time:/{P=(s<$NF&&$NF<e)?1:0}P' FILE

viato

谢谢大家，我自己去消化一下