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
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
[percona/pmm-server:2.43.2]
No errors or data indicating that the custom queries are loaded or not.
Query should show up in dashboard ( advanced-data-exploration)
Query is not found.
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