O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required