SHOW-workload-GROUPS
SHOW-workload-GROUPS
Name
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
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 |
+----------+--------+--------------------------+---------+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