On the performance monitoring page of a tenant, you can add a custom monitoring dashboard by configuring general monitoring metrics as needed.
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.
Manage the dashboards on the Custom Dashboard tab.
Create a custom dashboard
On the Custom Dashboard tab, click Create Custom Dashboard.
When creating a custom dashboard for the first time, the interface is as follows:
If a custom dashboard already exists, the interface is as follows:
Enter the dashboard name, select the tenant and metrics to be monitored. For more information, see Tenant monitoring metrics.
Note
- The name of the dashboard cannot exceed 20 characters in length.
- At present, you can create at most seven custom monitoring dashboards.
Click OK.
View a custom dashboard
On the Custom Dashboard tab, you can view the custom dashboards. Select the custom dashboard through the Select Dashboard filter.
Edit a custom dashboard
On the Custom Dashboard tab, select the dashboard you want to edit.
Click Edit Dashboard.
Modify the name, tenant, and metrics. For more information, see Tenant monitoring metrics.
Click OK.
Delete a custom dashboard
On the Custom Dashboard tab, select the dashboard you want to delete.
Click Delete Dashboard.
Click Confirm.
Tenant monitoring metrics
| Metric Category | Metric Name | Unit | Description |
|---------------|-------------|------|-------------|
| Performance and SQL | sql_all_count | times/s | The number of SQL statements processed per second. |
| Performance and SQL | sql_delete_count | times/s | The number of Delete statements processed per second. |
| Performance and SQL | sql_insert_count | times/s | The number of Insert statements processed per second. |
| Performance and SQL | sql_other_count | times/s | The number of other statements, such as DDL, DCL, and DTL statements, processed per second. |
| Performance and SQL | sql_replace_count | times/s | The number of Replace statements processed per second. |
| Performance and SQL | sql_select_count | times/s | The number of Select statements processed per second. |
| Performance and SQL | sql_update_count | times/s | The number of Update statements processed per second. |
| Performance and SQL | sql_all_rt | ms | The average processing time of SQL statements. |
| Performance and SQL | sql_delete_rt | ms | The average processing time of Delete statements. |
| Performance and SQL | sql_insert_rt | ms | The average processing time of Insert statements. |
| Performance and SQL | sql_other_rt | ms | The average processing time of other statements, such as DDL, DCL, and DTL statements. |
| Performance and SQL | sql_replace_rt | ms | The average processing time of Replace statements. |
| Performance and SQL | sql_select_rt | ms | The average processing time of Select statements. |
| Performance and SQL | sql_update_rt | ms | The average processing time of Update statements. |
| Performance and SQL | sql_all_rt_p99 | ms | The 99th percentile processing time of SQL statements. |
| Performance and SQL | sql_delete_rt_p99 | ms | The 99th percentile processing time of Delete statements. |
| Performance and SQL | sql_insert_rt_p99 | ms | The 99th percentile processing time of Insert statements. |
| Performance and SQL | sql_other_rt_p99 | ms | The 99th percentile processing time of other statements, such as DDL, DCL, and DTL statements. |
| Performance and SQL | sql_replace_rt_p99 | ms | The 99th percentile processing time of Replace statements. |
| Performance and SQL | sql_select_rt_p99 | ms | The 99th percentile processing time of Select statements. |
| Performance and SQL | sql_update_rt_p99 | ms | The 99th percentile processing time of Update statements. |
| Performance and SQL | sql_all_rt_p95 | ms | The 95th percentile processing time of SQL statements. |
| Performance and SQL | sql_delete_rt_p95 | ms | The 95th percentile processing time of Delete statements. |
| Performance and SQL | sql_insert_rt_p95 | ms | The 95th percentile processing time of Insert statements. |
| Performance and SQL | sql_other_rt_p95 | ms | The 95th percentile processing time of other statements, such as DDL, DCL, and DTL statements. |
| Performance and SQL | sql_replace_rt_p95 | ms | The 95th percentile processing time of Replace statements. |
| Performance and SQL | sql_select_rt_p95 | ms | The 95th percentile processing time of Select statements. |
| Performance and SQL | sql_update_rt_p95 | ms | The 95th percentile processing time of Update statements. |
| Performance and SQL | sql_all_rt_p90 | ms | The 90th percentile processing time of SQL statements. |
| Performance and SQL | sql_delete_rt_p90 | ms | The 90th percentile processing time of Delete statements. |
| Performance and SQL | sql_insert_rt_p90 | ms | The 90th percentile processing time of Insert statements. |
| Performance and SQL | sql_other_rt_p90 | ms | The 90th percentile processing time of other statements, such as DDL, DCL, and DTL statements. |
| Performance and SQL | sql_replace_rt_p90 | ms | The 90th percentile processing time of Replace statements. |
| Performance and SQL | sql_select_rt_p90 | ms | The 90th percentile processing time of Select statements. |
| Performance and SQL | sql_update_rt_p90 | ms | The 90th percentile processing time of Update statements. |
| Performance and SQL | all_session | count | The number of current sessions. |
| Performance and SQL | active_session | count | The number of active sessions. |
| Performance and SQL | sql_distributed_count | times/s | The number of distributed execution plans processed per second. |
| Performance and SQL | sql_local_count | times/s | The number of local executions processed per second. |
| Performance and SQL | sql_remote_count | times/s | The number of remote execution plans processed per second. |
| Performance and SQL | ob_sql_event | count | The number of execution events in a specific database state. |
| Performance and SQL | ob_sql_event_in_parse | count | The number of execution events in the parse state. |
| Performance and SQL | ob_sql_event_in_pl_parse | count | The number of execution events in the pl parse state. |
| Performance and SQL | ob_sql_event_in_plan_cache | count | The number of execution events in the plan cache state. |
| Performance and SQL | ob_sql_event_in_sql_optimize | count | The number of execution events in the sql optimize state. |
| Performance and SQL | ob_sql_event_in_sql_execution | count | The number of execution events in the sql execution state. |
| Performance and SQL | ob_sql_event_in_px_execution | count | The number of execution events in the px execution state. |
| Performance and SQL | ob_sql_event_in_sequence_load | count | The number of execution events in the sequence load state. |
| Performance and SQL | wait_event_count | times/s | The number of wait events per second. |
| Performance and SQL | system_event_other_count | times/s | The number of other wait events per second. |
| Performance and SQL | system_event_application_count | ms | The average wait time of application wait events per second. |
| Performance and SQL | system_event_configuration_count | ms | The average wait time of configuration wait events per second. |
| Performance and SQL | system_event_administrative_count | ms | The average wait time of administrative wait events per second. |
| Performance and SQL | system_event_concurrency_count | ms | The average wait time of concurrency wait events per second. |
| Performance and SQL | system_event_commit_count | ms | The average wait time of commit wait events per second. |
| Performance and SQL | system_event_idle_count | ms | Average idle wait event time per second |
| Performance and SQL | system_event_network_count | ms | Average network wait event time per second |
| Performance and SQL | system_event_user_io_count | ms | Average user_io wait event time per second |
| Performance and SQL | system_event_system_io_count | ms | Average system_io wait event time per second |
| Performance and SQL | system_event_scheduler_count | ms | Average scheduler wait event time per second |
| Performance and SQL | system_event_cluster_count | ms | Average cluster wait event time per second |
| Performance and SQL | wait_event_rt | ms | Average wait event time |
| Performance and SQL | system_event_other_time_waites | μs | Average other wait event time |
| Performance and SQL | system_event_application_time_waites | μs | Average application wait event time |
| Performance and SQL | system_event_configuration_time_waites | μs | Average configuration wait event time |
| Performance and SQL | system_event_administrative_time_waites | μs | Average administrative wait event time |
| Performance and SQL | system_event_concurrency_waites | μs | Average concurrency wait event time |
| Performance and SQL | system_event_commit_waites | μs | Average commit wait event time |
| Performance and SQL | system_event_idle_waites | μs | Average idle wait event time |
| Performance and SQL | system_event_network_waites | μs | Average network wait event time |
| Performance and SQL | system_event_user_io_waites | μs | Average user_io wait event time |
| Performance and SQL | system_event_system_io_waites | μs | Average system_io wait event time |
| Performance and SQL | system_event_scheduler_waites | μs | Average scheduler wait event time |
| Performance and SQL | system_event_cluster_waites | μs | Average cluster wait event time |
| Performance and SQL | request_dequeue_count | times (count) | Number of requests dequeued from the processing queue |
| Performance and SQL | request_enqueue_count | times (count) | Number of requests enqueued into the processing queue |
| Performance and SQL | request_queue_time | μs | Time spent waiting in the SQL request queue |
| Performance and SQL | ob_waitevent_count | times (count) | Number of wait events |
| Performance and SQL | ob_foreground_waitevent_count | times (count) | Number of wait events in the foreground database |
| Performance and SQL | ob_background_waitevent_count | times (count) | Number of wait events in the background database |
| Performance and SQL | ob_cpu_percent | % | CPU usage rate of tenant threads |
| Performance and SQL | ob_tenant_memory_percent | % | Memory usage rate of OB tenants |
| Performance and SQL | memstore_percent | % | MEMStore usage |
| Performance and SQL | opened_cursors_count | times (count) | Number of open cursors |
| Performance and SQL | rpc_packet_in_rt | μs | Average time spent receiving RPC packets |
| Performance and SQL | rpc_packet_out_rt | μs | Average time spent sending RPC packets |
| Performance and SQL | rpc_packet_in | byte | RPC packet receiving throughput |
| Performance and SQL | rpc_packet_out | byte | RPC packet sending throughput |
| Performance and SQL | ob_clog_ls_max_replayed_scn | ms | Replica lag |
| Transactions | transaction_count | times/s | TPS |
| Transactions | transaction_commit_count | times/s | Number of committed transactions per second |
| Transactions | transaction_rollback_count | times/s | Number of rolled back transactions per second |
| Transactions | transaction_timeout_count | times/s | Number of timed out transactions per second |
| Transactions | transaction_rt | ms | Average transaction processing time per transaction |
| Transactions | transaction_commit_rt | ms | Average transaction commit time |
| Transactions | transaction_rollback_rt | ms | Average transaction rollback time |
| Transactions | trans_commit_log_count | times/s | Number of committed transaction logs per second |
| Transactions | clog_trans_log_total_size | byte | Size of committed transaction logs per second |
| Transactions | memstore_write_lock_fail_count | times/s | Number of failed write lock waits |
| Transactions | memstore_write_lock_succ_count | times/s | Number of successful write lock waits |
| Transactions | memstore_write_lock_wait_time | μs | Average write lock wait time |
| Transactions | transaction_multi_partition_count | times/s | Number of distributed transactions per second |
| Transactions | transaction_single_partition_count | times/s | Number of ordinary transactions per second |
| Transactions | trans_commit_log_sync_rt | μs | Average time spent synchronizing transaction logs over the network |
| Storage and Cache | io_read_count | times/s | Number of reads from the SSStore per second |
| Storage and Cache | io_write_count | times/s | Number of writes to the SSStore per second |
| Storage and Cache | io_read_rt | μs | Average time spent reading from the SSStore |
| Storage and Cache | io_read_rt | μs | Average time spent writing to the SSStore |
| Storage and Cache | io_read_size | byte | Size of data read from the SSStore per second |
| Storage and Cache | io_write_size | byte | Size of data written to the SSStore per second |
| Storage and Cache | active_memstore_used | GiB | Size of active MEMStore |
| Storage and Cache | major_freeze_trigger | MiB | Major freeze trigger threshold |
| Storage and Cache | memstore_limit | MiB | MEMStore limit |
| Storage and Cache | total_memstore_used | MiB | Total size of MEMStore |
| Storage and cache | ob_tenant_binlog_disk_used | GiB | Binlog disk usage |
| Storage and cache | ob_tenant_log_disk_total_bytes | GiB | Log disk total size |
| Storage and cache | ob_tenant_log_disk_used_bytes | GiB | Log disk used size |
| Storage and cache | ob_tenant_server_required_size | GiB | Tenant data size |
| Storage and cache | ob_tenant_server_data_size | GiB | Tenant data size |
| Storage and cache | block_cache_size | MiB | Block cache size |
| Storage and cache | bloom_filter_cache_size | MiB | Bloom filter cache size |
| Storage and cache | clog_cache_size | MiB | Clog cache size |
| Storage and cache | plan_cache_size | MiB | Plan cache size |
| Storage and cache | row_cache_size | MiB | Row cache size |
| Storage and cache | block_cache_hit_ratio | Percentage (%) | Block cache hit ratio |
| Storage and cache | bloom_filter_cache_hit_ratio | Percentage (%) | Bloom filter cache hit ratio |
| Storage and cache | clog_cache_hit_ratio | Percentage (%) | Clog cache hit ratio |
| Storage and cache | location_cache_hit_ratio | Percentage (%) | Location cache hit ratio |
| Storage and cache | plan_cache_hit_ratio | Percentage (%) | Plan cache hit ratio |
| Storage and cache | row_cache_hit_ratio | Percentage (%) | Row cache hit ratio |
| Storage and cache | block_cache_req_total | Count | Block cache request count |
| Storage and cache | bloom_filter_cache_req_total | Count | Bloom filter cache request count |
| Storage and cache | clog_cache_req_total | Count | Clog cache request count |
| Storage and cache | location_cache_req_total | Count | Location cache request count |
| Storage and cache | row_cache_req_total | Count | Row cache request count |
| Binlog service | binlog_instance_convert_delay | ms | Binlog conversion delay |
| Binlog service | binlog_instance_convert_iops | MiB | Binlog conversion IOPS |
| Binlog service | binlog_instance_convert_fetch_rps | - | Conversion RPS |
| Binlog service | binlog_instance_convert_storage_rps | - | Storage RPS |
| Binlog service | ob_tenant_binlog_disk_used | GiB | Binlog disk usage |
| Binlog service | binlog_instance_dump_delay | s | Binlog sending delay (top 5) |
| Binlog service | binlog_instance_dump_iops | MiB | Binlog network traffic (top 5) |
| Binlog service | binlog_instance_dump_rps | - | Binlog sending RPS (top 5) |