On the tenant performance monitoring page of OceanBase Cloud, you can configure common monitoring metrics as needed to create a custom monitoring dashboard.
Manage custom dashboards
Log in to OceanBase Cloud.
In the left-side navigation pane, click Instances.
In the instance list, find the target instance and click the expand button to its left.
Under the expanded instance, locate the target tenant and click its name.
In the left-side navigation pane of the tenant workspace, click Metrics.
On the Custom Dashboard tab, manage your dashboards.
Add a custom dashboard
On the Custom Dashboard page, click Create Custom Dashboard.
The interface is as follows when creating a custom dashboard for the first time:
If a custom dashboard already exists, the interface is as follows:
Enter a dashboard name, select the tenant to monitor, and choose the monitoring metrics. For detailed descriptions of the monitoring metrics, see Tenant monitoring metrics list.
Note
- The dashboard name cannot exceed 20 characters in length.
- You can create up to 7 custom monitoring dashboards.
Click OK.
View a custom dashboard
On the Custom Dashboard tab, you can manage custom dashboards. Use Select Dashboard to specify the custom dashboard you want to view.
Edit a custom dashboard
On the Custom Dashboard page, select the dashboard you want to modify.
Click Edit Dashboard.
On the Edit Custom Dashboard page, edit the dashboard name, tenant, and metrics. For detailed descriptions of monitoring metrics, see Tenant monitoring metrics list.
Click OK.
Delete a custom dashboard
On the Custom Dashboard page, select the dashboard you want to delete.
Click the menu next to the custom dashboard and select Delete Dashboard.
In the confirmation dialog box, click OK.
Tenant monitoring metrics list
Monitoring Metrics Classification |
Monitoring Metric Name |
unit |
Metric description |
|---|---|---|---|
| Performance and SQL | sql_all_count | times/s | SQL statements processed per second |
| Performance and SQL | sql_delete_count | times/s | DELETE statements processed per second |
| Performance and SQL | sql_insert_count | times/s | INSERT statements processed per second |
| Performance and SQL | sql_other_count | times/s | Number of Other Statements Such as DDL, DCL, and DTL |
| Performance and SQL | sql_replace_count | times/s | REPLACE statements processed per second |
| Performance and SQL | sql_select_count | times/s | SELECT statements processed per second |
| Performance and SQL | sql_update_count | times/s | UPDATE statements processed per second |
| Performance and SQL | sql_all_rt | ms | Average processing time for SQL statements |
| Performance and SQL | sql_delete_rt | ms | Average processing time for DELETE statements |
| Performance and SQL | sql_insert_rt | ms | Average processing time for INSERT statements |
| Performance and SQL | sql_other_rt | ms | Average Processing Time for Other Statements Such as DDL, DCL, and DTL |
| Performance and SQL | sql_replace_rt | ms | Average processing time for REPLACE statements |
| Performance and SQL | sql_select_rt | ms | Average processing time for SELECT statements |
| Performance and SQL | sql_update_rt | ms | Average processing time for UPDATE statements |
| Performance and SQL | sql_all_rt_p99 | ms | P99 response time for all SQL statements |
| Performance and SQL | sql_delete_rt_p99 | ms | P99 response time for DELETE statements |
| Performance and SQL | sql_insert_rt_p99 | ms | P99 response time for INSERT statements |
| Performance and SQL | sql_other_rt_p99 | ms | P99 response time for other statements |
| Performance and SQL | sql_replace_rt_p99 | ms | P99 response time for REPLACE statements |
| Performance and SQL | sql_select_rt_p99 | ms | P99 response time for SELECT statements |
| Performance and SQL | sql_update_rt_p99 | ms | P99 response time for UPDATE statements |
| Performance and SQL | sql_all_rt_p95 | ms | P95 response time for all SQL statements |
| Performance and SQL | sql_delete_rt_p95 | ms | P95 response time for DELETE statements |
| Performance and SQL | sql_insert_rt_p95 | ms | P95 response time for INSERT statements |
| Performance and SQL | sql_other_rt_p95 | ms | P95 response time for other statements |
| Performance and SQL | sql_replace_rt_p95 | ms | P95 response time for REPLACE statements |
| Performance and SQL | sql_select_rt_p95 | ms | P95 response time for SELECT statements |
| Performance and SQL | sql_update_rt_p95 | ms | P95 response time for UPDATE statements |
| Performance and SQL | sql_all_rt_p90 | ms | P90 response time for all SQL statements |
| Performance and SQL | sql_delete_rt_p90 | ms | P90 response time for DELETE statements |
| Performance and SQL | sql_insert_rt_p90 | ms | P90 response time for INSERT statements |
| Performance and SQL | sql_other_rt_p90 | ms | P90 response time for other statements |
| Performance and SQL | sql_replace_rt_p90 | ms | P90 response time for REPLACE statements |
| Performance and SQL | sql_select_rt_p90 | ms | P90 response time for SELECT statements |
| Performance and SQL | sql_update_rt_p90 | ms | P90 response time for UPDATE statements |
| Performance and SQL | all_session | Count | Current Sessions |
| Performance and SQL | active_session | Count | Current Active Sessions |
| Performance and SQL | sql_distributed_count | times/s | Distributed Execution Plans Processed per Second |
| Performance and SQL | sql_local_count | times/s | Number of Locally Executed Operations Per Second |
| Performance and SQL | sql_remote_count | times/s | Remote Execution Plans Processed per Second |
| Performance and SQL | ob_sql_event | Count | Number of execution events in a specific database state |
| Performance and SQL | ob_sql_event_in_parse | Count | Number of execution events in the parse state |
| Performance and SQL | ob_sql_event_in_pl_parse | Count | Number of execution events in the pl parse state |
| Performance and SQL | ob_sql_event_in_plan_cache | Count | Number of execution events in the plan cache state |
| Performance and SQL | ob_sql_event_in_sql_optimize | Count | Number of execution events in the sql optimize state |
| Performance and SQL | ob_sql_event_in_sql_execution | Count | Number of execution events in the sql execution state |
| Performance and SQL | ob_sql_event_in_px_execution | Count | Number of execution events in the px execution state |
| Performance and SQL | ob_sql_event_in_sequence_load | Count | Number of execution events in the sequence load state |
| Performance and SQL | wait_event_count | times/s | Wait events per second |
| Performance and SQL | system_event_other_count | times/s | Other wait events per second |
| Performance and SQL | system_event_application_count | times/s | Application wait events per second |
| Performance and SQL | system_event_configuration_count | times/s | Configuration wait events per second |
| Performance and SQL | system_event_administrative_count | times/s | Administrative wait events per second |
| Performance and SQL | system_event_concurrency_count | times/s | Concurrency wait events per second |
| Performance and SQL | system_event_commit_count | times/s | Commit wait events per second |
| Performance and SQL | system_event_idle_count | times/s | Idle wait events per second |
| Performance and SQL | system_event_network_count | times/s | Network wait events per second |
| Performance and SQL | system_event_user_io_count | times/s | User I/O wait events per second |
| Performance and SQL | system_event_system_io_count | times/s | System I/O wait events per second |
| Performance and SQL | system_event_scheduler_count | times/s | Scheduler wait events per second |
| Performance and SQL | system_event_cluster_count | times/s | Cluster wait events per second |
| Performance and SQL | wait_event_rt | ms | Average wait event latency |
| Performance and SQL | system_event_other_time_waites | μs | Average other wait event latency |
| Performance and SQL | system_event_application_time_waites | μs | Average application wait event latency |
| Performance and SQL | system_event_configuration_time_waites | μs | Average configuration wait event latency |
| Performance and SQL | system_event_administrative_time_waites | μs | Average administrative wait event latency |
| Performance and SQL | system_event_concurrency_waites | μs | Average concurrency wait event latency |
| Performance and SQL | system_event_commit_waites | μs | Average commit wait event latency |
| Performance and SQL | system_event_idle_waites | μs | Average idle wait event latency |
| Performance and SQL | system_event_network_waites | μs | Average network wait event latency |
| Performance and SQL | system_event_user_io_waites | μs | Average user I/O wait event latency |
| Performance and SQL | system_event_system_io_waites | μs | Average system I/O wait event latency |
| Performance and SQL | system_event_scheduler_waites | μs | Average scheduler wait event latency |
| Performance and SQL | system_event_cluster_waites | μs | Average cluster wait event latency |
| Performance and SQL | request_dequeue_count | Count | Number of Requests Dequeued from the Processing Queue |
| Performance and SQL | request_enqueue_count | Count | Number of Requests Entered the Queue |
| Performance and SQL | request_queue_time | μs | Waiting Time of SQL Requests in the Queue |
| Performance and SQL | ob_waitevent_count | Count | Number of wait events |
| Performance and SQL | ob_foreground_waitevent_count | Count | Number of foreground wait events in a specific database state |
| Performance and SQL | ob_background_waitevent_count | Count | Number of background wait events in a specific database state |
| Performance and SQL | ob_cpu_percent | Percentage (%) | Tenant Thread CPU Usage |
| Performance and SQL | ob_tenant_memory_percent | Percentage (%) | OceanBase tenant memory utilization |
| Performance and SQL | memstore_percent | Percentage (%) | MemStore utilization |
| Performance and SQL | opened_cursors_count | Count | Number of Open Cursors |
| Performance and SQL | rpc_packet_in_rt | μs | Average time to receive an RPC packet |
| Performance and SQL | rpc_packet_out_rt | μs | Average time to send an RPC packet |
| Performance and SQL | rpc_packet_in | byte | RPC receive throughput |
| Performance and SQL | rpc_packet_out | byte | RPC send throughput |
| Performance and SQL | ob_clog_ls_max_replayed_scn | ms | Replica Latency |
| Transaction | transaction_count | times/s | TPS |
| Transaction | transaction_commit_count | times/s | Transactions committed per second |
| Transaction | transaction_rollback_count | times/s | Transactions rolled back per second |
| Transaction | transaction_timeout_count | times/s | Transactions timed out per second |
| Transaction | transaction_rt | ms | Average Transaction Processing Time on Server |
| Transaction | transaction_commit_rt | ms | Average Transaction Commit Time |
| Transaction | transaction_rollback_rt | ms | Average Transaction Rollback Time |
| Transaction | trans_commit_log_count | times/s | Number of Transaction Logs Committed per Second |
| Transaction | clog_trans_log_total_size | byte | Size of Transaction Logs Committed per Second |
| Transaction | memstore_write_lock_fail_count | times/s | Number of failed write lock waits |
| Transaction | memstore_write_lock_succ_count | times/s | Number of successful write lock waits |
| Transaction | memstore_write_lock_wait_time | μs | Average write lock wait time |
| Transaction | transaction_multi_partition_count | times/s | Distributed Transactions Per Second |
| Transaction | transaction_single_partition_count | times/s | Regular transactions per second |
| Transaction | trans_commit_log_sync_rt | μs | Average time to synchronize a transaction log over the network |
| Storage and Caching | io_read_count | times/s | SSStore Reads Per Second |
| Storage and Caching | io_write_count | times/s | SSStore Write Operations Per Second |
| Storage and Caching | io_read_rt | μs | Average Time Consumed per SSStore Read |
| Storage and Caching | io_write_rt | μs | Average Time Consumed per SSStore Write |
| Storage and Caching | io_read_size | byte | SSStore Data Read Volume per Second |
| Storage and Caching | io_write_size | byte | SSStore Data Written per Second |
| Storage and Caching | active_memstore_used | GiB | Active MemStore size |
| Storage and Caching | major_freeze_trigger | MiB | Major compaction trigger threshold |
| Storage and Caching | memstore_limit | MiB | MemStore limit |
| Storage and Caching | total_memstore_used | MiB | Total MemStore size |
| Storage and Caching | ob_tenant_binlog_disk_used | GiB | Disk Usage of Binlog Logs |
| Storage and Caching | ob_tenant_log_disk_total_bytes | GiB | Total Log Disk Space |
| Storage and Caching | ob_tenant_log_disk_used_bytes | GiB | Log Disk Usage |
| Storage and Caching | ob_tenant_server_required_size | GiB | Tenant Data Usage |
| Storage and Caching | ob_tenant_server_data_size | GiB | Tenant Data Volume |
| Storage and Caching | block_cache_size | MiB | Block Cache Size |
| Storage and Caching | bloom_filter_cache_size | MiB | Bloom Filter Cache Size |
| Storage and Caching | clog_cache_size | MiB | Clog Cache Size |
| Storage and Caching | plan_cache_size | MiB | Execution Plan Cache Size |
| Storage and Caching | row_cache_size | MiB | Row Cache Size |
| Storage and Caching | block_cache_hit_ratio | Percentage (%) | Block Cache Hit Rate |
| Storage and Caching | bloom_filter_cache_hit_ratio | Percentage (%) | Bloom Filter Cache Hit Rate |
| Storage and Caching | clog_cache_hit_ratio | Percentage (%) | Clog Cache Hit Rate |
| Storage and Caching | location_cache_hit_ratio | Percentage (%) | Location Cache Hit Rate |
| Storage and Caching | plan_cache_hit_ratio | Percentage (%) | Execution Plan Cache Hit Rate |
| Storage and Caching | row_cache_hit_ratio | Percentage (%) | Row Cache Hit Rate |
| Storage and Caching | block_cache_req_total | Count | Block Cache Requests |
| Storage and Caching | bloom_filter_cache_req_total | Count | Number of Bloom filter cache requests |
| Storage and Caching | clog_cache_req_total | Count | Number of Clog Cache Requests |
| Storage and Caching | location_cache_req_total | Count | Number of Location Cache Requests |
| Storage and Caching | row_cache_req_total | Count | Row Cache Requests |
| Binlog Service | binlog_instance_convert_delay | ms | Binlog conversion latency |
| Binlog Service | binlog_instance_convert_iops | MiB | IOPS of Binlog Conversion |
| Binlog Service | binlog_instance_convert_fetch_rps | - | Conversion RPS |
| Binlog Service | binlog_instance_convert_storage_rps | - | Disk write RPS |
| Binlog Service | ob_tenant_binlog_disk_used | GiB | Disk Usage of Binlog Logs |
| Binlog Service | binlog_instance_dump_delay | s | Top 5 Binlog Sending Delays |
| Binlog Service | binlog_instance_dump_iops | MiB | Top 5 Binlog Network Traffic |
| Binlog Service | binlog_instance_dump_rps | - | Top 5 Binlog Sending RPS |