On the Performance and SQL Monitoring details page of an OceanBase Cloud tenant, you can view monitoring data such as the tenant's basic information and SQL execution status.
View tenant performance and SQL monitoring details
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the cluster list, find the target cluster and click the expand icon next to its name.
In the expanded cluster, find the target tenant and click its name.
In the left-side navigation pane of the tenant workspace, click Metrics.
The Performance Monitoring page displays the Performance and SQL tabs by default, showing monitoring information from the last hour.
You can view the following information:
SQL
Performance metricMetric IDUnitDescriptionQPS - sql_all_count
- sql_delete_count
- sql_insert_count
- sql_other_count
- sql_replace_count
- sql_select_count
- sql_update_count
times/s - The number of SQL statements processed per second.
- The number of DELETE statements processed per second.
- The number of INSERT statements processed per second.
- The number of other statements such as DDL, DCL, and DTL statements.
- The number of REPLACE statements processed per second.
- The number of SELECT statements processed per second.
- The number of UPDATE statements processed per second.
SQL Response Time (avg) - sql_all_rt
- sql_delete_rt
- sql_insert_rt
- sql_other_rt
- sql_replace_rt
- sql_select_rt
- sql_update_rt
ms The average value is currently supported. - The average time consumed in processing an SQL statement.
- The average time consumed in processing a DELETE statement.
- The average time consumed in processing an INSERT statement.
- The average time consumed in processing other statements such as DDL, DCL, and DTL statements.
- The average time consumed in processing a REPLACE statement.
- The average time consumed in processing a SELECT statement.
- The average time consumed in processing an UPDATE statement.
SQL Response Time (P90) - sql_all_rt_p90
- sql_delete_rt_p90
- sql_insert_rt_p90
- sql_other_rt_p90
- sql_replace_rt_p90
- sql_select_rt_p90
- sql_update_rt_p90
ms - P90 response time for all SQL statements
- P90 response time for DELETE statements
- P90 response time for INSERT statements
- P90 response time for other statements
- P90 response time for REPLACE statements
- P90 response time for SELECT statements
- P90 response time for UPDATE statements
SQL Response Time (P95) - sql_all_rt_p95
- sql_delete_rt_p95
- sql_insert_rt_p95
- sql_other_rt_p95
- sql_replace_rt_p95
- sql_select_rt_p95
- sql_update_rt_p95
ms - P95 response time for all SQL statements
- P95 response time for DELETE statements
- P95 response time for INSERT statements
- P95 response time for other statements
- P95 response time for REPLACE statements
- P95 response time for SELECT statements
- P95 response time for UPDATE statements
SQL Response Time (P99) - sql_all_rt_p99
- sql_delete_rt_p99
- sql_insert_rt_p99
- sql_other_rt_p99
- sql_replace_rt_p99
- sql_select_rt_p99
- sql_update_rt_p99
ms - P99 response time for all SQL statements
- P99 response time for DELETE statements
- P99 response time for INSERT statements
- P99 response time for other statements
- P99 response time for REPLACE statements
- P99 response time for SELECT statements
- P99 response time for UPDATE statements
Sessions - active_session
- all_session
Count (count) - The current number of active sessions.
- The total number of sessions.
Number of SQL Execution Plans - sql_distributed_count
- sql_local_count
- sql_remote_count
times/s - The number of distributed execution plans processed per second.
- The number of local execution plans processed per second.
- The number of remote execution plans processed per second.
Events
Performance metricMetric nameUnitDescriptionNumber of Execution Events in a Specific State - ob_sql_event
- ob_sql_event_in_parse
- ob_sql_event_in_pl_parse
- ob_sql_event_in_plan_cache
- ob_sql_event_in_sql_optimize
- ob_sql_event_in_sql_execution
- ob_sql_event_in_px_execution
- ob_sql_event_in_sequence_load
Count - Number of execution events in a specific state for the tenant.
- Number of execution events in the parse state for the tenant.
- Number of execution events in the pl-parse state for the tenant.
- Number of execution events in the plan cache state for the tenant.
- Number of execution events in the sql-optimize state for the tenant.
- Number of execution events in the sql-execution state for the tenant.
- Number of execution events in the px-execution state for the tenant.
- Number of execution events in the sequence-load state for the tenant.
Wait events per second - system_event_internal_total_waits
- system_event_io_total_waits
- system_event_latch_total_waits
- system_event_other_total_waits
- system_event_row_lock_wait_total_waits
- system_event_sync_rpc_total_waits
- wait_event_count
times/s - Number of internal wait events per second.
- Number of I/O wait events per second.
- Number of latch wait events per second.
- Number of other wait events per second.
- Number of lock wait events per second.
- Number of synchronization RPC wait events per second.
- Number of wait events per second.
Average Wait Event Latency - wait_event_rt
- system_event_other_time_waites
- system_event_application_time_waites
- system_event_configuration_time_waites
- system_event_administrative_time_waites
- system_event_concurrency_waites
- system_event_commit_waites
- system_event_idle_waites
- system_event_network_waites
- system_event_user_io_waites
- system_event_system_io_waites
- system_event_scheduler_waites
ms - Average wait event latency
- Average other wait event latency
- Average application wait event latency
- Average configuration wait event latency
- Average administrative wait event latency
- Average concurrency wait event latency
- Average commit wait event latency
- Average idle wait event latency
- Average network wait event latency
- Average user I/O wait event latency
- Average system I/O wait event latency
- Average scheduler wait event latency
SQL requests queued per second - request_dequeue_count
- request_enqueue_count
times/s - Number of requests dequeuing from the processing queue.
- Number of requests queuing into the processing queue.
Wait Time of SQL Requests in the Queue request_queue_time μs The wait time of SQL requests in the queue. Wait events - ob_waitevent_count
- ob_foreground_waitevent_count
- ob_background_waitevent_count
Count - Number of wait events in a specific state for the tenant database.
- Number of wait events in a specific state for the foreground tenant database.
- Number of wait events in a specific state for the background tenant database.
System resources
Performance metricMetric nameUnitDescriptionTenant CPU Usage ob_cpu_percent Percentage (%) The CPU usage of tenant threads. MemStore utilization memstore_percent Percentage (%) The percentage of MemStore usage. Number of Open Cursors opened_cursors_count Count The number of open cursors. Storage resources
Performance metricMetric nameUnitDescriptionOceanBase Tenant Memory Usage ob_tenant_memory_percent Percentage (%) The memory usage of the OB tenant. RPC
Performance metricMetric nameUnitDescriptionRPC send/receive latency - rpc_packet_in_rt
- rpc_packet_out_rt
μs - Average time consumed in receiving an RPC packet.
- Average time consumed in sending an RPC packet.
RPC send/receive throughput - rpc_packet_in
- rpc_packet_out
Byte - RPC packet receiving throughput.
- RPC packet sending throughput.
Database Work Status
Performance metricMetric nameUnitDescriptionDatabase Working Time - ob_worktime
- ob_foreground_worktime
- ob_background_worktime
ms - Database working time.
- Foreground database working time.
- Background database working time.
Non-idle Waiting Time of the Database - ob_no_idle_waiting_time
- ob_foreground_no_idle_waiting_time
- ob_background_no_idle_waiting_time
ms - Non-idle waiting time of the database.
- Non-idle waiting time of the foreground database.
- Non-idle waiting time of the background database.
Replica Latency ob_clog_ls_max_replayed_scn ms Replica latency.