This topic describes how to monitor multidimensional metrics of an instance in OceanBase Cloud.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target instance, click its name, and go to the Overview page of the instance.
In the left-side navigation pane, click Metrics.
On the monitoring page, click the Multi-dimensional Metrics tab.
By default, the page displays the monitoring data of the instance in the last hour.
- To view the monitoring data of a specified tenant, select the tenant from the Tenant drop-down list.
- To view the monitoring data of a specified replica, select the replica from the Replicas drop-down list.
- To view the monitoring data of a specified node, select the node from the Node drop-down list.
- To view the metrics of a specified dimension, select the dimension from the Metric Dimension drop-down list. You can view metrics by tenant, replica, node, and other dimensions.
- To view the data of a specified time period, customize the time period.
- To adjust the chart layout, select the layout from the Layout drop-down list. You can set the layout to two charts per row or three charts per row.
- To enable or disable the time period comparison feature, select the Compare Time Ranges switch.
- To enable or disable the chart linkage feature, select the Link Charts switch. If you enable this feature, when you zoom in or out on one chart, the other charts will be synchronized.
- To set the automatic refresh interval or disable automatic refresh, select the interval from the Auto Refresh drop-down list.
- To create an alert rule based on a monitoring metric, click Create Alert Rule.
The following table describes the monitoring data of a database.
SQL
Metric Item Metric Name Description QPS sql_all_count The number of SQL statements processed per second by the tenant database. Unit: times/s. SQL Response Time sql_all_rt The average response time of an SQL statement. Unit: μs. I/O Count io_count The number of I/O operations per second on the SSStore. Unit: times/s. I/O Time io_rt The average time consumed for each read/write operation on the SSStore. Unit: μs. I/O Throughput io_size The amount of data processed per second by the SSStore. Unit: byte. Number of Waiting Events ob_waitevent_count The number of waiting events. Number of Execution Events in a Specified Status ob_sql_event The number of execution events in a specified status. Number of Sessions all_session The number of current sessions in the tenant database. Transactions
Metric Item Metric Name Description TPS transaction_count The number of transactions requested per second by the tenant database. Unit: times/s.
This metric is the sum of the following types of requests:- Insert
- Replace
- Update
- Delete
Transaction Response Time transaction_rt The average response time of a transaction. Unit: μs. Request Queue Time request_queue_time The time consumed for an SQL statement to wait in the request queue. Unit: μs. Number of Transaction Logs trans_commit_log_count The number of transaction logs committed per second by the tenant database. Unit: times/s. Size of Transaction Logs clog_trans_log_total_size The size of transaction logs committed per second by the tenant database. Unit: MiB. Average Time Consumed for Network Synchronization of Transaction Logs trans_commit_log_sync_rt The average time consumed for network synchronization of a transaction log. Unit: ms. Database Status
Metric Item Metric Name Description Database Working Time ob_worktime The working time of the database. Unit: h. Note
This metric is supported only for instances of OceanBase Database V4.2.5.
Database Non-Idle Waiting Time ob_no_idle_waiting_time The non-idle waiting time of the database. Unit: day. Note
This metric is supported only for instances of OceanBase Database V4.2.5 and V4.3.3.
Disk
Metric Metric Name Description Log disk total size ob_tenant_log_disk_total_bytes The total size of the log disk of an OB tenant, in GiB. Log disk usage ob_tenant_log_disk_used_bytes The size of the log disk used by an OB tenant, in GiB. Data usage ob_tenant_disk_used_percentage The size of the data disk used by an OB tenant, in GiB. Data size ob_tenant_data_size The size of the data of an OB tenant, in GiB. Binlog disk usage ob_tenant_binlog_disk_used The size of the Binlog disk used by an OB tenant, in GiB.