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 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.
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 Monitoring metrics for a tenant.
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, tenants, and metrics. For more information, see Monitoring metrics for a tenant.
Click OK.
Delete a custom dashboard
On the Custom Dashboard tab, select the dashboard you want to delete.
Click Delete Dashboard.
Click Confirm.
Monitoring metrics for a tenant
| Metric category | Metric | Description |
|-----------------|--------------|------------|
| Performance and SQL | sql_all_count | The number of SQL statements processed per second. |
| Performance and SQL | sql_delete_count | The number of DELETE statements processed per second. |
| Performance and SQL | sql_insert_count | The number of INSERT statements processed per second. |
| Performance and SQL | sql_other_count | The number of other statements that are processed per second, such as data definition language (DDL), data control language (DCL), and data transaction language (DTL) statements. |
| Performance and SQL | sql_replace_count | The number of REPLACE statements processed per second. |
| Performance and SQL | sql_select_count | The number of SELECT statements processed per second. |
| Performance and SQL | sql_update_count | The number of UPDATE statements processed per second. |
| Performance and SQL | sql_all_rt | The average time consumed in processing an SQL statement. |
| Performance and SQL | sql_delete_rt | The average time spent in processing a DELETE statement. |
| Performance and SQL | sql_insert_rt | The average time spent in processing an INSERT statement. |
| Performance and SQL | sql_other_rt | The average time spent in processing another type of statement such as a DDL, DCL, or DTL statement. |
| Performance and SQL | sql_replace_rt | The average time spent in processing a REPLACE statement. |
| Performance and SQL | sql_select_rt | The average time spent in processing a SELECT statement. |
| Performance and SQL | sql_update_rt | The average time spent in processing an UPDATE statement. |
| Performance and SQL | sql_select_rt_p99 | The average time spent in processing a SELECT statement at the 99th percentile. |
| Performance and SQL | sql_update_rt_p99 | The average time spent in processing an UPDATE statement at the 99th percentile. |
| Performance and SQL | sql_select_rt_p95 | The average time spent in processing a SELECT statement at the 95th percentile. |
| Performance and SQL | sql_update_rt_p95 | The average time spent in processing an UPDATE statement at the 95th percentile. |
| Performance and SQL | sql_select_rt_p90 | The average time spent in processing a SELECT statement at the 90th percentile. |
| Performance and SQL | sql_update_rt_p90 | The average time spent in processing an UPDATE statement at the 90th percentile. |
| Performance and SQL | transaction_commit_count | Transaction commits per second |
| Performance and SQL | transaction_count | TPS |
| Performance and SQL | transaction_rollback_count | Transaction rolled back per second |
| Performance and SQL | transaction_timeout_count | Timed-out transactions per second |
| Performance and SQL | transaction_commit_rt | Average transaction commit ltency |
| Performance and SQL | transaction_rollback_rt | Average transaction rollback latency |
| Performance and SQL | transaction_rt | Average transaction processing time |
| Performance and SQL | active_session | The number of active sessions. |
| Performance and SQL | all_session | The total number of sessions. |
| Performance and SQL | sql_distributed_count | The number of distributed execution plans processed per second. |
| Performance and SQL | sql_local_count | The number of local execution plans processed per second. |
| Performance and SQL | sql_remote_count | The number of remote execution plans processed per second. |
| Performance and SQL | system_event_internal_total_waits | The number of internal wait events that occur per second. |
| Performance and SQL | system_event_io_total_waits | The number of I/O wait events that occur per second. |
| Performance and SQL | system_event_latch_total_waits | The number of latch wait events that occur per second. |
| Performance and SQL | system_event_other_total_waits | The number of other types of wait events that occur per second. |
| Performance and SQL | system_event_row_lock_wait_total_waits | The number of lock wait events that occur per second. |
| Performance and SQL | system_event_sync_rpc_total_waits | The number of synchronization remote procedure call (RPC) wait events that occur per second. |
| Performance and SQL | wait_event_count | The number of wait events per second. |
| Performance and SQL | system_event_other_time_waites | The average time spent on a wait event of other types. |
| Performance and SQL | system_event_application_time_waites | The average time spent on an application wait event. |
| Performance and SQL | system_event_configuration_time_waites | The average time spent on an application wait event. |
| Performance and SQL | system_event_administrative_time_waites | The average time spent on an administrative wait event. |
| Performance and SQL | system_event_concurrency_waites | The average time spent on a concurrency wait event. |
| Performance and SQL | system_event_commit_waites | The average time spent on a commit wait event. |
| Performance and SQL | system_event_idle_waites | The average time spent on an idle wait event. |
| Performance and SQL | system_event_network_waites | The average time spent on a network wait event. |
| Performance and SQL | system_event_user_io_waites | The average time spent on a user_io wait event. |
| Performance and SQL | system_event_system_io_waites | The average time spent on a system_io wait event. |
| Performance and SQL | system_event_scheduler_waites | The average time spent on a scheduler wait event. |
| Performance and SQL | system_event_cluster_waites | The average time spent on a cluster wait event. |
| Performance and SQL | wait_event_rt | The average wait time of a wait event. |
| Performance and SQL | request_dequeue_count | The number of requests exiting the queue. |
| Performance and SQL | request_enqueue_count | The number of requests entering the queue. |
| Performance and SQL | request_queue_time | The average waiting time of an SQL statement in a queue. |
| Performance and SQL | ob_cpu_percent | The CPU utilization. |
| Performance and SQL | memstore_percent | The MemStore usage. |
| Performance and SQL | rpc_packet_in_rt | The average time spent in receiving an RPC packet. |
| Performance and SQL | rpc_packet_out_rt | The average time spent in sending an RPC packet. |
| Performance and SQL | rpc_packet_in | The RPC packet receiving throughput. |
| Performance and SQL | rpc_packet_out | The RPC packet sending throughput. |
| Performance and SQL | opened_cursors_count | The number of open cursors. |
| Performance and SQL | slow_sql_count | The number of queries. |
| Transaction | transaction_commit_count | The number of transactions committed per second. |
| Transaction | transaction_count | The number of transactions processed per second. |
| Transaction | transaction_rollback_count | The number of transactions rolled back per second. |
| Transaction | transaction_timeout_count | The number of transactions that time out per second. |
| Transaction | transaction_commit_rt | The average time spent in committing a transaction. |
| Transaction | transaction_rollback_rt | The average time spent in rolling back a transaction. |
| Transaction | transaction_rt | The average time spent in processing a transaction. |
| Transaction | trans_commit_log_count | The number of transaction logs committed per second. |
| Transaction | clog_trans_log_total_size | The total size of transaction logs committed per second. |
| Transaction | memstore_write_lock_fail_count | The number of failed write lock waits. |
| Transaction | memstore_write_lock_succ_count | The number of successful write lock waits. |
| Transaction | memstore_write_lock_wait_time | The average wait time of each write lock. |
| Transaction | transaction_multi_partition_count | The number of distributed transactions per second. |
| Transaction | transaction_single_partition_count | The number of regular transactions per second. |
| Transaction | trans_commit_log_sync_rt | The average time spent on each synchronization of transaction logs over the network. |
| Storage and Cache | active_memstore_used | The total size of active MemStores. |
| Storage and Cache | major_freeze_trigger | The threshold for triggering a major compaction. |
| Storage and Cache | memstore_limit | The upper limit of the total size of all MemStores. |
| Storage and Cache | total_memstore_used | The total size of MemStores. |
| Storage and Cache | io_read_count | The number of reads from the SSStore per second. |
| Storage and Cache | io_write_count | The number of writes to the SSStore per second. |
| Storage and Cache | io_read_rt | The average amount of time spent on each SSStore read. |
| Storage and Cache | io_write_rt | The average amount of time spent on each SSStore write. |
| Storage and Cache | io_read_size | The number of reads from the SSStore per second. |
| Storage and Cache | io_write_size | The amount of data written to the SSStore per second. |
| Storage and Cache | block_cache_size | The size of the block cache. |
| Storage and Cache | bloom_filter_cache_size | The size of the Bloom filter cache. |
| Storage and Cache | clog_cache_size | The size of the clog cache. |
| Storage and Cache | location_cache_size | The size of the location cache. |
| Storage and Cache | plan_cache_size | The size of the plan cache. |
| Storage and Cache | row_cache_size | The size of the row cache. |
| Storage and Cache | block_cache_hit_ratio | The hit rate of the block cache. |
| Storage and Cache | bloom_filter_cache_hit_ratio | The hit rate of the Bloom filter cache. |
| Storage and Cache | clog_cache_hit_ratio | The hit rate of the clog cache. |
| Storage and Cache | location_cache_hit_ratio | The hit rate of the location cache. |
| Storage and Cache | plan_cache_hit_ratio | The hit rate of the plan cache. |
| Storage and Cache | row_cache_hit_ratio | The hit rate of the row cache. |
| Storage and Cache | block_cache_req_total | The number of block cache requests. |
| Storage and Cache | bloom_filter_cache_req_total | The number of Bloom filter cache requests. |
| Storage and Cache | clog_cache_req_total | The number of clog cache requests. |
| Storage and Cache | location_cache_req_total | The number of location cache requests. |
| Storage and Cache | row_cache_req_total | The number of row cache requests. |
| Storage and Cache | ob_tenant_binlog_disk_used | The size of disk space occupied by binlogs. |
| Storage and Cache | ob_tenant_memory_percent | The memory usage of the tenant. |
| Binlog service | binlog_instance_convert_delay | Binlog conversion delay |
| Binlog service | binlog_instance_convert_iops | Binlog conversion IOPS |
| Binlog service | binlog_instance_convert_fetch_rps | Conversion RPS |
| Binlog service | binlog_instance_convert_storage_rps | Binlog write RPS |
| Binlog service | ob_tenant_binlog_disk_used | Binlog disk usage |
| Binlog service | binlog_instance_dump_delay | Binlog Binlog send delay Top5 |
| Binlog service | binlog_instance_dump_iops | Binlog network traffic Top5 |
| Binlog service | binlog_instance_dump_rps | Binlog send RPS Top5 |