亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: 處理mysql 慢日志不是root[root] @ localhost 的選項(xiàng)的日志 [打印本頁(yè)]
作者: zl624867243    時(shí)間: 2023-02-21 12:10
標(biāo)題: 處理mysql 慢日志不是root[root] @ localhost 的選項(xiàng)的日志
有這樣一段慢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
復(fù)制代碼
想要過(guò)濾不是 root[root] @ localhost 的慢日志，想要的結(jié)果如下：
  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
復(fù)制代碼




作者: Super_Niu    時(shí)間: 2023-02-25 17:09
本帖最后由 Super_Niu 于 2023-02-25 18:36 編輯
  1. awk '/^# T/ { b = $0; f = 0 } /^# U/ && !/root\[root] @ localhost/ { print b; f = 1 } f' slow.log
復(fù)制代碼
PS: 樓主的示例輸出末尾多了一行








歡迎光臨 Chinaunix (http://72891.cn/) Powered by Discuz! X3.2