community-logstash-grok-patterns
community-logstash-grok-patterns copied to clipboard
Mysql-slow failing to parse
Hey,
I'm trying to use your mysql-slowlogs but it apparently fails to parse. For example, the final message sent to the output for my latest test :
# Schema: Last_errno: 0 Killed: 0 # Query_time: 30.000804 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 Rows_affected: 0 # Bytes_sent: 57 SET timestamp=1505222653; SELECT SLEEP(30);
It doesn't look like what you seem to be matching against, is that for an old version of mysql, or do I maybe miss some setting in the mysql's config for formatting ?
After coming across this repository, I managed to modify the configurations found here to suit our needs for MariaDB.
See it here: https://gist.github.com/nicklaw5/7f7297f936c428e55603905122fbd13b