This topic describes monitoring metrics related to the time consumed by waiting events within an OceanBase Database tenant. These metrics collect statistics on the time consumed by different types of waiting events. These metrics are all, internal_wait, sync_rpc_wait, row_lock_wait, io_wait, latch_wait, and other_wait. You can specify a statistical period to query statistics about the time consumed by waiting events in a single zone or on a single OBServer of an OceanBase database tenant.
all
Definition
The average time consumed by waiting events within a tenant in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| all | wait_event_rt | Milliseconds |
Calculation expression
sum(rate(ob_waitevent_wait_seconds_total{@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_waitevent_wait_total{@LABELS}[@INTERVAL])) by (@GBLABELS)
internal_wait
Definition
The average time consumed by internal waiting events within a tenant in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| internal_wait | system_event_internal_time_waited | Milliseconds |
Calculation expression
sum(rate(ob_system_event_time_waited{event_group="INTERNAL",@LABELS}[@INTERVAL])) by (@GBLABELS)
sync_rpc_wait
Definition
The average time consumed by waiting events for synchronizing remote procedure calls (RPCs) within a tenant in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| sync_rpc_wait | system_event_sync_rpc_total_waits | Milliseconds |
Calculation expression
sum(rate(ob_system_event_total_waits{event_group="SYNC_RPC",@LABELS}[@INTERVAL])) by (@GBLABELS)
row_lock_wait
Definition
The average time consumed by lock waiting events within a tenant in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| row_lock_wait | system_event_row_lock_wait_total_waits | Milliseconds |
Calculation expression
sum(rate(ob_system_event_total_waits{event_group="ROW_LOCK_WAIT",@LABELS}[@INTERVAL])) by (@GBLABELS)
io_wait
Definition
The average time consumed by I/O waiting events within a tenant in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| io_wait | system_event_io_total_waits | Milliseconds |
Calculation expression
sum(rate(ob_system_event_total_waits{event_group="IO",@LABELS}[@INTERVAL])) by (@GBLABELS)
latch_wait
Definition
The average time consumed by latch waiting events within a tenant in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| latch_wait | system_event_latch_total_waits | Milliseconds |
Calculation expression
sum(rate(ob_system_event_total_waits{event_group="LATCH",@LABELS}[@INTERVAL])) by (@GBLABELS)
other_wait
Definition
The average time consumed by other waiting events within a tenant in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| other_wait | system_event_other_total_waits | Milliseconds |
Calculation expression
sum(rate(ob_system_event_total_waits{event_group="OTHER",@LABELS}[@INTERVAL])) by (@GBLABELS)