This topic describes monitoring metrics related to lock waits within an OceanBase Database tenant. These metrics collect statistics on the number of successful and failed write lock waits within a tenant. A successful write lock wait means that a write lock can be added after a write lock wait elapses. If a write lock fails to be added, a write lock wait fails. You can specify a statistical period to query statistics about the lock waits in a single zone or on a single OBServer of an OceanBase Database tenant.
success
Definition
The number of successful write lock waits in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| success | memstore_write_lock_succ_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="60021",@LABELS}[@INTERVAL])) by (@GBLABELS)
fail
Definition
The number of failed write lock waits in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| fail | memstore_write_lock_fail_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="60022",@LABELS}[@INTERVAL])) by (@GBLABELS)