On the performance monitoring page of a tenant in OceanBase Cloud, you can configure commonly used monitoring metrics as custom dashboards.
Manage custom dashboards
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
On the Instances page, click the expand icon next to the target instance name.
Find the target tenant and click its name.
In the left-side navigation pane of the Overview page of the tenant, click Metrics.
On the Custom Dashboards tab, you can:
Create a custom dashboard
On the Custom Dashboards page, click Create Custom Dashboard.
Enter a dashboard name and select the tenant and metrics to monitor. For detailed metric descriptions, see Tenant monitoring metrics.
Note
- Dashboard names cannot exceed 20 characters.
- You can create up to 7 custom monitoring dashboards.
Click OK.
View custom dashboards
On the Custom Dashboards tab, you can manage your custom dashboards. Use the Select Dashboard dropdown to choose which dashboard to view.
Edit a custom dashboard
On the Custom Dashboards page, select the dashboard you want to modify.
Click Edit Current Dashboard.
On the Edit Custom Dashboard page, modify the dashboard name, tenant, and metrics as needed. For detailed metric descriptions, see Tenant monitoring metrics.
Click OK.
Delete a custom dashboard
On the Custom Dashboards page, select the dashboard you want to delete.
Click the menu icon next to the dashboard name and select Delete Current Dashboard.
In the confirmation dialog box, click OK.
Tenant monitoring metrics
| Category | Metric name | Description |
|---|---|---|
| Performance & SQL | single_kv_delete_count | Average number of single deletes per second |
| Performance & SQL | single_kv_insert_count | Average number of single inserts per second |
| Performance & SQL | single_kv_select_count | Average number of single selects per second |
| Performance & SQL | single_kv_update_count | Average number of single updates per second |
| Performance & SQL | single_kv_insert_or_update_count | Average number of single insert-or-updates per second |
| Performance & SQL | single_kv_replace_count | Average number of single replaces per second |
| Performance & SQL | single_kv_increment_count | Average number of single increments per second |
| Performance & SQL | single_kv_append_count | Average number of single appends per second |
| Performance & SQL | single_kv_all_count | Average number of all single operations per second |
| Performance & SQL | single_kv_delete_rt | Average response time for single deletes |
| Performance & SQL | single_kv_insert_rt | Average response time for single inserts |
| Performance & SQL | single_kv_select_rt | Average response time for single selects |
| Performance & SQL | single_kv_update_rt | Average response time for single updates |
| Performance & SQL | single_kv_insert_or_update_rt | Average response time for single insert-or-updates |
| Performance & SQL | single_kv_increment_rt | Average response time for single increments |
| Performance & SQL | single_kv_append_rt | Average response time for single appends |
| Performance & SQL | single_kv_all_rt | Average response time for all single operations |
| Performance & SQL | single_kv_delete_rt_p99 | 99th percentile response time for single deletes |
| Performance & SQL | single_kv_insert_rt_p99 | 99th percentile response time for single inserts |
| Performance & SQL | single_kv_select_rt_p99 | 99th percentile response time for single selects |
| Performance & SQL | single_kv_update_rt_p99 | 99th percentile response time for single updates |
| Performance & SQL | single_kv_insert_or_update_rt_p99 | 99th percentile response time for single insert-or-updates |
| Performance & SQL | single_kv_increment_rt_p99 | 99th percentile response time for single increments |
| Performance & SQL | single_kv_append_rt_p99 | 99th percentile response time for single appends |
| Performance & SQL | single_kv_all_rt_p99 | 99th percentile response time for all single operations |
| Performance & SQL | single_kv_delete_rt_p95 | 95th percentile response time for single deletes |
| Performance & SQL | single_kv_insert_rt_p95 | 95th percentile response time for single inserts |
| Performance & SQL | single_kv_select_rt_p95 | 95th percentile response time for single selects |
| Performance & SQL | single_kv_update_rt_p95 | 95th percentile response time for single updates |
| Performance & SQL | single_kv_insert_or_update_rt_p95 | 95th percentile response time for single insert-or-updates |
| Performance & SQL | single_kv_increment_rt_p95 | 95th percentile response time for single increments |
| Performance & SQL | single_kv_append_rt_p95 | 95th percentile response time for single appends |
| Performance & SQL | single_kv_all_rt_p95 | 95th percentile response time for all single operations |
| Performance & SQL | single_kv_delete_rt_p90 | 90th percentile response time for single deletes |
| Performance & SQL | single_kv_insert_rt_p90 | 90th percentile response time for single inserts |
| Performance & SQL | single_kv_select_rt_p90 | 90th percentile response time for single selects |
| Performance & SQL | single_kv_update_rt_p90 | 90th percentile response time for single updates |
| Performance & SQL | single_kv_insert_or_update_rt_p90 | 90th percentile response time for single insert-or-updates |
| Performance & SQL | single_kv_increment_rt_p90 | 90th percentile response time for single increments |
| Performance & SQL | single_kv_append_rt_p90 | 90th percentile response time for single appends |
| Performance & SQL | single_kv_all_rt_p90 | 90th percentile response time for all single operations |
| Performance & SQL | multi_kv_delete_count | Average number of batch deletes per second |
| Performance & SQL | multi_kv_insert_count | Average number of batch inserts per second |
| Performance & SQL | multi_kv_select_count | Average number of batch selects per second |
| Performance & SQL | multi_kv_update_count | Average number of batch updates per second |
| Performance & SQL | multi_kv_insert_or_update_count | Average number of batch insert-or-updates per second |
| Performance & SQL | multi_kv_replace_count | Average number of batch replaces per second |
| Performance & SQL | multi_kv_increment_count | Average number of batch increments per second |
| Performance & SQL | multi_kv_append_count | Average number of batch appends per second |
| Performance & SQL | multi_kv_all_count | Average number of all batch operations per second |
| Performance & SQL | multi_kv_delete_rt | Average response time for batch deletes |
| Performance & SQL | multi_kv_insert_rt | Average response time for batch inserts |
| Performance & SQL | multi_kv_select_rt | Average response time for batch selects |
| Performance & SQL | multi_kv_update_rt | Average response time for batch updates |
| Performance & SQL | multi_kv_insert_or_update_rt | Average response time for batch insert-or-updates |
| Performance & SQL | multi_kv_replace_rt | Average response time for batch replaces |
| Performance & SQL | multi_kv_increment_rt | Average response time for batch increments |
| Performance & SQL | multi_kv_append_rt | Average response time for batch appends |
| Performance & SQL | multi_kv_all_rt | Average response time for all batch operations |
| Performance & SQL | multi_kv_delete_row | Average number of rows in batch deletes |
| Performance & SQL | multi_kv_insert_row | Average number of rows in batch inserts |
| Performance & SQL | multi_kv_select_row | Average number of rows in batch selects |
| Performance & SQL | multi_kv_update_row | Average number of rows in batch updates |
| Performance & SQL | multi_kv_insert_or_update_row | Average number of rows in batch insert-or-updates |
| Performance & SQL | multi_kv_replace_row | Average number of rows in batch replaces |
| Performance & SQL | multi_kv_increment_row | Average number of rows in batch increments |
| Performance & SQL | multi_kv_append_row | Average number of rows in batch appends |
| Performance & SQL | multi_kv_all_row | Average number of rows in all batch operations |
| Performance & SQL | batch_kv_select_count | Average number of mixed batch selects per second |
| Performance & SQL | batch_kv_hybrid_count | Average number of mixed batch hybrid operations per second |
| Performance & SQL | batch_kv_all_count | Average number of all mixed batch operations per second |
| Performance & SQL | batch_kv_select_rt | Average response time for mixed batch selects |
| Performance & SQL | batch_kv_hybrid_rt | Average response time for mixed batch hybrid operations |
| Performance & SQL | batch_kv_all_rt | Average response time for all mixed batch operations |
| Performance & SQL | batch_kv_select_row | Average number of rows in mixed batch selects |
| Performance & SQL | batch_kv_hybrid_row | Average number of rows in mixed batch hybrid operations |
| Performance & SQL | batch_kv_all_row | Average number of rows in all mixed batch operations |
| Performance & SQL | query_kv_select_count | Average number of queries per second |
| Performance & SQL | query_kv_select_rt | Average query response time |
| Performance & SQL | query_kv_select_row | Average number of rows per query |
| Performance & SQL | query_and_muate_kv_select_count | Average number of query-and-mutate operations per second |
| Performance & SQL | query_and_muate_kv_select_rt | Average response time for query-and-mutate operations |
| Performance & SQL | query_and_muate_kv_select_row | Average number of rows in query-and-mutate operations |
| Performance & SQL | sql_all_count | Number of SQL statements processed per second |
| Performance & SQL | sql_delete_count | Number of DELETE statements processed per second |
| Performance & SQL | sql_insert_count | Number of INSERT statements processed per second |
| Performance & SQL | sql_other_count | Number of other statements (DDL, DCL, DTL) per second |
| Performance & SQL | sql_replace_count | Number of REPLACE statements processed per second |
| Performance & SQL | sql_select_count | Number of SELECT statements processed per second |
| Performance & SQL | sql_update_count | Number of UPDATE statements processed per second |
| Performance & SQL | sql_all_rt | Average SQL statement processing time |
| Performance & SQL | sql_delete_rt | Average DELETE statement processing time |
| Performance & SQL | sql_insert_rt | Average INSERT statement processing time |
| Performance & SQL | sql_other_rt | Average processing time for other statements (DDL, DCL, DTL) |
| Performance & SQL | sql_replace_rt | Average REPLACE statement processing time |
| Performance & SQL | sql_select_rt | Average SELECT statement processing time |
| Performance & SQL | sql_update_rt | Average UPDATE statement processing time |
| Performance & SQL | p99_sql_all_rt | 99th percentile SQL statement processing time |
| Performance & SQL | active_session | Number of active sessions |
| Performance & SQL | all_session | Total number of sessions |
| Performance & SQL | sql_distributed_count | Number of distributed execution plans per second |
| Performance & SQL | sql_local_count | Number of local executions per second |
| Performance & SQL | sql_remote_count | Number of remote execution plans per second |
| Performance & SQL | system_event_internal_total_waits | Number of internal wait events per second |
| Performance & SQL | system_event_io_total_waits | Number of I/O wait events per second |
| Performance & SQL | system_event_latch_total_waits | Number of latch wait events per second |
| Performance & SQL | system_event_other_total_waits | Number of other wait events per second |
| Performance & SQL | system_event_row_lock_wait_total_waits | Number of lock wait events per second |
| Performance & SQL | system_event_sync_rpc_total_waits | Number of sync RPC wait events per second |
| Performance & SQL | wait_event_count | Total number of wait events per second |
| Performance & SQL | system_event_internal_time_waited | Average internal wait event time |
| Performance & SQL | system_event_io_time_waited | Average I/O wait event time |
| Performance & SQL | system_event_latch_time_waited | Average latch wait event time |
| Performance & SQL | system_event_other_time_waited | Average other wait event time |
| Performance & SQL | system_event_row_lock_wait_time_waited | Average lock wait event time |
| Performance & SQL | system_event_sync_rpc_time_waited | Average sync RPC wait event time |
| Performance & SQL | wait_event_rt | Average wait event time |
| Performance & SQL | request_dequeue_count | Number of requests dequeued from processing queue |
| Performance & SQL | request_enqueue_count | Number of requests enqueued to processing queue |
| Performance & SQL | request_queue_time | SQL request queue wait time |
| Performance & SQL | ob_cpu_percent | Tenant thread CPU usage |
| Performance & SQL | memstore_percent | MemStore usage percentage |
| Performance & SQL | rpc_packet_in_rt | Average RPC packet receive time |
| Performance & SQL | rpc_packet_out_rt | Average RPC packet send time |
| Performance & SQL | rpc_packet_in | RPC incoming packet throughput |
| Performance & SQL | rpc_packet_out | RPC outgoing packet throughput |
| Performance & SQL | opened_cursors_count | Number of open cursors |
| Performance & SQL | ob_worktime | Database work time |
| Performance & SQL | ob_foreground_worktime | Database foreground work time |
| Performance & SQL | ob_background_worktime | Database background work time |
| Performance & SQL | ob_no_idle_waiting_time | Database non-idle wait time |
| Performance & SQL | ob_foreground_no_idle_waiting_time | Database foreground non-idle wait time |
| Performance & SQL | ob_background_no_idle_waiting_time | Database background non-idle wait time |
| Performance & SQL | ob_waiteven_count | Number of database wait events in specific states |
| Performance & SQL | ob_foreground_waitevent_count | Number of database foreground wait events in specific states |
| Performance & SQL | ob_background_waiteven_count | Number of database background wait events in specific states |
| Performance & SQL | ob_sql_eventt | Number of tenant execution events in specific states |
| Performance & SQL | ob_sql_event_in_parse | Number of execution events in parse state |
| Performance & SQL | ob_sql_event_in_pl_parse | Number of execution events in PL parse state |
| Performance & SQL | ob_sql_event_in_plan_cache | Number of execution events in plan cache state |
| Performance & SQL | ob_sql_event_in_sql_optimize | Number of execution events in SQL optimize state |
| Performance & SQL | ob_sql_event_in_sql_execution | Number of execution events in SQL execution state |
| Performance & SQL | ob_sql_event_in_px_execution | Number of execution events in parallel execution state |
| Performance & SQL | ob_sql_event_in_sequence_load | Number of execution events in sequence load state |
| Performance & SQL | ob_sql_event_in_committing | Number of execution events in committing state |
| Performance & SQL | ob_sql_event_in_storage_read | Number of execution events in storage read state |
| Performance & SQL | ob_sql_event_in_storage_write | Number of execution events in storage write state |
| Performance & SQL | ob_sql_event_in_remote_das_execution | Number of execution events in remote DAS execution state |
| Performance & SQL | ob_sql_event_in_plsql_compilation | Number of execution events in PL/SQL compilation state |
| Performance & SQL | ob_sql_event_in_plsql_execution | Number of execution events in PL/SQL execution state |
| Performance & SQL | slow_sql_count | Number of slow SQL queries |
| Transaction | transaction_commit_count | Number of transactions committed per second |
| Transaction | transaction_count | Transactions per second (TPS) |
| Transaction | transaction_rollback_count | Number of transactions rolled back per second |
| Transaction | transaction_timeout_count | Number of transactions timed out per second |
| Transaction | transaction_commit_rt | Average transaction commit time |
| Transaction | transaction_rollback_rt | Average transaction rollback time |
| Transaction | transaction_rt | Average server-side transaction processing time |
| Transaction | trans_commit_log_count | Number of transaction logs committed per second |
| Transaction | clog_trans_log_total_size | Size of transaction logs committed per second |
| Transaction | memstore_write_lock_fail_count | Number of failed write lock waits |
| Transaction | memstore_write_lock_succ_count | Number of successful write lock waits |
| Transaction | memstore_write_lock_wait_time | Average write lock wait time |
| Transaction | transaction_multi_partition_count | Number of distributed transactions per second |
| Transaction | transaction_single_partition_count | Number of single-partition transactions per second |
| Transaction | trans_commit_log_sync_rt | Average transaction log network sync time |
| Storage & Cache | active_memstore_used | Active MemStore size |
| Storage & Cache | major_freeze_trigger | Major compaction trigger threshold |
| Storage & Cache | memstore_limit | MemStore limit |
| Storage & Cache | total_memstore_used | Total MemStore size |
| Storage & Cache | io_read_count | SSStore reads per second |
| Storage & Cache | io_write_count | SSStore writes per second |
| Storage & Cache | io_read_rt | Average SSStore read time |
| Storage & Cache | io_write_rt | Average SSStore write time |
| Storage & Cache | io_read_size | SSStore read throughput per second |
| Storage & Cache | io_write_size | SSStore write throughput per second |
| Storage & Cache | block_cache_size | Block cache size |
| Storage & Cache | bloom_filter_cache_size | Bloom filter cache size |
| Storage & Cache | clog_cache_size | Clog cache size |
| Storage & Cache | location_cache_size | Location cache size |
| Storage & Cache | plan_cache_size | Execution plan cache size |
| Storage & Cache | row_cache_size | Row cache size |
| Storage & Cache | block_cache_hit_ratio | Block cache hit ratio |
| Storage & Cache | bloom_filter_cache_hit_ratio | Bloom filter cache hit ratio |
| Storage & Cache | clog_cache_hit_ratio | Clog cache hit ratio |
| Storage & Cache | location_cache_hit_ratio | Location cache hit ratio |
| Storage & Cache | plan_cache_hit_ratio | Execution plan cache hit ratio |
| Storage & Cache | row_cache_hit_ratio | Row cache hit ratio |
| Storage & Cache | block_cache_req_total | Number of block cache requests |
| Storage & Cache | bloom_filter_cache_req_total | Number of Bloom filter cache requests |
| Storage & Cache | clog_cache_req_total | Number of Clog cache requests |
| Storage & Cache | location_cache_req_total | Number of location cache requests |
| Storage & Cache | row_cache_req_total | Number of row cache requests |
| Storage & Cache | ob_tenant_binlog_disk_used | Binlog disk usage |
| Storage & Cache | ob_tenant_memory_percent | OB tenant memory usage |
| Storage & Cache | ob_tenant_log_disk_total_bytes | Total log disk size |
| Storage & Cache | ob_tenant_log_disk_used_bytes | Log disk usage |
| Storage & Cache | ob_tenant_disk_used_percentage | Data space usage |
| Storage & Cache | ob_tenant_data_size | Data volume |