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, ...