Database Autonomy Service (DAS) uses machine learning and fine-grained monitoring to provide 24/7 anomaly detection, closed-loop diagnostics, and autonomy features such as automatic SQL optimization, SQL throttling, space expansion, and performance scaling. The following examples use an ApsaraDB RDS for MySQL instance.
Enable autonomy features
-
Log on to the DAS console.
-
In the left-side navigation pane, choose Intelligent O&M Center > Instance Monitoring.
Find the target instance and click the instance ID to open the instance details page.
In the navigation pane on the left, click Autonomy Center.
On the Autonomy Center page, click Autonomy Service Settings in the upper-right corner.
-
On the Autonomous Function Management page, enable the autonomy service.
-
On the Optimization and Throttling tab, enable the autonomy features that you need.
NoteThe available autonomy features vary depending on the database engine. For more information, see Supported database engines and features.
-
Select Auto Index Creation and Deletion and then SQL Diagnostics and Automatic Index Creation. DAS automatically diagnoses and optimizes SQL statements and creates indexes on your instance. For more information, see automatic SQL optimization.
-
Select Automatic Throttling and configure the throttling parameters. DAS automatically triggers SQL throttling when the specified conditions are met. For more information, see automatic SQL throttling.
-
Select Automatic Space Expansion and configure the parameters. DAS automatically expands the storage space of your database instance when it is insufficient. For more information, see automatic space expansion.
-
Select Automatic Performance Scaling and configure the parameters. DAS automatically scales the instance up or down based on the average CPU utilization. For more information, see automatic performance scaling.
-
-
On the Auto Scaling tab, create a policy and configure its parameters. After you apply the policy, DAS provides scaling recommendations based on your preset policy and automatically scales your instance up or down when its performance reaches the specified thresholds. For more information, see auto scaling.
NoteThe available auto scaling features vary depending on the database engine. For more information, see Supported database engines and features.
-
Click OK to save your autonomy settings.
-
(Optional) After you complete the settings, you can continue to Alert Settings. If you do not need to configure alerts, click Cancel. This action does not affect the autonomy features that you configured.
The system recommends an alert template and adds alert rules for the corresponding autonomy events. Follow the prompts to complete the configuration.
Note-
If you have already configured an alert template for the instance, follow the prompts to add alert rules for the corresponding autonomy events to the template.
-
If you want to configure an alert template and alert rules yourself, see Configure alert templates and Configure alert rules.
-
Select an Alert Contact Group to receive notifications.
-
Click Add Contact to add a new alert contact.
-
Click Add Contact Group to add a new alert contact group.
-
To update or delete a contact's information, click Modify or Remove next to the contact.
For more information, see Manage alert contacts.
-
-
Confirm the Associate with Resources.
-
Click Submit Configuration and confirm the alert configuration in the dialog box that appears.
-
View autonomy results
Log on to the DAS console.
In the navigation pane on the left, click .
Find the target instance and click the instance ID to open the instance details page.
In the navigation pane on the left, click Autonomy Center.
-
On the Autonomy Center page, select a time range to view all types of events from that period.
To view the details of an event, click Details in the event's row.
Disable autonomy features
-
Log on to the DAS console.
-
In the left-side navigation pane, choose Intelligent O&M Center > Instance Monitoring.
Find the target instance and click the instance ID to open the instance details page.
In the navigation pane on the left, click Autonomy Center.
On the Autonomy Center page, click Autonomy Service Settings in the upper-right corner.
-
On the Autonomous Function Management page, disable the autonomy service.
If you want to disable DAS Economy Edition or DAS Enterprise Edition, see Disable O&M Services (formerly DAS Economy Edition) or audit logs for a database instance.