MySQL :: MySQL 8.4 参考手册 :: 28.3.26 INFORMATION_SCHEMA RESOURCE

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 71%

RESOURCE_GROUPS 表提供对资源组信息的访问。有关资源组功能的一般讨论，请参见第 7.1.16 节，“资源组”。The RESOURCE_GROUPS table provides access to information about resource groups. For general discussion of the resource group capability, see Section 7.1.16, “Resource Groups”.

您只能查看对您具有某些权限的列的信息。You can see information only for columns for which you have some privilege.

RESOURCE_GROUPS 表具有以下列：The RESOURCE_GROUPS table has these columns:

RESOURCE_GROUP_NAME
资源组的名称。The name of the resource group.
RESOURCE_GROUP_TYPE
资源组类型，可以是 SYSTEM 或 USER。The resource group type, either SYSTEM or USER.
RESOURCE_GROUP_ENABLED
资源组是否启用 (1) 或禁用 (0);Whether the resource group is enabled (1) or disabled (0);
VCPU_IDS
CPU 亲和性；即资源组可以使用的一组虚拟 CPU。值为用逗号分隔的 CPU 编号或范围列表。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_PRIORITYTHREAD_PRIORITY
分配给资源组的线程优先级。优先级范围从 -20（最高优先级）到 19（最低优先级）。系统资源组的优先级范围为 -20 到 0。用户资源组的优先级范围为 0 到 19。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.