You can view the tenants, the resource distribution information of all tenants, and monitoring data of the top 5 tenants in the cluster that you manage.
Prerequisites
You have all permissions on the cluster and the management permissions on its tenants.
Procedure
Log on to the OceanBase Cloud Platform (OCP) console.
In the left-side navigation pane, click Clusters to go to the Clusters page.
In the Clusters list, find the target cluster and click its name.
In the left-side navigation pane, click Tenant Management to go to the Tenant Management page.
Click Create Tenant to create a tenant for the cluster. For more information, see Create a tenant.
View the resource distribution information in the Capacity Usage Overview module.
The resource distribution information includes the CPU utilization, memory usage, and data disk usage of each tenant in percentage, as well as the remaining CPU, memory, and data disk resources of the system in percentage.
When you move the pointer over a tenant in a pie chart, the chart displays the specific resource usage of the tenant. You can also click View Usage Trends in the upper-right corner of Data disk to view the data disk usage trend within a specified period of time.
In the Tenants section, view the basic information about each tenant, including the tenant name, tag, tenant ID, zone priorities, tenant mode, read-only or not, locked or not, status, and creation time.
- Hover the pointer over the Tag field of a tenant to view all tags of the tenant. You can click the Edit icon to manage the tags. For more information, see Manage Tags.
- Lock or copy tenants. For more information, see Lock a tenant and Copy a tenant.
In the Top 5 Tenants section, view the performance metrics of the top 5 tenants by workload, such as the QPS, TPS, SQL response time, transaction response time, number of sessions, event waiting_count, event waiting_time, capacity_tables, and capacity_partitions. You can also view the monitoring information during the last hour, day, or week as needed.
The following table describes the performance monitoring metrics.
Metric Description Source QPS The average number of SQL statements processed per second. v$sysstat TPS The average number of transactions processed per second. v$sysstat SQL response time The SQL response time, in µs. v$sysstat Transaction response time The average time taken by the server to process a transaction, in µs. v$sysstat Sessions The number of active sessions and the number of current sessions. __all_virtual_processlist Event waiting_count The average number of wait events per second. v$system_event Event waiting_time The average wait time of each wait event, in μs. v$system_event Capacity_tables The number of tables. gv$table Capacity_partitions The number of partitions. v$partition