Monitor multi-dimensional metrics of an instance

This topic describes how to monitor multi-dimensional metrics of an instance in OceanBase Cloud.

Procedure

1. Log in to the OceanBase Cloud console.

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

3. In the instance list, find the target instance, click its name, and go to the Overview page of the instance.

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

5. On the monitoring page, click the Multi-dimensional Metrics tab.

6. By default, this tab shows the monitoring data in 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	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 an SQL statement.
     Average Number of Operations Per Second for Single Operations	single_kv_all_count	times/s	The average number of operations processed per second for single operations.
     Average Response Time for Single Operations	single_kv_all_rt	μs	The average response time for single operations.
     Average Number of Operations Per Second for Batch Operations of the Same Type	multi_kv_all_count	times/s	The average number of batch operations of the same type processed per second.
     Average Response Time for Batch Operations of the Same Type	multi_kv_all_rt	ms	The average response time for batch operations of the same type.
     P99 Response Time for TABLE Operations	kv_table_all_rt_p99	ms	The P99 response time for TABLE operations.
     Average Number of Rows for Batch Operations of the Same Type	multi_kv_all_row		The average number of rows for batch operations of the same type.
     Average Number of Operations Per Second for Mixed Batch Operations	batch_kv_all_count	times/s	The average number of mixed batch operations processed per second.
     Average Response Time for Mixed Batch Operations	batch_kv_all_rt	ms	The average response time for 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.
     Average Number of Queries Per Second	query_kv_select_count	times/s	The average number of queries processed per second.
     Average Query Response Time	query_kv_select_rt	ms	The average response time for a query.
     Average Number of Rows for Queries	query_kv_select_row	count	The average number of rows for a query.
     Average Number of Queries and Modifications Per Second	query_and_muate_kv_select_count	times/s	The average number of queries and modifications processed per second.
     Average Response Time for Queries and Modifications	query_and_muate_kv_select_rt	μs	The average response time for queries and modifications.
     Average Number of Rows for Queries and Modifications	query_and_muate_kv_select_row	count	The average number of rows for queries and modifications.
     Number of HBase Operations	hbase_all_count	count	The total number of HBase operations.
     Total Response Time for HBase Operations	hbase_rt	μs	The total response time for all HBase operations.
     P999 Response Time for HBase Operations	kv_hbase_all_rt_p999	ms	The P999 response time for HBase operations.
     Total Number of Rows for HBase Operations	hbase_all_rows	count	The total number of rows for all HBase operations.
     Number of I/O Operations	io_count	times/s	The number of I/O operations processed per second by an SSStore.
     I/O Response Time	io_rt	μs	The I/O response time.
     I/O Throughput	io_size	byte	The amount of data processed per second by an SSStore.
     Number of Waiting Events	ob_waitevent_count	count	The number of waiting events in a specific state.
     Database execution events in a specific state	ob_sql_event	count	Number of database execution events in a specific state
     Number of sessions	all_session	count	Number of current sessions

   • Transactions

     Metric item	Metric name	Unit	Description
     TPS	transaction_count	times/s	TPS
     Transaction response time	transaction_rt	ms	Average transaction processing time on the server side
     Request queue waiting time	request_queue_time	μs	Waiting time of SQL requests in the waiting queue
     Number of transaction logs	trans_commit_log_count	times/s	Number of transaction logs committed per second
     Size of transaction logs	clog_trans_log_total_size	MiB	Size of transaction logs committed per second
     Number of transactions	transaction_partition_count	times/s	Number of transactions per second
     Network synchronization time of transaction logs	trans_commit_log_sync_rt	μs	Average network synchronization time of transaction logs per transaction

   • Database working status

     Metric item	Metric name	Unit	Description
     Database working time	ob_worktime	s	Database working time
     Database non-idle waiting time	ob_no_idle_waiting_time	ms	Database non-idle waiting time

   • Disk

     Metric item	Metric name	Unit	Description
     Total size of log disks	ob_tenant_log_disk_total_bytes	GiB	Total size of log disks
     Used size of log disks	ob_tenant_log_disk_used_bytes	GiB	Used size of log disks
     Data occupied size	ob_tenant_server_required_size	GiB	Data occupied size
     Data size	ob_tenant_server_data_size	GiB	Data size
     Binlog disk usage	ob_tenant_binlog_disk_used	GiB	Binlog disk usage

   • Cache

     Metric item	Metric 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.