After resource pools are created successfully, you can view the resource pools in the cluster and the distribution of each resource pool.
Procedure
Log in to the
systenant of the cluster as therootuser.Execute the following statement to view resource pool information 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 setThe fields are described as follows:
RESOURCE_POOL_ID: the resource pool ID. Each resource pool has one resource pool ID.TENANT_ID: the tenant ID to which the resource pool belongs. Each tenant has one tenant ID. The tenant ID of thesystenant is1. For instructions on viewing detailed information about the current tenant, see View tenant and resource 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 instructions on allocating 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 resource unit specification ID of the resource pool. Each resource unit has one resource unit specification ID.For instructions on viewing resource unit specifications (resource unit configurations), see View resource unit configurations.
ZONE_LIST: the zone list of the resource pool, indicating in which zones the resources of the resource pool are used.