# PMM Missing DB Conns and DB QPS Data

**URL:** <https://forums.percona.com/t/pmm-missing-db-conns-and-db-qps-data/9170>\
**Category:** Percona Monitoring and Management (PMM)\
**Created:** [February 8, 2021, 6:28pm UTC](https://forums.percona.com/t/pmm-missing-db-conns-and-db-qps-data/9170 "2021-02-08T18:28:36Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![aredman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aredman/32/1360_2.png) [@aredman](https://forums.percona.com/u/aredman)\
**Post date:** [February 8, 2021, 6:28pm UTC](https://forums.percona.com/t/pmm-missing-db-conns-and-db-qps-data/9170/1 "2021-02-08T18:28:36Z")

</div>

Greetings All:

I’ve deployed PMM successfully and have a three node pxc cluster I am seeking to monitor. I have created the DB USER and can harvest CPU, MEM, DISK and NETWORK stats, but DB query detail and QPS always say N/A.

 ![missing data](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/c8c1ae3462097727d0a01928bc85d4130056b74a.png)

Thoughts?

Thanks so much,

Andy

---

<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:** [February 8, 2021, 7:16pm UTC](https://forums.percona.com/t/pmm-missing-db-conns-and-db-qps-data/9170/2 "2021-02-08T19:16:37Z")

</div>

Hi Andy,

Node metrics (CPU, MEM, DISK, NETWORK) are collected by node\_exporter but missed ones are collected by myslqd\_exporter.

Could you run command `pmm-admin list` on pxc1 node?  
So you would be able to check statuses of all component.

---

<div class="post-metadata">

**Author:** ![aredman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aredman/32/1360_2.png) [@aredman](https://forums.percona.com/u/aredman)\
**Post date:** [February 8, 2021, 7:19pm UTC](https://forums.percona.com/t/pmm-missing-db-conns-and-db-qps-data/9170/3 "2021-02-08T19:19:29Z")

</div>

Greetings adivinho:

aredman@pxc1:[~]: pmm-admin list  
Service type Service name Address and port Service ID

Agent type Status Metrics Mode Agent ID Service ID  
pmm\_agent Connected /agent\_id/2bf184cb-4375-4523-a113-40c66b3f7100  
node\_exporter Running push /agent\_id/1b7f657f-f48d-4780-96ec-778f849e8f44  
vmagent Running push /agent\_id/ebb1afb5-97e9-4d8d-97e6-080ef2c90802

Thoughts?

Andy

---

<div class="post-metadata">

**Author:** ![aredman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aredman/32/1360_2.png) [@aredman](https://forums.percona.com/u/aredman)\
**Post date:** [February 8, 2021, 7:37pm UTC](https://forums.percona.com/t/pmm-missing-db-conns-and-db-qps-data/9170/4 "2021-02-08T19:37:38Z")

</div>

Hmm, are there particular ports that I need to ensure are open on the client and/or pmm server? I’m using ufw to tighten things up, hence may need to know those specifics?

---

<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:** [February 8, 2021, 7:39pm UTC](https://forums.percona.com/t/pmm-missing-db-conns-and-db-qps-data/9170/5 "2021-02-08T19:39:17Z")

</div>

It’s required to create a mysql account and add pxc node monitoring.

> **[MySQL - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html)**
>
> Documentation

---

<div class="post-metadata">

**Author:** ![aredman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aredman/32/1360_2.png) [@aredman](https://forums.percona.com/u/aredman)\
**Post date:** [February 8, 2021, 9:00pm UTC](https://forums.percona.com/t/pmm-missing-db-conns-and-db-qps-data/9170/6 "2021-02-08T21:00:01Z")

</div>

Bingo. Thanks for the excellent and greatly valued input. Solved!

---

<div class="post-metadata">

**Author:** ![Nanuka](https://avatars.discourse-cdn.com/v4/letter/n/9fc29f/32.png) [@Nanuka](https://forums.percona.com/u/Nanuka)\
**Post date:** [June 24, 2022, 12:14pm UTC](https://forums.percona.com/t/pmm-missing-db-conns-and-db-qps-data/9170/7 "2022-06-24T12:14:33Z")

</div>

what about proxysql db info, it does not show anything for node 2 in my case

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/3d5e382a0c8664cf6cf8c915456a2357bb3f0df2.png)