resource_groups
resource_groups
β
Nameβ
resource_groups
descriptionβ
Table-Value-Function, generate a temporary table named resource_groups
. This tvf is used to view informations about current resource groups.
This function is used in FROM
clauses.
syntaxβ
resource_groups()
The table schema of resource_groups()
tvf:
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