# Disable performance\_schema queries

**URL:** https://forums.percona.com/t/disable-performance-schema-queries/11015
**Category:** PMM 2.x
**Created:** [June 24, 2021, 7:05am UTC](https://forums.percona.com/t/disable-performance-schema-queries/11015 "2021-06-24T07:05:40Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![domby](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/domby/32/1273_2.png) [@domby](https://forums.percona.com/u/domby)
#### Post date: [June 24, 2021, 7:05am UTC](https://forums.percona.com/t/disable-performance-schema-queries/11015/1 "2021-06-24T07:05:40Z")

</div>

Hi,

im using percona xtradb 8 + pmm2 under debian.  
PMM2 frequently queries this select: “SELECT EVENT\_NAME, COUNT\_STAR, SUM\_TIMER\_WAIT FROM performance\_schema.events\_waits\_summary\_global\_by\_event\_name”

After a few days, this queries getting slower and slower (1sec+), and i have to restart the nodes to avoid high CPU usage.

Is there any way to truncate/reset the statistics? Or any way to disable pmm2 to collect these metrics? In fact I just want to collect the slow queries to analyze.

thanks

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [July 6, 2021, 4:06pm UTC](https://forums.percona.com/t/disable-performance-schema-queries/11015/2 "2021-07-06T16:06:43Z")

</div>

Hello @domby,  
You need to re-add the mysql server in question to PMM using the pmm-admin tool and specify that the slow query source is slowlog, and not perfschema. Check the --help of pmm-admin for the exact syntax.

---

<div class="post-metadata">

### Author: ![domby](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/domby/32/1273_2.png) [@domby](https://forums.percona.com/u/domby)
#### Post date: [July 6, 2021, 8:10pm UTC](https://forums.percona.com/t/disable-performance-schema-queries/11015/3 "2021-07-06T20:10:01Z")

</div>

@matthewb thanks, its working.
