SHOW-WORKLOAD-GROUPS
SHOW-WORKLOAD-GROUPS
Name
SHOW WORKLOAD GROUPS
Description
该语句用于展示当前用户具有usage_priv权限的资源组。
语法:
SHOW WORKLOAD GROUPS [LIKE "pattern"];
说明:
该语句仅做资源组简单展示,更复杂的展示可参考 tvf workload_groups().
Example
展示所有资源组:
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 |
+----------+--------+--------------------------+---------+使用 LIKE 模糊匹配:
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