SHOW WORKLOAD GROUPS

Description

This statement is used to display the resource groups for which the current user has usage_priv privileges.

grammar:

SHOW WORKLOAD GROUPS [LIKE "pattern"];

Description:

This statement only does a simple display of workload groups, for a more complex display refer to tvf workload_groups().

Example

1. Show all workload groups:

   mysql> show workload groups;
   +----------+--------+--------------------------+---------+
   | Id       | Name   | Item                     | Value   |
   +----------+--------+--------------------------+---------+
   | 10343386 | normal | cpu_share                | 10      |
   | 10343386 | normal | memory_limit             | 30%     |
   | 10343386 | normal | enable_memory_overcommit | true    |
   | 10352416 | g1     | memory_limit             | 20%     |
   | 10352416 | g1     | cpu_share                | 10      |
   +----------+--------+--------------------------+---------+

2. Show workload groups using pattern

   mysql> show workload groups like "normal%";
   +----------+--------+--------------------------+---------+
   | Id       | Name   | Item                     | Value   |
   +----------+--------+--------------------------+---------+
   | 10343386 | normal | cpu_share                | 10      |
   | 10343386 | normal | memory_limit             | 30%     |
   | 10343386 | normal | enable_memory_overcommit | true    |
   +----------+--------+--------------------------+---------+

Keywords

SHOW, WORKLOAD, GROUPS, GROUP

Best Practice