PMM Missing DB Conns and DB QPS Data

aredman · February 8, 2021, 6:28pm

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.

Thoughts?

Thanks so much,

Andy

adivinho · February 8, 2021, 7:16pm

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.

aredman · February 8, 2021, 7:19pm

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

aredman · February 8, 2021, 7:37pm

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?

adivinho · February 8, 2021, 7:39pm

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

https://www.percona.com/doc/percona-monitoring-and-management/2.x/setting-up/client/mysql.html

aredman · February 8, 2021, 9:00pm

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

Nanuka · June 24, 2022, 12:14pm

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