# PMM QAN shows query from n/a database & taking load on database. how to resolve this? **URL:** \ **Category:** Percona Monitoring and Management (PMM)\ **Tags:** community, pmm, mysql\ **Created:** [June 30, 2023, 9:53am UTC](https://forums.percona.com/t/pmm-qan-shows-query-from-n-a-database-taking-load-on-database-how-to-resolve-this/23233 "2023-06-30T09:53:02Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [June 30, 2023, 9:53am UTC](https://forums.percona.com/t/pmm-qan-shows-query-from-n-a-database-taking-load-on-database-how-to-resolve-this/23233/1 "2023-06-30T09:53:02Z")
Getting Below query in PMM QAN. its taking load on database. how can i disable this and its shows from database (n/a). what does it mean database n/a.? can someone help me to disable this query? and what is the impact of disalbe of this query? SELECT `t`.`table_schema`, `t`.`table_name`, COLUMN\_NAME, AUTO\_INCREMENT, `pow` ( ?, CASE `data_type` WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? WHEN ? THEN ? END + (`column_type` LIKE ?) ) - ? AS `max_int` FROM `information_schema`.`columns` `c` STRAIGHT\_JOIN `information_schema`.`tables` `t` ON BINARY `t`.`table_schema` = `c`.`table_schema` AND BINARY `t`.`table_name` = `c`.`table_name` WHERE `c`.`extra` = ? AND `t`.`auto_increment` IS NOT NULL. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/f84cdcb6080b048f5158c6d6a7d238f4b1a73326.jpeg) ---
**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\ **Post date:** [June 30, 2023, 11:20am UTC](https://forums.percona.com/t/pmm-qan-shows-query-from-n-a-database-taking-load-on-database-how-to-resolve-this/23233/2 "2023-06-30T11:20:57Z")
Hi @Pavanmysql Please see the “Schema” filter to detect what Schema this query belongs to (there is confusion between Schema and Database in MySQL and PostgreSQL usage) From what I can see: it’s probably the number of Tables in some schema causing this problem. Try to add the MySQL with `--disable-tablestats` flag to pmm, which will stop pmm from collecting such metrics. ---
**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\ **Post date:** [June 30, 2023, 11:24am UTC](https://forums.percona.com/t/pmm-qan-shows-query-from-n-a-database-taking-load-on-database-how-to-resolve-this/23233/3 "2023-06-30T11:24:21Z")
Hi @Pavanmysql, Refer to this [documentation](https://docs.percona.com/percona-monitoring-and-management/how-to/optimize.html) page. The query comes from table statistics usage and you can disable it by following the instructions there. In general, the “?” refers to the fingerprint process and are values are generalised for representation. Similarly, when there is no default database, I believe, you’re seeing “N/A” Thanks, K ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [June 30, 2023, 12:35pm UTC](https://forums.percona.com/t/pmm-qan-shows-query-from-n-a-database-taking-load-on-database-how-to-resolve-this/23233/4 "2023-06-30T12:35:44Z")
Thanks for the update. @kedarpercona so as per the document i need to remove and add node again in pmm , right? ---
**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\ **Post date:** [June 30, 2023, 12:59pm UTC](https://forums.percona.com/t/pmm-qan-shows-query-from-n-a-database-taking-load-on-database-how-to-resolve-this/23233/5 "2023-06-30T12:59:16Z")
Sure Pavan. Do that. ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [July 3, 2023, 9:21am UTC](https://forums.percona.com/t/pmm-qan-shows-query-from-n-a-database-taking-load-on-database-how-to-resolve-this/23233/6 "2023-07-03T09:21:48Z")
@kedarpercona @Roma_Novikov i removed the mysql node and added again in PMM using below command. root# pmm-admin add mysql --disable-tablestats vm-mysql1-prod-sa --username=pmm --password=\*\*\* --query-source=perfschema 127.0.0.1:13306 MySQL Service added. Service ID : /service\_id/8cc0d21b-15e3-4c0e-ab74-defeb3e8a049 Service name: \*\*\*\*\*\* Table statistics collection disabled (always). i have checked QAN after 1 hour of reconfiguration for last 5 min and 15 min and i m still seeing this query in QAN and its comming from schema n/a and node name (that i reconfigured). how to fix this or i m missing something? ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [July 4, 2023, 5:11am UTC](https://forums.percona.com/t/pmm-qan-shows-query-from-n-a-database-taking-load-on-database-how-to-resolve-this/23233/8 "2023-07-04T05:11:25Z")
i disabled the table stats and restart the pmm-server but still this query executing in database. ☹ ---
**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Post date:** [July 4, 2023, 9:10am UTC](https://forums.percona.com/t/pmm-qan-shows-query-from-n-a-database-taking-load-on-database-how-to-resolve-this/23233/9 "2023-07-04T09:10:27Z")
solved. upgraded pmm server and pmm client with dislabe tablestats. thanks all 🙂