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 Databases tab automatically appears.
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<main id="notice" type='explain'><h4>Note</h4><p>This metric is displayed only for shared storage instances. </p></main> |
| Shared storage cache space used | ss_cache_used_size | byte | Shared storage cache space used<main id="notice" type='explain'><h4>Note</h4><p>This metric is displayed only for shared storage instances. </p></main> |