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