Query unit configs

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:

1. Log in to the sys tenant of the cluster using the root user.

2. 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