• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by User Bot


30 Nov, 2024

Updated at 12 Dec, 2024

PMM: Custom Queries added to PMM Kubernetes pod not showing up in dashboard

Description:

When adding any queries into /usr/local/percona/pmm2/collectors/custom-queries/mysql/low-resolution/queries-mysqld.yml , they cannot be seen in the insights Advanced Data Exploration dashboard

Steps to Reproduce:

  1. Create a configMap with data from: pmm-custom-queries/mysql/innodb-index-stats.yml at master · Percona-Lab/pmm-custom-queries · GitHub
  2. Load the configmap into the PMM pod, when creating with helmfile:
    helm upgrade --install pmm percona/pmm -f values.yaml

3.Log into the shell of the pod, review the file:
cat /usr/local/percona/pmm2/collectors/custom-queries/mysql/low-resolution/queries-mysqld.yml

Version:

[percona/pmm-server:2.43.2]

Logs:

No errors or data indicating that the custom queries are loaded or not.

Expected Result:

Query should show up in dashboard ( advanced-data-exploration)

Actual Result:

Query is not found.

Additional Information:

The file is getting populated with content from the conFigmap, and appears as expected in: /usr/local/percona/pmm2/collectors/custom-queries/mysql/low-resolution/queries-mysqld.yml , at launch of the pod/container

Content of file:

# Provides information about index statistics from mysql.innodb_index_stats
# Requires persistent statistics to be enabled (default in MySQL 8.0)
#
mysql_innodb_index_stats:
   query: "select database_name as schema_name,table_name,index_name,stat_value*@@innodb_page_size as size_bytes from mysql.innodb_index_stats where stat_name='size';"
   metrics:
    - table_name:
        usage: "LABEL"
        description: "Table name"
    - size_bytes:
        usage: "GAUGE"
        description: "Index Size in Bytes"
    - schema_name:
        usage: "LABEL"
        description: "Schema Name"
    - index_name:
        usage: "LABEL"
        description: "Index name"
mysql_innodb_index_stats_leaf:
   query: "select database_name as schema_name,table_name,index_name,stat_value*@@innodb_page_size as pages_size_bytes from mysql.innodb_index_stats where stat_name='n_leaf_pages';"
   metrics:
    - table_name:
        usage: "LABEL"
        description: "Table name"
    - pages_size_bytes:
        usage: "GAUGE"
        description: "Leaf Pages Size in Bytes"
    - schema_name:
        usage: "LABEL"
        description: "Schema Name"
    - index_name:
        usage: "LABEL"
        description: "Index name"

1 post - 1 participant

Read full topic