Addition of more insightful metric for mysql operator

Products

• APM

Issue/Introduction

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

 

Environment

Release : 20.2

Component : APM Agents

Resolution

An enhancement request has been opened to add this functionality.