Delete resource specification (unit config)

This topic describes how to delete a resource specification.

Prerequisites

Before deleting a resource specification, you must ensure that the current resource specification is not in use. If the resource specification is being used, you need to remove it from the resource pool first, then delete it. For detailed instructions, see Modify resource pool properties.

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. Confirm the usage information of the resource specification through the DBA_OB_UNIT_CONFIGS and DBA_OB_RESOURCE_POOLS views.

   Example: If the resource specification name does not appear in the UNIT_NAME column of the query result, the resource specification is not allocated to any resource pool. If the resource specification name appears in the UNIT_NAME column, the resource specification is allocated to a resource pool.

   Confirm that the resource specification S2_unit_config is no longer in use.

   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. Drop the resource specification using the DROP RESOURCE UNIT statement.

   Example: Drop the resource specification S2_unit_config:

   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 confirm that the resource specification is successfully deleted.

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

References

• Modify resource pool properties