SQL Diagnosis

Precautions

• This function is available only to MySQL InnoDB.
• Only SELECT, INSERT, UPDATE, and DELETE statements can be diagnosed. An INSERT statement must contain a SELECT clause.
• SQL statements for querying system databases like information_schema, test, and mysql cannot be diagnosed.
• SQL statements that contain views cannot be diagnosed.
• SQL Diagnosis obtains table structures and data distribution information (non-original). The obtained data is only for logic diagnosis, but not stored on the DAS server.
• Obtaining table structures and data distribution information may cause additional load to your instance, but has little impact on its performance.
• SQL diagnosis history is stored on the DAS server only. If you delete SQL diagnosis history on the console, it will be also deleted from the DAS server.
• SQL formatting improves readability of SQL statements. Formatting SQL statements enables statements to be displayed in line break mode, but does not change their logic and semantics.
• SQL formatting takes effect for all the SQL statements in the SQL window. You cannot format only one selected statement.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click 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.
   Figure 1 Searching for instances
   

6. Locate the box containing your target instance and click Details.
7. In the upper right corner of the page, click Go to Old Edition.
   Figure 2 Accessing Intelligent O&M of the old version
   

8. Choose SQL > SQL Diagnosis. On the displayed dialog box, perform the following operations:
   • On the SQL Diagnosis tab page, select the database where you want to diagnose a SQL statement, enter a SQL statement, and click Diagnose. The diagnosis result page is displayed.
     Figure 3 SQL diagnosis
     
   • Select a database where you want to execute a SQL statement, enter a SQL statement, and click Execute. The system executes the statement and displays a result set.
     Figure 4 SQL execution result set
     
   • Select the database where you want to format SQL statements, enter SQL statements, and click Format. The system formats all the SQL statements.
   • Select the database where you want to view the SQL execution plan, enter SQL statements, and click View Execution Plan. The system executes all the SQL statements in sequence.