SQL Diagnosis

Updated on 2023-03-07 GMT+08:00

View PDF

Procedure

Log in to the DAS console.
On the Overview page, click Go to Intelligent O&M.
Select the target instance and click Details.
Choose SQL > SQL Diagnosis. On the displayed page, select your desired database, enter the SQL statements to be diagnosed, and click Diagnose. The diagnosis result page is displayed.
On the SQL Diagnosis page, enter SQL statements and click Execute. The system automatically executes the statements and displays a result set.
On the SQL Diagnosis page, enter multiple SQL statements and click Format. The system automatically formats all SQL statements.
On the SQL Diagnosis page, enter multiple SQL statements and click View Execution Plan. The system automatically executes all SQL statements in sequence.
NOTE:
- Only MySQL InnoDB is supported.
- Only the diagnosis of the SELECT, INSERT, UPDATE, and DELETE statements is supported. An INSERT statement must contain a SELECT clause.
- SQL statements for querying system databases like information_schema, test, and mysql are not supported.
- View statements are not supported.
- The SQL tuning function obtains the table structure and data distribution information (non-original). The obtained data is only for logic diagnosis, but not stored on the DAS server.
- Obtaining table structure and data distribution information may add additional loads to the DB instance, but has little impact on its performance.
- Only the SQL diagnosis history is stored on the DAS server. You can delete it from the server permanently.
- Format SQL: improves the readability of SQL statements. Formatting SQL statements enables statements to be displayed in line break mode, but does not change their logic and semantics.
  The formatting takes effect for all the SQL statements in the SQL window. You cannot format only the selected statements.