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 the monitoring data of the tenant. If you select multiple tenants, you can click a node name in the chart to filter and view the information of the node.
- You can select a time period from the Time drop-down list to view the data of the period.
The following table describes the performance metrics.
* SQL
| Metric | Metric Name | Unit | Description |
|-----------|------------|------|--------|
| QPS | sql_all_count | times/s | The number of SQL statements processed by the tenant database per second. |
| SQL Response Time | sql_all_rt | μs | The average time taken to process an SQL statement. |
| I/O Operations | io_count | times/s | The number of I/O operations performed by the SSStore per second. |
| I/O Time | io_rt | μs | The average time taken for each read/write operation on the SSStore. |
| I/O Throughput | io_size | byte | The amount of data processed by the SSStore per second. |
| Number of Waiting Events | ob_waitevent_count| Count | The number of waiting events. |
| Number of Execution Events in a Specific State | ob_sql_event | Count | The number of execution events when the tenant is in a specific state. |
| Number of Sessions | all_session | Count | The number of current sessions in the tenant database. |
* Transactions
| Metric | Metric Name | Unit | Description |
|-----------|------------|------|-------------|
| TPS | transaction_count | times/s | The number of transactions requested by the tenant database per second.</br>This metric is the sum of the following types of requests:<ul><li>Insert</li><li>Replace</li><li>Update</li><li>Delete</li></ul> |
| Transaction Response Time | transaction_rt | μs | The average time taken to process a transaction. |
| Request Queue Time | request_queue_time | μs | The time spent waiting in the queue for an SQL statement. |
| Number of Transaction Logs | trans_commit_log_count | times/s | The number of transaction logs committed by the tenant database per second. |
| Size of Transaction Logs | clog_trans_log_total_size | byte | The size of transaction logs committed by the tenant database per second. |
| Number of Transactions | transaction_partition_count | times/s | The number of transactions per second. |
| Time for Network Synchronization of Transaction Logs | trans_commit_log_sync_rt | μs | The average time taken for network synchronization of transaction logs per synchronization. |
* Database status
| Metric | Metric Name | Unit | Description |
|-----------|------------|-----|-------------|
| Database Working Time | ob_worktime | s | The working time of the database.<main id="notice" type='explain'><h4>Note</h4><p>This metric is supported only for instances of database version V4.2.5. </p></main> |
| Database Non-idle Waiting Time | ob_no_idle_waiting_time | ms | The non-idle waiting time of the database.<main id="notice" type='explain'><h4>Note</h4><p>This metric is supported only for instances of database version V4.2.5 and V4.3.3. </p></main> |
* Disk
| Metric | Metric Name | Unit | Description |
|-----------|------------|-----|---------|
| Total Log Disk Size | ob_tenant_log_disk_total_bytes | GiB | The total size of the log disk of the OB tenant. |
| Log Disk Usage | ob_tenant_log_disk_used_bytes | GiB | The size of the log disk used by the tenant. |
| Data Usage | ob_tenant_disk_used_percentage | Percentage (%) | The percentage of the data disk used by the tenant. |
| Data Size | ob_tenant_data_size | GiB | The size of the data of the tenant. |
| Binlog Disk Usage | ob_tenant_binlog_disk_used | GiB | The size of the Binlog disk used by the tenant. |