On the cluster instance 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 the OceanBase Cloud console.
In the left-side navigation pane, click Cluster List.
In the cluster list, find the target cluster and click its name to go to the Cluster Workspace.
On the cluster dashboard, click the Custom Dashboard tab.
On the Custom Dashboard tab, you can manage 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 and monitoring metrics to monitor. For detailed descriptions of the monitoring metrics, see Cluster monitoring metrics list.
Note
- The dashboard name cannot exceed 20 characters in length.
- You can create up to 7 custom 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 Cluster 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 choose Delete Dashboard.
In the confirmation dialog box, click OK.
Cluster monitoring metrics list
Monitoring Metrics Classification |
Monitoring Metric Name |
unit |
Metric description |
|---|---|---|---|
| Cluster database | sql_delete_count | times/s | DELETE statements processed per second |
| Cluster database | sql_other_count | times/s | Number of Other Statements Such as DDL, DCL, and DTL |
| Cluster database | sql_replace_count | times/s | REPLACE statements processed per second |
| Cluster database | sql_select_count | times/s | SELECT statements processed per second |
| Cluster database | sql_update_count | times/s | UPDATE statements processed per second |
| Cluster database | sql_all_rt | ms | Average processing time for SQL statements |
| Cluster database | sql_delete_rt | ms | Average processing time for DELETE statements |
| Cluster database | sql_insert_rt | ms | Average processing time for INSERT statements |
| Cluster database | sql_other_rt | ms | Average Processing Time for Other Statements Such as DDL, DCL, and DTL |
| Cluster database | sql_replace_rt | ms | Average processing time for REPLACE statements |
| Cluster database | sql_select_rt | ms | Average processing time for SELECT statements |
| Cluster database | sql_update_rt | ms | Average processing time for UPDATE statements |
| Cluster database | sql_all_rt_p99 | ms | P99 response time for all SQL statements |
| Cluster database | sql_delete_rt_p99 | ms | P99 response time for DELETE statements |
| Cluster database | sql_insert_rt_p99 | ms | P99 response time for INSERT statements |
| Cluster database | sql_other_rt_p99 | ms | P99 response time for other statements |
| Cluster database | sql_replace_rt_p99 | ms | P99 response time for REPLACE statements |
| Cluster database | sql_select_rt_p99 | ms | P99 response time for SELECT statements |
| Cluster database | sql_update_rt_p99 | ms | P99 response time for UPDATE statements |
| Cluster database | sql_all_rt_p95 | ms | P95 response time for all SQL statements |
| Cluster database | sql_delete_rt_p95 | ms | P95 response time for DELETE statements |
| Cluster database | sql_insert_rt_p95 | ms | P95 response time for INSERT statements |
| Cluster database | sql_other_rt_p95 | ms | P95 response time for other statements |
| Cluster database | sql_replace_rt_p95 | ms | P95 response time for REPLACE statements |
| Cluster database | sql_select_rt_p95 | ms | P95 response time for SELECT statements |
| Cluster database | sql_update_rt_p95 | ms | P95 response time for UPDATE statements |
| Cluster database | sql_all_rt_p90 | ms | P90 response time for all SQL statements |
| Cluster database | sql_delete_rt_p90 | ms | P90 response time for DELETE statements |
| Cluster database | sql_insert_rt_p90 | ms | P90 response time for INSERT statements |
| Cluster database | sql_other_rt_p90 | ms | P90 response time for other statements |
| Cluster database | sql_replace_rt_p90 | ms | P90 response time for REPLACE statements |
| Cluster database | sql_select_rt_p90 | ms | P90 response time for SELECT statements |
| Cluster database | sql_update_rt_p90 | ms | P90 response time for UPDATE statements |
| Cluster database | io_count | times/s | SSStore IOPS |
| Cluster database | io_read_count | times/s | SSStore Reads Per Second |
| Cluster database | io_write_count | times/s | SSStore Write Operations Per Second |
| Cluster database | io_rt | μs | I/O Time |
| Cluster database | io_read_rt | μs | Average Time Consumed per SSStore Read |
| Cluster database | io_write_rt | μs | Average Time Consumed per SSStore Write |
| Cluster database | io_size | byte | SSStore Data Processing Volume per Second |
| Cluster database | io_read_size | byte | SSStore Data Read Volume per Second |
| Cluster database | io_write_size | byte | SSStore Data Written per Second |
| Cluster database | ob_waitevent_count | times/s | Number of wait events in a specific database state |
| Cluster database | ob_foreground_waitevent_count | times/s | Number of foreground wait events in a specific database state |
| Cluster database | ob_background_waitevent_count | times/s | Number of background wait events in a specific database state |
| Cluster database | ob_sql_event | Count | Number of execution events in a specific database state |
| Cluster database | ob_sql_event_in_parse | Count | Number of execution events in the parse state |
| Cluster database | ob_sql_event_in_pl_parse | Count | Number of execution events in the pl parse state |
| Cluster database | ob_sql_event_in_plan_cache | Count | Number of execution events in the plan cache state |
| Cluster database | ob_sql_event_in_sql_optimize | Count | Number of execution events in the sql optimize state |
| Cluster database | ob_sql_event_in_sql_execution | Count | Number of execution events in the sql execution state |
| Cluster database | ob_sql_event_in_px_execution | Count | Number of execution events in the px execution state |
| Cluster database | ob_sql_event_in_sequence_load | Count | Number of execution events in the sequence load state |
| Cluster database | all_session | Count | Current Sessions |
| Cluster database | active_session | Count | Current Active Sessions |
| Cluster database | transaction_count | times/s | TPS |
| Cluster database | transaction_commit_count | times/s | Transactions committed per second |
| Cluster database | transaction_rollback_count | times/s | Transactions rolled back per second |
| Cluster database | transaction_timeout_count | times/s | Transactions timed out per second |
| Cluster database | transaction_rt | ms | Average Transaction Processing Time on Server |
| Cluster database | transaction_commit_rt | ms | Average Transaction Commit Time |
| Cluster database | transaction_rollback_rt | ms | Average Transaction Rollback Time |
| Cluster database | request_queue_time | μs | Waiting Time of SQL Requests in the Queue |
| Cluster database | trans_commit_log_count | times/s | Number of Transaction Logs Committed per Second |
| Cluster database | clog_trans_log_total_size | byte | Size of Transaction Logs Committed per Second |
| Cluster database | transaction_partition_count | times/s | TPS |
| Cluster database | transaction_multi_partition_count | times/s | Distributed Transactions Per Second |
| Cluster database | transaction_single_partition_count | times/s | Regular transactions per second |
| Cluster database | trans_commit_log_sync_rt | μs | Average time to synchronize a transaction log over the network |
| Cluster database | ob_tenant_log_disk_total_bytes | GiB | Total Log Disk Space |
| Cluster database | ob_tenant_log_disk_used_bytes | GiB | Log Disk Usage |
| Cluster database | ob_tenant_server_required_size | GiB | Tenant Data Usage |
| Cluster database | ob_tenant_server_data_size | GiB | Tenant Data Volume |
| Cluster database | ob_tenant_binlog_disk_used | GiB | Disk Usage of Binlog Logs |
| Cluster Host | load1 | - | Average System Load in Last 1 Minute |
| Cluster Host | load5 | - | Average System Load in Last 5 Minutes |
| Cluster Host | load15 | - | Average System Load in Last 15 Minutes |
| Cluster Host | cpu_percent | Percentage (%) | CPU Usage |
| Cluster Host | memory_percent | Percentage (%) | OceanBase tenant memory utilization |
| Cluster Host | net_throughput | MiB | Network Throughput |
| Cluster Host | net_recv | MiB | Data Received per Second |
| Cluster Host | net_send | MiB | Data Sent per Second |
| Cluster Host | ob_data_disk_used_size | GiB | Disk Usage |
| Cluster Host | ob_data_disk_percent | Percentage (%) | Space utilization of the OceanBase data disk |
| Cluster Host | ob_clog_disk_percent | Percentage (%) | Space utilization of the OceanBase log disk |
| Cluster Host | ob_data_required_size | GiB | Data Usage |
| Cluster Host | ob_clog_io | times/s | Average IOPS of the OceanBase log disk |
| Cluster Host | ob_clog_io_read | times/s | Average read IOPS of the OceanBase log disk |
| Cluster Host | ob_clog_io_write | times/s | Average write IOPS of the OceanBase log disk |
| Cluster Host | ob_clog_io_time | μs | Average I/O latency of the OceanBase log disk |
| Cluster Host | ob_clog_io_read_time | times/s | Average read latency of the OceanBase log disk |
| Cluster Host | ob_clog_io_write_time | times/s | Average write latency of the OceanBase log disk |
| Cluster Host | ob_clog_io_byte | MiB | Average I/O throughput of the OceanBase log disk |
| Cluster Host | ob_clog_io_read_byte | MiB | Read throughput of the OceanBase log disk |
| Cluster Host | ob_clog_io_write_byte | MiB | Write throughput of the OceanBase log disk |
| Cluster Host | ob_clog_io_util | Percentage (%) | I/O busy ratio of the OceanBase log disk |
| Cluster Host | obcloud.metric_chart.host.log_disk_io_util_percent | Percentage (%) | I/O utilization of the OceanBase log disk |
| Cluster Host | obcloud.metric_chart.host.log_disk_throughput_util_percent | Percentage (%) | Throughput utilization of the OceanBase log disk |
| Cluster Host | ob_data_io | times/s | Average IOPS of the OceanBase data disk |
| Cluster Host | ob_data_io_read | times/s | Average read IOPS of the OceanBase data disk |
| Cluster Host | ob_data_io_write | times/s | Average write IOPS of the OceanBase data disk |
| Cluster Host | ob_data_io_time | ms | Average I/O latency of the OceanBase data disk |
| Cluster Host | ob_data_io_read_time | ms | Average read latency of the OceanBase data disk |
| Cluster Host | ob_data_io_write_time | ms | Average write latency of the OceanBase data disk |
| Cluster Host | ob_data_io_byte | MiB | Average I/O throughput of the OceanBase data disk |
| Cluster Host | ob_data_io_read_byte | MiB | Read throughput of the OceanBase data disk |
| Cluster Host | ob_data_io_write_byte | MiB | Write throughput of the OceanBase data disk |
| Cluster Host | ob_data_io_util | Percentage (%) | I/O busy ratio of the OceanBase data disk |
| Cluster Host | obcloud.metric_chart.host.data_disk_io_util_percent | Percentage (%) | I/O utilization of the OceanBase data disk |
| Cluster Host | obcloud.metric_chart.host.data_disk_throughput_util_percent | Percentage (%) | Throughput utilization of the OceanBase data disk |
| Cluster Host | ob_host_real_time_iops | Count | Real-time IOPS of OB Host |
| Cluster Host | ob_host_real_time_throughput | MiB/s | Real-time Throughput of OB Host |
| Cluster Host | ob_host_iops_used_percent | Percentage (%) | IO Usage of OB Host |
| Cluster Host | ob_host_throughput_used_percent | Percentage (%) | OB Host Throughput Utilization |
| Cluster Host | ntp_offset_milliseconds | ms | NTP Clock Offset |
| Cluster Host | uptime | s | Available Time |
| Cluster Host | ob_process_exists | - | OB Process Liveness Status |
| Database Proxy | client_connections | Count | Number of client connections through the database proxy |
| Database Proxy | server_connections | Count | Number of server-side connections through the database proxy |
| Database Proxy | qps | times/s | SQL statements processed per second |
| Database Proxy | qps_select | times/s | SELECT statements processed per second |
| Database Proxy | qps_update | times/s | UPDATE statements processed per second |
| Database Proxy | qps_insert | times/s | INSERT statements processed per second |
| Database Proxy | qps_delete | times/s | DELETE statements processed per second |
| Database Proxy | qps_other | times/s | Other Statements Processed per Second |
| Database Proxy | qps_rt_total | ms | Average processing time for SQL statements |
| Database Proxy | qps_rt_total_select | ms | Average processing time for SELECT statements |
| Database Proxy | qps_rt_total_update | ms | Average processing time for UPDATE statements |
| Database Proxy | qps_rt_total_insert | ms | Average processing time for INSERT statements |
| Database Proxy | qps_rt_total_delete | ms | Average processing time for DELETE statements |
| Database Proxy | qps_rt_total_other | ms | Average Processing Time for Other Statements Such as DDL, DCL, and DTL |
| Database Proxy | tps | times/s | Transactions Per Second |
| Database Proxy Host | load1 | - | Average System Load in Last 1 Minute |
| Database Proxy Host | load5 | - | Average System Load in Last 5 Minutes |
| Database Proxy Host | load15 | - | Average System Load in Last 15 Minutes |
| Database Proxy Host | cpu_percent | Percentage (%) | CPU Usage |
| Database Proxy Host | memory_buffers | GiB | Kernel Buffer Cache Size |
| Database Proxy Host | memory_free | GiB | Available Physical Memory |
| Database Proxy Host | io_read | times/s | Reads Per Second |
| Database Proxy Host | io_write | times/s | Write Operations Per Second |
| Database Proxy Host | net_recv | MiB | Data Received per Second |
| Database Proxy Host | net_send | MiB | Data Sent per Second |