A tenant is a logical concept that represents a resource allocation unit in OceanBase Database. It is the basis for the management of database objects and resources. It is critical for system O&M, especially for the O&M of cloud databases. After you log on to the OceanBase Cloud Platform (OCP) console, you can click Tenants in the left-side navigation pane to go to the Tenants page, where you can obtain the tenant overview information. By default, the page displays a list of tenants that you have the permission to view, and displays performance monitoring charts of top 5 tenants.
On the Tenants page, you can see a Tenants list and charts of Top 5 Tenants. You can also perform tenant management operations on this page. For more information, see Unit specification management, Create a tenant, Lock a tenant, and Copy a tenant.
Tenants
The Tenants list displays the information of each tenant in columns such as Tenant Name, Tag, Cluster, OceanBase Database Version, Tenant Mode, Zone Priority, Read-only, Locked, Status, Created At, and Actions. You can search for multiple tenants at a time by specifying their names separated with spaces.
You can click the name of a tenant to go to its Overview page. For more information, see Overview.
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.
Click the copy button to the right of the tenant name to copy the tenant name.
You can sort tenants by the Cluster column. In addition, you can click the name of a cluster to go to the tenant management page of the cluster. For more information, see Overview of the Cluster Details page.
When a tenant is in the Maintaining state, you can click View Task in the Actions column to go to the task details page of the tenant. On the task details page, you can perform operations such as viewing task logs, rolling back a task, and retrying a task. For more information, see Manage tasks.
| Parameter | Description |
|---|---|
| Mode | The mode of the tenant, which may be Oracle or MySQL. You can filter tenants by mode. |
| Zone Priority | The priorities of zones of the tenant. |
| Status | The status of the cluster. Valid values include Running, Creating, Maintaining, Deleting, and Unavailable. |
| Created At | The time when the tenant was created. You can sort tenants by creation time. |
| Actions | You can perform operations on the tenant by clicking Lock, Copy, View Task, and Delete. Note |
Top 5 Tenants
In this section, you can view the following monitoring data of tenants in the last hour, 24 hours, or 7 days: QPS, TPS, SQL response time, Transaction response time, Sessions, Event waiting_Number of times, Event waiting_Time, and Capacity_Number of tables.
You can click the zoom-in icon in the upper-right corner to zoom in the chart or select a monitoring time range.
| Metric | Description |
|---|---|
| QPS | The average number of SQL statements processed per second. |
| TPS | The average number of transactions processed per second. |
| SQL response time | The SQL response time, in µs. |
| Transaction response time | The average amount of time taken by the server to process a transaction, in µs. |
| Sessions | The current number of sessions and the current number of active sessions. Data source: __all_virtual_processlist. |
| Event waiting_Number of times | The average number of wait events per second. |
| Event waiting_Time | The average wait time of each wait event, in μs. |
| Capacity_Number of tables | The number of tables. |