You can use the diagnostics feature to learn about the load and health status of a tenant.
View diagnostic information
Go to the Clusters page of the ApsaraDB for OceanBase console.
Click the name of the target cluster to go to the cluster management page.
Click Diagnose in the left-side navigation pane. The diagnostics entry is displayed in the right-side panel.
On the diagnostics entry page, select the tenant that you want to diagnose, and click Diagnose next to it to go to the diagnostic details page. If no tenant is created in the cluster, the diagnostics entry page shows no tenant and you can click Create Tenant to create a tenant.
NoteBy default, monitoring statistics of the last six hours are displayed. You can also view the monitoring statistics of the last 5 minutes, last 30 minutes, and last hour. In addition, you can specify a custom period to query diagnostic information within the last 30 days.
If you need more capabilities such as one-click diagnostics, root cause analysis, and capacity prediction, click Autonomy Service. For more information about autonomy service, see Overview.
On the diagnostics overview page, click View Optimization Records in the upper-right corner to view optimization records.
On the Optimization Records page, you can view the optimization records of the current tenant. An optimization record displays the code, name of the owner tenant, database name, operation type, operation details, SQL ID, start time, end time, and current status of the relevant statement.
On the diagnostics overview page, view information of the Read/Write Request Response Time, Read/Write Requests, Sessions, and CPU parameters.
Parameter
Description
Read/Write Request Response Time
The write request response time (TPS RT) and read request response time (QPS RT), in milliseconds.
Read/Write Requests
The numbers of read requests and write requests.
Sessions
The maximum number of active sessions. Data is collected every 5s.
CPU
The maximum and average CPU utilization.
On the SQL tab, view the SQL analysis information of the tenant. For more information, see Overview.
On the Session Management tab, view the session information of the tenant. For more information, see Session management.
On the SQL Audit tab, view the SQL audit information. For more information, see SQL audit.