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


(apaul pang) #1

Hi

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

2015-05-26 09:06:39^^^apaul[apaul] @ [192.168.1.1]^^^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
user:apaul
sql:select * from general_log

Could anyone tell me how to write a filter conf?

Thanks
Apaul


#2

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