View instance database performance monitoring

This topic describes how to view and analyze the database monitoring details of analytical instances in the OceanBase Cloud console.

Procedure

1. Log in to the OceanBase Cloud console.

2. In the left-side navigation pane, click Cluster List.

3. In the cluster list, find the target cluster and click its name to go to the Cluster Dashboard page.

4. In the left-side navigation pane of the cluster dashboard page, click Metrics.

5. On the monitoring page, the Databases tab is displayed by default.

6. The cluster database monitoring page displays the monitoring data of all clusters in the last 1 hour by default.

   

   • Use the tenant selection box to select a tenant to view its monitoring data. If you select multiple tenants, you can click node names in the chart to filter and view specific information.
   • Use the custom filter time to view data within the corresponding time period.

   You can view the following monitoring data:

   • SQL

     Monitoring Item	Metric Name	Unit	Description
     QPS	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 processing time for an SQL statement.
     IOPS	io_count	times/s	The number of I/O operations per second for SSStore.
     IORate	io_rt	μs	The average time spent on each read or write operation for SSStore.
     IOTraffic	io_size	byte	The amount of data processed per second for SSStore.
     Number of Waiting Events	ob_waitevent_count	Count	The number of waiting events.
     Number of Events Executed with Database in a Specific State	ob_sql_event	Count	The number of events executed with the tenant database in a specific state.
     Number of Sessions	all_session	Count	The current number of sessions in the tenant database.

   • Transactions

     Monitoring Item	Metric Name	Unit	Description
     TPS	transaction_count	times/s	The number of transactions requested per second by the tenant database. This monitoring data is the sum of the following types of requests: Insert Replace Update Delete
     Transaction Response Time	transaction_rt	μs	The average processing time for a transaction.
     Request Queue Time	request_queue_time	μs	The waiting 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 network synchronization time	trans_commit_log_sync_rt	μs	The average time consumed for each transaction log network synchronization.

   • Database working status

     Monitoring item	Metric name	Unit	Description
     Database working time	ob_worktime	s	The working time of the database. Note This monitoring metric is supported only in instances with database version V4.2.5.
     Non-idle waiting time of the database	ob_no_idle_waiting_time	ms	The non-idle waiting time of the database. Note This monitoring metric is supported only in instances with database version V4.2.5 or V4.3.3.

   • Disk

     Monitoring item	Metric name	Unit	Description
     Total log disk space	ob_tenant_log_disk_total_bytes	GiB	The total size of the tenant's log disk space.
     Log disk usage	ob_tenant_log_disk_used_bytes	GiB	The used size of the tenant's log disk space.
     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.