View transaction monitoring details

On the Transaction tab of a tenant, you can view the monitoring data related to transaction processing of the tenant.

Procedure

1. Log in to the OceanBase Cloud console.

2. In the left-side navigation pane, click Instances.

3. On the Instances page, find the target cluster instance and click the expand icon next to the instance name.

4. Find the target tenant and click the tenant name.

5. On the Overview page of the tenant, click Metrics in the left-side navigation pane.

6. On the page that appears, click the Transaction tab.

   By default, the Transaction tab shows the monitoring data in the last 1 hour.

   

   Metric	Metric name	Unit	Description
   TPS	transaction_commit_count transaction_count transaction_rollback_count transaction_timeout_count	times/s	Number of transactions committed per second Number of transactions processed per second Number of transactions rolled back per second Number of transactions that timed out per second
   Average Server-Side Transaction Processing Time	transaction_commit_rt transaction_rollback_rt transaction_rt	ms	Average time spent committing a transaction Average time spent rolling back a transaction Average time spent processing each transaction on the server
   Transaction Logs Committed per Second	trans_commit_log_count	times/s	Number of transaction logs committed per second
   Transaction Log Size Committed per Second	clog_trans_log_total_size	byte	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	Number of failed write lock waits Number of successful write lock waits
   Average Wait Time per Lock	memstore_write_lock_wait_time	μs	Average wait time for write locks
   Transaction Count	transaction_multi_partition_count transaction_single_partition_count	times/s	Number of distributed transactions per second Number of single-partition transactions per second
   Average Transaction Log Network Synchronization Time	trans_commit_log_sync_rt	ms	Average time spent on each transaction log network synchronization