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 SQL statements.
     Single Operation Per Second	single_kv_all_count	times/s	The number of operations processed per second for a single operation.
     Average Single Operation Time	single_kv_all_rt	μs	The average time consumed for a single operation.
     Average Multi-Operation Per Second	multi_kv_all_count	times/s	The number of operations processed per second for a batch operation of the same type.
     Average Multi-Operation Time	multi_kv_all_rt	ms	The average time consumed for a batch operation 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 number of operations processed per second for mixed batch operations.
     Average Time Consumed for Mixed Batch Operations	batch_kv_all_rt	ms	The average time consumed for mixed batch operations.
     Average Number of Rows for Mixed Batch Operations	batch_kv_all_row	times (count)	The average number of rows for mixed batch operations.
     Average Number of Queries Per Second	query_kv_select_count	times/s	The number of queries processed per second.
     Average Query Time	query_kv_select_rt	ms	The average time consumed for a query.
     Average Number of Rows for Queries	query_kv_select_row	times (count)	The average number of rows for queries.
     Average Number of Queries and Modifications Per Second	query_and_muate_kv_select_count	times/s	The 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	times (count)	The average number of rows for queries and modifications.
     Number of HBase Operations	hbase_all_count	times (count)	The number of all HBase operations.
     Total Time Consumed for All HBase Operations	hbase_rt	μs	The total time consumed for all HBase operations.
     P999 Response Time for HBase Operations	kv_hbase_all_rt_p999	ms	The P999 response time for HBase operations.
     Number of Rows for All HBase Operations	hbase_all_rows	times (count)	The 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 the SSStore.
     I/O Time	io_rt	μs	The time consumed for an I/O operation.
     I/O Throughput	io_size	byte	The data processed per second by the SSStore.
     Number of Waiting Events	ob_waitevent_count	times (count)	The number of waiting events in a specific database state.
     Number of Execution Events in a Specific Database State	ob_sql_event	times (count)	The number of execution events in a specific database state.
     Session Count	all_session	Count	Current Session Count

   • 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 Time	request_queue_time	μs	Time spent waiting in the request queue for SQL requests
     Transaction Log Count	trans_commit_log_count	times/s	Number of transaction logs committed per second
     Transaction Log Size	clog_trans_log_total_size	MiB	Size of transaction logs committed per second
     Transaction Count	transaction_partition_count	times/s	Number of transactions per second
     Transaction Log Network Synchronization Time	trans_commit_log_sync_rt	μs	Average time spent on network synchronization for each transaction log

   • 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 Log Disk Size	ob_tenant_log_disk_total_bytes	GiB	Total size of the log disk
     Log Disk Usage	ob_tenant_log_disk_used_bytes	GiB	Log disk usage
     Data Occupancy	ob_tenant_server_required_size	GiB	Data occupancy
     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 monitoring 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 monitoring metric is displayed only for shared storage instances.