Help Center > > User Guide> MySQL Database Management> SQL Operations> SQL Tuning

SQL Tuning

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

SQL tuning is used to query the SQL statements that are executed frequently, consume a large amount of resources, or take a long time to execute.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. On the top menu bar, choose SQL Operation > SQL Window.
  2. Select a specified database, or select a database from the navigation pane on the left.
  3. In the SQL window, enter the SQL statement to be executed and click SQL Tuning to diagnose the current SQL statement.

    Your sensitive data will not be queried or stored during SQL tuning.

  4. After the diagnosis is complete, the SQL Tuning page is displayed. Select the start date and end date and then click Search to filter the diagnosis report.
  5. In the diagnosis list, view the details of the SQL statement in the SQL column and obtain detailed information about the diagnosis in the Result column.

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