Database Autonomy Service (DAS) uses machine learning and intelligent algorithms to monitor and predict the anomalies in the core metrics of database instances. DAS also provides the one-click diagnostics feature to help you identify root causes.
Prerequisites
- Your database instance is an ApsaraDB RDS for MySQL instance.
- The database instance is connected to DAS and is in the Accessed state. For more information, see Connect an Alibaba Cloud database instance to DAS.
Procedure
Metrics
DAS supports the following metrics for anomaly detection.
Metric | Description |
---|---|
tps | The transactions per second (TPS). |
qps | The queries per second (QPS). |
active_session | The number of active sessions. |
delete_ps | The average number of DELETE statements that are executed per second. |
insert_ps | The average number of INSERT statements that are executed per second. |
update_ps | The average number of UPDATE statements that are executed per second. |
select_ps | The average number of SELECT statements that are executed per second. |
bytes_received | The average number of bytes that are received from all clients per second. |
bytes_sent | The average number of bytes that are sent to all clients per second. |
innodb_bp_hit | The read hit ratio of the InnoDB buffer pool. |
innodb_data_written | The average number of bytes in the data that is written to InnoDB per second. |
innodb_data_read | The average number of bytes in the data that is read from InnoDB per second. |
mysql.innodb_log_writes | The average number of physical writes to the InnoDB redo log file per second. |
innodb_rows_deleted | The average number of InnoDB rows from which data is deleted per second. |
innodb_rows_read | The average number of InnoDB rows from which data is read per second. |
innodb_rows_inserted | The average number of InnoDB rows into which data is inserted per second. |
innodb_rows_updated | The average number of InnoDB rows in which data is updated per second. |
mysql.mem_usage | The memory usage of the ApsaraDB RDS for MySQL instance in the entire operating system. |
mysql.cpu_usage | The CPU utilization of MySQL processes. The maximum value of this metric is 100% for Alibaba Cloud database instances. |