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 |
| 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 usage rate
- 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
- Bytes read per second from data disk
- Bytes written per second to data disk
- Bytes read per second from log disk
- Bytes written per second to log disk
- System CPU load per minute
|
| Network |
- Bytes received per second
- Bytes sent per second
- NTP clock offset
- OceanBase node NIC I/O traffic ratio
- Inbound bandwidth utilization of cross-cloud network channel connection (Alibaba Cloud)
- Outbound bandwidth utilization of cross-cloud network channel connection (Alibaba Cloud)
- Inbound packets of cross-cloud network channel connection (Alibaba Cloud)
- Outbound packets of cross-cloud network channel connection (Alibaba Cloud)
|
| 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 |
| Service availability |
- Log backup delay
- Data backup task timeout
- OceanBase instance SSL certificate has expired
- OceanBase instance SSL certificate will expire soon
|
Tenant-level alerts
Metrics
| Metric type |
Metric |
| Transactions and SQL statements |
- Average transaction commit time
- Transactions per second (TPS)
- SQL statements per second
- Number of slow SQL statements
- Incremental refresh delay for tenant materialized views
|
| Resources and performance |
- MEMStore:
- Active memory for tenant
- Memstore usage percentage
- Memstore usage
- CPU:
- OceanBase node tenant CPU usage rate
- Tenant CPU usage rate
- Session:
- Number of active sessions
- Total number of sessions
- I/O:
- Read IOPS
- Physical I/O throughput
- Amount of data read per second
- Write IOPS
- Write I/O throughput
- SQL:
- Time spent waiting in the queue
- 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 delay
- Binlog subscription delay
- Number of Binlog subscription errors
- Binlog disk usage rate
- Binlog disk usage
|
| Service availability |
- Time since last major compaction for tenant
- Major compaction errors for tenant
|
Events
| Event type |
Event |
| Transactions and SQL statements |
- Slow SQL statements exist for tenant
- SQL statements with performance degradation exist for tenant
- SQL statements with deteriorated execution plans exist for tenant
- Incremental refresh for tenant materialized views fails
|
Database proxy metrics
Metrics
| Metric type |
Metric |
| Resources and performance |
Session:
- OceanBase server connections
- Client connections
|
| Transactions and SQL statements |
OBProxy SQL execution errors |
Data service
Metrics
| Metric type |
Metric |
| Data migration |
Incremental synchronization delay for data migration |
Events
| Event type |
Event |
| 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 |
