Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 44.6Mb
PDF (A4) - 44.7Mb
PDF (RPM) - 40.4Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 205.6Kb
Man Pages (Zip) - 308.8Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  INFORMATION_SCHEMA Tables  /  The INFORMATION_SCHEMA RESOURCE_GROUPS Table

25.21 The INFORMATION_SCHEMA RESOURCE_GROUPS Table

The RESOURCE_GROUPS table provides access to information about resource groups. For general discussion of the resource group capability, see Section 8.12.5, “Resource Groups”.

You can see information only for columns for which you have some privilege.

The RESOURCE_GROUPS table has these columns:

  • RESOURCE_GROUP_NAME

    The name of the resource group.

  • RESOURCE_GROUP_TYPE

    The resource group type, either SYSTEM or USER.

  • RESOURCE_GROUP_ENABLED

    Whether the resource group is enabled (1) or disabled (0);

  • VCPU_IDS

    The CPU affinity; that is, the set of virtual CPUs that the resource group can use. The value is a list of comma-separated CPU numbers or ranges.

  • THREAD_PRIORITY

    The priority for threads assigned to the resource group. The priority ranges from -20 (highest priority) to 19 (lowest priority). System resource groups have a priority that ranges from -20 to 0. User resource groups have a priority that ranges from 0 to 19.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.