This topic describes how to monitor the performance of databases in an instance by using OceanBase Cloud.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
On the Instances page, click the name of the target instance to go to the Overview page of the instance.
In the left-side navigation pane of the Overview page of the instance, click Metrics.
The Database Metrics tab automatically appears. By default, this tab shows the monitoring data of all databases in the instance in the last 6 hours.
- 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.
Monitoring item Metric Unit Description Single Operation QPS single_kv_all_count times/s The average number of all single operations per second Single Operation Average Response Time single_kv_all_rt ms The average response time for single operations Same-type Batch Operation QPS multi_kv_all_count times/s The average number of same-type batch operations per second Same-type Batch Operation Average Response Time multi_kv_all_rt ms The average response time for same-type batch operations Same-type Batch Operation Average Row Count multi_kv_all_row - The average number of rows in same-type batch operations Mixed Batch Operation QPS batch_kv_all_count times/s The average number of mixed batch operations per second Mixed Batch Operation Average Response Time batch_kv_all_rt ms The average response time for mixed batch operations Mixed Batch Operation Average Row Count batch_kv_all_row - The average number of rows in mixed batch operations Query QPS query_kv_select_count times/s The average number of query operations per second Query Average Response Time query_kv_select_rt ms The average response time for query operations Query Average Row Count query_kv_select_row - The average number of rows in query operations Query and Mutate Operation QPS query_and_muate_kv_select_count - The average number of query and mutate operations Query and Mutate Operation Average Response Time query_and_muate_kv_select_rt ms The average response time for query and mutate operations Query and Mutate Operation Average Row Count query_and_muate_kv_select_row - The average number of rows in query and mutate operations QPS sql_all_count times/s The number of SQL statements processed per second Average SQL Statement Processing Time sql_all_rt ms The average time consumed in processing an SQL statement TPS transaction_count times/s The number of transactions per second Transaction Response Time transaction_rt ms The average time consumed in processing a transaction on the server side Number of Sessions all_session - The current number of sessions Queue Time request_queue_time μs The wait time of an SQL query in a queue Trans Log trans_commit_log_count times/s The number of transaction logs committed per second Trans Log Size clog_trans_log_total_size byte The total size of transaction logs committed per second IOPS io_count times/s The average number of I/O operations per second in the SSStore IORT io_rt ms The average time consumed in each I/O operation IO Throughput io_size byte The amount of data processed per second in the SSStore Transaction Count transaction_partition_count times/s The number of transactions per second Uptime uptime s The amount of time when the service is available Average Trans Log Sync Time trans_commit_log_sync_rt s The average time consumed on each synchronization of transaction logs Number of Wait Events ob_waiteven_count - The number of wait events in a specific state Number of Execution Events ob_sql_event - The number of execution events in a specific state Total Log Disk Size ob_tenant_log_disk_total_bytes GB The total size of the log disk Log Disk Usage ob_tenant_log_disk_used_bytes GB The occupied space of the log disk Data Usage ob_tenant_server_required_size GB The occupied space of data Data Volume ob_tenant_server_data_size GB The volume of data Binlog Disk Usage ob_tenant_binlog_disk_used GB The disk space occupied by binlogs