We were exploring available standard list of custom metrics available using UMA Agent's mysql extension.
Document we referring:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/dx-apm-saas/SaaS/implementing-agents/infrastructure-agent/mysql-database-monitoring.html
It is observed that some additional insightful metrics are missing from standard list.
Below is the list of such metrics:
- PMM Query Analytics
- Transaction history length
- Disk Space
We have internally deployed a PMM Server at our end as it supports the metrics we were requesting.
Below is the list of metrics we are obtaining from that client :
- Percona pxc node disk space remaining
- Percona number of pxc nodes
- Percona transaction history length
- Cloud SQL availability (uptime change)
- Cloud SQL transaction history length
- Cloud SQL Replication delay
- CPU usage tracking
- Cloud SQL Availability of MySQL (connect, SELECT 1)
- Percona pxc node count < 3
- Percona disk size
PMM Documentation:
https://www.percona.com/doc/percona-monitoring-and-management/2.x/how-to/configure.html#communication
Release : 20.2
Component : APM Agents
An enhancement request has been opened to add this functionality.