AnalyticDB for MySQL clusters collect two categories of data — time series metrics and internal logs — which the monitoring and alerting system uses to trace and troubleshoot issues.
Time series data collection
Time series data is collected at two levels: process-level resource metrics and service-level performance metrics.
Process metrics
| Resource type | Metrics |
|---|---|
| Computing | CPU utilization |
| Storage | I/O throughput, I/O usage, IOPS, used storage, storage usage |
Service metrics
Service metrics are collected based on different roles of processes.
Business metrics — cover data query and write performance:
| Operation | Metrics |
|---|---|
| Queries | Queries per second (QPS), query response time, queuing time, planning time, query failure rates |
| Writes | Transactions per second (TPS), number of BUILD INDEX jobs, write response time |
Node metrics — cover resource consumption per node type:
| Node type | Metrics |
|---|---|
| Compute nodes | CPU utilization |
| Storage nodes | CPU utilization, I/O metrics |
Log data collection
Internal logs are collected and sent to Simple Log Service for centralized storage and processing.
| Log type | What it records |
|---|---|
| Audit logs | All DDL and DML operations |
| Query details logs | Execution plan, memory and CPU consumption per node, recorded during execution |