Debian Codegraph @

mysql-test/suite/perfschema/include/memory_aggregate_load.inc

raw
1 # Tests for the performance schema
2
3 # ========================================
4 # HELPER include/memory_aggregate_load.inc
5 # ========================================
6
7 echo "================== Step 1 ==================";
8 --vertical_results
9 call dump_thread();
10 execute dump_memory_account;
11 execute dump_memory_user;
12 execute dump_memory_host;
13 execute dump_memory_global;
14 --horizontal_results
15 execute dump_accounts;
16 execute dump_users;
17 execute dump_hosts;
18
19 # Notes about this test
20 #
21 # get_lock("marker") causes the following memory allocation:
22 # memory/sql/User_level_lock, 1 malloc, size 16 (size 8 for 32-bit systems).
23 # release_lock("marker") causes the following memory free:
24 # memory/sql/User_level_lock, 1 free, size 16 (size 8 for 32-bit systems).
25 #
26 # To avoid noise from main, the background threads are disabled.
27
28 connect (con1, localhost, user1, , );
29
30 echo "================== con1 connected ==================";
31
32 --connection default
33
34 # Wait for the connect to complete
35 let $wait_condition=
36 select count(*) = 1 from performance_schema.threads
37 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user1';
38 --source include/wait_condition.inc
39
40 echo "================== Step 2 ==================";
41 --vertical_results
42 call dump_thread();
43 execute dump_memory_account;
44 execute dump_memory_user;
45 execute dump_memory_host;
46 execute dump_memory_global;
47 --horizontal_results
48 execute dump_accounts;
49 execute dump_users;
50 execute dump_hosts;
51
52 --connection con1
53
54 set GLOBAL query_cache_size=1000*1024;
55 select get_lock("marker_1", 10);
56 select release_lock("marker_1");
57 set @v1 = repeat("a", 1000);
58 set @v2 = repeat("b", 2000);
59 set @v3 = repeat("c", 4000);
60
61 echo "================== con1 marker ==================";
62
63 --connection default
64
65 # Wait for the payload to complete
66 let $wait_condition=
67 select count(*) = 1 from performance_schema.events_waits_current
68 where EVENT_NAME= 'idle';
69 --source include/wait_condition.inc
70
71 echo "================== Step 3 ==================";
72 --vertical_results
73 call dump_thread();
74 execute dump_memory_account;
75 execute dump_memory_user;
76 execute dump_memory_host;
77 execute dump_memory_global;
78 --horizontal_results
79 execute dump_accounts;
80 execute dump_users;
81 execute dump_hosts;
82
83 # Debugging helpers
84 # select * from performance_schema.events_waits_history_long;
85 # select PROCESSLIST_USER, PROCESSLIST_HOST, INSTRUMENTED from performance_schema.threads;
86
87 connect (con2, localhost, user2, , );
88
89 echo "================== con2 connected ==================";
90
91 --connection default
92
93 # Wait for the connect to complete
94 let $wait_condition=
95 select count(*) = 1 from performance_schema.threads
96 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user2';
97 --source include/wait_condition.inc
98
99 echo "================== Step 4 ==================";
100 --vertical_results
101 call dump_thread();
102 execute dump_memory_account;
103 execute dump_memory_user;
104 execute dump_memory_host;
105 execute dump_memory_global;
106 --horizontal_results
107 execute dump_accounts;
108 execute dump_users;
109 execute dump_hosts;
110
111 --connection con2
112
113 set GLOBAL query_cache_size=2000*1024;
114 select get_lock("marker_2", 10);
115 select release_lock("marker_2");
116 set @v1 = repeat("a", 1000);
117 set @v2 = repeat("b", 2000);
118 set @v3 = repeat("c", 4000);
119
120 echo "================== con2 marker ==================";
121
122 --connection default
123
124 # Wait for the payload to complete
125 let $wait_condition=
126 select count(*) = 2 from performance_schema.events_waits_current
127 where EVENT_NAME= 'idle';
128 --source include/wait_condition.inc
129
130 echo "================== Step 5 ==================";
131 --vertical_results
132 call dump_thread();
133 execute dump_memory_account;
134 execute dump_memory_user;
135 execute dump_memory_host;
136 execute dump_memory_global;
137 --horizontal_results
138 execute dump_accounts;
139 execute dump_users;
140 execute dump_hosts;
141
142 truncate table performance_schema.memory_summary_by_thread_by_event_name;
143
144 echo "================== MEMORY_BY_THREAD truncated ==================";
145
146 echo "================== Step 5b ==================";
147 --vertical_results
148 call dump_thread();
149 execute dump_memory_account;
150 execute dump_memory_user;
151 execute dump_memory_host;
152 execute dump_memory_global;
153 --horizontal_results
154 execute dump_accounts;
155 execute dump_users;
156 execute dump_hosts;
157
158 connect (con3, localhost, user3, , );
159
160 echo "================== con3 connected ==================";
161
162 --connection default
163
164 # Wait for the connect to complete
165 let $wait_condition=
166 select count(*) = 1 from performance_schema.threads
167 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user3';
168 --source include/wait_condition.inc
169
170 echo "================== Step 6 ==================";
171 --vertical_results
172 call dump_thread();
173 execute dump_memory_account;
174 execute dump_memory_user;
175 execute dump_memory_host;
176 execute dump_memory_global;
177 --horizontal_results
178 execute dump_accounts;
179 execute dump_users;
180 execute dump_hosts;
181
182 --connection con3
183
184 set GLOBAL query_cache_size=500*1024;
185 select get_lock("marker_3", 10);
186 select release_lock("marker_3");
187 set @v1 = repeat("a", 1000);
188 set @v2 = repeat("b", 2000);
189 set @v3 = repeat("c", 4000);
190
191 echo "================== con3 marker ==================";
192
193 --connection default
194
195 # Wait for the payload to complete
196 let $wait_condition=
197 select count(*) = 3 from performance_schema.events_waits_current
198 where EVENT_NAME= 'idle';
199 --source include/wait_condition.inc
200
201 echo "================== Step 7 ==================";
202 --vertical_results
203 call dump_thread();
204 execute dump_memory_account;
205 execute dump_memory_user;
206 execute dump_memory_host;
207 execute dump_memory_global;
208 --horizontal_results
209 execute dump_accounts;
210 execute dump_users;
211 execute dump_hosts;
212
213 connect (con4, localhost, user4, , );
214 connect (con5, localhost, user4, , );
215
216 echo "================== con4/con5 (both user4) connected ==================";
217
218 --connection default
219
220 # Wait for the connects to complete
221 let $wait_condition=
222 select count(*) = 2 from performance_schema.threads
223 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user4';
224 --source include/wait_condition.inc
225
226 echo "================== Step 8 ==================";
227 --vertical_results
228 call dump_thread();
229 execute dump_memory_account;
230 execute dump_memory_user;
231 execute dump_memory_host;
232 execute dump_memory_global;
233 --horizontal_results
234 execute dump_accounts;
235 execute dump_users;
236 execute dump_hosts;
237
238 --connection con4
239
240 set GLOBAL query_cache_size=4000*1024;
241 select get_lock("marker_4", 10);
242 select release_lock("marker_4");
243 set @v1 = repeat("a", 1000);
244 set @v2 = repeat("b", 2000);
245 set @v3 = repeat("c", 4000);
246
247 --connection con5
248 select get_lock("marker_5", 10);
249 select release_lock("marker_5");
250 set @v1 = repeat("a", 1000);
251 set @v2 = repeat("b", 2000);
252 set @v3 = repeat("c", 4000);
253
254 echo "================== con4/con5 marker ==================";
255
256 --connection default
257
258 # Wait for the payload to complete
259 let $wait_condition=
260 select count(*) = 5 from performance_schema.events_waits_current
261 where EVENT_NAME= 'idle';
262 --source include/wait_condition.inc
263
264 echo "================== Step 9 ==================";
265 --vertical_results
266 call dump_thread();
267 execute dump_memory_account;
268 execute dump_memory_user;
269 execute dump_memory_host;
270 execute dump_memory_global;
271 --horizontal_results
272 execute dump_accounts;
273 execute dump_users;
274 execute dump_hosts;
275
276 --disconnect con1
277
278 --connection default
279
280 # Wait for the disconnects to complete
281 let $wait_condition=
282 select count(*) = 0 from performance_schema.threads
283 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user1';
284 --source include/wait_condition.inc
285
286 --disconnect con5
287 let $wait_condition=
288 select count(*) = 1 from performance_schema.threads
289 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user4';
290 --source include/wait_condition.inc
291
292 echo "================== con1/con5 disconnected ==================";
293
294 echo "================== Step 10 ==================";
295 --vertical_results
296 call dump_thread();
297 execute dump_memory_account;
298 execute dump_memory_user;
299 execute dump_memory_host;
300 execute dump_memory_global;
301 --horizontal_results
302 execute dump_accounts;
303 execute dump_users;
304 execute dump_hosts;
305
306 --disconnect con2
307
308 --connection default
309
310 # Wait for the disconnect to complete
311 let $wait_condition=
312 select count(*) = 0 from performance_schema.threads
313 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user2';
314 --source include/wait_condition.inc
315
316 echo "================== con2 disconnected ==================";
317
318 echo "================== Step 11 ==================";
319 --vertical_results
320 call dump_thread();
321 execute dump_memory_account;
322 execute dump_memory_user;
323 execute dump_memory_host;
324 execute dump_memory_global;
325 --horizontal_results
326 execute dump_accounts;
327 execute dump_users;
328 execute dump_hosts;
329
330 --disconnect con3
331
332 --connection default
333
334 # Wait for the disconnect to complete
335 let $wait_condition=
336 select count(*) = 0 from performance_schema.threads
337 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user3';
338 --source include/wait_condition.inc
339
340 echo "================== con3 disconnected ==================";
341
342 echo "================== Step 12 ==================";
343 --vertical_results
344 call dump_thread();
345 execute dump_memory_account;
346 execute dump_memory_user;
347 execute dump_memory_host;
348 execute dump_memory_global;
349 --horizontal_results
350 execute dump_accounts;
351 execute dump_users;
352 execute dump_hosts;
353
354 --disconnect con4
355
356 --connection default
357
358 # Wait for the disconnect to complete
359 let $wait_condition=
360 select count(*) = 0 from performance_schema.threads
361 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user4';
362 --source include/wait_condition.inc
363
364 echo "================== con4 disconnected ==================";
365
366 echo "================== Step 13 ==================";
367 --vertical_results
368 call dump_thread();
369 execute dump_memory_account;
370 execute dump_memory_user;
371 execute dump_memory_host;
372 execute dump_memory_global;
373 --horizontal_results
374 execute dump_accounts;
375 execute dump_users;
376 execute dump_hosts;
377
378 --connection default
379
380 truncate performance_schema.memory_summary_by_thread_by_event_name;
381
382 echo "================== MEMORY_BY_THREAD truncated ==================";
383
384 echo "================== Step 14 ==================";
385 --vertical_results
386 call dump_thread();
387 execute dump_memory_account;
388 execute dump_memory_user;
389 execute dump_memory_host;
390 execute dump_memory_global;
391 --horizontal_results
392 execute dump_accounts;
393 execute dump_users;
394 execute dump_hosts;
395
396 truncate performance_schema.memory_summary_by_account_by_event_name;
397
398 echo "================== MEMORY_BY_ACCOUNT truncated ==================";
399
400 echo "================== Step 15 ==================";
401 --vertical_results
402 call dump_thread();
403 execute dump_memory_account;
404 execute dump_memory_user;
405 execute dump_memory_host;
406 execute dump_memory_global;
407 --horizontal_results
408 execute dump_accounts;
409 execute dump_users;
410 execute dump_hosts;
411
412 truncate performance_schema.memory_summary_by_user_by_event_name;
413
414 echo "================== MEMORY_BY_USER truncated ==================";
415
416 echo "================== Step 16 ==================";
417 --vertical_results
418 call dump_thread();
419 execute dump_memory_account;
420 execute dump_memory_user;
421 execute dump_memory_host;
422 execute dump_memory_global;
423 --horizontal_results
424 execute dump_accounts;
425 execute dump_users;
426 execute dump_hosts;
427
428 truncate performance_schema.memory_summary_by_host_by_event_name;
429
430 echo "================== MEMORY_BY_HOST truncated ==================";
431
432 echo "================== Step 17 ==================";
433 --vertical_results
434 call dump_thread();
435 execute dump_memory_account;
436 execute dump_memory_user;
437 execute dump_memory_host;
438 execute dump_memory_global;
439 --horizontal_results
440 execute dump_accounts;
441 execute dump_users;
442 execute dump_hosts;
443
444 truncate performance_schema.memory_summary_global_by_event_name;
445
446 echo "================== MEMORY_GLOBAL truncated ==================";
447
448 echo "================== Step 18 ==================";
449 --vertical_results
450 call dump_thread();
451 execute dump_memory_account;
452 execute dump_memory_user;
453 execute dump_memory_host;
454 execute dump_memory_global;
455 --horizontal_results
456 execute dump_accounts;
457 execute dump_users;
458 execute dump_hosts;
459
460 truncate performance_schema.accounts;
461
462 echo "================== ACCOUNTS truncated ==================";
463
464 echo "================== Step 19 ==================";
465 --vertical_results
466 call dump_thread();
467 execute dump_memory_account;
468 execute dump_memory_user;
469 execute dump_memory_host;
470 execute dump_memory_global;
471 --horizontal_results
472 execute dump_accounts;
473 execute dump_users;
474 execute dump_hosts;
475
476 truncate performance_schema.users;
477
478 echo "================== USERS truncated ==================";
479
480 echo "================== Step 20 ==================";
481 --vertical_results
482 call dump_thread();
483 execute dump_memory_account;
484 execute dump_memory_user;
485 execute dump_memory_host;
486 execute dump_memory_global;
487 --horizontal_results
488 execute dump_accounts;
489 execute dump_users;
490 execute dump_hosts;
491
492 truncate performance_schema.hosts;
493
494 echo "================== HOSTS truncated ==================";
495
496 echo "================== Step 21 ==================";
497 --vertical_results
498 call dump_thread();
499 execute dump_memory_account;
500 execute dump_memory_user;
501 execute dump_memory_host;
502 execute dump_memory_global;
503 --horizontal_results
504 execute dump_accounts;
505 execute dump_users;
506 execute dump_hosts;
507