跳到主要内容
跳到主要内容

SHOW-WORKLOAD-GROUPS

SHOW-WORKLOAD-GROUPS

Name

SHOW WORKLOAD GROUPS

Description

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

语法:

SHOW WORKLOAD GROUPS [LIKE "pattern"];

说明:

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

Example

  1. 展示所有资源组:

    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 |
    +----------+--------+--------------------------+---------+
  2. 使用 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

Best Practice