This topic describes the following two metrics related to request queue size in an OceanBase Database tenant : request_queue and large_request_queue. You can specify a statistical range to query the metrics in a single zone or on a single OBServer node for a tenant.****
request_queue
Definition
The request queue size in a tenant within the specified statistical range.
Description
| Metric | Metric name | Unit |
|---|---|---|
| request_queue | ob_tenant_request_queue_size | N/A |
Calculation expression
sum(ob_tenant_request_queue_total_size{@LABELS}) by (@GBLABELS)
SQL statements for metric collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ tenant_id, req_queue_total_size as total_size, large_queued as large_size from __all_virtual_dump_tenant_info where (tenant_id > 1000 or tenant_id = 1) and svr_ip = ? and svr_port = ?
large_request_queue
Definition
The size of the large query queue in a tenant within the specified statistical range.
Description
| Metric | Metric name | Unit |
|---|---|---|
| large_request_queue | ob_tenant_request_queue_large_size | N/A |
Calculation expression
sum(ob_tenant_request_queue_large_size{@LABELS}) by (@GBLABELS)
SQL statements for metric collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ tenant_id, req_queue_total_size as total_size, large_queued as large_size from __all_virtual_dump_tenant_info where (tenant_id > 1000 or tenant_id = 1) and svr_ip = ? and svr_port = ?