Debian Codegraph @

mysql-test/suite/perfschema/r/service_pfs_resource_group.result

raw
1
2 ## Test the Performance Schema Resource Group service WL#8881
3 ##
4 ## 1. Load component to register callbacks for each API
5 ## 2. Create users to trigger tests within the component
6 ## 3. Write test results to a log file
7 ## 4. Print out log file
8 ##
9 ## Note: The test component sets its own resource group name, PFS_CURRENT_THREAD, for root.
10
11 ## Install test component
12 INSTALL COMPONENT 'file://component_test_pfs_resource_group';
13
14 ## Create test-specific users. The internal tests are triggered when the user connects.
15 CREATE USER PFS_TEST_CURRENT_THREAD;
16 CREATE USER PFS_TEST_VALID_GROUP_NAME;
17 CREATE USER PFS_TEST_INVALID_THREAD_ID;
18 CREATE USER PFS_TEST_INVALID_GROUP_NAME;
19 GRANT ALL ON *.* TO PFS_TEST_CURRENT_THREAD;
20 GRANT ALL ON *.* TO PFS_TEST_VALID_GROUP_NAME;
21 GRANT ALL ON *.* TO PFS_TEST_INVALID_THREAD_ID;
22 GRANT ALL ON *.* TO PFS_TEST_INVALID_GROUP_NAME;
23
24 ## TEST 1. CURRENT THREAD (INSTRUMENTED)
25 ## PFS_CURRENT_THREAD is the group name for the component connection, set during component initialization.
26 ## This also exercises the THREADS.RESOURCE_GROUP index.
27
28 SELECT name, type, processlist_user, processlist_host, processlist_db, resource_group
29 FROM performance_schema.threads WHERE resource_group = 'PFS_CURRENT_THREAD';
30 name type processlist_user processlist_host processlist_db resource_group
31 thread/sql/one_connection FOREGROUND root localhost test PFS_CURRENT_THREAD
32
33 ## TEST 2. VALID GROUP NAME
34 ## set_resource_group() with a valid group name
35 ## CONNECT PFS_TEST_VALID_GROUP_NAME
36
37 ## TEST 3. INVALID THREAD_ID
38 ## Test set_resource_group() with an invalid thread_id
39 ## CONNECT PFS_TEST_INVALID_THREAD_ID
40
41 ## TEST 4. INVALID GROUP NAME
42 ## Test set_resource_group() with an invalid group name
43 ## CONNECT PFS_TEST_INVALID_GROUP_NAME
44 ## Disconnect PFS_TEST_VALID_GROUP_NAME
45 ## Disconnect PFS_TEST_INVALID_THREAD_ID
46 ## Disconnect PFS_TEST_INVALID_GROUP_NAME
47
48 ## Connect default
49
50 ## PRINT LOG FILE
51 =========================================
52 =========================================
53
54 ## Uninstall component
55
56 UNINSTALL COMPONENT 'file://component_test_pfs_resource_group';
57
58 ## Clean up
59
60 DROP USER PFS_TEST_CURRENT_THREAD;
61 DROP USER PFS_TEST_VALID_GROUP_NAME;
62 DROP USER PFS_TEST_INVALID_THREAD_ID;
63 DROP USER PFS_TEST_INVALID_GROUP_NAME;