vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/das/umn/das_04_0074.html
Wang , Deng Ke 0f41701050 DAS UMN Initial version 
Reviewed-by: gtema <artem.goncharov@gmail.com>
Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com>
Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
2022-10-18 12:51:00 +00:00

4.6 KiB
Raw Permalink Blame History

Tuning SQL Statements

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

There is at least one SQL statement or character in the SQL window.

Procedure

  1. On the top menu bar, choose SQL Operations > SQL Window. In the SQL window, click Tune SQL.
  2. View the tuning result on the displayed SQL Tuning page, which is opened after the system automatically tunes the SQL statements.
  3. Click View Details to view diagnosis information.
  4. On the SQL Tuning page, click Add SQL Performance Tuning to add a SQL tuning task.
  5. On the displayed page, enter the SQL statements or upload a SQL file.

    Separate multiple SQL statements with semicolons (;) if you choose to enter SQL statements. Upload a file of no more than 100 MB if you choose to upload a SQL file.

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

    On the displayed diagnosis details page, view the tuning details, including the basic information, tuning status preview, tuning task list, and optimization suggestions.

    • SQL tuning has the following constraints:
      • 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.

Parent topic: SQL Operations