Before you create a resource pool, you must check the resource unit configurations to select an appropriate resource template.
Procedure
A resource unit can be considered a template for using server resources. You can query a view for the existing resource unit configurations in the current cluster.
View the listening result:
Log on to the
systenant of the cluster as therootuser.Execute the following statement to query all resource unit configurations 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