View the Optimization Center page

This topic describes how to use the features on the Optimization Center page.

Prerequisites

Make sure that you have the following permissions:

• Resource Permissions : Cluster Read-only or Tenant Read-only permission
• Menu Permissions : Permission on the Optimization Center menu of OceanBase Autonomy Service

Procedure

1. Log on to the OceanBase Cloud Platform (OCP) console.

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

3. In the Cluster Details section, click the name of the cluster that you want to view.

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

5. On the Optimization Suggestions tab, you can view the following information:

   1. At the top of the page, you can view the optimization information related to exception events in the last three days in fields such as Object , Name , Behavior, Current Status, Occurrence Time, Recovery Time , and Duration .

   2. You can select one tenant or all tenants in the Tenants section to view the charts of information, such as the QPS, response time, number of sessions, and CPU utilization of the tenants.

      • QPS: the average number of SQL statements processed per second.
      • Response Time : the average processing time of an SQL statement.
      • Sessions : the number of tenant sessions.
      • Tenant CPU consumption: the percentage of the number of CPU cores occupied by the tenant to the number of CPU cores allocated to the tenant.

      You can move the pointer over a curve to view the information at that point in time, and click the zoom-in button in the upper right corner of a chart to zoom in the chart.

   3. In the upper-right corner of the section, you can select Last 5 Minutes , Last 30 Minutes , Last 1 Hour , or Last 6 Hours , or specify a custom period to view statistics within the specified period.

   4. In the section below the charts, you can view the optimization records of SQL statements and schemas in columns such as Optimization Type, Tenant , Database , Optimization Objects, Reasons for Diagnosis, and Optimization Suggestions .

   5. You can click View SQL Diagnostics to view real-time diagnostics information.

   

6. Click the Optimization Records tab.

   In the upper-right corner, specify a time range to view the corresponding optimization records in columns such as Operation Description , Tenant Name , Database Name , Operation Type , Operation Details , SQL ID, Operation Time , and Status . You can filter the optimization records by the operation type and status.