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

**URL:** https://forums.percona.com/t/want-idea-for-get-alert-for-any-query-running-more-than-10-mins-in-mysql/12150
**Category:** PMM 1.x
**Tags:** percona, pmm, mysql
**Created:** [September 14, 2021, 6:12am UTC](https://forums.percona.com/t/want-idea-for-get-alert-for-any-query-running-more-than-10-mins-in-mysql/12150 "2021-09-14T06:12:55Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Ajithkumar\_ops](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Ajithkumar\_ops](https://forums.percona.com/u/Ajithkumar_ops)
#### Post date: [September 14, 2021, 6:12am UTC](https://forums.percona.com/t/want-idea-for-get-alert-for-any-query-running-more-than-10-mins-in-mysql/12150/1 "2021-09-14T06:12:55Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)
#### Post date: [September 14, 2021, 9:38am UTC](https://forums.percona.com/t/want-idea-for-get-alert-for-any-query-running-more-than-10-mins-in-mysql/12150/2 "2021-09-14T09:38:59Z")

</div>

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](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/9/94ce32636b49ba1fcac474970a9d0c45233496ff.png)

---

<div class="post-metadata">

### Author: ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)
#### Post date: [September 14, 2021, 12:04pm UTC](https://forums.percona.com/t/want-idea-for-get-alert-for-any-query-running-more-than-10-mins-in-mysql/12150/3 "2021-09-14T12:04:32Z")

</div>

Look at long\_query\_time value in order to populate the metric adivinho mentioned.

---

<div class="post-metadata">

### Author: ![Ajithkumar\_ops](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Ajithkumar\_ops](https://forums.percona.com/u/Ajithkumar_ops)
#### Post date: [September 15, 2021, 6:37am UTC](https://forums.percona.com/t/want-idea-for-get-alert-for-any-query-running-more-than-10-mins-in-mysql/12150/4 "2021-09-15T06:37:47Z")

</div>

Thank you @Vadim_Yalovets @Ivan_Groenewold

---

<div class="post-metadata">

### Author: ![Ajithkumar\_ops](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Ajithkumar\_ops](https://forums.percona.com/u/Ajithkumar_ops)
#### Post date: [September 16, 2021, 1:40pm UTC](https://forums.percona.com/t/want-idea-for-get-alert-for-any-query-running-more-than-10-mins-in-mysql/12150/5 "2021-09-16T13:40:20Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)
#### Post date: [September 16, 2021, 3:30pm UTC](https://forums.percona.com/t/want-idea-for-get-alert-for-any-query-running-more-than-10-mins-in-mysql/12150/6 "2021-09-16T15:30:00Z")

</div>

> [@Ajithkumar\_ops](#):
>
> pls can u give me a metric query for that dashboard

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