logstash收集mysql_logstash收集MySQL慢查询日志

#此处以收集mysql慢查询日志为准，根据文件名不同添加不同的字段值

input {file{

path=> "/data/order-slave-slow.log"type=> "mysql-slow-log"start_position=> "beginning"codec=>multiline {

pattern=> "^# User@Host:"negate=> truewhat=>previous

}

}file{

path=> "/data/other-slave-slow.log"type=> "mysql-slow-log"start_position=> "beginning"codec=>multiline {

pattern=> "^# User@Host:"negate=> truewhat=>previous

}

}file{

path=> "/data/order-master-slow.log"type=> "mysql-slow-log"start_position=> "beginning"codec=>multiline {

pattern=> "^# User@Host:"negate=> truewhat=>previous

}