This topic describes the monitoring metric time consumed by lock waits within an OceanBase Database tenant. You can specify a statistical period to query the time consumed by lock waits in a single zone or on a single OBServer of an OceanBase Database tenant.
Time consumed by lock waits
Definition
The average time consumed in waiting for a write lock in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| - | memstore_write_lock_wait_time | Microseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="60023",@LABELS}[@INTERVAL])) by (@GBLABELS) / (sum(rate(ob_sysstat{stat_id="60021",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="60022",@LABELS}[@INTERVAL])) by (@GBLABELS))