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 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, tenants, 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 |
|---|---|---|---|
| Cluster database | sql_delete_count | times/s | The number of Delete statements processed per second. |
| Cluster database | sql_other_count | times/s | The number of other statements, such as DDL, DCL, and DTL statements, processed per second. |
| Cluster database | sql_replace_count | times/s | The number of Replace statements processed per second. |
| Cluster database | sql_select_count | times/s | The number of Select statements processed per second. |
| Cluster database | sql_update_count | times/s | The number of Update statements processed per second. |
| Cluster database | sql_all_rt | ms | The average processing time of SQL statements. |
| Cluster database | sql_delete_rt | ms | The average processing time of Delete statements. |
| Cluster database | sql_insert_rt | ms | The average processing time of Insert statements. |
| Cluster database | sql_other_rt | ms | The average processing time of other statements, such as DDL, DCL, and DTL statements. |
| Cluster database | sql_replace_rt | ms | The average processing time of Replace statements. |
| Cluster database | sql_select_rt | ms | The average processing time of Select statements. |
| Cluster database | sql_update_rt | ms | The average processing time of Update statements. |
| Cluster database | sql_all_rt_p99 | ms | The 99th percentile processing time of SQL statements. |
| Cluster database | sql_delete_rt_p99 | ms | The 99th percentile processing time of Delete statements. |
| Cluster database | sql_insert_rt_p99 | ms | The 99th percentile processing time of Insert statements. |
| Cluster database | sql_other_rt_p99 | ms | The 99th percentile processing time of other statements, such as DDL, DCL, and DTL statements. |
| Cluster database | sql_replace_rt_p99 | ms | The 99th percentile processing time of Replace statements. |
| Cluster database | sql_select_rt_p99 | ms | The 99th percentile processing time of Select statements. |
| Cluster database | sql_update_rt_p99 | ms | The 99th percentile processing time of Update statements. |
| Cluster database | sql_all_rt_p95 | ms | The 95th percentile processing time of SQL statements. |
| Cluster database | sql_delete_rt_p95 | ms | The 95th percentile processing time of Delete statements. |
| Cluster database | sql_insert_rt_p95 | ms | The 95th percentile processing time of Insert statements. |
| Cluster database | sql_other_rt_p95 | ms | The 95th percentile processing time of other statements, such as DDL, DCL, and DTL statements. |
| Cluster database | sql_replace_rt_p95 | ms | The 95th percentile processing time of Replace statements. |
| Cluster database | sql_select_rt_p95 | ms | The 95th percentile processing time of Select statements. |
| Cluster database | sql_update_rt_p95 | ms | The 95th percentile processing time of Update statements. |
| Cluster database | sql_all_rt_p90 | ms | The 90th percentile processing time of SQL statements. |
| Cluster database | sql_delete_rt_p90 | ms | The 90th percentile processing time of Delete statements. |
| Cluster database | sql_insert_rt_p90 | ms | The 90th percentile processing time of Insert statements. |
| Cluster database | sql_other_rt_p90 | ms | The 90th percentile processing time of other statements, such as DDL, DCL, and DTL statements. |
| Cluster database | sql_replace_rt_p90 | ms | The 90th percentile processing time of Replace statements. |
| Cluster database | sql_select_rt_p90 | ms | The 90th percentile processing time of Select statements. |
| Cluster database | sql_update_rt_p90 | ms | The 90th percentile processing time of Update statements. |
| Cluster database | io_count | times/s | The number of I/O operations performed by SSStore per second. |
| Cluster database | io_read_count | times/s | The number of read operations performed by SSStore per second. |
| Cluster database | io_write_count | times/s | The number of write operations performed by SSStore per second. |
| Cluster database | io_rt | μs | The I/O time. |
| Cluster database | io_read_rt | μs | The average read time of SSStore. |
| Cluster database | io_read_rt | μs | The average write time of SSStore. |
| Cluster database | io_size | byte | The amount of data processed by SSStore per second. |
| Cluster database | io_read_size | byte | The amount of data read by SSStore per second. |
| Cluster database | io_write_size | byte | The amount of data written by SSStore per second. |
| Cluster database | ob_waitevent_count | times/s | The number of wait events in a specific state. |
| Cluster database | ob_foreground_waitevent_count | times/s | The number of wait events in a specific state in the foreground. |
| Cluster database | ob_background_waitevent_count | times/s | The number of wait events in a specific state in the background. |
| Cluster database | ob_sql_event | count | The number of execution events in a specific state. |
| Cluster database | ob_sql_event_in_parse | count | The number of execution events in the parse state. |
| Cluster database | ob_sql_event_in_pl_parse | count | The number of execution events in the pl parse state. |
| Cluster database | ob_sql_event_in_plan_cache | count | The number of execution events in the plan cache state. |
| Cluster database | ob_sql_event_in_sql_optimize | count | The number of execution events in the sql optimize state. |
| Cluster database | ob_sql_event_in_sql_execution | count | The number of execution events in the sql execution state. |
| Cluster database | ob_sql_event_in_px_execution | count | The number of execution events in the px execution state. |
| Cluster database | ob_sql_event_in_sequence_load | count | The number of execution events in the sequence load state. |
| Cluster database | all_session | count | The number of current sessions. |
| Cluster database | active_session | count | The number of current active sessions. |
| Cluster database | transaction_count | times/s | TPS |
| Cluster database | transaction_commit_count | times/s | The number of committed transactions per second. |
| Cluster database | transaction_rollback_count | times/s | The number of rolled-back transactions per second. |
| Cluster Database | transaction_timeout_count | times/s | Number of transaction timeouts per second |
| Cluster Database | transaction_rt | ms | Average transaction processing time on the 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 | SQL request waiting time in the waiting 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 | Number of transactions per second |
| Cluster Database | transaction_multi_partition_count | times/s | Number of distributed transactions per second |
| Cluster Database | transaction_single_partition_count | times/s | Number of regular transactions per second |
| Cluster Database | trans_commit_log_sync_rt | μs | Average transaction log network synchronization time per transaction |
| Cluster Database | ob_tenant_log_disk_total_bytes | GiB | Total size of log disks |
| Cluster Database | ob_tenant_log_disk_used_bytes | GiB | Size of log disk used |
| Cluster Database | ob_tenant_server_required_size | GiB | Data size occupied by the tenant |
| Cluster Database | ob_tenant_server_data_size | GiB | Data size of the tenant |
| Cluster Database | ob_tenant_binlog_disk_used | GiB | Size of Binlog disk used |
| Cluster Host | load1 | - | Average system load over the last 1 minute |
| Cluster Host | load5 | - | Average system load over the last 5 minutes |
| Cluster Host | load15 | - | Average system load over the last 15 minutes |
| Cluster Host | cpu_percent | Percentage (%) | CPU utilization |
| Cluster Host | memory_percent | Percentage (%) | OB 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 (%) | OB data disk utilization |
| Cluster Host | ob_clog_disk_percent | Percentage (%) | OB log disk utilization |
| Cluster Host | ob_data_required_size | GiB | Data size occupied |
| Cluster Host | ob_clog_io | times/s | Average number of I/O operations per second on the OB log disk |
| Cluster Host | ob_clog_io_read | times/s | Average number of read I/O operations per second on the OB log disk |
| Cluster Host | ob_clog_io_write | times/s | Average number of write I/O operations per second on the OB log disk |
| Cluster Host | ob_clog_io_time | times/s | Average I/O time per I/O operation on the OB log disk |
| Cluster Host | ob_clog_io_read_time | times/s | Average read I/O time per I/O operation on the OB log disk |
| Cluster Host | ob_clog_io_write_time | times/s | Average write I/O time per I/O operation on the OB log disk |
| Cluster Host | ob_clog_io_byte | MiB | Average I/O data per second on the OB log disk |
| Cluster Host | ob_clog_io_read_byte | MiB | Average read I/O data per second on the OB log disk |
| Cluster Host | ob_clog_io_write_byte | MiB | Average write I/O data per second on the OB log disk |
| Cluster Host | ob_clog_io_util | Percentage (%) | I/O busy ratio of the OB log disk |
| Cluster Host | obcloud.metric_chart.host.log_disk_io_util_percent | Percentage (%) | I/O utilization of the OB log disk |
| Cluster Host | obcloud.metric_chart.host.log_disk_throughput_util_percent | Percentage (%) | Throughput utilization of the OB log disk |
| Cluster Host | ob_data_io | times/s | Average number of I/O operations per second on the OB data disk |
| Cluster Host | ob_data_io_read | times/s | Average number of read I/O operations per second on the OB data disk |
| Cluster Host | ob_data_io_write | times/s | Average number of write I/O operations per second on the OB data disk |
| Cluster Host | ob_data_io_time | ms | Average I/O time per I/O operation on the OB data disk |
| Cluster Host | ob_data_io_read_time | ms | Average read I/O time per I/O operation on the OB data disk |
| Cluster Host | ob_data_io_write_time | ms | Average write I/O time per I/O operation on the OB data disk |
| Cluster Host | ob_data_io_byte | MiB | Average I/O data per second on the OB data disk |
| Cluster Host | ob_data_io_read_byte | MiB | Average read I/O data per second on the OB data disk |
| Cluster Host | ob_data_io_write_byte | MiB | Average write I/O data per second on the OB data disk |
| Cluster Host | ob_data_io_util | Percentage (%) | I/O busy ratio of the OB data disk |
| Cluster Host | obcloud.metric_chart.host.data_disk_io_util_percent | Percentage (%) | I/O utilization of the OB data disk |
| Cluster Host | obcloud.metric_chart.host.data_disk_throughput_util_percent | Percentage (%) | Throughput utilization of the OB data disk |
| Cluster Host | ob_host_real_time_iops | count | Real-time IOPS of the OB host |
| Cluster Host | ob_host_real_time_throughput | MiB/s | Real-time throughput of the OB host |
| Cluster Host | ob_host_iops_used_percent | Percentage (%) | I/O utilization of the OB host |
| Cluster Host | ob_host_throughput_used_percent | Percentage (%) | Throughput utilization of the OB host |
| Cluster Host | ntp_offset_milliseconds | ms | NTP clock offset |
| Cluster Host | uptime | s | Uptime |
| Cluster Host | ob_process_exists | - | OB process status |
| Database Proxy | client_connections | count | Number of clients connected to the database through the database proxy |
| Database Proxy | server_connections | count | Number of servers connected to the database through the database proxy |
| Database Proxy | qps | times/s | Number of SQL statements processed per second |
| Database Proxy | qps_select | times/s | Number of SELECT statements processed per second |
| Database Agent | qps_update | times/s | Number of update statements processed per second |
| Database Agent | qps_insert | times/s | Number of insert statements processed per second |
| Database Agent | qps_delete | times/s | Number of delete statements processed per second |
| Database Agent | qps_other | times/s | Number of other statements processed per second |
| Database Agent | qps_rt_total | ms | Average SQL statement processing time |
| Database Agent | qps_rt_total_select | ms | Average select statement processing time |
| Database Agent | qps_rt_total_update | ms | Average update statement processing time |
| Database Agent | qps_rt_total_insert | ms | Average insert statement processing time |
| Database Agent | qps_rt_total_delete | ms | Average delete statement processing time |
| Database Agent | qps_rt_total_other | ms | Average processing time of other statements such as DDL, DCL, and DTL |
| Database Agent | tps | times/s | Number of transactions requested per second |
| Database Agent Host | load1 | - | Average system load over the last minute |
| Database Agent Host | load5 | - | Average system load over the last 5 minutes |
| Database Agent Host | load15 | - | Average system load over the last 15 minutes |
| Database Agent Host | cpu_percent | Percentage (%) | CPU utilization |
| Database Agent Host | memory_buffers | GiB | Kernel buffer cache size |
| Database Agent Host | memory_free | GiB | Size of available physical memory |
| Database Agent Host | io_read | times/s | Number of read operations per second |
| Database Agent Host | io_write | times/s | Number of write operations per second |
| Database Agent Host | net_recv | MiB | Amount of data received per second |
| Database Agent Host | net_send | MiB | Amount of data sent per second |