Who could help me to find a conf file in Logstash for MySQL slowlog

(apaul pang) #1


I have a simple data with mysql slow query format as below.

2015-05-26 09:06:39^^^apaul[apaul] @ []^^^00:00:14^^^00:00:00^^^36772^^^2090463^^^mysql^^^select * from general_log

The Separator is ^^^, Now I want to send the data to ES like this format
datetime: 2015-05-26 09:06:39
sql:select * from general_log

Could anyone tell me how to write a filter conf?



Your mysql slow query log format is not the same as mine - is it standard?
I used http://www.phase2technology.com/blog/adding-mysql-slow-query-logs-to-logstash/ to help me.

(system) #3