ApsaraDB RDS:Use automatic SQL optimization

How it works

DAS uses Online DDL statements supported by the native MySQL kernel to create indexes. This avoids the table locks that regular index creation can cause. For details, see SQL optimization technology.

DAS runs in two modes:

Enable automatic SQL optimization

1. Go to the Instances page. In the top navigation bar, select the region where your RDS instance resides. Find your instance and click its ID.

2. In the left-side navigation pane, choose Autonomy Services > Diagnostics. On the page that appears, click the Autonomy Center tab, then click Autonomy Service Settings.

3. On the Autonomous Function Settings tab, enable the autonomy service. On the Optimization and Throttling tab, select Automatic Index Creation and Deletion and choose a mode:

   • SQL Diagnostics Only: DAS diagnoses SQL daily and provides index optimization suggestions. No indexes are created.

   • SQL Diagnostics and Automatic Index Creation: DAS diagnoses SQL daily, provides index optimization suggestions, and creates indexes automatically within your maintenance window.

4. Click OK.

5. (Optional) In the Alert Configuration section, configure an alert template to receive notifications about automatic SQL optimization tasks. The system recommends an alert template and adds alert rules for the required autonomy events. Follow the prompts to configure it: If you already have an alert template configured for this instance, add the required autonomy event alert rules to that existing template. If you haven't configured one yet, see Configure alert templates and Configure alert rules.

   1. In the Select Alert Contact Group step, select an alert contact group. For more information, see Manage alert contacts.

      • Click Add Contact to add an alert contact.

      • Click Create Contact Group to create an alert contact group.

      • To update or remove an existing contact, find it in the list and click Edit or Remove in the Actions column.

   2. Confirm the settings in the Associate with Resources step.

   3. Click Submit Configuration and confirm in the dialog box.

View optimization results

On the Autonomy Center tab, view optimization events within a specified time range.

Find the event you want to review and click Details. On the Root Cause Analysis and Suggestions tab of the Slow SQL Statements Diagnostics (Diagnostics and Optimization) event, you can view:

• Problematic SQL Statements

• SQL Statement Optimization

• Index Recommendation

• Statement Optimization

API reference