resource_groups
resource_groups
Name
resource_groups
description
表函数,生成 resource_groups 临时表,可以查看当前资源组信息。
该函数用于from子句中。
syntax
resource_groups()
resource_groups()表结构:
mysql> desc function resource_groups();
+-------+-------------+------+-------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-------+---------+-------+
| Id | BIGINT | No | false | NULL | NONE |
| Name | VARCHAR(64) | No | false | NULL | NONE |
| Item | VARCHAR(64) | No | false | NULL | NONE |
| Value | INT | No | false | NULL | NONE |
+-------+-------------+------+-------+---------+-------+
example
mysql> select * from resource_groups()\G
+-------+------------+-----------+-------+
| Id | Name | Item | Value |
+-------+------------+-----------+-------+
| 10076 | group_name | cpu_share | 1 |
| 10077 | group_test | cpu_share | 10 |
+-------+------------+-----------+-------+
keywords
resource_groups