On the performance monitoring page of a cluster instance, you can create personalized monitoring views by configuring key performance metrics in custom reports.
Manage custom reports for a cluster
Log on to the OceanBase Management Console .
In the navigation pane on the left, click Instance List.
In the instance list, find the target instance and click its name to open the Cluster Instance Workbench.
In the navigation pane on the left, click Performance Monitoring.
On the Performance Monitoring page, click the Custom Reports tab.
On the Custom Reports tab, you can manage your reports.
View a custom report
On the Custom Reports tab, select the report you want to view from the Select Report drop-down list.
Add a custom report
On the Custom Reports page, click Add Custom Report.
If you are creating a custom report for the first time, the page appears as follows:
If custom reports already exist, the page appears as follows:
Enter a report name, and select the tenants and monitoring metrics. For more information about the monitoring metrics, see List of monitoring metrics.
NoteThe report name cannot exceed 20 characters.
You can create a maximum of 7 custom monitoring reports.
Click OK.
Edit a custom report
On the Custom Reports page, select the report you want to edit.
Click Edit Current Report.
On the Edit Custom Report page, edit the report name, tenants, and metrics. For more information about the monitoring metrics, see List of monitoring metrics.
Click OK.
Delete a custom report
On the Custom Report page, select the report to modify.
Click Delete Current Report.
In the confirmation dialog box, click OK.
List of monitoring metrics
Monitoring metrics for the database proxy and host agent can be selected only if proxy monitoring is enabled. Database proxy monitoring is currently available only to whitelisted users. To enable this feature, contact technical support.
Metric classification | Metric name | Description |
Cluster database | sql_all_count | Number of SQL statements processed per second |
sql_delete_count | Number of Delete statements processed per second | |
sql_insert_count | Number of Insert statements processed per second | |
sql_other_count | Number of other statements, such as Data Definition Language (DDL), Data Control Language (DCL), and Data Transaction Language (DTL) statements | |
sql_replace_count | Number of Replace statements processed per second | |
sql_select_count | Number of Select statements processed per second | |
sql_update_count | Number of Update statements processed per second | |
sql_all_rt | Average processing time of SQL statements | |
sql_delete_rt | Average processing time of Delete statements | |
sql_insert_rt | Average processing time of Insert statements | |
sql_other_rt | Average processing time of other statements, such as DDL, DCL, and DTL statements | |
sql_replace_rt | Average processing time of Replace statements | |
sql_select_rt | Average processing time of Select statements | |
sql_update_rt | Average processing time of Update statements | |
transaction_commit_count | Number of transactions committed per second | |
transaction_count | Number of transactions processed per second | |
transaction_rollback_count | Number of transactions rolled back per second | |
transaction_timeout_count | Number of timed-out transactions per second | |
transaction_commit_rt | Average commit time of transactions | |
transaction_rollback_rt | Average rollback time of transactions | |
transaction_rt | Average processing time of transactions | |
active_session | Number of active sessions | |
all_session | Number of current sessions | |
request_queue_time | Wait time of SQL statements in the queue | |
trans_commit_log_count | Number of transaction logs committed per second | |
clog_trans_log_total_size | Size of transaction logs committed per second | |
io_count | Number of I/O operations per second for SSStore | |
io_read_count | Number of read operations per second for SSStore | |
io_write_count | Number of write operations per second for SSStore | |
io_read_rt | Average time of each read operation for SSStore | |
io_rt | I/O time. | |
io_write_rt | Average time of each write operation for SSStore | |
io_read_size | Data volume read per second for SSStore | |
io_size | Data volume processed per second for SSStore | |
io_write_size | Data volume written per second for SSStore | |
transaction_multi_partition_count | Number of distributed transactions per second | |
transaction_partition_count | Number of transactions per second | |
transaction_single_partition_count | Number of regular transactions per second | |
uptime | Available time | |
trans_commit_log_sync_rt | Average network sync time for each transaction log | |
Cluster host | load1 | Average system load in the last 1 minute |
load15 | Average system load in the last 15 minutes | |
load5 | Average system load in the last 5 minutes | |
cpu_percent | CPU utilization | |
memory_buffers | Size of the kernel buffer cache | |
memory_cached | Memory used by the cache | |
memory_free | Available physical memory size | |
memory_used | Used physical memory size | |
net_recv | Data volume received per second | |
net_send | Data volume sent per second | |
net_throughput | Network throughput | |
ntp_offset_milliseconds | NTP clock offset | |
ob_data_disk_percent | Usage of the OceanBase (OB) data disk | |
ob_clog_disk_percent | Usage of the OB log disk | |
ob_data_disk_used_size | Used space of the OB data disk | |
ob_process_exists | Liveness status of the OB process | |
ob_clog_io | Average number of I/O operations per second for the OB log disk | |
ob_clog_io_read | Average number of read I/O operations per second for the OB log disk | |
ob_clog_io_write | Average number of write I/O operations per second for the OB log disk | |
ob_clog_io_read_time | Average time of each read I/O operation for the OB log disk | |
ob_clog_io_time | Average time of each I/O operation for the OB log disk | |
ob_clog_io_write_time | Average time of each write I/O operation for the OB log disk | |
ob_clog_io_byte | Average data volume of I/O operations per second for the OB log disk | |
ob_clog_io_read_byte | Data volume of read I/O operations per second for the OB log disk | |
ob_clog_io_write_byte | Data volume of write I/O operations per second for the OB log disk | |
ob_clog_io_util | I/O utilization of the OB log disk | |
ob_data_io | Average number of I/O operations per second for the OB data disk | |
ob_data_io_read | Average number of read I/O operations per second for the OB data disk | |
ob_data_io_write | Average number of write I/O operations per second for the OB data disk | |
ob_data_io_read_time | Average time of each read I/O operation for the OB data disk | |
ob_data_io_time | Average time of each I/O operation for the OB data disk | |
ob_data_io_write_time | Average time of each write I/O operation for the OB data disk | |
ob_data_io_byte | Average data volume of I/O operations per second for the OB data disk | |
ob_data_io_read_byte | Data volume of read I/O operations per second for the OB data disk | |
ob_data_io_write_byte | Data volume of write I/O operations per second for the OB data disk | |
ob_data_io_util | I/O utilization of the OB data disk | |
Database proxy | client_connections | Number of client connections |
server_connections | Number of server-side connections | |
qps_rt | Average processing time of each SQL statement on the server-side | |
tps | Average number of transactions processed per second |