All Products
Search
Document Center

ApsaraDB for OceanBase:Transaction monitoring details

Last Updated:Feb 22, 2024

On the transaction details page, you can view the monitoring data related to transaction processing.

View transaction monitoring data

By default, the Transaction tab displays the number of processed transactions, average transaction execution time, and transaction log information in the last hour.

The following table describes the performance metrics.

Note

You can click the question mark (?) next to a monitoring metric to view its details.

Monitoring item

Metric

Description

TPS

The number of a specific type of transactions committed per second. Unit: times/s.

Average processing time per transaction on the server

The average processing time of each transaction on the server. Unit: μs.

Number of transaction logs committed per second

trans_commit_log_count

The number of transaction logs committed per second in the tenant. Unit: times/s.

Total size of transaction logs committed per second

clog_trans_log_total_size

The total size of transaction logs committed per second in the tenant. Unit: GB.

Transaction log processing time

The average transaction log processing time of the tenant. Unit: μs.

Number of transaction lock waits per second

The number of successful or failed transaction lock waits per second in the tenant. Unit: times/s.

Average wait time for each lock

memstore_write_lock_wait_time

The average wait time for each lock in the tenant. Unit: μs.

Number of transactions

The number of distributed or regular transactions per second in the tenant. Unit: times/s.