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:

1. 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:

1. mysql> show workload groups; 2. +----------+--------+--------------------------+---------+ 3. | Id | Name | Item | Value | 4. +----------+--------+--------------------------+---------+ 5. | 10343386 | normal | cpu_share | 10 | 6. | 10343386 | normal | memory_limit | 30% | 7. | 10343386 | normal | enable_memory_overcommit | true | 8. | 10352416 | g1 | memory_limit | 20% | 9. | 10352416 | g1 | cpu_share | 10 | 10. +----------+--------+--------------------------+---------+ 2. Show workload groups using pattern

1. mysql> show workload groups like "normal%"; 2. +----------+--------+--------------------------+---------+ 3. | Id | Name | Item | Value | 4. +----------+--------+--------------------------+---------+ 5. | 10343386 | normal | cpu_share | 10 | 6. | 10343386 | normal | memory_limit | 30% | 7. | 10343386 | normal | enable_memory_overcommit | true | 8. +----------+--------+--------------------------+---------+

Keywords

1. SHOW, WORKLOAD, GROUPS, GROUP

Best Practice