An AnalyticDB for MySQL cluster collects various types of data. The collected data is used by the monitoring and alerting system to trace and troubleshoot issues.
Time series data collection
Time series data in processes
Computing resources: CPU utilization.
Storage resources: I/O throughput, I/O usage, IOPS, used storage, and storage usage.
Time series data in services
Various types of time series data in services is collected based on different roles of processes.
Time series data related to business: time series metrics related to data queries and writes. Time series metrics related to data queries include the queries per second (QPS), query response time, queuing time, planning time, and query failure rates. Time series metrics related to data writes include the transactions per second (TPS), number of BUILD INDEX jobs, and write response time.
Time series metrics related to compute nodes include the CPU utilization.
Time series metrics related to storage nodes include the CPU utilization and I/O metrics.
Log data collection
The following types of internal logs are collected and sent to Simple Log Service for centralized storage and processing:
Audit logs: record all operations, such as DDL and DML operations.
Query details logs: record detailed query information during execution, including the execution plan and memory and CPU consumption on each node.