On the Performance and SQL tab of a tenant, you can view basic information about the tenant and the monitoring data such as SQL execution information.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
On the Instances page, find the target instance and click the expand icon next to the instance name.
Find the target tenant and click the tenant name.
On the Overview page of the tenant, click Metrics in the left-side navigation pane.
By default, the Performance and SQL tab automatically appears and shows the monitoring data in the last hour.
You can view the following information:
SQL
Performance metric Metric name in English Unit Description QPS - sql_all_count
- sql_delete_count
- sql_insert_count
- sql_other_count
- sql_replace_count
- sql_select_count
- sql_update_count
times/s - Number of SQL statements processed per second
- Number of Delete statements processed per second
- Number of Insert statements processed per second
- Number of other statements (such as DDL, DCL, and DTL statements) processed per second
- Number of Replace statements processed per secondt
- Number of Select statements processed per second
- Number of Update statements processed per second
SQL response time - sql_all_rt
- sql_delete_rt
- sql_insert_rt
- sql_other_rt
- sql_replace_rt
- sql_select_rt
- sql_update_rt
ms - Average time consumed in processing SQL statements
- Average time consumed in processing Delete statements
- Average time consumed in processing Insert statements
- Average time consumed in processing other statements (such as DDL, DCL, and DTL statements)
- Average time consumed in processing Replace statements
- Average time consumed in processing Select statements
- Average time consumed in processing Update statements
Number of sessions - active_session
- all_session
times (count) - Number of active sessions
- Total number of sessions
Number of SQL execution plans - sql_distributed_count
- sql_local_count
- sql_remote_count
times/s - Number of distributed execution plans processed per second
- Number of local executions processed per second
- Number of remote execution plans processed per second
Number of execution events in a specific state ob_sql_event and others times (count) Number of execution events in a specific state Note
For more information about the supported states, see the monitoring page.
Events
Performance metric Metric name in English Unit Description Number of waiting events per second wait_event_count and others times/s Number of waiting events per second Note
For more information about the supported states, see the monitoring page.
Average waiting time wait_event_rt and others ms Average response time of read requests Note
For more information about the supported states, see the monitoring page.
Number of SQL requests entering the waiting queue per second - request_dequeue_count
- request_enqueue_count
times/s - Number of requests dequeued from the processing queue
- Number of requests enqueued into the processing queue
Request waiting time in the queue request_queue_time μs Waiting time of an SQL request in the waiting queue Number of waiting events ob_waitevent_count times (count) Number of waiting events System resources
Performance metric Metric name in English Unit Description CPU usage of the tenant thread ob_cpu_percent % CPU usage of the tenant thread MEMStore usage percentage memstore_percent % MEMStore usage percentage Number of open cursors opened_cursors_count times (count) Number of open cursors Storage resources
Performance metric Metric name in English Unit Description OceanBase Tenant Memory Usage ob_tenant_memory_percent % Memory usage of the OB tenant. RPC
Metric Metric Name Unit Description Rpc Packet In/Out Time - rpc_packet_in_rt
- rpc_packet_out_rt
μs - Average time taken to receive an Rpc packet
- Average time taken to send an Rpc packet
Rpc Packet In/Out Throughput - rpc_packet_in
- rpc_packet_out
byte - Throughput of Rpc packets received
- Throughput of Rpc packets sent
Database status
Metric Metric Name Unit Description Database Working Time - ob_worktime
- ob_foreground_worktime
- ob_background_worktime
s - Database working time
- Database foreground working time
- Database background working time
Database Non-idle Waiting Time - ob_no_idle_waiting_time
- ob_foreground_no_idle_waiting_time
- ob_background_no_idle_waiting_time
ms - Database non-idle waiting time
- Database foreground non-idle waiting time
- Database background non-idle waiting time
Database Waiting Events in a State - ob_waitevent_count
- ob_foreground_waitevent_count
- ob_background_waiteven_count
count - Number of waiting events in a state for the database
- Number of waiting events in a state for the database foreground
- Number of waiting events in a state for the database background
Replica Delay ob_clog_ls_max_replayed_scn ms Replica delay