ApsaraDB for OceanBase:Overview

Procedure

1. Log on to the ApsaraDB for OceanBase console.

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

3. On the Instances page, click the target instance name to enter the instance workbench.

4. In the left-side navigation pane, click Diagnostics.

5. On the Diagnostics page, select the target tenant from the drop-down list.

   Note

   • By default, the system displays the diagnostic data for the last 6 hours. You can also select Last 5 Minutes, Last Half Hour, Last Hour, or Custom Time.

   • If you need more features, such as one-click diagnostics, root cause analysis, capacity forecast, etc., click Autonomous Service.

6. View the diagnostic data of the target tenant, including: QPS, Average SQL Statement Processing Time, and CPU Percent.

   

7. Click View Optimization Records in the upper-right corner of the Diagnostics page to view historical optimization records.

   On the Optimization Records page, view the optimization records of the current tenant, including: SQL Text, SQL ID, Tenant Name, Database Name, Operation Type, Operation Details, Task Start Time, Task End Time, and Status.

   

8. On the SQL tab, view the SQL analysis information of the tenant. For more information, see SQL basic information.

9. On the Session Management tab, view the session information of the tenant. For more information, see Session management.

10. On the SQL Audit tab, view the SQL audit information. For more information, see SQL audit.