View resource pools

After a resource pool is created, you can view the resource pools in the cluster and check the resource distribution among the resource pools.

Procedure

1. Log on to the sys tenant of the cluster as the root user.

2. Execute the following statement to view information of resource pools in the current 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
   

   Parameters:

   • RESOURCE_POOL_ID: the ID of the resource pool. Each resource pool ID corresponds to one resource pool.

   • TENANT_ID: the ID of the tenant to which the resource pool belongs. Each tenant ID corresponds to one tenant. The ID of the sys tenant is 1. For more information about how to view the details of the current tenant, see View tenant information.

     If the value of TENANT_ID is NULL in the query result, the resource pool is not bound to any tenant. You can allocate the resource pool to a tenant. For more information about how to allocate a resource pool to a tenant, see Allocate a resource pool to a tenant.

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

   • UNIT_CONFIG_ID: the ID of the resource unit configs in the resource pool. One resource unit corresponds to one resource unit config ID.

     For more information about how to view resource unit configs, namely resource unit configurations, see View resource unit configurations.

   • ZONE_LIST: the zones that are allowed to use resources in the resource pool.