View tenant overview information

2024-07-30 09:31:29  Updated

A tenant is a logical concept that represents a resource allocation unit in ApsaraDB for OceanBase. 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 the performance monitoring charts of the top 5 tenants. You can also perform tenant management operations on this page. For more information, see Manage unit specifications, Create a tenant, Lock a tenant, and Copy a tenant.

Tenants

On the Tenants page, you can view tenant information in the following columns: Tenant Name, Tag, Cluster, OceanBase version number, Mode, Primary Zone, Read-only, Locked, Status, and Created On. The Actions column provides options for you to perform related operations on tenants. You can query tenants by name in batches, and the tenant names are separated with spaces.

  • You can click the name of a tenant to go to its Overview page. For more information, see Overview.

  • You can hover the pointer over the tag indicating the primary/standby status of a tenant and view its primary tenant or standby tenants in the pop-up window. You can click Topology of Primary/Standby Tenants to go to the topology page and view details about the primary tenant or standby tenants of the current tenant. For more information, see View the topology of primary/standby relationships of a tenant.

  • You can hover the pointer over the tag of a tenant to view all its tags. You can click the Edit icon to manage the tags. For more information, see Manage tags.

  • You can click the Copy icon next to the name of a tenant to copy its 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.

07051024

Parameter Description
Tag A tag that is set based on the content and attributes of the tenant.
Mode The mode of the tenant, which may be Oracle or MySQL. You can filter tenants by mode.
Primary Zone 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.
  • If you lock a tenant, the tenant cannot be accessed.
  • If you copy a tenant, a new tenant with the same settings will be created in the same cluster.
  • If a tenant is in the Creating or Creation failed state, you can view the task details.
  • You can delete a tenant that is in the Creation failed state.
  • Note
    You can click View task and Delete only on the Overview page of a tenant.

    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.

    1

    Metric Description
    QPS The average number of SQL statements processed per second.
    TPS The average number of transactions processed per second.
    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.

    Contact Us