Debian Codegraph @

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

raw
1 ################# suite/perfschema/t/show_plugin.test ##########################
2 # #
3 # MySQL plugins can define their own status variables and system variables. #
4 # This test exercises SHOW STATUS, SHOW VARIABLES and the status and system #
5 # variable tables while the EXAMPLE plugin is loaded and unloaded. #
6 # #
7 # The EXAMPLE plugin defines the following system and status variables: #
8 # Global system variables: #
9 # example_double_thdvar #
10 # example_double_var #
11 # example_enum_var #
12 # example_ulong_var #
13 # #
14 # Session variables: #
15 # example_double_thdvar - Local and/or global #
16 # #
17 # Global status: #
18 # example_func_example - Status function #
19 # #
20 ################################################################################
21
22 --source include/not_asan_mac.inc
23 --source include/have_example_plugin.inc
24 --source include/have_debug_sync.inc
25
26 --enable_connect_log
27
28 --echo
29 --echo ================================================================================
30 --echo SETUP
31 --echo ================================================================================
32 --echo # Save the initial number of concurrent sessions
33 --source include/count_sessions.inc
34 --echo
35 --echo # Verify EXAMPLE plugin is not loaded
36 SELECT COUNT(*) = 0 AS "Expect 1" FROM information_schema.plugins WHERE plugin_name = "EXAMPLE";
37 --echo
38 --echo # Create one session to force local and global system variables;
39 connect(con0, localhost, root,,);
40 --connection default
41 --echo
42 --echo ================================================================================
43 --echo TEST 1- NO PLUGIN VARS
44 --echo ================================================================================
45 --source ../include/show_plugin_verifier.inc
46 --echo
47
48 --echo ================================================================================
49 --echo TEST 2 - PLUGIN LOAD, UNLOAD, RELOAD
50 --echo ================================================================================
51 --echo ================================================================================
52 --echo 2.1 - INSTALL PLUGIN
53 --echo ================================================================================
54 --replace_regex /\.dll/.so/
55 eval INSTALL PLUGIN example SONAME '$EXAMPLE_PLUGIN';
56
57 --echo
58 --echo ================================================================================
59 --echo 2.1a - FORCE SYNC OF LOCAL AND GLOBAL SYSTEM VARS
60 --echo ================================================================================
61 --source ../include/show_plugin_verifier.inc
62
63 --disconnect con0
64
65 --echo
66 --echo ================================================================================
67 --echo 2.2 - SET PLUGIN VARS
68 --echo ================================================================================
69 --echo # GLOBAL
70 SET GLOBAL example_ulong_var = 100;
71 SET GLOBAL example_enum_var = e1;
72 SET GLOBAL example_double_var = 100.9990;
73 SET GLOBAL example_double_thdvar = 101.9991;
74 --echo # SESSION
75 SET SESSION example_double_thdvar = 102.9992;
76
77 --echo
78 --echo ================================================================================
79 --echo 2.3 - VERIFY UPDATED PLUGIN VARS
80 --echo ================================================================================
81 --source ../include/show_plugin_verifier.inc
82
83 --echo
84 --echo ================================================================================
85 --echo 2.4 - UNINSTALL PLUGIN
86 --echo ================================================================================
87 UNINSTALL PLUGIN example;
88
89 --echo
90 --echo ================================================================================
91 --echo 2.5 - VERIFY NO PLUGIN VARS
92 --echo ================================================================================
93 --source ../include/show_plugin_verifier.inc
94
95 --echo
96 --echo ================================================================================
97 --echo 2.6 - REINSTALL PLUGIN
98 --echo ================================================================================
99 --echo # Reinstall EXAMPLE plugin
100 --replace_regex /\.dll/.so/
101 eval INSTALL PLUGIN example SONAME '$EXAMPLE_PLUGIN';
102
103 --echo
104 --echo ================================================================================
105 --echo 2.7 - SET PLUGIN VARS AGAIN
106 --echo ================================================================================
107 --echo # GLOBAL
108 SET GLOBAL example_ulong_var = 200;
109 SET GLOBAL example_enum_var = e2;
110 SET GLOBAL example_double_var = 200.8880;
111 SET GLOBAL example_double_thdvar = 201.8881;
112 --echo # SESSION
113 SET SESSION example_double_thdvar = 202.8882;
114
115 --echo
116 --echo ================================================================================
117 --echo 2.8 - VERIFY PLUGIN VARS
118 --echo ================================================================================
119 --source ../include/show_plugin_verifier.inc
120
121 --echo
122 --echo ================================================================================
123 --echo 2.9 - UNINSTALL PLUGIN
124 --echo ================================================================================
125 UNINSTALL PLUGIN example;
126
127 --echo
128 --echo ================================================================================
129 --echo 2.10 - VERIFY NO PLUGIN VARS
130 --echo ================================================================================
131 --source ../include/show_plugin_verifier.inc
132
133 --echo
134 --echo ================================================================================
135 --echo TEST 3 - SESSION PLUGIN VARS ON MULTIPLE CONNECTIONS
136 --echo ================================================================================
137 --echo
138 --echo ================================================================================
139 --echo 3.1 - INSTALL PLUGIN
140 --echo ================================================================================
141 --replace_regex /\.dll/.so/
142 eval INSTALL PLUGIN example SONAME '$EXAMPLE_PLUGIN';
143
144 --echo
145 --echo ================================================================================
146 --echo 3.2 - SET GLOBAL AND DEFAULT CONNECTION VARS
147 --echo ================================================================================
148 --connection default
149 SET GLOBAL example_ulong_var = 300;
150 SET GLOBAL example_enum_var = e1;
151 SET GLOBAL example_double_var = 301.0000;
152 SET GLOBAL example_double_thdvar = 302.0000;
153 SET SESSION example_double_thdvar = 300.0000;
154
155 --echo
156 --echo ================================================================================
157 --echo 3.3 - CONNECT 3 CLIENTS, SET LOCAL PLUGIN VARS
158 --echo ================================================================================
159 connect(con1, localhost, root,,);
160 SET SESSION example_double_thdvar = 300.1111;
161 --echo
162 connect(con2, localhost, root,,);
163 SET SESSION example_double_thdvar = 300.2222;
164 --echo
165 connect(con3, localhost, root,,);
166 SET SESSION example_double_thdvar = 300.3333;
167 --echo
168 --connection default
169
170 --echo
171 --echo ================================================================================
172 --echo 3.4 - VERIFY GLOBAL AND SESSION PLUGIN VARS
173 --echo ================================================================================
174 --source ../include/show_plugin_verifier.inc
175 --echo
176 --echo # Variables by thread
177 SELECT variable_name, variable_value FROM performance_schema.variables_by_thread
178 WHERE variable_name LIKE "example_%" ORDER BY variable_name, variable_value;
179
180 --echo
181 --echo ================================================================================
182 --echo 3.5 - DISCONNECT CLIENTS
183 --echo ================================================================================
184 --connection con1
185 --disconnect con1
186 --source include/wait_until_disconnected.inc
187
188 --connection con2
189 --disconnect con2
190 --source include/wait_until_disconnected.inc
191
192 --connection con3
193 --disconnect con3
194 --source include/wait_until_disconnected.inc
195
196 --connection default
197
198 --echo
199 --echo ================================================================================
200 --echo 3.6 - VERIFY SESSION VARS ARE REMOVED
201 --echo ================================================================================
202 --source ../include/show_plugin_verifier.inc
203 --echo
204 --echo # Variables by thread
205 SELECT variable_name, variable_value FROM performance_schema.variables_by_thread
206 WHERE variable_name LIKE "example_%" ORDER BY variable_name, variable_value;
207
208 --echo
209 --echo ================================================================================
210 --echo 3.7 - RECONNECT 3 CLIENTS, SET SESSION VARS FOR EACH
211 --echo ================================================================================
212 connect(con1, localhost, root,,);
213 SET SESSION example_double_thdvar = 311.1111;
214 --echo
215 connect(con2, localhost, root,,);
216 SET SESSION example_double_thdvar = 322.2222;
217 --echo
218 connect(con3, localhost, root,,);
219 SET SESSION example_double_thdvar = 333.3333;
220 --echo
221 --connection default
222
223 --echo
224 --echo ================================================================================
225 --echo 3.8 - VERIFY GLOBAL AND SESSION VARS
226 --echo ================================================================================
227 --source ../include/show_plugin_verifier.inc
228 --echo
229 --echo # Variables by thread
230 SELECT variable_name, variable_value FROM performance_schema.variables_by_thread
231 WHERE variable_name LIKE "example_%" ORDER BY variable_name, variable_value;
232
233 --echo
234 --echo ================================================================================
235 --echo 3.9 - UNINSTALL PLUGIN, LEAVE CLIENTS CONNECTED
236 --echo ================================================================================
237 UNINSTALL PLUGIN example;
238
239 --echo
240 --echo ================================================================================
241 --echo 3.10 - VERIFY SESSION VARS ARE REMOVED
242 --echo ================================================================================
243 --source ../include/show_plugin_verifier.inc
244 --echo
245 --echo # VARIABLES BY THREAD
246 SELECT variable_name, variable_value FROM performance_schema.variables_by_thread
247 WHERE variable_name LIKE "example_%" ORDER BY variable_name, variable_value;
248
249 --echo
250 --echo ================================================================================
251 --echo 3.11 - DISCONNECT CLIENTS
252 --echo ================================================================================
253 --connection con1
254 --disconnect con1
255 --source include/wait_until_disconnected.inc
256
257 --connection con2
258 --disconnect con2
259 --source include/wait_until_disconnected.inc
260
261 --connection con3
262 --disconnect con3
263 --source include/wait_until_disconnected.inc
264
265 --connection default
266
267 --echo
268 --echo ================================================================================
269 --echo 3.12 - VERIFY CLIENTS ARE REMOVED
270 --echo ================================================================================
271 --source ../include/show_plugin_verifier.inc
272 --echo
273 --echo # VARIABLES BY THREAD
274 SELECT variable_name, variable_value FROM performance_schema.variables_by_thread
275 WHERE variable_name LIKE "example_%" ORDER BY variable_name, variable_value;
276
277 --echo
278 --echo ================================================================================
279 --echo TEST 5 - BUG#22225549 MYSQL_CHANGE_USER/MYSQL_RESET_CONNECTION + SET INNODB...
280 --echo Update to plugin-defined session variable triggers resync with global
281 --echo variables and deadlocks on THD::LOCK_thd_sysvar.
282 --echo ================================================================================
283 #
284 # The deadlock occurs when plugin-defined session variables are resynced with the global
285 # variables. To force a resync, change the user and update a session variable from a
286 # plugin, in this case InnoDB.
287 #
288 select @@session.innodb_strict_mode;
289 let $innodb_strict_mode_save = `select @@session.innodb_strict_mode`;
290 select user(), current_user();
291 --echo change_user root
292 --change_user root
293 --echo #
294 --echo # Trigger a resync of session variables with global variables.
295 --echo #
296 set @@session.innodb_strict_mode=off;
297
298 --echo
299 --echo # Restore
300 --echo
301 eval set @@session.innodb_strict_mode=$innodb_strict_mode_save;
302 select @@session.innodb_strict_mode;
303
304 --echo
305 --echo ================================================================================
306 --echo CLEAN UP
307 --echo ================================================================================
308 --connection default
309 --echo
310
311 --echo
312 --disable_connect_log
313
314 --echo
315 --echo # Wait till we reached the initial number of concurrent sessions
316 --source include/wait_until_count_sessions.inc