<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-resource-groups-table">
      </a>
      28.3.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045079001616">
  </a>
  <p>
   The
   <a class="link" href="information-schema-resource-groups-table.html" title="28.3.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table">
    <code class="literal">
     RESOURCE_GROUPS
    </code>
   </a>
   table provides
      access to information about resource groups. For general
      discussion of the resource group capability, see
   <a class="xref" href="resource-groups.html" title="7.1.16 Resource Groups">
    Section 7.1.16, “Resource Groups”
   </a>
   .
  </p>
  <p>
   You can see information only for columns for which you have some
      privilege.
  </p>
  <p>
   The
   <a class="link" href="information-schema-resource-groups-table.html" title="28.3.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table">
    <code class="literal">
     RESOURCE_GROUPS
    </code>
   </a>
   table has these
      columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       RESOURCE_GROUP_NAME
      </code>
     </p>
     <p>
      The name of the resource group.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       RESOURCE_GROUP_TYPE
      </code>
     </p>
     <p>
      The resource group type, either
      <code class="literal">
       SYSTEM
      </code>
      or
      <code class="literal">
       USER
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       RESOURCE_GROUP_ENABLED
      </code>
     </p>
     <p>
      Whether the resource group is enabled (1) or disabled (0);
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       VCPU_IDS
      </code>
     </p>
     <p>
      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.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       THREAD_PRIORITY
      </code>
     </p>
     <p>
      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.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
