All Products
Document Center

AnalyticDB for MySQL:Data collection

Last Updated:Jan 08, 2024

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.