View resource pool information

After successfully creating resource pools a cluster, you can view the information about them in the cluster.

Procedure

1. Log in to the sys tenant of the cluster using the root user.

2. View the information about the resource pools in the cluster:

   obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS\G;
   *************************** 1. row ***************************
   RESOURCE_POOL_ID: 1
               NAME: sys_pool
          TENANT_ID: 1
        CREATE_TIME: 2022-11-15 14:26:23.038148
        MODIFY_TIME: 2022-11-15 14:26:23.044325
         UNIT_COUNT: 1
     UNIT_CONFIG_ID: 1
          ZONE_LIST: zone1
       REPLICA_TYPE: FULL
   *************************** 2. row ***************************
   RESOURCE_POOL_ID: 1001
               NAME: pool_mysql001_zone1_bmg
          TENANT_ID: 1002
        CREATE_TIME: 2022-11-15 14:50:41.839785
        MODIFY_TIME: 2022-11-15 14:50:41.923685
         UNIT_COUNT: 1
     UNIT_CONFIG_ID: 1001
          ZONE_LIST: zone1
       REPLICA_TYPE: FULL
   *************************** 3. row ***************************
   RESOURCE_POOL_ID: 1002
               NAME: pool_mysql002_zone1_pej
          TENANT_ID: 1004
        CREATE_TIME: 2022-11-15 14:51:22.271744
        MODIFY_TIME: 2022-11-15 14:51:22.321220
         UNIT_COUNT: 1
     UNIT_CONFIG_ID: 1002
          ZONE_LIST: zone1
       REPLICA_TYPE: FULL
   *************************** 4. row ***************************
   RESOURCE_POOL_ID: 1003
               NAME: pool_oracle001_zone1_zco
          TENANT_ID: 1006
        CREATE_TIME: 2022-11-15 14:51:49.622973
        MODIFY_TIME: 2022-11-15 14:51:49.675680
         UNIT_COUNT: 1
     UNIT_CONFIG_ID: 1003
          ZONE_LIST: zone1
       REPLICA_TYPE: FULL
   *************************** 5. row ***************************
   RESOURCE_POOL_ID: 1004
               NAME: pool_oracle002_zone1_mjh
          TENANT_ID: 1008
        CREATE_TIME: 2022-11-15 14:55:10.986570
        MODIFY_TIME: 2022-11-15 14:55:11.036814
         UNIT_COUNT: 1
     UNIT_CONFIG_ID: 1004
          ZONE_LIST: zone1
       REPLICA_TYPE: FULL
   5 rows in set
   

   where

   • RESOURCE_POOL_ID: indicates the ID of a resource pool, which uniquely identifies a resource pool.

   • TENANT_ID: indicates the ID of the tenant to which the resource pool belongs, which uniquely identifies a tenant. The ID of the sys tenant is 1. For instructions on viewing detailed information about the current tenant, see View tenant and resource information.

     If the value of TENANT_ID is NULL, the resource pool is not bound to any tenant. You can allocate the resource pool to a tenant. For instructions on allocating a resource pool to a tenant, see Allocate a resource pool to a tenant.

   • UNIT_COUNT: indicates the number of resource units in the resource pool.

   • UNIT_CONFIG_ID: indicates the ID of a resource unit config (namely, a resource unit configuration) in the resource pool, which uniquely identifies a resource unit config.

     For instructions on viewing resource unit configs, see View resource unit configurations.

   • ZONE_LIST: indicates which zones are using the resources in the resource pool.