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 of the instance.

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

5. The Databases tab automatically appears.

6. By default, this 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	English Name	Unit	Description
     QPS	sql_all_count	times/s	The number of SQL statements processed per second.
     SQL Response Time	sql_all_rt	ms	The average response time of SQL statements.
     Single Operation Requests per Second	single_kv_all_count	times/s	The average number of all operations processed per second for single operations.
     Single Operation Response Time	single_kv_all_rt	μs	The average response time of single operations.
     Multi-Operation Requests per Second	multi_kv_all_count	times/s	The average number of all operations processed per second for multi-operations of the same type.
     Multi-Operation Response Time	multi_kv_all_rt	ms	The average response time of multi-operations of the same type.
     TABLE Operation P99 Response Time	kv_table_all_rt_p99	ms	The P99 response time of TABLE operations.
     Average Number of Rows for Multi-Operations	multi_kv_all_row		The average number of rows for multi-operations of the same type.
     Batch Operation Requests per Second	batch_kv_all_count	times/s	The average number of all operations processed per second for mixed batch operations.
     Batch Operation Response Time	batch_kv_all_rt	ms	The average response time of mixed batch operations.
     Average Number of Rows for Mixed Batch Operations	batch_kv_all_row	count	The average number of rows for mixed batch operations.
     Query Requests per Second	query_kv_select_count	times/s	The average number of queries processed per second.
     Query Response Time	query_kv_select_rt	ms	The average response time of queries.
     Average Number of Rows for Queries	query_kv_select_row	count	The average number of rows for queries.
     Query and Modify Requests per Second	query_and_muate_kv_select_count	times/s	The average number of queries processed per second for query and modify operations.
     Query and Modify Response Time	query_and_muate_kv_select_rt	μs	The average response time of query and modify operations.
     Average Number of Rows for Query and Modify Operations	query_and_muate_kv_select_row	count	The average number of rows for query and modify operations.
     HBase Operation Count	hbase_all_count	count	The total number of HBase operations.
     HBase Operation Time	hbase_rt	μs	The total time consumed for all HBase operations.
     HBase Operation P999 Response Time	kv_hbase_all_rt_p999	ms	The P999 response time of HBase operations.
     HBase Operation Rows	hbase_all_rows	count	The total number of rows for all HBase operations.
     IOPS	io_count	times/s	The number of I/O operations per second for the SSStore.
     I/O Response Time	io_rt	μs	The average I/O response time.
     I/O Throughput	io_size	byte	The amount of data processed per second by the SSStore.
     Number of Waiting Events	ob_waitevent_count	count	The number of waiting events in a specific database state.
     Number of Execution Events in a Specific Database State	ob_sql_event	count	The number of execution events in a specific database state.
     Number of Sessions	all_session	count	The number of current sessions.

   • Transactions

     Metric	English Name	Unit	Description
     TPS	transaction_count	times/s	TPS.
     Transaction Response Time	transaction_rt	ms	The average response time of each transaction on the server.
     Request Queue Time	request_queue_time	μs	The time spent in the waiting queue for an SQL request.
     Number of Transaction Logs	trans_commit_log_count	times/s	The number of transaction logs committed per second.
     Transaction Log Size	clog_trans_log_total_size	MiB	The size of transaction logs committed per second.
     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 spent for each transaction log network synchronization.

   • Database status

     Metric	English Name	Unit	Description
     Database Working Time	ob_worktime	s	The working time of the database.
     Database Non-idle Waiting Time	ob_no_idle_waiting_time	ms	The non-idle waiting time of the database.

   • Disk

     Metric	English name	Unit	Description
     Total log disk space	ob_tenant_log_disk_total_bytes	GiB	Total log disk space
     Log disk space used	ob_tenant_log_disk_used_bytes	GiB	Log disk space used
     Data space occupied	ob_tenant_server_required_size	GiB	Data space occupied
     Data volume	ob_tenant_server_data_size	GiB	Data volume
     Binlog disk space used	ob_tenant_binlog_disk_used	GiB	Binlog disk space used

   • Cache

     Metric	English name	Unit	Description
     Shared storage cache space allocated	ss_cache_assigned_size	byte	Shared storage cache space allocated Note This metric is displayed only for shared storage instances.
     Shared storage cache space used	ss_cache_used_size	byte	Shared storage cache space used Note This metric is displayed only for shared storage instances.