Drop a unit config

This topic describes how to drop a unit config.

Prerequisites

Before you drop a unit config, make sure that the unit config that you want to drop is not in use. If it is being used by a tenant, remove it from the resource pool of the tenant first. For more information, see Modify attributes of a resource pool.

Procedure

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

   obclient -h172.30.xx.xx -P2883 -uroot@sys#cluster -p**** -A
   

2. Access the database named oceanbase.

   obclient [(none)]> USE oceanbase;
   

3. Query the DBA_OB_UNIT_CONFIGS and DBA_OB_RESOURCE_POOLS views for the use information about unit configs.

   In the query result, if the name of the target unit config does not exist in the UNIT_NAME column, the unit config is not allocated to any resource pool. If the name exists, the unit config is allocated to the corresponding resource pool.

   To verify whether the unit config named S2_unit_config is in use, execute the following statement:

   obclient [oceanbase]> SELECT a.UNIT_CONFIG_ID, a.NAME AS UNIT_NAME, b.NAME AS POOL_NAME FROM oceanbase.DBA_OB_UNIT_CONFIGS a,oceanbase.DBA_OB_RESOURCE_POOLS b WHERE b.UNIT_CONFIG_ID=a.UNIT_CONFIG_ID;
   +----------------+-------------------------------+--------------------------+
   | UNIT_CONFIG_ID | UNIT_NAME                     | POOL_NAME                |
   +----------------+-------------------------------+--------------------------+
   |              1 | sys_unit_config               | sys_pool                 |
   |           1001 | config_mysql001_zone1_S1_okz  | pool_mysql001_zone1_okz  |
   |           1002 | config_mysql001_zone2_S1_pme  | pool_mysql001_zone2_pme  |
   |           1003 | config_mysql001_zone3_S1_jsu  | pool_mysql001_zone3_jsu  |
   |           1013 | config_oracle001_zone3_S1_exu | pool_oracle001_zone3_exu |
   |           1014 | config_oracle001_zone2_S1_hli | pool_oracle001_zone2_hli |
   |           1015 | config_oracle001_zone1_S1_owy | pool_oracle001_zone1_owy |
   |           1020 | S1_unit_config                | mq_pool_01               |
   +----------------+-------------------------------+--------------------------+
   8 rows in set
   

   For more information about the DBA_OB_UNIT_CONFIGS view, see DBA_OB_UNIT_CONFIGS.

   For more information about the DBA_OB_RESOURCE_POOLS view, see DBA_OB_RESOURCE_POOLS.

4. Execute the DROP RESOURCE UNIT statement to drop the unit config.

   To drop a unit config named S2_unit_config, execute the following statement:

   obclient [oceanbase]> DROP RESOURCE UNIT S2_unit_config;
   Query OK, 0 rows affected
   

   For more information about the DROP RESOURCE UNIT statement, see DROP RESOURCE UNIT.

5. Query the DBA_OB_UNIT_CONFIGS view to verify whether the unit config is dropped.

   obclient [oceanbase]> SELECT * FROM DBA_OB_UNIT_CONFIGS WHERE NAME = 'S2_unit_config';
   Empty set
   

References

• Modify attributes of a resource pool