You can view the tenant, the resource distribution information of all tenants, and monitoring data of top 5 tenants in the cluster that you manage.
Prerequisite
You have all permissions on the cluster and the management permissions on its tenants.
Procedure
Log on to the OceanBase Cloud Platform (OCP) console. The Clusters page automatically appears.
In the Clusters list on the Cluster page, find the target cluster and click its name.
In the left-side navigation pane of the page that appears, click Tenant Management .
You can view the resource distribution on the Tenant Management page. The resource distribution information includes the percentage of CPU and memory usage of each tenant, and the percentage of the remaining CPU and memory of the system.
When you move the pointer over the pie chart, the chart displays the resource usage of the tenant.
Click Create Tenant to create a tenant for the cluster. For more information, see Create a new tenant.
In the Tenants section, you can view the basic information of all tenants, such as the tenant name, replica type, zone priority, tenant mode, and status.
In the Top 5 Tenants section, you can view the performance metrics of the top 5 tenants by workload, such as the TPS, QPS, SQL response time, transaction response time, number of active sessions, number of waits, wait time, capacity_number of tables, and capacity_number of partitions. You can also view the monitoring information of the last hour, day, or week as needed.
The following table describes the performance monitoring metrics.
Metric Description Data source QPS The average number of SQL statements processed per second. v$sysstat TPS The average number of transactions processed per second (transactions/second). v$sysstat SQL response time The SQL response time in the unit of µs. v$sysstat Transaction response time The average time in microseconds taken by the server to process a transaction. v$sysstat Number of active sessions The number of active sessions (sessions) in this tenant. __all_virtual_processlist Event waiting_number of times The average number of waiting events per second (events/second). v$system_event Event waiting_time The average wait time of each wait event in the unit of μs. v$system_event Capacity_Number of tables The number of tables in this tenant. gv$table Capacity_Number of partitions The number of partitions. v$partition