Missing Node from dashboard

[Aneel_Ahmad]

Hello Community,

I am encountering a problem with PMM dashboard. There is one Mysql Node is missing from dashboard.
Setup:
Version: Grafana 9.2.13
Datasource: Metrics
To get the nodes: I am using query label_values(mysql_up{service_name=~“$service_name”}, node_name)

The Node and Service status are Ok. Also I could see Node on OS and Mysql Overview dashboards. Could you please guide hint on what could be problem here?

Thanks and regards

[anil.joshi]

@Aneel_Ahmad

I am encountering a problem with PMM dashboard. There is one Mysql Node is missing from dashboard.

Can you please share the screenshot/snapshot of the dashboard where the Node seems to be missing ? Also, share the similar screenshot/snapshot of the dashboards where the same node is reflecting fine ?

Exactly, what PMM Server version you are running ?

Please also verify if the node details appearing fine in PMM Inventory - PMM Inventory - Percona Monitoring and Management also.

[Vadim_Yalovets]

Hi Aneel,

@Aneel_Ahmad

I am encountering a problem with PMM dashboard. There is one Mysql Node is missing from dashboard.

Could you check on “MySQL Instances Overview” dashboard if all nodes are shown?

e.g.

[Aneel_Ahmad]

Hello everyone,
Thanks for taking time to reply on this thread. It turned out the PMM stopped gathering stats as default table limit was reached so I deleted the service and add it back with --disable-tablestats-limit=1500 option and that resolved the issue.
Thanks again