On the performance monitoring page of an instance in OceanBase Cloud, you can create custom monitoring dashboards by configuring commonly used monitoring metrics.
Manage custom dashboards
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
On the Instances page, click the name of the target instance to go to the Overview page of the instance.
In the left-side navigation pane of the Overview page of the instance, click Metrics.
On the Metrics page, click the Custom Dashboard tab.
On the Custom Dashboard tab, manage your dashboards.
Create a custom dashboard
On the Custom Dashboard tab, click Create Custom Dashboard.
Enter a dashboard name, select the tenants to monitor, and choose monitoring metrics. For detailed metric descriptions, see Monitoring metrics.
Note
- The dashboard name cannot exceed 20 characters in length.
- You can create up to 7 custom monitoring dashboards.
Click OK.
View custom dashboards
On the Custom Dashboard 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 Dashboard tab, select the dashboard you want to modify.
Click Edit Current Dashboard.
On the edit page, modify the dashboard name, tenants, and metrics as needed. For detailed metric descriptions, see Monitoring metrics.
Click OK.
Delete a custom dashboard
On the Custom Dashboard tab, 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.
Monitoring metrics
| Category | Metric | Description |
|---|---|---|
| Database | single_kv_delete_count | The average number of single delete operations per second |
| Database | single_kv_insert_count | The average number of single insert operations per second |
| Database | single_kv_select_count | The average number of single select operations per second |
| Database | single_kv_update_count | The average number of single update operations per second |
| Database | single_kv_insert_or_update_count | The average number of single insert or update operations per second |
| Database | single_kv_replace_count | The average number of single replace operations per second |
| Database | single_kv_increment_count | The average number of single increment operations per second |
| Database | single_kv_append_count | The average number of single append operations per second |
| Database | single_kv_all_count | The average number of all single operations per second |
| Database | single_kv_delete_rt | The average response time for single delete operations |
| Database | single_kv_insert_rt | The average response time for single insert operations |
| Database | single_kv_select_rt | The average response time for single select operations |
| Database | single_kv_update_rt | The average response time for single update operations |
| Database | single_kv_insert_or_update_rt | The average response time for single insert or update operations |
| Database | single_kv_increment_rt | The average response time for single increment operations |
| Database | single_kv_append_rt | The average response time for single append operations |
| Database | single_kv_all_rt | The average response time for all single operations |
| Database | single_kv_delete_rt_p99 | The 99th percentile response time for single delete operations |
| Database | single_kv_insert_rt_p99 | The 99th percentile response time for single insert operations |
| Database | single_kv_select_rt_p99 | The 99th percentile response time for single select operations |
| Database | single_kv_update_rt_p99 | The 99th percentile response time for single update operations |
| Database | single_kv_insert_or_update_rt_p99 | The 99th percentile response time for single insert or update operations |
| Database | single_kv_increment_rt_p99 | The 99th percentile response time for single increment operations |
| Database | single_kv_append_rt_p99 | The 99th percentile response time for single append operations |
| Database | single_kv_all_rt_p99 | The 99th percentile response time for all single operations |
| Database | single_kv_delete_rt_p95 | The 95th percentile response time for single delete operations |
| Database | single_kv_insert_rt_p95 | The 95th percentile response time for single insert operations |
| Database | single_kv_select_rt_p95 | The 95th percentile response time for single select operations |
| Database | single_kv_update_rt_p95 | The 95th percentile response time for single update operations |
| Database | single_kv_insert_or_update_rt_p95 | The 95th percentile response time for single insert or update operations |
| Database | single_kv_increment_rt_p95 | The 95th percentile response time for single increment operations |
| Database | single_kv_append_rt_p95 | The 95th percentile response time for single append operations |
| Database | single_kv_all_rt_p95 | The 95th percentile response time for all single operations |
| Database | single_kv_delete_rt_p90 | The 90th percentile response time for single delete operations |
| Database | single_kv_insert_rt_p90 | The 90th percentile response time for single insert operations |
| Database | single_kv_select_rt_p90 | The 90th percentile response time for single select operations |
| Database | single_kv_update_rt_p90 | The 90th percentile response time for single update operations |
| Database | single_kv_insert_or_update_rt_p90 | The 90th percentile response time for single insert or update operations |
| Database | single_kv_increment_rt_p90 | The 90th percentile response time for single increment operations |
| Database | single_kv_append_rt_p90 | The 90th percentile response time for single append operations |
| Database | single_kv_all_rt_p90 | The 90th percentile response time for all single operations |
| Database | multi_kv_delete_count | The average number of batch delete operations per second |
| Database | multi_kv_insert_count | The average number of batch insert operations per second |
| Database | multi_kv_select_count | The average number of batch select operations per second |
| Database | multi_kv_update_count | The average number of batch update operations per second |
| Database | multi_kv_insert_or_update_count | The average number of batch insert or update operations per second |
| Database | multi_kv_replace_count | The average number of batch replace operations per second |
| Database | multi_kv_increment_count | The average number of batch increment operations per second |
| Database | multi_kv_append_count | The average number of batch append operations per second |
| Database | multi_kv_all_count | The average number of all batch operations per second |
| Database | multi_kv_delete_rt | The average response time for batch delete operations |
| Database | multi_kv_insert_rt | The average response time for batch insert operations |
| Database | multi_kv_select_rt | The average response time for batch select operations |
| Database | multi_kv_update_rt | The average response time for batch update operations |
| Database | multi_kv_insert_or_update_rt | The average response time for batch insert or update operations |
| Database | multi_kv_replace_rt | The average response time for batch replace operations |
| Database | multi_kv_increment_rt | The average response time for batch increment operations |
| Database | multi_kv_append_rt | The average response time for batch append operations |
| Database | multi_kv_all_rt | The average response time for all batch operations |
| Database | multi_kv_delete_row | The average number of rows in batch delete operations |
| Database | multi_kv_insert_row | The average number of rows in batch insert operations |
| Database | multi_kv_select_row | The average number of rows in batch select operations |
| Database | multi_kv_update_row | The average number of rows in batch update operations |
| Database | multi_kv_insert_or_update_row | The average number of rows in batch insert or update operations |
| Database | multi_kv_replace_row | The average number of rows in batch replace operations |
| Database | multi_kv_increment_row | The average number of rows in batch increment operations |
| Database | multi_kv_append_row | The average number of rows in batch append operations |
| Database | multi_kv_all_row | The average number of rows in all batch operations |
| Database | batch_kv_select_count | The average number of mixed batch select operations per second |
| Database | batch_kv_hybrid_count | The average number of mixed batch hybrid operations per second |
| Database | batch_kv_all_count | The average number of all mixed batch operations per second |
| Database | batch_kv_select_rt | The average response time for mixed batch select operations |
| Database | batch_kv_hybrid_rt | The average response time for mixed batch hybrid operations |
| Database | batch_kv_all_rt | The average response time for all mixed batch operations |
| Database | batch_kv_select_row | The average number of rows in mixed batch select operations |
| Database | batch_kv_hybrid_row | The average number of rows in mixed batch hybrid operations |
| Database | batch_kv_all_row | The average number of rows in all mixed batch operations |
| Database | query_kv_select_count | The average number of query operations per second |
| Database | query_kv_select_rt | The average response time for query operations |
| Database | query_kv_select_row | The average number of rows in query operations |
| Database | query_and_muate_kv_select_count | The average number of query and mutate operations |
| Database | query_and_muate_kv_select_rt | The average response time for query and mutate operations |
| Database | query_and_muate_kv_select_row | The average number of rows in query and mutate operations |
| Database | sql_all_count | The number of SQL statements processed per second |
| Database | sql_delete_count | The number of DELETE statements processed per second |
| Database | sql_insert_count | The number of INSERT statements processed per second |
| Database | sql_other_count | The number of other statements (DDL, DCL, DTL) processed per second |
| Database | sql_replace_count | The number of REPLACE statements processed per second |
| Database | sql_select_count | The number of SELECT statements processed per second |
| Database | sql_update_count | The number of UPDATE statements processed per second |
| Database | sql_all_rt | The average time spent processing SQL statements |
| Database | sql_delete_rt | The average time spent processing DELETE statements |
| Database | sql_insert_rt | The average time spent processing INSERT statements |
| Database | sql_other_rt | The average time spent processing other statements (DDL, DCL, DTL) |
| Database | sql_replace_rt | The average time spent processing REPLACE statements |
| Database | sql_select_rt | The average time spent processing SELECT statements |
| Database | sql_update_rt | The average time spent processing UPDATE statements |
| Database | transaction_commit_count | The number of transactions committed per second |
| Database | transaction_count | TPS |
| Database | transaction_rollback_count | The number of transactions rolled back per second |
| Database | transaction_timeout_count | The number of transactions that time out per second |
| Database | transaction_commit_rt | The average time spent committing transactions |
| Database | transaction_rollback_rt | The average time spent rolling back transactions |
| Database | transaction_rt | The average time spent processing transactions on the server side |
| Database | active_session | The number of active sessions |
| Database | all_session | The total number of sessions |
| Database | request_queue_time | The waiting time of SQL requests in the queue |
| Database | trans_commit_log_count | The number of transaction logs committed per second |
| Database | clog_trans_log_total_size | The total size of transaction logs committed per second |
| Database | io_count | The number of I/O operations per second in SSStore |
| Database | io_read_count | The number of read operations per second in SSStore |
| Database | io_write_count | The number of write operations per second in SSStore |
| Database | io_read_rt | The average time spent on each read operation in SSStore |
| Database | io_rt | The average time spent on I/O operations |
| Database | io_write_rt | The average time spent on each write operation in SSStore |
| Database | io_read_size | The amount of data read per second from SSStore |
| Database | io_size | The amount of data processed per second in SSStore |
| Database | io_write_size | The amount of data written per second to SSStore |
| Database | transaction_multi_partition_count | The number of distributed transactions per second |
| Database | transaction_partition_count | The number of transactions per second |
| Database | transaction_single_partition_count | The number of single-partition transactions per second |
| Database | uptime | The service uptime |
| Database | trans_commit_log_sync_rt | The average time spent on transaction log network synchronization |
| Database | ob_waiteven_count | The number of wait events in the database |
| Database | ob_foreground_waitevent_count | The number of wait events in the database frontend |
| Database | ob_background_waiteven_count | The number of wait events in the database backend |
| Database | ob_sql_event | The number of execution events in the database |
| Database | ob_sql_event_in_parse | The number of execution events in PARSE state |
| Database | ob_sql_event_in_pl_parse | The number of execution events in PL PARSE state |
| Database | ob_sql_event_in_plan_cache | The number of execution events in PLAN CACHE state |
| Database | ob_sql_event_in_sql_optimize | The number of execution events in SQL OPTIMIZE state |
| Database | ob_sql_event_in_sql_execution | The number of execution events in SQL EXECUTION state |
| Database | ob_sql_event_in_px_execution | The number of execution events in PX EXECUTION state |
| Database | ob_sql_event_in_sequence_load | The number of execution events in SEQUENCE LOAD state |
| Database | ob_tenant_log_disk_total_bytes | The total size of the log disk |
| Database | ob_tenant_log_disk_used_bytes | The used space of the log disk |
| Database | ob_tenant_server_required_size | The occupied data space |
| Database | ob_tenant_server_data_size | The data volume |
| Database | ob_tenant_binlog_disk_used | The disk space used by binlogs |
| Host | load1 | The average system load in the last 1 minute |
| Host | load15 | The average system load in the last 15 minutes |
| Host | load5 | The average system load in the last 5 minutes |
| Host | cpu_percent | The CPU utilization |
| Host | memory_buffers | The size of kernel buffer cache |
| Host | memory_cached | The memory used by caches |
| Host | memory_free | The size of available physical memory |
| Host | memory_used | The size of used physical memory |
| Host | net_recv | The amount of data received per second |
| Host | net_send | The amount of data sent per second |
| Host | net_throughput | The network throughput |
| Host | ntp_offset_milliseconds | The NTP clock offset |
| Host | ob_data_disk_percent | The data disk usage of OB |
| Host | ob_clog_disk_percent | The log disk usage of OB |
| Host | ob_data_disk_used_size | The disk space used |
| Host | ob_process_exists | The OB process status |
| Host | ob_clog_io | The average number of I/O operations per second on the log disk |
| Host | ob_clog_io_read | The average number of read operations per second on the log disk |
| Host | ob_clog_io_write | The average number of write operations per second on the log disk |
| Host | ob_clog_io_read_time | The average time spent on each read operation on the log disk |
| Host | ob_clog_io_time | The average time spent on each I/O operation on the log disk |
| Host | ob_clog_io_write_time | The average time spent on each write operation on the log disk |
| Host | ob_clog_io_byte | The average I/O throughput per second on the log disk |
| Host | ob_clog_io_read_byte | The read I/O throughput per second on the log disk |
| Host | ob_clog_io_write_byte | The write I/O throughput per second on the log disk |
| Host | ob_clog_io_util | The I/O utilization of the log disk |
| Host | ob_data_io | The average number of I/O operations per second on the data disk |
| Host | ob_data_io_read | The average number of read operations per second on the data disk |
| Host | ob_data_io_write | The average number of write operations per second on the data disk |
| Host | ob_data_io_read_time | The average time spent on each read operation on the data disk |
| Host | ob_data_io_time | The average time spent on each I/O operation on the data disk |
| Host | ob_data_io_write_time | The average time spent on each write operation on the data disk |
| Host | ob_data_io_byte | The average I/O throughput per second on the data disk |
| Host | ob_data_io_read_byte | The read I/O throughput per second on the data disk |
| Host | ob_data_io_write_byte | The write I/O throughput per second on the data disk |
| Host | ob_data_io_util | The I/O utilization of the data disk |
| Database Proxy | client_connections | The number of client connections |
| Database Proxy | server_connections | The number of server connections |