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 on OceanBase Cloud Platform (OCP).
Prerequisites
Make sure that you have the following permissions:
- Resource Permissions: Cluster Read-only permission
- Menu Permissions: Permission on the Tenant Management menu of Clusters
Procedure
Log on to the OCP console.
In the left-side navigation pane, click Clusters. The Clusters page automatically appears.
On the Clusters page, find the target cluster and click its name to go to the Overview page.
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 section.
The resource distribution information includes the CPU utilization, memory usage, log disk usage, and data disk usage of each tenant in percentage, as well as the remaining CPU, memory, log disk, 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 the Data disk area to view the data disk usage trend within a specified period of time.
Note
- If CPU overallocation is enabled for the cluster, the maximum and minimum numbers of CPU cores allocated to each tenant in the cluster are displayed in the Capacity Usage Overview section.
- The Log Disk data is displayed only for a cluster of OceanBase Database V4.0 or later.
In the Tenants section, view the basic information of all tenants in the following columns: Tenant Name, Tag, OceanBase version number, Mode, Primary Zone, Read-only, Locked, Status, and Created On.
- You can hover the pointer over the Tag field to view all tags of a tenant. You can click the Edit icon to manage the tags. For more information, see Manage tags.
- You can lock or clone a tenant. For more information, see Lock a tenant and Clone 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 data in the last hour, last 24 hours, or last 7 days 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. v$sysstat SQL Response Time The SQL response time, in µs. v$sysstat Transaction Response Time The average processing time per transaction on the server, in μs. v$sysstat Sessions The number of sessions and the number of active sessions. __all_virtual_processlist Event waiting_Number of times The average number of wait events per second. v$system_event Event waiting_Time The average wait time per wait event, in μs. v$system_event Capacity_Number of tables The number of tables. gv$table Capacity_Number of partitions The number of partitions. v$partition