Debian Codegraph @

mysql-test/suite/perfschema/t/service_pfs_resource_group.test

raw
1 --echo
2 --echo ## Test the Performance Schema Resource Group service WL#8881
3 --echo ##
4 --echo ## 1. Load component to register callbacks for each API
5 --echo ## 2. Create users to trigger tests within the component
6 --echo ## 3. Write test results to a log file
7 --echo ## 4. Print out log file
8 --echo ##
9
10 ## EXPECTED
11 ## TEST RESULT VERIFICATION
12 ## ------------------------------------------ -------- ---------------------------------
13 ## 1. Set resource group, current thread Success Group name = PFS_CURRENT_THREAD
14 ## 2. Set resource group, valid group name Success Group name = PFS_VALID_GROUP_NAME
15 ## 3. Set resource group, invalid thread id Fail Log message
16 ## 4. Set resource group, invalid group name Fail Log message
17
18 --echo ## Note: The test component sets its own resource group name, PFS_CURRENT_THREAD, for root.
19
20 --disable_ps_protocol
21
22 --echo
23 --echo ## Install test component
24 INSTALL COMPONENT 'file://component_test_pfs_resource_group';
25
26 --echo
27 --echo ## Create test-specific users. The internal tests are triggered when the user connects.
28
29 CREATE USER PFS_TEST_CURRENT_THREAD;
30 CREATE USER PFS_TEST_VALID_GROUP_NAME;
31 CREATE USER PFS_TEST_INVALID_THREAD_ID;
32 CREATE USER PFS_TEST_INVALID_GROUP_NAME;
33 # CREATE USER PFS_DEBUG_MODE;
34 GRANT ALL ON *.* TO PFS_TEST_CURRENT_THREAD;
35 GRANT ALL ON *.* TO PFS_TEST_VALID_GROUP_NAME;
36 GRANT ALL ON *.* TO PFS_TEST_INVALID_THREAD_ID;
37 GRANT ALL ON *.* TO PFS_TEST_INVALID_GROUP_NAME;
38 # GRANT ALL ON *.* TO PFS_DEBUG_MODE;
39
40 --echo
41 --echo ## TEST 1. CURRENT THREAD (INSTRUMENTED)
42 --echo ## PFS_CURRENT_THREAD is the group name for the component connection, set during component initialization.
43 --echo ## This also exercises the THREADS.RESOURCE_GROUP index.
44 --echo
45 SELECT name, type, processlist_user, processlist_host, processlist_db, resource_group
46 FROM performance_schema.threads WHERE resource_group = 'PFS_CURRENT_THREAD';
47
48 --echo
49 --echo ## TEST 2. VALID GROUP NAME
50 --echo ## set_resource_group() with a valid group name
51 --echo ## CONNECT PFS_TEST_VALID_GROUP_NAME
52 connect (con_valid_group_name, localhost, PFS_TEST_VALID_GROUP_NAME, , test);
53
54 #--echo
55 #--echo ## Verify valid group name test result
56 #--echo
57 #SELECT name, type, processlist_user, processlist_host, processlist_db, resource_group
58 #FROM performance_schema.threads WHERE resource_group = 'PFS_VALID_GROUP_NAME';
59
60 --echo
61 --echo ## TEST 3. INVALID THREAD_ID
62 --echo ## Test set_resource_group() with an invalid thread_id
63 --echo ## CONNECT PFS_TEST_INVALID_THREAD_ID
64 connect (con_invalid_thread_id, localhost, PFS_TEST_INVALID_THREAD_ID, , test);
65
66 --echo
67 --echo ## TEST 4. INVALID GROUP NAME
68 --echo ## Test set_resource_group() with an invalid group name
69 --echo ## CONNECT PFS_TEST_INVALID_GROUP_NAME
70 connect (con_invalid_group_name, localhost, PFS_TEST_INVALID_GROUP_NAME, , test);
71
72 --echo ## Disconnect PFS_TEST_VALID_GROUP_NAME
73 --connection con_valid_group_name
74 --disconnect con_valid_group_name
75 --source include/wait_until_disconnected.inc
76
77 --echo ## Disconnect PFS_TEST_INVALID_THREAD_ID
78 --connection con_invalid_thread_id
79 --disconnect con_invalid_thread_id
80 --source include/wait_until_disconnected.inc
81
82 --echo ## Disconnect PFS_TEST_INVALID_GROUP_NAME
83 --connection con_invalid_group_name
84 --disconnect con_invalid_group_name
85 --source include/wait_until_disconnected.inc
86
87 --echo
88 --echo ## Connect default
89 --source include/wait_until_disconnected.inc
90 connection default;
91
92 --echo
93 --echo ## PRINT LOG FILE
94 --echo =========================================
95 let $MYSQLD_DATADIR= `select @@datadir`;
96 #cat_file $MYSQLD_DATADIR/test_pfs_resource_group.log;
97 --echo =========================================
98
99 --echo
100 --echo ## Uninstall component
101 --echo
102 UNINSTALL COMPONENT 'file://component_test_pfs_resource_group';
103 let $wait_condition=SELECT count(*)=0 FROM mysql.component WHERE component_urn like '%component_test_pfs_resource_group';
104 --source include/wait_condition.inc
105
106 --echo
107 --echo ## Clean up
108 --echo
109 DROP USER PFS_TEST_CURRENT_THREAD;
110 DROP USER PFS_TEST_VALID_GROUP_NAME;
111 DROP USER PFS_TEST_INVALID_THREAD_ID;
112 DROP USER PFS_TEST_INVALID_GROUP_NAME;
113
114 remove_file $MYSQLD_DATADIR/test_pfs_resource_group.log;
115
116 --enable_ps_protocol