Delete a resource group

You can use the DELETE_CONSUMER_GROUP subprogram in the DBMS_RESOURCE_MANAGER package to delete an unused resource group.

Prerequisites

The target resource group already exists.

Considerations

Deleting a resource group will also delete the associated resource management plan config.

Procedure

1. Log in to a MySQL tenant of the cluster using the administrator.

2. Call the DELETE_CONSUMER_GROUP subprogram in the DBMS_RESOURCE_MANAGER package to delete the resource group.

   obclient [test]> CALL DBMS_RESOURCE_MANAGER.DELETE_CONSUMER_GROUP(
   CONSUMER_GROUP => 'interactive_group'
   );
   

   Here, CONSUMER_GROUP specifies the resource group.

3. Query the oceanbase.DBA_RSRC_CONSUMER_GROUPS view to verify whether the resource group has been deleted.

   obclient [test]> SELECT CONSUMER_GROUP_ID, CONSUMER_GROUP, COMMENTS FROM oceanbase.DBA_RSRC_CONSUMER_GROUPS;
   +-------------------+----------------+-----------------+
   | CONSUMER_GROUP_ID | CONSUMER_GROUP | COMMENTS        |
   +-------------------+----------------+-----------------+
   |                 5 | batch_group    | AP              |
   |                 2 | group1         | Transaction processing team      |
   |                 3 | group2         | Daily O&M team      |
   |                 0 | OTHER_GROUPS   | NULL            |
   |                 1 | SYS_GROUP      | NULL            |
   +-------------------+----------------+-----------------+
   5 rows in set
   

   For more information about the oceanbase.DBA_RSRC_CONSUMER_GROUPS view, see oceanbase.DBA_RSRC_CONSUMER_GROUPS.

References

DELETE_CONSUMER_GROUP