community-logstash-grok-patterns icon indicating copy to clipboard operation
community-logstash-grok-patterns copied to clipboard

Mysql-slow failing to parse

Open Ulrar opened this issue 8 years ago • 2 comments

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 ?

Ulrar avatar Sep 12 '17 13:09 Ulrar

@jslusher committed that via this PR.

Perhaps they can comment on if it's still valid?

markwalkom avatar Sep 12 '17 20:09 markwalkom

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

nicklaw5 avatar Oct 02 '17 03:10 nicklaw5