MySQL 8 Cookbook

Alter and drop resource group

You can dynamically adjust the number of CPUs or thread_priority of a resource group. If the system is heavily loaded, you can decrease the thread priority:

mysql> ALTER RESOURCE GROUP report_group VCPU = 3 THREAD_PRIORITY = 19;Query OK, 0 rows affected (0.12 sec)

Similarly, you can increase the priority when the system is lightly loaded:

mysql> ALTER RESOURCE GROUP report_group VCPU = 0-12 THREAD_PRIORITY = 0;Query OK, 0 rows affected (0.12 sec)

You can disable a resource group:

mysql> ALTER RESOURCE GROUP report_group DISABLE FORCE;Query OK, 0 rows affected (0.00 sec)

You can also drop a resource group using the DROP RESOURCE GROUP statement:

mysql> DROP RESOURCE GROUP report_group FORCE;

If FORCE is given, ...