OceanBase Cloud

Download PDF

Monitoring metrics for alerts|OceanBase Cloud |docs|OceanBase Documentations

Monitoring metrics for alerts

Last Updated:2026-10-12 05:53:29

This topic describes common monitoring metrics for alerts in OceanBase Cloud. You can create alerts based on the metrics that meet your business requirements.

Instance-level alerts

Metrics

Metric type	Metric name
Disk	OceanBase data disk usage OceanBase data disk usage rate OceanBase node data disk usage rate
CPU	OceanBase node CPU usage rate
Memory	OceanBase node memory usage rate
I/O	OPS System average load per minute Read disk response time Time spent on data disk read I/O OceanBase data disk I/O busy ratio OceanBase log disk I/O busy ratio OceanBase data disk I/O utilization OceanBase log disk I/O utilization OceanBase data disk throughput utilization OceanBase log disk throughput utilization Time spent on each I/O operation Time spent on data disk write I/O IOPS usage rate for OceanBase host Throughput usage rate for OceanBase host Data disk read IOPS Data disk write IOPS Log disk read IOPS Log disk write IOPS System CPU load per minute
Network	Bytes received per second Bytes sent per second NTP clock offset OceanBase node NIC I/O traffic ratio Inter-cloud network channel connection incoming bandwidth utilization (Alibaba Cloud) Inter-cloud network channel connection outgoing bandwidth utilization (Alibaba Cloud) Inter-cloud network channel connection incoming packets (Alibaba Cloud) Inter-cloud network channel connection outgoing packets (Alibaba Cloud)
Service availability	Time since last major compaction in OceanBase instance Major compaction errors in OceanBase instance Major compaction timeouts in OceanBase instance
Cache	Block cache hit rate Bloom filter cache hit rate Clog cache hit rate Execution plan cache hit rate Location cache hit rate Row cache hit rate

Note

The "OceanBase data disk I/O usage rate" alert metric has been renamed to "OceanBase data disk I/O busy ratio". Its calculation remains unchanged.

Events

Event type	Event name
Service availability	Log backup latency Data backup task timeout OceanBase instance SSL certificate has expired OceanBase instance SSL certificate will expire soon

Tenant-level alerts

Metrics

Metric type	Metric name
Transactions and SQL statements	Average commit time for transactions Transactions processed per second (TPS) SQL statements processed per second Slow SQL statements SQL statements with errors Incremental refresh latency of materialized views of tenant
Resources and performance	MemStore: Active memory of tenant MemStore usage percentage MemStore usage CPU: OceanBase node CPU usage rate of tenant CPU usage of tenant Session: Current active sessions Current sessions I/O: Read IOPS Physical I/O throughput IOPS Write IOPS Write I/O throughput SQL: Average waiting time in the waiting queue for SQL statements Average processing time for SQL statements at the P99, P95, and P90 percentiles. Average processing time for SELECT statements at the P99, P95, and P90 percentiles. Average processing time for INSERT statements at the P99, P95, and P90 percentiles. Average processing time for UPDATE statements at the P99, P95, and P90 percentiles. Average processing time for DELETE statements at the P99, P95, and P90 percentiles. Average processing time for REPLACE statements at the P99, P95, and P90 percentiles. Average processing time for COMMIT statements at the P99, P95, and P90 percentiles. Average processing time for other statements at the P99, P95, and P90 percentiles.
Binlog service	Binlog conversion latency Binlog subscription latency Binlog subscription exceptions Binlog disk usage rate Binlog disk usage
Service availability	Time since last major compaction in OceanBase tenant Major compaction errors in OceanBase tenant

Events

Event type	Event name
Transactions and SQL statements	Slow SQL statements exist in tenant SQL statements with performance degradation exist in tenant SQL statements with deteriorated execution plans exist in tenant Incremental refresh of materialized views of tenant fails

Database proxy metrics

Metrics

Metric type	Metric name
Resources and performance	Session: OceanBase server connections Client connections
Transactions and SQL statements	OBProxy SQL execution errors

Data services

Metrics

Metric type	Metric name
Data migration	Incremental synchronization latency in data migration

Events

Event type	Event name
Data archiving	Data archiving execution timeout Data archiving scheduling failure Data archiving execution failure
Data cleanup	Data cleanup execution timeout Data cleanup scheduling failure Data cleanup execution failure
Data import	Data import execution timeout Data import scheduling failure Data import execution failure
Data migration	Data migration task exception

Previous topic

Obtain a webhook URL

Next topic