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
|
| 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 |
- Time since last major compaction in OceanBase instance
- Major compaction errors in OceanBase instance
- Major compaction timeouts in OceanBase instance
|
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 |
| 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
|
| Transactions and SQL statements |
- Average commit time for transactions
- Transactions processed per second (TPS)
- SQL statements processed per second
- Slow SQL statements
- Incremental refresh latency of materialized views of tenant
|
| Service availability |
- Time since last major compaction in OceanBase tenant
- Major compaction errors in OceanBase tenant
|
| Binlog service |
- Binlog conversion latency
- Binlog subscription latency
- Binlog subscription exceptions
- Binlog disk usage rate
- Binlog disk usage
|
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 |
