On the performance and SQL monitoring page 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 cluster 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
Metric type Metric name 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 (avg) - sql_all_rt
- sql_delete_rt
- sql_insert_rt
- sql_other_rt
- sql_replace_rt
- sql_select_rt
- sql_update_rt
ms - Average SQL statement processing time
- Average Delete statement processing time
- Average Insert statement processing time
- Average processing time of other statements such as DDL, DCL, and DTL statements
- Average Replace statement processing time
- Average Select statement processing time
- Average Update statement processing time
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 - Average SQL statement processing time
- Average Delete statement processing time
- Average Insert statement processing time
- Average processing time of other statements such as DDL, DCL, and DTL statements
- Average Replace statement processing time
- Average Select statement processing time
- Average Update statement processing time
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 - Average SQL statement processing time
- Average Delete statement processing time
- Average Insert statement processing time
- Average processing time of other statements such as DDL, DCL, and DTL statements
- Average Replace statement processing time
- Average Select statement processing time
- Average Update statement processing time
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 - Average SQL statement processing time
- Average Delete statement processing time
- Average Insert statement processing time
- Average processing time of other statements such as DDL, DCL, and DTL statements
- Average Replace statement processing time
- Average Select statement processing time
- Average Update statement processing time
Sessions - active_session
- all_session
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
Events
Metric type Metric name Unit Description Number of execution events in a database 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 tenant state
- Number of execution events in a parse state
- Number of execution events in a pl parse state
- Number of execution events in a plan cache state
- Number of execution events in an sql optimize state
- Number of execution events in an sql execution state
- Number of execution events in an px execution state
- Number of execution events in a sequence load state
Number of 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 IO 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 synchronous RPC wait events per second
- Number of wait events per second
Average wait event duration - system_event_internal_time_waited
- 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_rt
μs Average response time of read requests Number of SQL requests entering the wait 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
Wait time of SQL requests in the wait queue request_queue_time μs Wait time of SQL requests in the wait queue. Number of wait events - ob_waiteven_count
- ob_foreground_waitevent_count
- ob_background_waiteven_count
count - Number of wait events in a tenant state
- Number of wait events in a foreground tenant state
- Number of wait events in a background tenant state
System resources
Metric type Metric name Unit Description Tenant CPU Usage ob_cpu_percent % CPU usage of tenant threads. Percentage of MEMStore usage memstore_percent % Percentage of MEMStore usage. Number of open cursors opened_cursors_count count Number of open cursors. Storage resources
Metric type Metric name Unit Description OceanBase Tenant Memory Usage ob_tenant_memory_percent % Memory usage of an OceanBase tenant. RPC
Metric type Metric name Unit Description Duration of receiving and sending packets in an RPC - rpc_packet_in_rt
- rpc_packet_out_rt
μs - Average duration of receiving packets in an RPC
- Average duration of sending packets in an RPC
Amount of data in bytes received and sent in an RPC within a unit of time - rpc_packet_in
- rpc_packet_out
byte - Throughput of receiving packets in an RPC
- Throughput of sending packets in an RPC
- Database working status
Metric type Metric name Unit Description Database working time - ob_worktime
- ob_foreground_worktime
- ob_background_worktime
ms - 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
Replica lag ob_clog_ls_max_replayed_scn ms Replica lag.