Back to listing

MySQL Slow Query LOG GROK pattern for Graylog

Other Solutions

MySQL Slow Query LOG GROK pattern for Graylog

zionio
free!

Published

05 Oct 07:52

Last Push

16 Apr 09:44

Marketplace Rating

No rating yet

Discussion

3 Comments

Your Rating

Please sign in to rate this add-on.

Comments

pardeeprathi 3 months ago

Hi,

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

# User@Host: test[test] @ [1.2.3.4]
# 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;
SELECT
created_on,
tenant_id,
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 10 months ago

Download content_pack.json here: https://github.com/zionio/graylog_grok_mysqlslowquery

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

rafaelcarsetimo about 1 year ago

How to use?

Please sign in to comment.

Back to listing