ApsaraDB for OceanBase:Database monitoring details

View database monitoring data

1. Log in to the ApsaraDB for OceanBase console.

2. In the left-side navigation pane, click Instances.

3. In the instance list, click the name of the target instance to go to the instance workspace.

4. In the left-side navigation pane of the instance workspace, click Performance Monitoring.

5. Click the Database Metrics tab.

6. 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.
   Query Response Time	sql_all_rt	The average time consumed in processing an SQL statement. Unit: ms.
   TPS	transaction_count	The number of transactions requested by the database of the tenant per second. The value is the sum of the following types of requests: Insert Replace Update Delete
   Transaction Response Time	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 SQL Requests in Queue	request_queue_time	The wait time of an SQL query in a queue. Unit: μs.
   Transactions Logged per Second	trans_commit_log_count	The number of transaction logs committed per second in the database of the tenant.
   Transaction Log Size	clog_trans_log_total_size	The total size of transaction logs committed per second in the database of the tenant. Unit: MB.
   IOPS	io_count	The average number of I/O operations per second in the SSStore.
   IO RT	io_rt	The average time consumed in each read or write operation in the SSStore. Unit: μs.
   IO Throughput	io_size	The amount of data processed per second in the SSStore. Unit: bytes.
   Transaction Count	transaction_partition_count	The number of transactions committed per second.
   Uptime	uptime(s):	The amount of time when the tenant is in service. Unit: seconds.
   Average Time for Network Synchronization of Transaction Logs per Transaction	trans_commit_log_sync_rt	The average amount of time consumed on each synchronization of transaction logs over the network. Unit: ms.
   Number of waiting events in a specific state for the database	ob_waiteven_count	The number of wait events in a specific state in the database.
   Execution Events in Specific State in Database	ob_sql_event	The number of execution events in a specific state in the database.
   Total number of log disks	ob_tenant_log_disk_total_bytes	The total size of the log disk. Unit: GB.
   Log disk usage	ob_tenant_log_disk_used_bytes	The occupied space of the log disk. Unit: GB.
   Data Usage	ob_tenant_disk_used_percentage	The disk space occupied by data. Unit: GB.
   Data Amount	ob_tenant_data_size	The volume of data. Unit: GB.
   Binlog Disk Usage	ob_tenant_binlog_disk_used	The size of disk space occupied by binlogs. Unit: GB.

   Note

   The monitoring metrics in this table are values supported for the Metrics parameter in the DescribeMetricsData API.