Help Center > > User Guide> Intelligent O&M> Intelligent O&M for RDS for MySQL and GaussDB(for MySQL) DB Instances> SQL> SQL Diagnosis

SQL Diagnosis

Updated at: Jun 09, 2021 GMT+08:00

Procedure

  1. Log in to the DAS console using your username and password.
  2. On the Overview page, click Go to Intelligent O&M.
  3. Locate your desired instance and click Details to go to the Intelligent O&M overview page.
  4. 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.

    Figure 1 SQL Diagnosis

  5. On the SQL Diagnosis page, enter SQL statements and click Execute. The system automatically executes the statements and displays a result set.

    Figure 2 SQL execution result set

  6. On the SQL Diagnosis page, enter multiple SQL statements and click Format. The system automatically formats all SQL statements.
  7. On the SQL Diagnosis page, enter multiple SQL statements and click Execute. The system automatically executes all SQL statements in sequence.

    • 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.
    • Querying stored SQL statements such as information_schema, test, mysql, is 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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel