Database Autonomy Service (DAS) provides the autonomy center feature for ApsaraDB RDS for MySQL. You can enable the autonomy center feature for your ApsaraDB RDS for MySQL instance to query events that occurred within a specified time range. The events include exceptions, optimization events, and auto scaling events.
Prerequisites
Your RDS instance runs one of the following MySQL versions and RDS editions:
MySQL 8.0 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition
MySQL 5.7 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition
MySQL 5.6 on RDS High-availability Edition
MySQL 5.5 on RDS High-availability Edition
Background information
DAS monitors the core metrics of your RDS instance to detect anomalies. If an anomaly is detected, DAS checks sessions, SQL statements, and the capacity of the RDS instance to identify the cause. DAS also provides suggestions on how to optimize performance or mitigate the loss. You can authorize DAS to automatically optimize performance or mitigate the loss.
Procedure
- Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane, choose Autonomy Service > Diagnostics.
Click the Autonomy Center tab.
In the upper-right corner of the Autonomy Center tab, click Autonomy Service Settings.
On the tab of the Autonomous Function Settings panel, enable the autonomy service and click OK.
View events that occurred within a specified time range.
In the trend chart, view the duration of a specific event and the trends of the CPU Utilization, Active Sessions, and IOPS Usage parameters of the RDS instance when the event occurred.
Find the event that you want to view and click Details.
