This topic describes monitoring metrics related to requests per second 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 | count |
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 | count |
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 | count |
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 | count |
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 | count |
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 | count |
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 | count |
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 | count |
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 | count |
Calculation expression
sum(rate(odp_sql_request_total{sqltype="OTHERS", @LABELS}[@INTERVAL])) by (@GBLABELS)