On the transaction monitoring page of a tenant, you can view the monitoring data related to transaction processing of the tenant.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
On the Instances page, find the target cluster instance and click the expand icon next to the instance name.
Find the target tenant and click the tenant name.
On the Overview page of the tenant, click Metrics in the left-side navigation pane.
On the page that appears, click the Transaction tab.
By default, the Transaction tab shows the monitoring data in the last hour.
Metric Metric name Unit Description TPS - transaction_commit_count
- transaction_count
- transaction_rollback_count
- transaction_timeout_count
times/s - The number of transactions committed per second.
- The number of transactions processed per second.
- The number of transactions rolled back per second.
- The number of transactions that time out per second.
Average Server-Side Transaction Processing Time - transaction_commit_rt
- transaction_rollback_rt
- transaction_rt
ms - The average time spent in committing a transaction.
- The average time spent in rolling back a transaction.
- The average time spent in processing each transaction on the server.
Transaction Logs Committed per Second trans_commit_log_count times/s The number of transaction logs committed per second. Transaction Log Size Committed per Second clog_trans_log_total_size Byte The total size of transaction logs committed per second. Transaction Lock Waits per Second - memstore_write_lock_fail_count
- memstore_write_lock_succ_count
times/s - The number of failed write lock waits.
- The number of successful write lock waits.
Average Wait Time per Lock memstore_write_lock_wait_time μs The average wait time of each write lock. Transaction Count - transaction_multi_partition_count
- transaction_single_partition_count
times/s - The number of distributed transactions per second.
- The number of regular transactions per second.
Average Transaction Log Network Synchronization Time per Transaction trans_commit_log_sync_rt ms The average time spent on each synchronization of transaction logs over the network.