處理mysql 慢日志不是root[root] @ localhost 的選項的日志

zl624867243

有這樣一段慢sql 如下:

1. # Time: 2023-02-20T18:03:03.847057Z
   
2. # User@Host: root[root] @ localhost []  Id: 4247637
   
3. # Query_time: 3.838672  Lock_time: 0.000002 Rows_sent: 361232  Rows_examined: 361232
   
4. use ecoflow_admin;
   
5. SET timestamp=1676916180;
   
6. SELECT /*!40001 SQL_NO_CACHE */ * FROM `act_hi_detail`;
   
7. # Time: 2023-02-20T18:03:10.270230Z
   
8. # User@Host: root[root] @ localhost []  Id: 4247637
   
9. # Query_time: 3.249318  Lock_time: 0.000001 Rows_sent: 330829  Rows_examined: 330829
   
10. SET timestamp=1676916187;
    
11. SELECT /*!40001 SQL_NO_CACHE */ * FROM `prm_sap_log`;
    
12. # Time: 2023-02-20T18:03:20.735960Z
    
13. # User@Host: root[root] @ localhost []  Id: 4247637
    
14. # Query_time: 10.073519  Lock_time: 0.000001 Rows_sent: 94846  Rows_examined: 94846
    
15. SET timestamp=1676916190;
    
16. SELECT /*!40001 SQL_NO_CACHE */ * FROM `prm_sap_send_log`;
    
17. # Time: 2023-02-20T21:28:34.641240Z
    
18. # User@Host: it_user_bpm[it_user_bpm] @  [10.10.10.27]  Id: 4228310
    
19. # Query_time: 119.030511  Lock_time: 119.028379 Rows_sent: 0  Rows_examined: 1160
    
20. use bpm_prd;
    
21. SET timestamp=1676928395;
    
22. DELETE FROM bpm_task_signdata WHERE bpm_task_signdata.tenant_id_ = '-1' AND inst_id_ IN ('1627781786987978752');
    
23. # Time: 2023-02-21T00:23:39.540305Z

復制代碼

想要過濾不是 root[root] @ localhost 的慢日志，想要的結果如下：

1. # Time: 2023-02-20T21:28:34.641240Z
   
2. # User@Host: it_user_bpm[it_user_bpm] @  [10.10.10.27]  Id: 4228310
   
3. # Query_time: 119.030511  Lock_time: 119.028379 Rows_sent: 0  Rows_examined: 1160
   
4. use bpm_prd;
   
5. SET timestamp=1676928395;
   
6. DELETE FROM bpm_task_signdata WHERE bpm_task_signdata.tenant_id_ = '-1' AND inst_id_ IN ('1627781786987978752');
   
7. # Time: 2023-02-21T00:23:39.540305Z

復制代碼

Super_Niu

1. awk '/^# T/ { b = $0; f = 0 } /^# U/ && !/root\[root] @ localhost/ { print b; f = 1 } f' slow.log

復制代碼

PS: 樓主的示例輸出末尾多了一行