This topic describes how to monitor the multi-dimensional metrics of a cluster in OceanBase Cloud.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Cluster List.
In the cluster list, find the target cluster and click its name to go to the Cluster Workspace page.
In the left-side navigation pane of the cluster dashboard page, click Metrics.
On the monitoring page, click the Cluster Multi-Dimensional Metrics tab.
The Cluster Multi-Dimensional Metrics page displays the monitoring data of all clusters in the last 1 hour by default.
- Use the Tenant drop-down list to select a tenant to view its monitoring data.
- Use the Replica drop-down list to select a replica to view its monitoring data.
- Use the Node drop-down list to select a node to view its monitoring data.
- Select a dimension from the Metric Dimension drop-down list. You can view metrics by tenant, replica, node, or other dimensions.
- Filter data within a specific time period.
- Adjust the chart layout from the Layout drop-down list. Supported layouts include two or three charts per row.
- Enable or disable the time period comparison feature by toggling the Compare Time Ranges switch.
- Enable or disable the chart linkage feature by toggling the Link Charts switch. When enabled, if you zoom in or out on one chart, other charts will dynamically adjust accordingly.
- Set the auto-refresh interval from the Auto Refresh drop-down list, or disable auto-refresh.
- Click Create alert rule to create an alert rule based on the monitored metrics.
The following monitoring data is available:
SQL
MetricNameDescriptionQPS sql_all_count The number of SQL statements processed per second by the database of the tenant. SQL Response Time sql_all_rt The average time consumed in processing an SQL statement. Unit: μs. IOPS io_count The number of I/O operations per second for SSStore. IORt io_rt The average time consumed per read or write operation for SSStore. Unit: μs. IOT io_size The amount of data processed per second for SSStore. Unit: byte. Number of Waiting Events ob_waitevent_count The number of wait events. Number of Events Executed in a Specific State ob_sql_event The number of events executed in a specific state in the tenant. Number of Sessions all_session The current number of sessions in the database of the tenant. Transactions
MetricNameDescriptionTPS transaction_count The number of transactions requested per second in the database of the tenant. Unit: times/s.
This monitoring metric is the sum of the following types of requests:- INSERT
- REPLACE
- UPDATE
- DELETE
Transaction response time transaction_rt The average processing time of a transaction. Unit: μs. Request queue time request_queue_time The waiting time of an SQL statement in a queue. Unit: μs. Number of transaction logs trans_commit_log_count The number of transaction logs committed per second in the database of the tenant. Unit: times/s. Transaction log size clog_trans_log_total_size The total size of transaction logs committed per second in the database of the tenant. Unit: MiB. Transaction log network synchronization time trans_commit_log_sync_rt The average time consumed for each transaction log network synchronization. Unit: ms. Database working status
Monitoring itemMetric nameDescriptionDatabase Working Time ob_worktime Database working time in milliseconds. Note
Currently, only instances with database version V4.2.5 support this monitoring metric.
Non-idle waiting time of the database ob_no_idle_waiting_time The non-idle waiting time of the database. Unit: day. Note
Currently, only instances with database versions V4.2.5 and V4.3.3 support this monitoring metric.
Disk
Monitoring itemMetric nameDescriptionTotal log disk space ob_tenant_log_disk_total_bytes The total size of the log disk space for the OB tenant. Unit: GiB. Log disk usage ob_tenant_log_disk_used_bytes The occupied size of the log disk space for the tenant. Unit: GiB. Data usage ob_tenant_disk_used_percentage The data usage of the tenant. Unit: GiB. Data volume ob_tenant_data_size The data volume of the tenant. Unit: GiB. Binlog disk usage ob_tenant_binlog_disk_used The size of the disk space occupied by binlogs. Unit: GiB.