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 (not displayed in real-time mode)	Select a time range for the data that you want to query.
   Stat Period (not displayed in real-time mode)	Specify the length of the statistical period of a performance data point. The value can be Per Minute or Per Second, indicating that the performance statistics are in the one-minute or one-second granule. OCP also calculates one more statistical period based on the selected time range to make the number of data points returned approximate 1,440. If the selected time range is long, the statistical period may be longer than one minute.
   Zone	Select the zone that you want to view.
   OBServer	Select the OBServer node that you want to view.

   • After you specify the filter conditions, the system displays the performance monitoring data based on the values you specified for Select Time and Stat Period.

     

     Note

     To view the trend details over a specific period, drag the pointer over the period to select this period. The system will then zoom in to display the trend details. After you view the trend details, double-click the trend chart to return to normal.

   • To view the performance metrics of an OBServer node in real time, toggle on the Real-time switch in the upper-right corner and select the target OBServer node.

     

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 SQL execution and performance data. The following table describes monitoring metrics related to performance and SQL execution.

     Metric	Description
     QPS	The average number of SQL statements processed per second. all: the number of SQL statements processed per second. select: the number of SELECT statements processed per second. insert: the number of INSERT statements processed per second. update: the number of UPDATE statements processed per second. replace: the number of REPLACE statements processed per second. delete: the number of DELETE statements processed per second.
     Response Time	The response time. all: the average time taken by the server to process an SQL statement, in the unit of µs. select: the average time taken by the server to process a SELECT statement, in the unit of µs. insert: the average time taken by the server to process an INSERT statement, in the unit of µs. update: the average time taken by the server to process an UPDATE statement, in the unit of µs. replace: the average time taken by the server to process a REPLACE statement, in the unit of µs. delete: the average time taken by the server to process a DELETE statement, in the unit of µs.
     Active Sessions	The number of active sessions.
     Execution Plan Type	The number of SQL execution plans processed per second, which is collected by plan type. local: the number of local execution plans processed per second. remote: the number of remote execution plans processed per second. distributed: the number of distributed execution plans processed per second.
     Wait events	The number of wait events per second.
     Time consumed by waiting events	The average time of wait events, in the unit of μs.
     Request queue	The number of SQL queries entering the waiting queue per second.
     Request queue time	The wait time of an SQL query in a queue, in the unit of μs.
     CPU Utilization	The CPU utilization, in percentage.
     MemStore Usage	The MemStore usage, in percentage.
     Rpc package rt	The time consumed for receiving and sending RPC packets. in: the average time consumed for receiving an RPC packet, in the unit of µs. out: the average time consumed for sending an RPC packet, in the unit of µs.
     Rpc package throughput	The data amount of RPC packets that are sent and received per unit time. in: the throughput of receiving RPC packets, in the unit of bytes. out: the throughput of sending RPC packets, in the unit of bytes.

   • Click the Transaction tab to view the transaction performance data. The following table describes transaction-related metrics.

     Metric	Description
     TPS	The average number of transactions processed per second.
     Transaction response time	The average time taken by the server to process a transaction, in the unit of μs.
     Number of transaction logs	The number of transaction logs committed per second.
     Transaction log volume	The total size of transaction logs committed per second, in the unit of bytes.
     Transaction log time-consuming	The average time taken by the server to process a transaction log, in the unit of μs.
     Lock wait	The number of transaction lock waits per second.
     Wait for lock time	The average wait time for a lock, in the unit of μs.

   • Click the Storage and Cache tab to view the performance data related to the storage and cache. The following table describes metrics related to the storage and cache.

     Metric	Description
     MemStore	The writable memory of the current tenant. total: the total size of MemStores, in the unit of MB. active: the size of active MemStores, in the unit of MB. trigger: the threshold that triggers major compaction, in the unit of MB. limit: the maximum size of an MemStore, in the unit of MB.
     IOPS	The average number of I/O operations per second. read: the number of reads from the SSStore per second. write: the number of writes to the SSStore per second.
     I/O Time	The average time consumed for an I/O operation. read: the average time of a read from the SSStore, in the unit of μs. write: the average time of a write to the SSStore, in the unit of μs.
     I/O Throughput	The average I/O throughput per second. read: the volume of data read from the SSStore per second, in the unit of bytes. write: the volume of data written to the SSStore per second, in the unit of bytes.
     Cache Size	The cache size. block_cache: the size of the block cache, in the unit of MB. row_cache: the size of the row cache, in the unit of MB. plan_cache: the size of the plan cache, in the unit of MB.
     Cache Hit Rate	The cache hit rate. block_cache: the hit rate of the block cache, in percentage. row_cache: the hit rate of the row cache, in percentage. plan_cache: the hit rate of the plan cache, in percentage.