On the database monitoring details page, you can view the monitoring information about databases of tenants in the cluster.
View database monitoring data
By default, the database monitoring page displays the monitoring data of all tenants 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.
Monitoring item | Metric | Description |
QPS | sql_all_count | The number of SQL queries processed per second in the database of the tenant. Unit: times/s. The value is the number of SELECT requests. |
Query response time | sql_all_rt | The average time consumed in processing an SQL statement. Unit: μs. |
TPS | transaction_count | The number of transactions requested by the database of the tenant per second. Unit: times/s. The value is the sum of the following types of requests:
|
Average processing time per transaction on the server | transaction_rt | The average time consumed in processing a transaction. Unit: μs. |
Number of sessions | all_session | The current number of sessions in the database of the tenant. |
Wait time of an SQL query in a queue | request_queue_time | The wait time of an SQL query in a queue. Unit: μs. |
Number of transaction logs committed per second | trans_commit_log_count | The number of transaction logs committed per second in the database of the tenant. Unit: times/s. |
Total size of transaction logs committed per second | clog_trans_log_total_size | The total size of transaction logs committed per second in the database of the tenant. Unit: MB. |
Transaction log processing time | clog_trans_disk_rt trans_log_rt | The average time consumed in processing a transaction. Unit: μs. The average time consumed in processing transaction logs on the server. Unit: μs. |
Average number of I/O operations per second | io_count | The average number of I/O operations per second in the SSStore. Unit: times/s. |
I/O time | io_rt | The average time consumed in each read or write operation in the SSStore. Unit: μs. |
I/O throughput | io_size | The amount of data processed per second in the SSStore. Unit: MB. |
Number of transactions | transaction_partition_count | The number of transactions processed per second in the database of the tenant. Unit: times/s. |
The monitoring metrics in this table are values supported for the Metrics parameter in the DescribeMetricsData API.