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
Log on to the
systenant of the cluster as therootuser.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 setParameters:
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 thesystenant is1. For more information about how to view the details of the current tenant, see View tenant information.If the value of
TENANT_IDisNULLin 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.