This topic describes performance metrics related to the transaction response time in an OceanBase cluster. These metrics are all, trans_commit_rt, and trans_rollback_rt. They collect statistics on the average time consumed in processing, committing, and rolling back a transaction in an OceanBase cluster. You can specify a statistical period to query statistics about the transaction response time in a single zone or on a single OBServer of an OceanBase cluster.
all
Definition
The average time for processing a transaction in an OceanBase cluster.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| all | transaction_rt | Microseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="30006",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="30005",@LABELS}[@INTERVAL])) by (@GBLABELS)
trans_commit_rt
Definition
The average time for committing a transaction in an OceanBase cluster.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| trans_commit_rt | transaction_commit_rt | Microseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="30008",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="30007",@LABELS}[@INTERVAL])) by (@GBLABELS)
trans_rollback_rt
Definition
The average time for rolling back a transaction in an OceanBase cluster.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| trans_rollback_rt | transaction_rollback_rt | Microseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="30010",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="30009",@LABELS}[@INTERVAL])) by (@GBLABELS)