Help Center > > User Guide> MySQL DB Instance Management (Development Tool)> Intelligent O&M> SQL Tuning

SQL Tuning

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

Scenarios

SQL tuning helps you identify the SQL statements that are executed frequently or slowly, and consume large volumes of resources. You can optimize the database according to the diagnosis suggestions to ensure database stability.

Prerequisites

  • You have tuned SQL statements in the SQL window.

Procedure

  1. On the top menu bar, choose Intelligent O&M > SQL Tuning.

    Figure 1 SQL tuning-1

  2. On the SQL Tuning page, click Add SQL Performance Tuning to add a SQL tuning task. In the displayed dialog box, enter SQL statements or upload a SQL file as required, and then click OK.

    Figure 2 SQL tuning-2
    Figure 3 SQL tuning-3

  3. In the SQL tuning task list, select a database, specify a time range, and click Search to filter tuning reports. Click View Details in the Operation column to view tuning details.

    Figure 4 SQL tuning

    On the View Details page, you can view basic information of the tuning task, turning statuses, and tuned SQL statements.

    Figure 5 SQL tuning details

    In the tuned SQL list, locate the required SQL and click View Tuning Result Detail.

    Figure 6 Tuning details
    • 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.

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