This topic describes monitoring metrics related to QPS in an OBProxy cluster.
commit
Definition
The average number of COMMIT requests forwarded by an OBProxy cluster per second.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| commit | request_total_commit | N/A |
Calculation expression
sum(rate(odp_sql_request_total{sqltype="COMMIT", @LABELS}[@INTERVAL])) by (@GBLABELS)
delete
Definition
The average number of DELETE requests forwarded by an OBProxy cluster per second.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| delete | request_total_delete | N/A |
Calculation expression
sum(rate(odp_sql_request_total{sqltype="DELETE", @LABELS}[@INTERVAL])) by (@GBLABELS)
insert
Definition
The average number of INSERT requests forwarded by an OBProxy cluster per second.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| insert | request_total_insert | N/A |
Calculation expression
sum(rate(odp_sql_request_total{sqltype="INSERT", @LABELS}[@INTERVAL])) by (@GBLABELS)
large
Definition
The average number of large requests forwarded by an OBProxy cluster per second.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| large | request_total_large | N/A |
Calculation expression
sum(rate(odp_sql_request_total{sqlLarge = "large", @LABELS}[@INTERVAL])) by (@GBLABELS)
select
Definition
The average number of SELECT requests forwarded by an OBProxy cluster per second.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| select | request_total_select | N/A |
Calculation expression
sum(rate(odp_sql_request_total{sqltype="SELECT", @LABELS}[@INTERVAL])) by (@GBLABELS)
sequence
Definition
The average number of SEQUENCE requests forwarded by an OBProxy cluster per second.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| sequence | request_total_sequence | N/A |
Calculation expression
sum(rate(odp_sql_request_total{sqltype="SEQUENCE", @LABELS}[@INTERVAL])) by (@GBLABELS)
slow
Definition
The average number of slow requests forwarded by an OBProxy cluster per second.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| slow | request_total_slow | N/A |
Calculation expression
sum(rate(odp_sql_request_total{slowQuery = "true", @LABELS}[@INTERVAL])) by (@GBLABELS)
update
Definition
The average number of UPDATE requests forwarded by an OBProxy cluster per second.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| update | request_total_update | N/A |
Calculation expression
sum(rate(odp_sql_request_total{sqltype="UPDATE", @LABELS}[@INTERVAL])) by (@GBLABELS)
others
Definition
The average number of other requests forwarded by an OBProxy cluster per second.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| others | request_total_others | N/A |
Calculation expression
sum(rate(odp_sql_request_total{sqltype="OTHERS", @LABELS}[@INTERVAL])) by (@GBLABELS)