描述

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

语法

1SHOW WORKLOAD GROUPS [LIKE "<pattern>"];

注意事项

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

示例

1. 展示所有资源组：

   SQL 复制

   1mysql> 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 模糊匹配：

   SQL 复制

   1mysql> 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+----------+--------+--------------------------+---------+