pmm icon indicating copy to clipboard operation
pmm copied to clipboard

Published 20 hours ago • verified publisher icon percona

MySQL Table Details dashboard showing No Data

Open GenLN opened this issue 2 years ago • 2 comments

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

GenLN avatar Feb 23 '23 10:02 GenLN

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)

ritbl avatar Feb 23 '23 11:02 ritbl

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

GenLN avatar Mar 08 '23 12:03 GenLN