On the multidimensional metrics monitoring page of a cluster, you can view monitoring data from different dimensions, including cluster, tenant, replica, and node.
View multidimensional metrics monitoring data
Log in 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.
Click Multidimensional metrics.
By default, the multidimensional metrics monitoring page displays the monitoring data of all tenants in the last hour.
You can select a dimension such as cluster, tenant, replica, or node from the Metric dimension drop-down list to view the corresponding monitoring data.
You can also specify a time period to filter the data to view.
The following table describes the performance metrics.
Monitoring item
Metric
Description
QPS
sql_all_count
The number of SQL queries processed per second in the database of the tenant.
Average SQL Statement Processing Time
sql_all_rt
The average time consumed in processing an SQL statement. Unit: ms.
TPS
transaction_count
The number of transactions requested by the database of the tenant per second.
The value is the sum of the following types of requests:
Insert
Replace
Update
Delete
Transaction Response Time
transaction_rt
The average time consumed in processing a transaction. Unit: μs.
Number of Sessions
all_session
The current number of sessions in the database of the tenant.
Wait Time of SQL Requests in Queue
request_queue_time
The wait time of an SQL query in a queue. Unit: μs.
Transactions Logged per Second
trans_commit_log_count
The number of transaction logs committed per second in the database of the tenant.
Transaction Log Size
clog_trans_log_total_size
The total size of transaction logs committed per second in the database of the tenant. Unit: MB.
IOPS
io_count
The average number of I/O operations per second in the SSStore.
IO RT
io_rt
The average time consumed in each read or write operation in the SSStore. Unit: μs.
IO Throughput
io_size
The amount of data processed per second in the SSStore. Unit: bytes.
Transaction Count
transaction_partition_count
The number of transactions committed per second.
Uptime
uptime(s):
The amount of time when the tenant is in service. Unit: seconds.
Average Time for Network Synchronization of Transaction Logs per Transaction
trans_commit_log_sync_rt
The average amount of time consumed on each synchronization of transaction logs over the network. Unit: ms.
Wait Events in Specific State in Database
ob_waiteven_count
The number of wait events in a specific state in the database.
Execution Events in Specific State in Database
ob_sql_event
The number of execution events in a specific state in the database.
Total Log Disk Size
ob_tenant_log_disk_total_bytes
The total size of the log disk. Unit: GB.
Log Disk Usage
ob_tenant_log_disk_used_bytes
The occupied space of the log disk. Unit: GB.
Data Usage
ob_tenant_server_required_size
The disk space occupied by data. Unit: GB.
Data Amount
ob_tenant_server_data_size
The volume of data. Unit: GB.
Binlog Disk Usage
ob_tenant_binlog_disk_used
The size of disk space occupied by binlogs. Unit: GB.