PMM Missing DB Conns and DB QPS Data

[aredman]

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]

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]

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]

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]

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]

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