# How to control the PMM monitoring query execution?

**URL:** https://forums.percona.com/t/how-to-control-the-pmm-monitoring-query-execution/19669
**Category:** Uncategorized
**Created:** [January 18, 2023, 5:05am UTC](https://forums.percona.com/t/how-to-control-the-pmm-monitoring-query-execution/19669 "2023-01-18T05:05:36Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Asuwini\_P](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/asuwini_p/32/9824_2.png) [@Asuwini\_P](https://forums.percona.com/u/Asuwini_P)
#### Post date: [January 18, 2023, 5:05am UTC](https://forums.percona.com/t/how-to-control-the-pmm-monitoring-query-execution/19669/1 "2023-01-18T05:05:36Z")

</div>

Hi Guys,

I have written a custom queries for monitoring the MySQL performance and placed the custom queries into medium-resolution directory. The custom queries are executing frequently and stalled the DB. How can I control the query execution. I need to execute the query 5 minutes once.

---

<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: [January 18, 2023, 6:44am UTC](https://forums.percona.com/t/how-to-control-the-pmm-monitoring-query-execution/19669/2 "2023-01-18T06:44:20Z")

</div>

Hi Asuwini,

Here is the link to documentation refer metrics resolution intervals.

> **[Configure - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/how-to/configure.html#metrics-resolution)**
>
> Documentation

---

<div class="post-metadata">

### Author: ![Asuwini\_P](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/asuwini_p/32/9824_2.png) [@Asuwini\_P](https://forums.percona.com/u/Asuwini_P)
#### Post date: [January 18, 2023, 8:20am UTC](https://forums.percona.com/t/how-to-control-the-pmm-monitoring-query-execution/19669/3 "2023-01-18T08:20:48Z")

</div>

Thank you for your reply @Vadim_Yalovets

Seems like this will set it for the whole dashboard. Can we set it for Specific dashboard or metrices? If I changed the metrics resolution value to 5 m, it will affect the entire 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: [January 18, 2023, 4:43pm UTC](https://forums.percona.com/t/how-to-control-the-pmm-monitoring-query-execution/19669/4 "2023-01-18T16:43:05Z")

</div>

Such values are global and affect all metrics.

---

<div class="post-metadata">

### Author: ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)
#### Post date: [January 18, 2023, 5:34pm UTC](https://forums.percona.com/t/how-to-control-the-pmm-monitoring-query-execution/19669/5 "2023-01-18T17:34:37Z")

</div>


