On the performance monitoring page of a cluster instance, you can configure general metrics for the custom monitoring panel.
Create a custom report
Log on to the ApsaraDB for OceanBase console.
In the left-side navigation pane, click Instances.
In the instance list, click the name of the target instance to go to the instance workspace.
In the left-side navigation pane of the instance workspace, click Performance Monitoring.
On the Performance Monitoring page, click Add Custom Report in the upper-right corner.
Enter the name of the monitoring report, select the tenant for which you want to create the report, and select metrics for the report. For more information about the metrics, see Metrics.
NoteThe name of the report cannot exceed 20 characters in length.
At present, you can create at most seven custom monitoring reports.
Click OK. You can view the information about the created custom report on the Performance Monitoring page.
Edit a custom report
Log on to the ApsaraDB for OceanBase console.
In the left-side navigation pane, click Instances.
In the instance list, click the name of the target instance to go to the instance workspace.
In the left-side navigation pane of the instance workspace, click Performance Monitoring.
Find the target custom report, click the More icon next to the report name, and select Edit.
On the Edit Custom Report page, modify the report name, tenant, and metrics. For more information about the metrics, see Metrics.
Click OK.
Delete a custom report
Log on to the ApsaraDB for OceanBase console.
In the left-side navigation pane, click Instances.
In the instance list, click the name of the target instance to go to the instance workspace.
In the left-side navigation pane of the instance workspace, click Performance Monitoring.
Find the target custom report, click the More icon next to the report name, and select Delete.
In the pop-up window that appears, click OK.
Metrics
Metrics for database proxies and proxy hosts are available only if you have enabled proxy monitoring. Proxy-related monitoring is available for only customers on the allowlist. To enable proxy-related monitoring, contact Alibaba Cloud Technical Support.
Metric category | Metric | Description |
Cluster database | sql_all_count | Number of SQL statements processed per second. |
Cluster database | sql_delete_count | Number of DELETE statements processed per second. |
Cluster database | sql_insert_count | Number of INSERT statements processed per second. |
Cluster database | sql_other_count | 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. |
Cluster database | sql_replace_count | Number of REPLACE statements processed per second. |
Cluster database | sql_select_count | Number of SELECT statements processed per second. |
Cluster database | sql_update_count | Number of UPDATE statements processed per second. |
Cluster database | sql_all_rt | Average amount of time spent in processing an SQL statement. |
Cluster database | sql_delete_rt | Average amount of time spent in processing a DELETE statement. |
Cluster database | sql_insert_rt | Average amount of time spent in processing an INSERT statement. |
Cluster database | sql_other_rt | Average amount of time spent in processing each of other statements such as DDL, DCL, and DTL statements. |
Cluster database | sql_replace_rt | Average amount of time spent in processing a REPLACE statement. |
Cluster database | sql_select_rt | Average amount of time spent in processing a SELECT statement. |
Cluster database | sql_update_rt | Average amount of time spent in processing an UPDATE statement. |
Cluster database | transaction_commit_count | Number of transactions committed per second. |
Cluster database | transaction_count | Number of transactions processed per second. |
Cluster database | transaction_rollback_count | Number of transactions rolled back per second. |
Cluster database | transaction_timeout_count | Number of transactions that time out per second. |
Cluster database | transaction_commit_rt | Average amount of time spent in committing a transaction. |
Cluster database | transaction_rollback_rt | Average amount of time spent in rolling back a transaction. |
Cluster database | transaction_rt | Average amount of time spent in processing a transaction. |
Cluster database | active_session | Number of active sessions. |
Cluster database | all_session | Total number of sessions. |
Cluster database | request_queue_time | Average waiting time of an SQL statement in a queue. |
Cluster database | trans_commit_log_count | Number of transaction logs committed per second. |
Cluster database | clog_trans_log_total_size | Total size of transaction logs committed per second. |
Cluster database | io_count | Average number of I/O operations per second in the SSStore. |
Cluster database | io_read_count | Number of reads from the SSStore per second. |
Cluster database | io_write_count | Number of writes to the SSStore per second. |
Cluster database | io_read_rt | Average amount of time spent on each SSStore read. |
Cluster database | io_rt | Average amount of time spent on each I/O operation. |
Cluster database | io_write_rt | Average amount of time spent on each SSStore write. |
Cluster database | io_read_size | Amount of data read from the SSStore per second. |
Cluster database | io_size | Amount of data processed per second in the SSStore. |
Cluster database | io_write_size | Amount of data written to the SSStore per second. |
Cluster database | transaction_multi_partition_count | Number of distributed transactions per second. |
Cluster database | transaction_partition_count | Number of transactions per second. |
Cluster database | transaction_single_partition_count | Number of regular transactions per second. |
Cluster database | uptime | Active time. |
Cluster database | trans_commit_log_sync_rt | Average amount of time spent on each synchronization of transaction logs over the network. |
Cluster host | load1 | Average system load in the last minute. |
Cluster host | load15 | Average system load in the last 15 minutes. |
Cluster host | load5 | Average system load in the last 5 minutes. |
Cluster host | cpu_percent | CPU utilization. |
Cluster host | memory_buffers | Size of the kernel buffer cache. |
Cluster host | memory_cached | Size of the memory used by caches. |
Cluster host | memory_free | Size of the available physical memory. |
Cluster host | memory_used | Size of the physical memory used. |
Cluster host | net_recv | Amount of data received per second. |
Cluster host | net_send | Amount of data sent per second. |
Cluster host | net_throughput | Network throughput. |
Cluster host | ntp_offset_milliseconds | NTP clock offset. |
Cluster host | ob_data_disk_percent | OceanBase Database data disk usage. |
Cluster host | ob_clog_disk_percent | OceanBase Database log disk usage. |
Cluster host | ob_data_disk_used_size | Size of occupied data disk space of the OBServer node. |
Cluster host | ob_process_exists | Indicates whether the observer process of the OBServer node is alive. |
Cluster host | ob_clog_io | Average number of I/O operations per second on the log disk of the OBServer node. |
Cluster host | ob_clog_io_read | Average number of I/O reads per second from the log disk of the OBServer node. |
Cluster host | ob_clog_io_write | Average number of I/O writes per second to the log disk of the OBServer node. |
Cluster host | ob_clog_io_read_time | Average amount of time spent on each I/O read from the log disk of the OBServer node. |
Cluster host | ob_clog_io_time | Average amount of time spent on each I/O operation on the log disk of the OBServer node. |
Cluster host | ob_clog_io_write_time | Average amount of time spent on each I/O write to the log disk of the OBServer node. |
Cluster host | ob_clog_io_byte | Average I/O throughput per second of the log disk of the OBServer node. |
Cluster host | ob_clog_io_read_byte | Average throughput of I/O reads per second from the log disk of the OBServer node. |
Cluster host | ob_clog_io_write_byte | Average throughput of I/O writes per second to the log disk of the OBServer node. |
Cluster host | ob_clog_io_util | I/O usage of the log disk of the OBServer node. |
Cluster host | ob_data_io | Average number of I/O operations per second on the data disk of the OBServer node. |
Cluster host | ob_data_io_read | Average number of I/O reads per second from the data disk of the OBServer node. |
Cluster host | ob_data_io_write | Average number of I/O writes per second to the data disk of the OBServer node. |
Cluster host | ob_data_io_read_time | Average amount of time spent on each I/O read from the data disk of the OBServer node. |
Cluster host | ob_data_io_time | Average amount of time spent on each I/O operation on the data disk of the OBServer node. |
Cluster host | ob_data_io_write_time | Average amount of time spent on each I/O write to the data disk of the OBServer node. |
Cluster host | ob_data_io_byte | Average I/O throughput per second of the data disk of the OBServer node. |
Cluster host | ob_data_io_read_byte | Average throughput of I/O reads per second from the data disk of the OBServer node. |
Cluster host | ob_data_io_write_byte | Average throughput of I/O writes per second to the data disk of the OBServer node. |
Cluster host | ob_data_io_util | I/O usage of the data disk of the OBServer node. |
Database proxy | client_connections | Number of connected clients. |
Database proxy | server_connections | Number of connected servers. |
Database proxy | qps | Average number of SQL statements processed per second. |
Database proxy | qps_rt | Average amount of time consumed by the OBServer in processing each SQL statement. |
Database proxy | tps | Number of transactions processed per second. |
Proxy host | load1 | Average system load in the last minute. |
Proxy host | load15 | Average system load in the last 15 minutes. |
Proxy host | load5 | Average system load in the last 5 minutes. |
Proxy host | cpu_percent | CPU utilization. |
Proxy host | io_byte | Average I/O throughput per second. |
Proxy host | io_read_byte | Amount of data read each time. |
Proxy host | io_write_byte | Amount of data written each time. |
Proxy host | memory_buffers | Size of the kernel buffer cache. |
Proxy host | memory_free | Size of the available physical memory. |
Proxy host | io_read | Average amount of time spent on each I/O read. |
Proxy host | io_write | Average amount of time spent on each I/O write. |
Proxy host | io_read_byte | Amount of data read each time. |
Proxy host | io_write_byte | Amount of data written each time. |
Proxy host | net_recv | Amount of data received per second. |
Proxy host | net_send | Amount of data sent per second. |