Want idea for get alert for any query running more than 10 mins in mysql

Percona Monitoring and Management (PMM) PMM 1.x
, ,
1

Is there a way to monitor for Long-running queries on a MySQL database and have a dashboard, so that we can set up alerts if a query is running for more than x minutes on a DB server. Can someone please point me in the right direction, please

Thanks in advance.

2

Hi Ajithkumar,

You may use metric mysql_global_status_slow_queries for getting amount of slow queries.

e.g.

Screenshot 2021-09-14 at 12.14.38
Screenshot 2021-09-14 at 12.14.381974×531 85.8 KB

3

Look at long_query_time value in order to populate the metric adivinho mentioned.

4

Thank you @Vadim_Yalovets @Ivan_Groenewold

5

hi sir,
pls can u give me a metric query for that dashboard

6

https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html