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/have_perfschema.inc
23 --source include/not_embedded.inc
24 --source include/not_windows_embedded.inc
25 --source include/have_example_plugin.inc
26 --source include/have_innodb.inc
27 --source include/have_debug_sync.inc
28
29 --enable_connect_log
30
31 --echo #
32 --echo # ================================================================================
33 --echo # SETUP
34 --echo # ================================================================================
35 --echo # Save the initial number of concurrent sessions
36 --source include/count_sessions.inc
37 --echo #
38 --echo # Verify EXAMPLE plugin is not loaded
39 SELECT COUNT(*) = 0 AS "Expect 1" FROM information_schema.plugins WHERE plugin_name = "EXAMPLE";
40 --echo #
41 --echo # Create one session to force local and global system variables
42 --connect(con0, localhost, root,,)
43 --connection default
44 --echo #
45 --echo # ================================================================================
46 --echo # TEST 1- NO PLUGIN VARS
47 --echo # ================================================================================
48 --source ../include/show_plugin_verifier.inc
49 --echo #
50
51 --echo # ================================================================================
52 --echo # TEST 2 - PLUGIN LOAD, UNLOAD, RELOAD
53 --echo # ================================================================================
54 --echo # ================================================================================
55 --echo # 2.1 - INSTALL PLUGIN
56 --echo # ================================================================================
57 INSTALL PLUGIN example SONAME 'ha_example';
58
59 --echo #
60 --echo # ================================================================================
61 --echo # 2.1a - FORCE SYNC OF LOCAL AND GLOBAL SYSTEM VARS
62 --echo # ================================================================================
63 --source ../include/show_plugin_verifier.inc
64
65 --disconnect con0
66
67 --echo #
68 --echo # ================================================================================
69 --echo # 2.2 - SET PLUGIN VARS
70 --echo # ================================================================================
71 --echo # GLOBAL
72 SET GLOBAL example_ulong_var = 100;
73 SET GLOBAL example_enum_var = e1;
74 SET GLOBAL example_double_var = 100.9990;
75 SET GLOBAL example_double_thdvar = 101.9991;
76 --echo # SESSION
77 SET SESSION example_double_thdvar = 102.9992;
78
79 --echo #
80 --echo # ================================================================================
81 --echo # 2.3 - VERIFY UPDATED PLUGIN VARS
82 --echo # ================================================================================
83 --source ../include/show_plugin_verifier.inc
84
85 --echo #
86 --echo # ================================================================================
87 --echo # 2.4 - UNINSTALL PLUGIN
88 --echo # ================================================================================
89 UNINSTALL PLUGIN example;
90
91 --echo #
92 --echo # ================================================================================
93 --echo # 2.5 - VERIFY NO PLUGIN VARS
94 --echo # ================================================================================
95 --source ../include/show_plugin_verifier.inc
96
97 --echo #
98 --echo # ================================================================================
99 --echo # 2.6 - REINSTALL PLUGIN
100 --echo # ================================================================================
101 --echo # Reinstall EXAMPLE plugin
102 INSTALL PLUGIN example SONAME 'ha_example';
103
104 --echo #
105 --echo # ================================================================================
106 --echo # 2.7 - SET PLUGIN VARS AGAIN
107 --echo # ================================================================================
108 --echo # GLOBAL
109 SET GLOBAL example_ulong_var = 200;
110 SET GLOBAL example_enum_var = e2;
111 SET GLOBAL example_double_var = 200.8880;
112 SET GLOBAL example_double_thdvar = 201.8881;
113 --echo # SESSION
114 SET SESSION example_double_thdvar = 202.8882;
115
116 --echo #
117 --echo # ================================================================================
118 --echo # 2.8 - VERIFY PLUGIN VARS
119 --echo # ================================================================================
120 --source ../include/show_plugin_verifier.inc
121
122 --echo #
123 --echo # ================================================================================
124 --echo # 2.9 - UNINSTALL PLUGIN
125 --echo # ================================================================================
126 UNINSTALL PLUGIN example;
127
128 --echo #
129 --echo # ================================================================================
130 --echo # 2.10 - VERIFY NO PLUGIN VARS
131 --echo # ================================================================================
132 --source ../include/show_plugin_verifier.inc
133
134 --echo #
135 --echo # ================================================================================
136 --echo # TEST 3 - SESSION PLUGIN VARS ON MULTIPLE CONNECTIONS
137 --echo # ================================================================================
138 --echo #
139 --echo # ================================================================================
140 --echo # 3.1 - INSTALL PLUGIN
141 --echo # ================================================================================
142 INSTALL PLUGIN example SONAME 'ha_example';
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_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_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_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_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_value;
276
277 --echo #
278 --echo # ================================================================================
279 --echo # TEST 4 - BUG#18008907: DEADLOCK WITH CHANGE_USER, SHOW VARIABLES, INSTALL PLUGIN
280 --echo # ================================================================================
281 --echo #
282 --echo #
283 --echo # ================================================================================
284 --echo # TEST 5 - BUG#22225549 MYSQL_CHANGE_USER/MYSQL_RESET_CONNECTION + SET INNODB...
285 --echo Update to plugin-defined session variable triggers resync with global
286 --echo variables and deadlocks on THD::LOCK_thd_sysvar.
287 --echo # ================================================================================
288 #
289 # The deadlock occurs when plugin-defined session variables are resynced with the global
290 # variables. To force a resync, change the user and update a session variable from a
291 # plugin, in this case InnoDB.
292 #
293 select @@session.innodb_strict_mode;
294 let $innodb_strict_mode_save = `select @@session.innodb_strict_mode`;
295 select user(), current_user();
296 --echo # change_user root
297 --change_user root
298 --echo #
299 --echo # Trigger a resync of session variables with global variables.
300 --echo #
301 set @@session.innodb_strict_mode=off;
302
303 --echo #
304 --echo # Restore
305 --echo #
306 eval set @@session.innodb_strict_mode=$innodb_strict_mode_save;
307 select @@session.innodb_strict_mode;
308
309 --echo #
310 --echo # ================================================================================
311 --echo # CLEAN UP
312 --echo # ================================================================================
313 --connection default
314 --echo #
315
316 --echo #
317 --disable_connect_log
318
319 --echo #
320 --echo # Wait till we reached the initial number of concurrent sessions
321 --source include/wait_until_count_sessions.inc