Before you create a resource pool, it is necessary to query the details of existing unit configs to select a suitable unit config as a template.
Procedure
A resource unit serves as a template for utilizing server resources. By querying the view such as oceanbase.DBA_OB_UNIT_CONFIGS, you can obtain the configuration information of the existing resource units in the current cluster.
To query unit configs, perform the following steps:
Log in to the
systenant of the cluster using therootuser.Query all unit configs in the cluster:
obclient> SELECT * FROM oceanbase.DBA_OB_UNIT_CONFIGS\G *************************** 1. row *************************** UNIT_CONFIG_ID: 1 NAME: sys_unit_config MAX_CPU: 2.5 MIN_CPU: 2.5 MEMORY_SIZE: 17179869184 LOG_DISK_SIZE: 17179869184 MAX_IOPS: 25000 MIN_IOPS: 25000 IOPS_WEIGHT: 2 *************************** 2. row *************************** UNIT_CONFIG_ID: 1001 NAME: unit001 MAX_CPU: 1 MIN_CPU: 1 MEMORY_SIZE: 6442450944 LOG_DISK_SIZE: 19327352832 MAX_IOPS: 10000 MIN_IOPS: 10000 IOPS_WEIGHT: 1 *************************** 3. row *************************** UNIT_CONFIG_ID: 1002 NAME: unit002 MAX_CPU: 1 MIN_CPU: 1 MEMORY_SIZE: 6442450944 LOG_DISK_SIZE: 19327352832 MAX_IOPS: 10000 MIN_IOPS: 10000 IOPS_WEIGHT: 1 3 rows in set