View the performance metrics of a tenant

You can view the performance metrics of a tenant in the OceanBase Cloud Platform (OCP) console.

Procedure

1. Log on to the OCP console.

2. Select Tenants to go to the Tenants page.

3. In the Tenants list, find the target tenant and click its name.

4. In the left-side navigation pane on the page that appears, click Performance Monitoring.

5. In the Data Filtering section, you can filter the performance data to display.

   The following table describes the filter conditions.

   Condition	Description
   Select Time	Select a time range for the data that you want to query.
   Auto Refresh	By default, auto refresh is disabled. After auto refresh is enabled, the data is refreshed every 5s.
   Zone	Select the zone that you want to view.
   OBServer node	Select the OBServer node that you want to view.

6. Click the Performance & SQL, Transaction, and Storage and Cache tabs to view different performance monitoring data.

   • Click the Performance & SQL tab to view the performance data related to SQL execution, including the QPS, response time, number of sessions, number of SQL executions, wait events, wait time, request wait queue, request queuing time, CPU utilization, memory usage, MemStore usage in percentage, RPC packet response time, RPC packet throughput, number of opened cursors, clog synchronization delay, and SQL execution time.

   • Click the Transaction tab to view the transaction performance data, including the TPS, transaction response time, number of transaction logs, transaction log volume, transaction log time, lock waits, average lock wait time, number of transactions, and transaction response time details.

   • Click the Storage and Cache tab to view the performance data related to storage and caching, including the MemStore, IOPS, I/O time, I/O throughput, cache size, cache hit rate, and number of cache requests.

   For more information, see Tenant performance monitoring in the OCP User Guide of the corresponding version.