Customize a monitoring dashboard for an instance|OceanBase Cloud| docs|Distributed Database

Customize a monitoring dashboard for an instance

Last Updated：2025-10-21 07:33:55 Updated

On the performance monitoring page of an instance in OceanBase Cloud, you can create a custom monitoring dashboard by configuring monitoring metrics as needed.

Procedure

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. Click the Custom Dashboard tab.
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 tenants and metrics to be monitored. For more information, see Monitoring metrics for an instance.
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 an instance.
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 an instance

Metric category	Metric	Description
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 that are processed per second, such as data definition language (DDL), data control language (DCL), and data transaction language (DTL) statements.
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 in processing an SQL statement.
Database	sql_delete_rt	The average time spent in processing a DELETE statement.
Database	sql_insert_rt	The average time spent in processing an INSERT statement.
Database	sql_other_rt	The average time spent in processing another type of statement such as a DDL, DCL, or DTL statement.
Database	sql_replace_rt	The average time spent in processing a REPLACE statement.
Database	sql_select_rt	The average time spent in processing a SELECT statement.
Database	sql_update_rt	The average time spent in processing an UPDATE statement.
Database	transaction_commit_count	The number of transactions committed per second.
Database	transaction_count	The number of transactions processed per second.
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 in committing a transaction.
Database	transaction_rollback_rt	The average time spent in rolling back a transaction.
Database	transaction_rt	The average time spent in processing a transaction.
Database	active_session	The number of active sessions.
Database	all_session	The total number of sessions.
Database	request_queue_time	The average waiting time of an SQL statement in a 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 average number of I/O operations per second in the SSStore.
Database	io_read_count	The number of reads from the SSStore per second.
Database	io_write_count	The number of writes to the SSStore per second.
Database	io_read_rt	The average time spent on each SSStore read.
Database	io_rt	The average time spent on each I/O operation.
Database	io_write_rt	The average time spent on each SSStore write.
Database	io_read_size	The amount of data read from the SSStore per second.
Database	io_size	The amount of data processed per second in the SSStore.
Database	io_write_size	The amount of data written to the SSStore per second.
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 regular transactions per second.
Database	uptime	Database service hours.
Database	trans_commit_log_sync_rt	The average time spent on each synchronization of transaction logs over the network.
Database	ob_worktime	Database working hours.
Database	ob_foreground_worktime	Database frontend working hours.
Database	ob_background_worktime	Database backend working hours.
Database	ob_no_idle_waiting_time	Database non-idle wait time.
Database	ob_foreground_no_idle_waiting_time	Database frontend non-idle wait time.
Database	ob_background_no_idle_waiting_time	Database backend non-idle wait time.
Database	ob_waiteven_count	The number of wait events in a specific state in the database of the tenant.
Database	ob_foreground_waitevent_count	The number of wait events in a specific state in the database frontend of the tenant.
Database	ob_background_waiteven_count	The number of wait events in a specific state in the database backend of the tenant.
Database	ob_sql_event	The number of execution events in a specific state in the tenant.
Database	ob_sql_event_in_parse	The number of execution events in the PARSE state in the tenant.
Database	ob_sql_event_in_pl_parse	The number of execution events in the PL PARSE state the tenant.
Database	ob_sql_event_in_plan_cache	The number of execution events in the PLAN CACHE state in the tenant.
Database	ob_sql_event_in_sql_optimize	The number of execution events in the SQL OPTIMIZE state in the tenant.
Database	ob_sql_event_in_sql_execution	The number of execution events in the SQL EXECUTION state in the tenant.
Database	ob_sql_event_in_px_execution	The number of execution events in the PX EXECUTION state in the tenant.
Database	ob_sql_event_in_sequence_load	The number of execution events in the SEQUENCE LOAD state in the tenant.
Database	ob_tenant_log_disk_total_bytes	The total size of the tenant log disk.
Database	ob_tenant_log_disk_used_bytes	The occupied space of the tenant log disk.
Database	ob_tenant_disk_used_percentage	The disk space occupied by tenant data.
Database	ob_tenant_data_size	The volume of tenant data.
Database	ob_tenant_binlog_disk_used	The size of disk space occupied 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 the kernel buffer cache.
Host	memory_cached	The size of the memory used by caches.
Host	memory_free	The size of the available physical memory.
Host	memory_used	The size of the 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 of the node.
Host	ob_data_disk_percent	The data disk usage of the node.
Host	ob_clog_disk_percent	The log disk usage of the node.
Host	ob_data_disk_used_size	The size of used data disk space on the node.
Host	ob_process_exists	The status of the observer process on the node.
Host	ob_clog_io	The average number of I/O operations per second on the log disk of the node.
Host	ob_clog_io_read	The average number of I/O reads per second from the log disk of the node.
Host	ob_clog_io_write	The average number of I/O writes per second to the log disk of the node.
Host	ob_clog_io_read_time	The average time spent on each I/O read from the log disk of the node.
Host	ob_clog_io_time	The average time spent on each I/O operation on the log disk of the node.
Host	ob_clog_io_write_time	The average time spent on each I/O write to the log disk of the node.
Host	ob_clog_io_byte	The average I/O throughput per second of the log disk of the node.
Host	ob_clog_io_read_byte	The average throughput of I/O reads per second from the log disk of the node.
Host	ob_clog_io_write_byte	The average throughput of I/O writes per second to the log disk of the node.
Host	ob_clog_io_util	The I/O usage of the log disk of the node.
Host	ob_data_io	The average number of I/O operations per second on the data disk of the node.
Host	ob_data_io_read	The average number of I/O reads per second from the data disk of the node.
Host	ob_data_io_write	The average number of I/O writes per second to the data disk of the node.
Host	ob_data_io_read_time	The average time spent on each I/O read from the data disk of the node.
Host	ob_data_io_time	The average time spent on each I/O operation on the data disk of the node.
Host	ob_data_io_write_time	The average time spent on each I/O write to the data disk of the node.
Host	ob_data_io_byte	The average I/O throughput per second of the data disk of the node.
Host	ob_data_io_read_byte	The average throughput of I/O reads per second from the data disk of the node.
Host	ob_data_io_write_byte	The average throughput of I/O writes per second to the data disk of the node.
Host	ob_data_io_util	The I/O usage of the data disk of the node.
Host	ob_host_real_time_iops	The realtime IOPS of OceanBase host.
Host	ob_host_real_time_throughput	The realtime throughput of OceanBase host.
Host	ob_host_iops_used_percent	The IOPS usage rate of OceanBase host.
Host	ob_host_throughput_used_percent	The throughput usage rate of OceanBase host.