The monitoring capability of OceanBase Database relies on the OceanBase Cloud Platform (OCP) monitoring feature. It supports 24/7 monitoring and collection of various metrics including cluster performance, capacity, and operational status at the cluster, tenant, and node levels. These metrics are presented through visual graphs and tables, providing you with a comprehensive view of the OceanBase cluster's status. It helps in quickly identifying any cluster exceptions and triggering timely alerts, ensuring the smooth and efficient operation of your databases.
Monitoring
The monitoring feature of OceanBase Database covers the following aspects:
Cluster status monitoring: Displays the health status, overall performance trends, top N clusters ranked by elapsed time of major compaction, maintenance tasks, inspection data, and server usage of OceanBase clusters in OCP.
Cluster performance monitoring: Displays the historical and real-time monitoring data of performance metrics such as the resource status and QTPS of OceanBase clusters.
SQL diagnostics: Displays the monitoring data of metrics such as suspicious SQL statements, top SQL statements, slow SQL statements, RPC, events, and locks.
Alerts
The alert feature of OceanBase Database is dependent on the alert feature in OCP. When an alert event occurs, alert messages are sent to subscribers through the configured alert notification channels. The alert feature provided by OceanBase Database covers alert configuration, alert subscription, alert message management, and general alert item configuration.