Debian Codegraph @

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

raw
1 --echo ##
2 --echo ## Test the Performance Schema-based implementation of SHOW PROCESSLIST.
3 --echo ##
4 --echo ## Verify the Host field (hostname:port) against the legacy implementation.
5 --echo ##
6
7 --source include/no_protocol.inc
8 --source include/not_embedded.inc
9
10 --echo
11 --echo ### Setup ###
12 --echo
13 select @@global.performance_schema_show_processlist into @save_processlist;
14
15 --echo
16 --echo # Control user
17 create user user0@localhost;
18 grant ALL on *.* to user0@localhost;
19
20 --echo # Test users
21 --echo
22 create user user1@localhost, user2@localhost,
23 user3@localhost, user4@localhost;
24 --echo
25 # Grant no privileges to user1 to ensure only one process
26 grant USAGE on *.* to user1@localhost;
27 grant ALL on *.* to user2@localhost;
28 grant ALL on *.* to user3@localhost;
29 grant ALL on *.* to user4@localhost;
30 --echo
31 flush privileges;
32 --echo
33 show grants for user1@localhost;
34
35 --echo
36 --echo # Connect (con_user0, 127.0.0.1, user0, , , MASTER_MYPORT, )
37 connect (con_user0, 127.0.0.1, user0, , , $MASTER_MYPORT, );
38 --echo
39 select connection_id() into @con_user0_id;
40
41 --echo # Connect (con_user1, 127.0.0.1, user1, , , MASTER_MYPORT, )
42 connect (con_user1, 127.0.0.1, user1, , , $MASTER_MYPORT, );
43
44 --echo # Connect (con_user2, 127.0.0.1, user2, , , MASTER_MYPORT, )
45 connect (con_user2, 127.0.0.1, user2, , , $MASTER_MYPORT, );
46
47 --echo # Connect (con_user3, 127.0.0.1, user3, , , MASTER_MYPORT, )
48 connect (con_user3, 127.0.0.1, user3, , , $MASTER_MYPORT, );
49
50 --echo # Connect (con_user4, 127.0.0.1, user4, , , MASTER_MYPORT, )
51 connect (con_user4, 127.0.0.1, user4, , , $MASTER_MYPORT, );
52
53 --echo # Connection user0
54 --connection con_user0
55 let $wait_condition = select connection_id() = @con_user0_id;
56 --source include/wait_condition.inc
57
58 --echo
59 --echo ### Compare the SHOW PROCESSLIST Host column between the new and old implementations
60 --echo
61 --echo ## New SHOW PROCESSLIST
62 let $pfs_spl = on;
63 --source ../include/processlist_set.inc
64 --source ../include/processlist_load.inc
65
66 --echo
67 --echo # Connection user1
68 --connection con_user1
69
70 --echo # Get Host:Port, new
71 let $host_new = query_get_value(SHOW FULL PROCESSLIST, Host, 1);
72
73 --echo
74 --echo ## Legacy SHOW PROCESSLIST
75 --connection con_user0
76 let $pfs_spl = off;
77 --source ../include/processlist_set.inc
78 --source ../include/processlist_load.inc
79
80 --echo
81 --echo # Connection user1
82 --connection con_user1
83
84 --echo # Get Host:Port, legacy
85 let $host_old = query_get_value(SHOW FULL PROCESSLIST, Host, 1);
86
87 --echo
88
89 ## DEBUG ONLY
90 ## --echo DEBUG: New: $host_new Old: $host_old
91
92 if ($host_new == $host_old)
93 {
94 --echo ***SUCCESS*** The SHOW PROCESSLIST Host fields match
95 }
96
97 if ($host_new != $host_old)
98 {
99 --echo ***ERROR*** SHOW PROCESSLIST Host fields do not match. New: $host_new Old: $host_old
100 }
101
102 --echo
103 --echo ### Compare the processlist Host column between Performance Schema and the Information Schema
104 --echo
105 --echo # Connection con_user0
106 --connection con_user0
107 let $count_new = `select count(*) from performance_schema.processlist`;
108 let $count_old = `select count(*) from information_schema.processlist`;
109 let $count_join = `select count(*) from performance_schema.processlist pspl
110 left join information_schema.processlist ispl on pspl.host = ispl.host and pspl.id = ispl.id`;
111
112 --echo
113
114 if ($count_old == $count_join)
115 {
116 --echo ***SUCCESS*** The processlist Host fields match between the Performance Schema and the Information Schema
117 }
118
119 if ($count_old != $count_join)
120 {
121 --echo ***ERROR*** The processlist Host fields do not match
122 --echo Count new: $count_new Count old: $count_old Count join: $count_join
123 --echo
124 select * from performance_schema.processlist order by host, id;
125 --echo
126 select * from information_schema.processlist order by host, id;
127 --echo
128 select * from performance_schema.processlist pspl
129 left join information_schema.processlist ispl on pspl.host = ispl.host and pspl.id = ispl.id;
130 }
131
132 --echo
133 --echo
134 --echo ### Clean up ###
135 --echo
136
137 --echo # Disconnect con_user0
138 --connection con_user0
139 --disconnect con_user0
140 --echo # Disconnect con_user1
141 --connection con_user1
142 --disconnect con_user1
143 --echo # Disconnect con_user2
144 --connection con_user2
145 --disconnect con_user2
146 --echo # Disconnect con_user3
147 --connection con_user3
148 --disconnect con_user3
149 --echo # Disconnect con_user4
150 --connection con_user4
151 --disconnect con_user4
152
153 --echo # Connection default
154 --connection default
155 --echo
156 drop user user0@localhost;
157 drop user user1@localhost;
158 drop user user2@localhost;
159 drop user user3@localhost;
160 drop user user4@localhost;
161 --echo
162 set @@global.performance_schema_show_processlist = @save_processlist;