This topic describes monitoring metrics related to the request queue within an OceanBase Database tenant. These metrics are enqueue_count and dequeue_count. You can specify a statistical period to query statistics about the request queue in a single zone or on a single OBServer of an OceanBase Database tenant.
enqueue_count
Definition
The average number of SQL statements that are added to the queue per second in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| enqueue_count | request_enqueue_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="20000",@LABELS}[@INTERVAL])) by (@GBLABELS)
dequeue_count
Definition
The average number of SQL statements that are removed from the queue per second in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| dequeue_count | request_queue_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="20001",@LABELS}[@INTERVAL])) by (@GBLABELS)