Updated on 2025-09-15 GMT+08:00

SQL Diagnosis

DAS can diagnose SQL statements executed on databases.

Prerequisites

You have created an RDS for MySQL instance.

Procedure

  1. Log in to the console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner. Choose Databases > Data Admin Service.
  4. In the navigation pane, choose Intelligent O&M > Instance List.

    Alternatively, on the Overview page, click Go to Intelligent O&M.

  5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP address.
  6. Click the SQL tab and then SQL Diagnosis.
  7. Select a node and database. Enter the SQL statement to be diagnosed.

    Figure 1 SQL diagnosis

  8. Click Diagnose. In the displayed dialog box, click OK.

    Figure 2 Confirming SQL diagnosis

  9. On the Diagnosis Details page, check the database, diagnosis results, diagnosed SQL statement, execution plan, and table.

    Figure 3 SQL diagnosis details