Debian Codegraph @

mysql-test/suite/x/r/session_resource_group.result

raw
1 CREATE RESOURCE GROUP my_group TYPE=USER;
2
3 USR_default
4 ===========
5 RUN SET RESOURCE GROUP USR_default
6
7 0 rows affected
8 RUN SELECT RESOURCE_GROUP FROM performance_schema.threads WHERE THREAD_ID = PS_CURRENT_THREAD_ID()
9 Verify [Resource group needs to be 'USR_default']
10 RUN SELECT /*+ RESOURCE_GROUP(SYS_default) */ 1 AS value
11 value
12 1
13 0 rows affected
14 Warnings generated:
15 WARNING | 3661 | Unable to bind resource group SYS_default with thread id (ID).(System resource group can't be bound with a session thread).
16 RUN SELECT RESOURCE_GROUP FROM performance_schema.threads WHERE THREAD_ID = PS_CURRENT_THREAD_ID()
17 Verify [Resource group needs to be 'USR_default']
18 RUN SELECT /*+ RESOURCE_GROUP(my_group) */ 1 AS value
19 value
20 1
21 0 rows affected
22 RUN SELECT RESOURCE_GROUP FROM performance_schema.threads WHERE THREAD_ID = PS_CURRENT_THREAD_ID()
23 Verify [Resource group needs to be 'USR_default']
24 RUN SELECT /*+ RESOURCE_GROUP(USR_default) */ 1 AS value
25 value
26 1
27 0 rows affected
28 RUN SELECT RESOURCE_GROUP FROM performance_schema.threads WHERE THREAD_ID = PS_CURRENT_THREAD_ID()
29 Verify [Resource group needs to be 'USR_default']
30 Mysqlx.Ok {
31 msg: "bye!"
32 }
33 ok
34
35 my_group
36 ========
37 RUN SET RESOURCE GROUP my_group
38
39 0 rows affected
40 RUN SELECT RESOURCE_GROUP FROM performance_schema.threads WHERE THREAD_ID = PS_CURRENT_THREAD_ID()
41 Verify [Resource group needs to be 'my_group']
42 RUN SELECT /*+ RESOURCE_GROUP(SYS_default) */ 1 AS value
43 value
44 1
45 0 rows affected
46 Warnings generated:
47 WARNING | 3661 | Unable to bind resource group SYS_default with thread id (ID).(System resource group can't be bound with a session thread).
48 RUN SELECT RESOURCE_GROUP FROM performance_schema.threads WHERE THREAD_ID = PS_CURRENT_THREAD_ID()
49 Verify [Resource group needs to be 'my_group']
50 RUN SELECT /*+ RESOURCE_GROUP(my_group) */ 1 AS value
51 value
52 1
53 0 rows affected
54 RUN SELECT RESOURCE_GROUP FROM performance_schema.threads WHERE THREAD_ID = PS_CURRENT_THREAD_ID()
55 Verify [Resource group needs to be 'my_group']
56 RUN SELECT /*+ RESOURCE_GROUP(USR_default) */ 1 AS value
57 value
58 1
59 0 rows affected
60 RUN SELECT RESOURCE_GROUP FROM performance_schema.threads WHERE THREAD_ID = PS_CURRENT_THREAD_ID()
61 Verify [Resource group needs to be 'my_group']
62 Mysqlx.Ok {
63 msg: "bye!"
64 }
65 ok
66 DROP RESOURCE GROUP my_group FORCE;