SHOW-WORKLOAD-GROUPS

Name

SHOW WORKLOAD GROUPS

Description

该语句用于展示当前用户具有usage_priv权限的资源组。

语法：

1. SHOW WORKLOAD GROUPS [LIKE "pattern"];

说明：

该语句仅做资源组简单展示，更复杂的展示可参考 tvf workload_groups().

Example

1. 展示所有资源组：

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. 使用 LIKE 模糊匹配：

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