MySQL Table Details dashboard showing No Data

[GenLN]

Description

Dashboard showing no data. Hundreds of clients connected to PMM server. Variable "Service Name" not loading any value. Query used for service_name variable is label_values(mysql_info_schema_table_version, service_name)

This raw metric also crash victoriametrics when used in explore. Only queries using "by" works.. for example: label_values(max by(service_name)(mysql_info_schema_table_version), service_name)

Maybe solution is to use some kind of aggregation on the query or simple change metric to "mysql_up" and it should look like: label_values(mysql_up, service_name)

Expected Results

Showing data per service name

Actual Results

No data, empty var Service Name

Version

PMM Server 2.34 > PMM client 2.34

Steps to reproduce

No response

Relevant logs

No response

Code of Conduct

• [X] I agree to follow Percona Community Code of Conduct

[ritbl]

Hey @GenLN, thanks for reporting. Can you please give more details on your setup and what you monitor. So that we can try to reproduce the behavior you are experiencing. Please provide:

• how do you run PMM Server and PMM Client
• what databases you are monitoring (vendors+versions+number of instances)

[GenLN]

running in k8s PMM server using helm chart. PMM clients in docker. 250+ instances mysql,mongodb