# No any information show for schemas in PMM Query analytics

**URL:** <https://forums.percona.com/t/no-any-information-show-for-schemas-in-pmm-query-analytics/20517>\
**Category:** PMM 2.x\
**Tags:** mysql\
**Created:** [March 10, 2023, 11:13am UTC](https://forums.percona.com/t/no-any-information-show-for-schemas-in-pmm-query-analytics/20517 "2023-03-10T11:13:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![iPavel](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ipavel/32/6141_2.png) [@iPavel](https://forums.percona.com/u/iPavel)\
**Post date:** [March 10, 2023, 11:13am UTC](https://forums.percona.com/t/no-any-information-show-for-schemas-in-pmm-query-analytics/20517/1 "2023-03-10T11:13:00Z")

</div>

Hello, I’m just installed pmm, but in PMM Query analytics got just queries responsible for querieng monitoring data. Schema n/a contains 99.5% of all queries, but in my working schema it just shows one query “USE NAME\_OF\_MY\_DB”. I’m using mysql 5.6.39, maybe that’s the reason? How to locate the issue?  
UPD: pmm-admin status shows  
/agent\_id/712e25eb-536a-41e5-9193-a53ef999f4cb mysql\_perfschema\_agent Running 0 - so it isn’t collecting data, but why?

---

<div class="post-metadata">

**Author:** ![steve.hoffman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/steve.hoffman/32/66_2.png) [@steve.hoffman](https://forums.percona.com/u/steve.hoffman)\
**Post date:** [March 10, 2023, 3:03pm UTC](https://forums.percona.com/t/no-any-information-show-for-schemas-in-pmm-query-analytics/20517/2 "2023-03-10T15:03:28Z")

</div>

What version of PMM are you using? 5.6 went EOL just over 2 years ago and we stopped testing about a year ago as we ended our own post-EOL support for 5.6. You might have luck going with an older PMM client/server combination (5.15.0 was the last release when it went official EOL but maybe 5.23.0 or so would give better results than the latest version).

---

<div class="post-metadata">

**Author:** ![iPavel](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ipavel/32/6141_2.png) [@iPavel](https://forums.percona.com/u/iPavel)\
**Post date:** [March 10, 2023, 5:31pm UTC](https://forums.percona.com/t/no-any-information-show-for-schemas-in-pmm-query-analytics/20517/3 "2023-03-10T17:31:51Z")

</div>

Thank you, I’ve installed 2.15.0 server and client, but the same result. Another thing worth mentioning that my mysql and pmm-client are on lxd container, so maybe something related to this is the issue (but on the other hand, if no connection, why then I see query “USE NAME\_OF\_MY\_DB” for my every working schema in Query Analytics)…

---

<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:** [March 13, 2023, 2:27pm UTC](https://forums.percona.com/t/no-any-information-show-for-schemas-in-pmm-query-analytics/20517/4 "2023-03-13T14:27:36Z")

</div>

Hello @iPavel,  
You can look in the PMM agent logs to find out why the collector isn’t running. Perhaps permissions issue, or similar. Beyond that, as Steve said, 5.6 isn’t supported anymore. And as an FYI, 5.7 goes EOL October 2023 so you should really put forth effort to upgrade to MySQL 8.