This topic describes the performance metric TPS within an OceanBase cluster. TPS indicates the number of transactions processed per second in an OceanBase cluster. TPS consists of the following two sub-metrics: transaction_single_partition_count that indicates the number of general transactions processed per second, and transaction_multi_partition_count that indicates the number of distributed transactions processed per second in a cluster. You can specify a statistical period to query the TPS in a single zone or on a single OBServer of an OceanBase cluster.
transaction_single_partition_count
Definition
The total number of general transactions processed per second in an OceanBase cluster.
Metric
| Metric | Metric name | Unit |
|---|---|---|
| transaction_single_partition_count | transaction_single_partition_count | N/A |
Calculation expression
sum(rate(ob_sysstat{stat_id="30012",@LABELS}[@INTERVAL])) by (@GBLABELS)
transaction_single_partition_count
Definition
The total number of distributed transactions processed per second in an OceanBase cluster.
Metric
| Metric | Metric name | Unit |
|---|---|---|
| transaction_multi_partition_count | transaction_multi_partition_count | N/A |
Calculation expression
sum(rate(ob_sysstat{stat_id="30013",@LABELS}[@INTERVAL])) by (@GBLABELS)