workload_groups

Name

SinceVersion dev

workload_groups

description

表函数，生成 workload_groups 临时表，可以查看当前用户具有权限的资源组信息。

该函数用于from子句中。

syntax

workload_groups()

workload_groups()表结构：

1. mysql> desc function workload_groups();
2. +-------+-------------+------+-------+---------+-------+
3. | Field | Type        | Null | Key   | Default | Extra |
4. +-------+-------------+------+-------+---------+-------+
5. | Id    | BIGINT      | No   | false | NULL    | NONE  |
6. | Name  | STRING      | No   | false | NULL    | NONE  |
7. | Item  | STRING      | No   | false | NULL    | NONE  |
8. | Value | STRING      | No   | false | NULL    | NONE  |
9. +-------+-------------+------+-------+---------+-------+

example

1. mysql> select * from workload_groups()\G
2. +-------+--------+--------------+-------+
3. | Id    | Name   | Item         | Value |
4. +-------+--------+--------------+-------+
5. | 11001 | normal | memory_limit | 100%  |
6. | 11001 | normal | cpu_share    | 10    |
7. +-------+--------+--------------+-------+

keywords

1. workload_groups