This topic describes how to monitor the performance of databases in a cluster by using 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, the Databases tab is displayed by default.
The cluster database monitoring page displays the monitoring data of all clusters in the last 1 hour by default.
- You can select a tenant from the tenant selection box to view its monitoring data. If you select multiple tenants, you can click node names in a chart to filter and view specific information.
- You can also specify a custom time period to view data within that period.
The following monitoring data is available:
SQL
MetricNameUnitDescriptionQPS sql_all_count times/s The number of SQL statements processed per second by the tenant database. SQL Response Time sql_all_rt μs The average time consumed in processing an SQL statement. IOPS io_count times/s The number of I/O operations per second in the SSStore. IORt io_rt μs The average time consumed in each read or write operation in the SSStore. IOT io_size byte The amount of data processed per second in the SSStore. Number of Waiting Events ob_waitevent_count count The number of wait events. Number of Executed Events with the Database in a Specific State ob_sql_event count The number of executed events with the tenant database in a specific state. Number of Sessions all_session count The current number of sessions in the tenant database. Transactions
MetricNameUnitDescriptionTPS transaction_count times/s The number of transactions requested per second by the tenant database.
This metric is the sum of the following types of requests:- INSERT
- REPLACE
- UPDATE
- DELETE
Transaction Response Time transaction_rt μs The average time consumed in processing a transaction. Request Queue Time request_queue_time μs The wait time of an SQL statement in a queue. Number of Transaction Logs trans_commit_log_count times/s The number of transaction logs committed per second by the tenant database. Transaction Log Size clog_trans_log_total_size byte The total size of transaction logs committed per second by the tenant database. Number of Transactions transaction_partition_count times/s The number of transactions per second. Transaction Log Synchronization Time trans_commit_log_sync_rt μs The average time consumed in each synchronization of transaction logs over the network. Database Work Status
Monitoring ItemMetric NameUnitDescriptionDatabase Working Time ob_worktime ms The duration during which the database is working. Note
This metric is currently supported only for instances with database version V4.2.5.
Non-idle Waiting Time of Database ob_no_idle_waiting_time ms The duration during which the database is in a non-idle waiting state. Note
This metric is currently supported only for instances with database versions V4.2.5 and V4.3.3.
Disk
Monitoring ItemMetric NameUnitDescriptionTotal Log Disk Space ob_tenant_log_disk_total_bytes GiB The total log disk space of the OB tenant. Log Disk Usage ob_tenant_log_disk_used_bytes GiB The used log disk space of the tenant. Data Usage ob_tenant_disk_used_percentage Percentage (%) The data usage of the tenant. Data Volume ob_tenant_data_size GiB The data volume of the tenant. Binlog Disk Usage ob_tenant_binlog_disk_used GiB The disk usage of binlogs.