This topic describes monitoring metrics related to the time consumed by transaction logs within an OceanBase Database tenant. These metrics are sync_time and write_disk. You can specify a statistical period to query statistics about the time consumed by transaction logs in a single zone or on a single OBServer of an OceanBase Database tenant.
sync_time
Definition
The average time consumed by each transaction log synchronization operation over the network in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| sync_time | trans_commit_log_sync_rt | Microseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="30000",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="30001",@LABELS}[@INTERVAL])) by (@GBLABELS)
write_disk
Definition
The average time consumed by each transaction log write to the disk in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| write_disk | clog_write_disk_rt | Microseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="80041",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="80040",@LABELS}[@INTERVAL])) by (@GBLABELS)