Back to listing

MySQL Slow Query LOG GROK pattern for Graylog

Other Solutions

MySQL Slow Query LOG GROK pattern for Graylog



06 Nov 17:52

Last Push

03 Sep 19:23

Marketplace Rating

No rating yet



Your Rating

Please sign in to rate this add-on.


zionio 11 months ago

Updated version for Graylog 3 pushed on GitHub

zionio 11 months ago

@dipinsugathan sorry for delay
Not yet tested on GL3, but you can easily extract pattern from content_pack.json and create your GROK pattern to apply to your pipeline/extractor.
Don't forget to create the right input (i'm using Filebeat as shipper) for the multiline message ingest.

dipinsugathan about 1 year ago

We are getting the following error on version above 3.0. Any workaround ??

Unhandled exception in REST resource
java.lang.IllegalArgumentException: Unsupported content pack version: 0

dipinsugathan about 1 year ago

Is this pack support version above Graylog 3.0 ?

pardeeprathi over 3 years ago


I'm trying this pattern with below message. But it's not working. Can you please help me out.

# User@Host: test[test] @ []
# Thread_id: 175092484 Schema: testdb QC_hit: No
# Query_time: 1.596409 Lock_time: 0.000142 Rows_sent: 37208 Rows_examined: 460730
SET timestamp=1520476663;
count(DISTINCT pricing_id) as total_book_click

FROM testdb.pr_xml
where created_on >= '2018-02-15 00:00:00' and xml_type='REQUEST' and tenant_id in(32,34,80,81,82,83)
group by created_on,tenant_id;
# Time: 180308 8:07:48

razvanvlasin about 4 years ago

Download content_pack.json here:

Then install it using Graylog Web Interface -> System -> Content Packs

rafaelcarsetimo over 4 years ago

How to use?

Please sign in to comment.

Back to listing