Optimization suggestions

The Optimization Center displays the performance monitoring metrics of each tenant and provides optimization suggestions for SQL statements and schema. This topic describes how to view these optimization suggestions.

Background information

By default, the Optimization Center displays the results of the last successful detection task. After you initiate a detection task, the system identifies the top 100 slowest SQL statements in the query time period, performs an optimization check on them, and evaluates whether there is room for improvement for the related tables and indexes.

Procedure

1. Log in to the OceanBase Cloud console.

2. In the left-side navigation pane, click Instances.

3. In the instance list, find the target instance, click the instance name, and go to the instance overview page.

4. In the left-side navigation pane, click Diagnostics, and then select the Optimization Center tab on the Diagnostics page.

5. Click the Optimization Suggestion tab.

   1. In the tenant information section, view the QPS, Average SQL statement processing time, and CPU Usage of the specified tenant.

      1. Click Initiate detection in the upper-right corner to generate a detection task. This task identifies the SQL statements, tables, and indexes that match the specified rules in the specified time period and provides corresponding optimization suggestions.
      2. Click Detection History in the upper-right corner to view the history of detection tasks.

   2. View the optimization suggestions and diagnostic reasons for SQL class and Schema.

      • On the SQL class tab, view the Optimization Objects, SQL ID, Optimization Type, Database, CPU percentage (%), Proportion of Elapsed Time (%), Reasons for Diagnosis, and Optimization suggestions.

      • On the Schema tab, view the Optimization Objects, Optimization Type, Database, Reasons for Diagnosis, and Optimization suggestions.