This topic describes performance metrics related to the queries per second (QPS) statistics. To be specific, this topic describes metrics related to the number of SQL statement executions per second in an OceanBase cluster.
all
Definition
The total number of SQL statement executions per second in an OceanBase cluster.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| all | sql_all_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="40000",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40002",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40004",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40006",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40008",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40018",@LABELS}[@INTERVAL])) by (@GBLABELS)
select
Definition
The number of SELECT statement executions per second in an OceanBase cluster.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| select | sql_select_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="40000",@LABELS}[@INTERVAL])) by (@GBLABELS)
insert
Definition
The number of INSERT statement executions per second in an OceanBase cluster.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| insert | sql_insert_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="40002",@LABELS}[@INTERVAL])) by (@GBLABELS)
update
Definition
The number of UPDATE statement executions per second in an OceanBase cluster.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| update | sql_update_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="40006",@LABELS}[@INTERVAL])) by (@GBLABELS)
replace
Definition
The number of REPLACE statement executions per second in an OceanBase cluster.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| replace | sql_replace_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="40004",@LABELS}[@INTERVAL])) by (@GBLABELS)
delete
Definition
The number of DELETE statement executions per second in an OceanBase cluster.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| delete | sql_delete_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="40008",@LABELS}[@INTERVAL])) by (@GBLABELS)
other
Definition
The number of executions of other statements such as data definition language (DDL), data control language (DCL), and data transaction language (DTL) statements per second in an OceanBase cluster.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| other | sql_other_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="40018",@LABELS}[@INTERVAL])) by (@GBLABELS)