ApsaraDB for OceanBase:Optimization suggestions

Procedure

1. Log on to the ApsaraDB for OceanBase console.

2. In the left-side navigation pane, click OceanBase Autonomy Service.

3. In the Instance Details section, click the name of the target cluster instance.

4. In the left-side navigation pane, click Optimization Center.

   1. On the Optimization Center tab, you can view the performance exceptions of the tenants in the cluster in the last three days.

   2. In the tenant information section, you can view the response time of read/write requests, number of read/write requests, number of sessions, and CPU utilization of a specific tenant.

      1. Click Detection history in the upper-right corner to view the performance detection history.

         Click View Details in the Actions column of a detection task to view details about this detection.

      2. Click Initiate detection in the upper-right corner to start detection at the specified time.

         Note

         You can specify a custom period within the last 15 days as the time range for detection. The time range cannot exceed 24 hours.

   3. You can view the optimization suggestions and diagnostics reasons for SQL statements and schemas.

      • Click View SQL Diagnostics and go to the Real-time Diagnostics page to view details.

      • On the SQL Class tab, view information in the following columns: Optimization Objects, SQL ID, Optimization Type, Tenant, Database, CPU percentage, Response time ratio, Reasons for Diagnosis, and Optimization Suggestions.

      • On the Structural Class tab, view information in the following columns: Optimization Objects, Optimization Type, Tenant, Database, Reasons for Diagnosis, and Optimization Suggestions.