Monitoring metrics for alerts

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 alert metrics

• Resource and performance

  Metric type	Metric name
  Disk	OceanBase data disk usage OceanBase data disk usage rate OceanBase node data disk usage rate
  Memory	OceanBase node memory usage rate
  CPU	OceanBase node CPU usage rate
  Network	Bytes sent per second Bytes received per second NTP clock offset OceanBase node NIC I/O traffic ratio
  I/O	System average load per minute OPS OceanBase data disk I/O usage rate Read disk response time Time spent on each I/O operation Time spent on data disk read I/O Time spent on data disk write I/O IOPS usage rate for OceanBase host Throughput usage rate for OceanBase host

• Service availability

  Metric type	Metric name
  Service availability	Time since last major compaction in OceanBase instance Major compaction errors in OceanBase instance Major compaction timeouts in OceanBase instance

Tenant-level alert metrics

• Transactions and SQL statements

  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

• Resources and performance

  Metric type	Metric name
  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

• Service availability

  Metric type	Metric name
  Service availability	Binlog subscription exceptions Binlog subscription latency Binlog conversion latency Time since last major compaction in OceanBase tenant Major compaction errors in OceanBase tenant

Database proxy metrics

• Resources and performance

  Metric type	Metric name
  Session	OceanBase server connections Client connections

• Transactions and SQL statements

  Metric type	Metric name
  Transactions and SQL statements	OBProxy SQL execution errors