logstash grok filter mysql慢速查询

mbjcgjjk  于 2021-06-18  发布在  Mysql
关注(0)|答案(1)|浏览(332)

我尝试使用grok来过滤mysql的慢查询。我需要得到
数据库名称
用户
知识产权
查询\u时间
命令
谁来帮帮我?


# User@Host: tysa6775_ua_data[tysa6775_ua_data] @ localhost []  Id:   360

# Query_time: 1.627188  Lock_time: 0.000246 Rows_sent: 5566  Rows_examined: 459414

use tysa6775_au_data1;
SET timestamp=1541421036;
select * from table_rating where id_product=1009 order by ngaytao desc;

# User@Host: tysa6775_ua_data[tysa6775_ua_data] @ localhost []  Id:   360

# Query_time: 0.000569  Lock_time: 0.000308 Rows_sent: 0  Rows_examined: 3

SET timestamp=1541421036;
select * from table_hoidap where id_product=1009 order by ngaytao desc;

# User@Host: tysa6775_ua_data[tysa6775_ua_data] @ localhost []  Id:   360

# Query_time: 0.000349  Lock_time: 0.000208 Rows_sent: 0  Rows_examined: 28

SET timestamp=1541421036;
select * from table_product_like where id_product='1009' and ip_nguoilike='5.188.210.8' order by stt,id desc;
zaqlnxep

zaqlnxep1#

由于您试图访问的数据分布在日志文件的多行上,因此需要使用多行编解码器,它将从这些行生成单个事件。

相关问题