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)