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 are 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 on to the sys tenant of the cluster as the root user.

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

2. Execute the following statement to go to the database named oceanbase:

   obclient [(none)]> USE oceanbase;
   

3. Query the oceanbase.DBA_OB_UNIT_CONFIGS and oceanbase.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. Otherwise, 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 oceanbase.DBA_OB_UNIT_CONFIGS view, see oceanbase.DBA_OB_UNIT_CONFIGS.

   For more information about the oceanbase.DBA_OB_RESOURCE_POOLSview, see oceanbase.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
   

More information

• Modify attributes of a resource pool