Monitor the performance of databases in an instance

This topic describes how to monitor the performance of databases in an instance by using OceanBase Cloud.

Procedure

1. Log in to the OceanBase Cloud console.

2. In the left-side navigation pane, click Instances.

3. On the Instances page, click the name of the target instance to go to the Overview page.

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

5. On the Metrics page, the Databases tab automatically appears.

6. By default, the Databases tab shows the monitoring data of all databases in the instance in the last hour.

   • You can select a tenant from the Tenant drop-down list to view its monitoring data. If you select multiple tenants, you can click tenant names in a chart to filter the data to view.
   • You can also specify a time period to filter the data to view.

   The following table describes the performance metrics.

   • SQL

     Metric	Metric Name	Unit	Description
     QPS	sql_all_count	times/s	The number of SQL statements processed by the tenant database per second.
     SQL Response Time	sql_all_rt	μs	The average response time of SQL statements.
     IOPS	io_count	times/s	The number of I/O operations per second on the SSStore.
     I/O Latency	io_rt	μs	The average latency of each read/write operation on the SSStore.
     I/O Throughput	io_size	byte	The amount of data processed by the SSStore per second.
     Number of Waiting Events	ob_waitevent_count	count	The number of waiting events.
     Number of Execution Events in a Specific State	ob_sql_event	count	The number of execution events in a specific state.
     Number of Sessions	all_session	count	The number of current sessions in the tenant database.

   • Transactions

     Metric	Metric Name	Unit	Description
     TPS	transaction_count	times/s	The number of transactions requested by the tenant database per second. This metric is the sum of the following types of requests: Insert Replace Update Delete
     Transaction Response Time	transaction_rt	μs	The average response time of transactions.
     Request Queue Time	request_queue_time	μs	The time spent waiting in the queue for SQL statements.
     Number of Transaction Logs	trans_commit_log_count	times/s	The number of transaction logs committed by the tenant database per second.
     Size of Transaction Logs	clog_trans_log_total_size	byte	The size of transaction logs committed by the tenant database per second.
     Number of Transactions	transaction_partition_count	times/s	The number of transactions per second.
     Transaction Log Network Synchronization Latency	trans_commit_log_sync_rt	μs	The average latency of each network synchronization of transaction logs.

   • Database status

     Metric	Metric Name	Unit	Description
     Database Uptime	ob_worktime	s	The duration for which the database has been running. Note This metric is supported only for instances of OceanBase Database V4.2.5.
     Database Non-idle Waiting Time	ob_no_idle_waiting_time	ms	The duration for which the database has been waiting without being idle. Note This metric is supported only for instances of OceanBase Database V4.2.5 and V4.3.3.

   • Disk

     Metric	Metric Name	Unit	Description
     Total Log Disk Size	ob_tenant_log_disk_total_bytes	GiB	The total size of the log disk of the tenant.
     Log Disk Usage	ob_tenant_log_disk_used_bytes	GiB	The size of the log disk used by the tenant.
     Data Usage	ob_tenant_disk_used_percentage	%	The percentage of the tenant data disk that is occupied.
     Data Size	ob_tenant_data_size	GiB	The size of the tenant data.
     Binlog Disk Usage	ob_tenant_binlog_disk_used	GiB	The size of the binlog disk used by the tenant.