Debian Codegraph @

mysql-test/suite/perfschema/r/memory_aggregate_no_a_no_u.result

raw
1 show global status like "performance_schema_memory_classes_lost";
2 Variable_name Value
3 Performance_schema_memory_classes_lost 0
4 "================== Step 1 =================="
5 call dump_thread();
6 username user1
7 status not found
8 username user2
9 status not found
10 username user3
11 status not found
12 username user4
13 status not found
14 execute dump_memory_account;
15 execute dump_memory_user;
16 execute dump_memory_host;
17 HOST localhost
18 EVENT_NAME memory/sql/user_var_entry::value
19 COUNT_ALLOC 0
20 COUNT_FREE 0
21 SUM_NUMBER_OF_BYTES_ALLOC 0
22 SUM_NUMBER_OF_BYTES_FREE 0
23 LOW_COUNT_USED 0
24 CURRENT_COUNT_USED 0
25 HIGH_COUNT_USED 0
26 LOW_NUMBER_OF_BYTES_USED 0
27 CURRENT_NUMBER_OF_BYTES_USED 0
28 HIGH_NUMBER_OF_BYTES_USED 0
29 execute dump_memory_global;
30 EVENT_NAME memory/sql/user_var_entry::value
31 COUNT_ALLOC 0
32 COUNT_FREE 0
33 SUM_NUMBER_OF_BYTES_ALLOC 0
34 SUM_NUMBER_OF_BYTES_FREE 0
35 LOW_COUNT_USED 0
36 CURRENT_COUNT_USED 0
37 HIGH_COUNT_USED 0
38 LOW_NUMBER_OF_BYTES_USED 0
39 CURRENT_NUMBER_OF_BYTES_USED 0
40 HIGH_NUMBER_OF_BYTES_USED 0
41 execute dump_accounts;
42 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
43 execute dump_users;
44 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
45 execute dump_hosts;
46 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
47 localhost 2 2
48 "================== con1 connected =================="
49 "================== Step 2 =================="
50 call dump_thread();
51 username user1
52 EVENT_NAME memory/sql/user_var_entry::value
53 COUNT_ALLOC 0
54 COUNT_FREE 0
55 SUM_NUMBER_OF_BYTES_ALLOC 0
56 SUM_NUMBER_OF_BYTES_FREE 0
57 LOW_COUNT_USED 0
58 CURRENT_COUNT_USED 0
59 HIGH_COUNT_USED 0
60 LOW_NUMBER_OF_BYTES_USED 0
61 CURRENT_NUMBER_OF_BYTES_USED 0
62 HIGH_NUMBER_OF_BYTES_USED 0
63 username user2
64 status not found
65 username user3
66 status not found
67 username user4
68 status not found
69 execute dump_memory_account;
70 execute dump_memory_user;
71 execute dump_memory_host;
72 HOST localhost
73 EVENT_NAME memory/sql/user_var_entry::value
74 COUNT_ALLOC 0
75 COUNT_FREE 0
76 SUM_NUMBER_OF_BYTES_ALLOC 0
77 SUM_NUMBER_OF_BYTES_FREE 0
78 LOW_COUNT_USED 0
79 CURRENT_COUNT_USED 0
80 HIGH_COUNT_USED 0
81 LOW_NUMBER_OF_BYTES_USED 0
82 CURRENT_NUMBER_OF_BYTES_USED 0
83 HIGH_NUMBER_OF_BYTES_USED 0
84 execute dump_memory_global;
85 EVENT_NAME memory/sql/user_var_entry::value
86 COUNT_ALLOC 0
87 COUNT_FREE 0
88 SUM_NUMBER_OF_BYTES_ALLOC 0
89 SUM_NUMBER_OF_BYTES_FREE 0
90 LOW_COUNT_USED 0
91 CURRENT_COUNT_USED 0
92 HIGH_COUNT_USED 0
93 LOW_NUMBER_OF_BYTES_USED 0
94 CURRENT_NUMBER_OF_BYTES_USED 0
95 HIGH_NUMBER_OF_BYTES_USED 0
96 execute dump_accounts;
97 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
98 execute dump_users;
99 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
100 execute dump_hosts;
101 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
102 localhost 3 3
103 select get_lock("marker_1", 10);
104 get_lock("marker_1", 10)
105 1
106 select release_lock("marker_1");
107 release_lock("marker_1")
108 1
109 set @v1 = repeat("a", 1000);
110 set @v2 = repeat("b", 2000);
111 set @v3 = repeat("c", 4000);
112 "================== con1 marker =================="
113 "================== Step 3 =================="
114 call dump_thread();
115 username user1
116 EVENT_NAME memory/sql/user_var_entry::value
117 COUNT_ALLOC 3
118 COUNT_FREE 0
119 SUM_NUMBER_OF_BYTES_ALLOC 7099
120 SUM_NUMBER_OF_BYTES_FREE 0
121 LOW_COUNT_USED 0
122 CURRENT_COUNT_USED 3
123 HIGH_COUNT_USED 3
124 LOW_NUMBER_OF_BYTES_USED 0
125 CURRENT_NUMBER_OF_BYTES_USED 7099
126 HIGH_NUMBER_OF_BYTES_USED 7099
127 username user2
128 status not found
129 username user3
130 status not found
131 username user4
132 status not found
133 execute dump_memory_account;
134 execute dump_memory_user;
135 execute dump_memory_host;
136 HOST localhost
137 EVENT_NAME memory/sql/user_var_entry::value
138 COUNT_ALLOC 3
139 COUNT_FREE 0
140 SUM_NUMBER_OF_BYTES_ALLOC 7099
141 SUM_NUMBER_OF_BYTES_FREE 0
142 LOW_COUNT_USED 0
143 CURRENT_COUNT_USED 3
144 HIGH_COUNT_USED 3
145 LOW_NUMBER_OF_BYTES_USED 0
146 CURRENT_NUMBER_OF_BYTES_USED 7099
147 HIGH_NUMBER_OF_BYTES_USED 7099
148 execute dump_memory_global;
149 EVENT_NAME memory/sql/user_var_entry::value
150 COUNT_ALLOC 3
151 COUNT_FREE 0
152 SUM_NUMBER_OF_BYTES_ALLOC 7099
153 SUM_NUMBER_OF_BYTES_FREE 0
154 LOW_COUNT_USED 0
155 CURRENT_COUNT_USED 3
156 HIGH_COUNT_USED 3
157 LOW_NUMBER_OF_BYTES_USED 0
158 CURRENT_NUMBER_OF_BYTES_USED 7099
159 HIGH_NUMBER_OF_BYTES_USED 7099
160 execute dump_accounts;
161 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
162 execute dump_users;
163 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
164 execute dump_hosts;
165 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
166 localhost 3 3
167 "================== con2 connected =================="
168 "================== Step 4 =================="
169 call dump_thread();
170 username user1
171 EVENT_NAME memory/sql/user_var_entry::value
172 COUNT_ALLOC 3
173 COUNT_FREE 0
174 SUM_NUMBER_OF_BYTES_ALLOC 7099
175 SUM_NUMBER_OF_BYTES_FREE 0
176 LOW_COUNT_USED 0
177 CURRENT_COUNT_USED 3
178 HIGH_COUNT_USED 3
179 LOW_NUMBER_OF_BYTES_USED 0
180 CURRENT_NUMBER_OF_BYTES_USED 7099
181 HIGH_NUMBER_OF_BYTES_USED 7099
182 username user2
183 EVENT_NAME memory/sql/user_var_entry::value
184 COUNT_ALLOC 0
185 COUNT_FREE 0
186 SUM_NUMBER_OF_BYTES_ALLOC 0
187 SUM_NUMBER_OF_BYTES_FREE 0
188 LOW_COUNT_USED 0
189 CURRENT_COUNT_USED 0
190 HIGH_COUNT_USED 0
191 LOW_NUMBER_OF_BYTES_USED 0
192 CURRENT_NUMBER_OF_BYTES_USED 0
193 HIGH_NUMBER_OF_BYTES_USED 0
194 username user3
195 status not found
196 username user4
197 status not found
198 execute dump_memory_account;
199 execute dump_memory_user;
200 execute dump_memory_host;
201 HOST localhost
202 EVENT_NAME memory/sql/user_var_entry::value
203 COUNT_ALLOC 3
204 COUNT_FREE 0
205 SUM_NUMBER_OF_BYTES_ALLOC 7099
206 SUM_NUMBER_OF_BYTES_FREE 0
207 LOW_COUNT_USED 0
208 CURRENT_COUNT_USED 3
209 HIGH_COUNT_USED 3
210 LOW_NUMBER_OF_BYTES_USED 0
211 CURRENT_NUMBER_OF_BYTES_USED 7099
212 HIGH_NUMBER_OF_BYTES_USED 7099
213 execute dump_memory_global;
214 EVENT_NAME memory/sql/user_var_entry::value
215 COUNT_ALLOC 3
216 COUNT_FREE 0
217 SUM_NUMBER_OF_BYTES_ALLOC 7099
218 SUM_NUMBER_OF_BYTES_FREE 0
219 LOW_COUNT_USED 0
220 CURRENT_COUNT_USED 3
221 HIGH_COUNT_USED 3
222 LOW_NUMBER_OF_BYTES_USED 0
223 CURRENT_NUMBER_OF_BYTES_USED 7099
224 HIGH_NUMBER_OF_BYTES_USED 7099
225 execute dump_accounts;
226 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
227 execute dump_users;
228 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
229 execute dump_hosts;
230 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
231 localhost 4 4
232 select get_lock("marker_2", 10);
233 get_lock("marker_2", 10)
234 1
235 select release_lock("marker_2");
236 release_lock("marker_2")
237 1
238 set @v1 = repeat("a", 1000);
239 set @v2 = repeat("b", 2000);
240 set @v3 = repeat("c", 4000);
241 "================== con2 marker =================="
242 "================== Step 5 =================="
243 call dump_thread();
244 username user1
245 EVENT_NAME memory/sql/user_var_entry::value
246 COUNT_ALLOC 3
247 COUNT_FREE 0
248 SUM_NUMBER_OF_BYTES_ALLOC 7099
249 SUM_NUMBER_OF_BYTES_FREE 0
250 LOW_COUNT_USED 0
251 CURRENT_COUNT_USED 3
252 HIGH_COUNT_USED 3
253 LOW_NUMBER_OF_BYTES_USED 0
254 CURRENT_NUMBER_OF_BYTES_USED 7099
255 HIGH_NUMBER_OF_BYTES_USED 7099
256 username user2
257 EVENT_NAME memory/sql/user_var_entry::value
258 COUNT_ALLOC 3
259 COUNT_FREE 0
260 SUM_NUMBER_OF_BYTES_ALLOC 7099
261 SUM_NUMBER_OF_BYTES_FREE 0
262 LOW_COUNT_USED 0
263 CURRENT_COUNT_USED 3
264 HIGH_COUNT_USED 3
265 LOW_NUMBER_OF_BYTES_USED 0
266 CURRENT_NUMBER_OF_BYTES_USED 7099
267 HIGH_NUMBER_OF_BYTES_USED 7099
268 username user3
269 status not found
270 username user4
271 status not found
272 execute dump_memory_account;
273 execute dump_memory_user;
274 execute dump_memory_host;
275 HOST localhost
276 EVENT_NAME memory/sql/user_var_entry::value
277 COUNT_ALLOC 6
278 COUNT_FREE 0
279 SUM_NUMBER_OF_BYTES_ALLOC 14198
280 SUM_NUMBER_OF_BYTES_FREE 0
281 LOW_COUNT_USED 0
282 CURRENT_COUNT_USED 6
283 HIGH_COUNT_USED 6
284 LOW_NUMBER_OF_BYTES_USED 0
285 CURRENT_NUMBER_OF_BYTES_USED 14198
286 HIGH_NUMBER_OF_BYTES_USED 14198
287 execute dump_memory_global;
288 EVENT_NAME memory/sql/user_var_entry::value
289 COUNT_ALLOC 6
290 COUNT_FREE 0
291 SUM_NUMBER_OF_BYTES_ALLOC 14198
292 SUM_NUMBER_OF_BYTES_FREE 0
293 LOW_COUNT_USED 0
294 CURRENT_COUNT_USED 6
295 HIGH_COUNT_USED 6
296 LOW_NUMBER_OF_BYTES_USED 0
297 CURRENT_NUMBER_OF_BYTES_USED 14198
298 HIGH_NUMBER_OF_BYTES_USED 14198
299 execute dump_accounts;
300 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
301 execute dump_users;
302 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
303 execute dump_hosts;
304 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
305 localhost 4 4
306 truncate table performance_schema.memory_summary_by_thread_by_event_name;
307 "================== MEMORY_BY_THREAD truncated =================="
308 "================== Step 5b =================="
309 call dump_thread();
310 username user1
311 EVENT_NAME memory/sql/user_var_entry::value
312 COUNT_ALLOC 3
313 COUNT_FREE 0
314 SUM_NUMBER_OF_BYTES_ALLOC 7099
315 SUM_NUMBER_OF_BYTES_FREE 0
316 LOW_COUNT_USED 3
317 CURRENT_COUNT_USED 3
318 HIGH_COUNT_USED 3
319 LOW_NUMBER_OF_BYTES_USED 7099
320 CURRENT_NUMBER_OF_BYTES_USED 7099
321 HIGH_NUMBER_OF_BYTES_USED 7099
322 username user2
323 EVENT_NAME memory/sql/user_var_entry::value
324 COUNT_ALLOC 3
325 COUNT_FREE 0
326 SUM_NUMBER_OF_BYTES_ALLOC 7099
327 SUM_NUMBER_OF_BYTES_FREE 0
328 LOW_COUNT_USED 3
329 CURRENT_COUNT_USED 3
330 HIGH_COUNT_USED 3
331 LOW_NUMBER_OF_BYTES_USED 7099
332 CURRENT_NUMBER_OF_BYTES_USED 7099
333 HIGH_NUMBER_OF_BYTES_USED 7099
334 username user3
335 status not found
336 username user4
337 status not found
338 execute dump_memory_account;
339 execute dump_memory_user;
340 execute dump_memory_host;
341 HOST localhost
342 EVENT_NAME memory/sql/user_var_entry::value
343 COUNT_ALLOC 6
344 COUNT_FREE 0
345 SUM_NUMBER_OF_BYTES_ALLOC 14198
346 SUM_NUMBER_OF_BYTES_FREE 0
347 LOW_COUNT_USED 0
348 CURRENT_COUNT_USED 6
349 HIGH_COUNT_USED 6
350 LOW_NUMBER_OF_BYTES_USED 0
351 CURRENT_NUMBER_OF_BYTES_USED 14198
352 HIGH_NUMBER_OF_BYTES_USED 14198
353 execute dump_memory_global;
354 EVENT_NAME memory/sql/user_var_entry::value
355 COUNT_ALLOC 6
356 COUNT_FREE 0
357 SUM_NUMBER_OF_BYTES_ALLOC 14198
358 SUM_NUMBER_OF_BYTES_FREE 0
359 LOW_COUNT_USED 0
360 CURRENT_COUNT_USED 6
361 HIGH_COUNT_USED 6
362 LOW_NUMBER_OF_BYTES_USED 0
363 CURRENT_NUMBER_OF_BYTES_USED 14198
364 HIGH_NUMBER_OF_BYTES_USED 14198
365 execute dump_accounts;
366 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
367 execute dump_users;
368 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
369 execute dump_hosts;
370 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
371 localhost 4 4
372 "================== con3 connected =================="
373 "================== Step 6 =================="
374 call dump_thread();
375 username user1
376 EVENT_NAME memory/sql/user_var_entry::value
377 COUNT_ALLOC 3
378 COUNT_FREE 0
379 SUM_NUMBER_OF_BYTES_ALLOC 7099
380 SUM_NUMBER_OF_BYTES_FREE 0
381 LOW_COUNT_USED 3
382 CURRENT_COUNT_USED 3
383 HIGH_COUNT_USED 3
384 LOW_NUMBER_OF_BYTES_USED 7099
385 CURRENT_NUMBER_OF_BYTES_USED 7099
386 HIGH_NUMBER_OF_BYTES_USED 7099
387 username user2
388 EVENT_NAME memory/sql/user_var_entry::value
389 COUNT_ALLOC 3
390 COUNT_FREE 0
391 SUM_NUMBER_OF_BYTES_ALLOC 7099
392 SUM_NUMBER_OF_BYTES_FREE 0
393 LOW_COUNT_USED 3
394 CURRENT_COUNT_USED 3
395 HIGH_COUNT_USED 3
396 LOW_NUMBER_OF_BYTES_USED 7099
397 CURRENT_NUMBER_OF_BYTES_USED 7099
398 HIGH_NUMBER_OF_BYTES_USED 7099
399 username user3
400 EVENT_NAME memory/sql/user_var_entry::value
401 COUNT_ALLOC 0
402 COUNT_FREE 0
403 SUM_NUMBER_OF_BYTES_ALLOC 0
404 SUM_NUMBER_OF_BYTES_FREE 0
405 LOW_COUNT_USED 0
406 CURRENT_COUNT_USED 0
407 HIGH_COUNT_USED 0
408 LOW_NUMBER_OF_BYTES_USED 0
409 CURRENT_NUMBER_OF_BYTES_USED 0
410 HIGH_NUMBER_OF_BYTES_USED 0
411 username user4
412 status not found
413 execute dump_memory_account;
414 execute dump_memory_user;
415 execute dump_memory_host;
416 HOST localhost
417 EVENT_NAME memory/sql/user_var_entry::value
418 COUNT_ALLOC 6
419 COUNT_FREE 0
420 SUM_NUMBER_OF_BYTES_ALLOC 14198
421 SUM_NUMBER_OF_BYTES_FREE 0
422 LOW_COUNT_USED 0
423 CURRENT_COUNT_USED 6
424 HIGH_COUNT_USED 6
425 LOW_NUMBER_OF_BYTES_USED 0
426 CURRENT_NUMBER_OF_BYTES_USED 14198
427 HIGH_NUMBER_OF_BYTES_USED 14198
428 execute dump_memory_global;
429 EVENT_NAME memory/sql/user_var_entry::value
430 COUNT_ALLOC 6
431 COUNT_FREE 0
432 SUM_NUMBER_OF_BYTES_ALLOC 14198
433 SUM_NUMBER_OF_BYTES_FREE 0
434 LOW_COUNT_USED 0
435 CURRENT_COUNT_USED 6
436 HIGH_COUNT_USED 6
437 LOW_NUMBER_OF_BYTES_USED 0
438 CURRENT_NUMBER_OF_BYTES_USED 14198
439 HIGH_NUMBER_OF_BYTES_USED 14198
440 execute dump_accounts;
441 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
442 execute dump_users;
443 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
444 execute dump_hosts;
445 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
446 localhost 5 5
447 select get_lock("marker_3", 10);
448 get_lock("marker_3", 10)
449 1
450 select release_lock("marker_3");
451 release_lock("marker_3")
452 1
453 set @v1 = repeat("a", 1000);
454 set @v2 = repeat("b", 2000);
455 set @v3 = repeat("c", 4000);
456 "================== con3 marker =================="
457 "================== Step 7 =================="
458 call dump_thread();
459 username user1
460 EVENT_NAME memory/sql/user_var_entry::value
461 COUNT_ALLOC 3
462 COUNT_FREE 0
463 SUM_NUMBER_OF_BYTES_ALLOC 7099
464 SUM_NUMBER_OF_BYTES_FREE 0
465 LOW_COUNT_USED 3
466 CURRENT_COUNT_USED 3
467 HIGH_COUNT_USED 3
468 LOW_NUMBER_OF_BYTES_USED 7099
469 CURRENT_NUMBER_OF_BYTES_USED 7099
470 HIGH_NUMBER_OF_BYTES_USED 7099
471 username user2
472 EVENT_NAME memory/sql/user_var_entry::value
473 COUNT_ALLOC 3
474 COUNT_FREE 0
475 SUM_NUMBER_OF_BYTES_ALLOC 7099
476 SUM_NUMBER_OF_BYTES_FREE 0
477 LOW_COUNT_USED 3
478 CURRENT_COUNT_USED 3
479 HIGH_COUNT_USED 3
480 LOW_NUMBER_OF_BYTES_USED 7099
481 CURRENT_NUMBER_OF_BYTES_USED 7099
482 HIGH_NUMBER_OF_BYTES_USED 7099
483 username user3
484 EVENT_NAME memory/sql/user_var_entry::value
485 COUNT_ALLOC 3
486 COUNT_FREE 0
487 SUM_NUMBER_OF_BYTES_ALLOC 7099
488 SUM_NUMBER_OF_BYTES_FREE 0
489 LOW_COUNT_USED 0
490 CURRENT_COUNT_USED 3
491 HIGH_COUNT_USED 3
492 LOW_NUMBER_OF_BYTES_USED 0
493 CURRENT_NUMBER_OF_BYTES_USED 7099
494 HIGH_NUMBER_OF_BYTES_USED 7099
495 username user4
496 status not found
497 execute dump_memory_account;
498 execute dump_memory_user;
499 execute dump_memory_host;
500 HOST localhost
501 EVENT_NAME memory/sql/user_var_entry::value
502 COUNT_ALLOC 9
503 COUNT_FREE 0
504 SUM_NUMBER_OF_BYTES_ALLOC 21297
505 SUM_NUMBER_OF_BYTES_FREE 0
506 LOW_COUNT_USED 0
507 CURRENT_COUNT_USED 9
508 HIGH_COUNT_USED 9
509 LOW_NUMBER_OF_BYTES_USED 0
510 CURRENT_NUMBER_OF_BYTES_USED 21297
511 HIGH_NUMBER_OF_BYTES_USED 21297
512 execute dump_memory_global;
513 EVENT_NAME memory/sql/user_var_entry::value
514 COUNT_ALLOC 9
515 COUNT_FREE 0
516 SUM_NUMBER_OF_BYTES_ALLOC 21297
517 SUM_NUMBER_OF_BYTES_FREE 0
518 LOW_COUNT_USED 0
519 CURRENT_COUNT_USED 9
520 HIGH_COUNT_USED 9
521 LOW_NUMBER_OF_BYTES_USED 0
522 CURRENT_NUMBER_OF_BYTES_USED 21297
523 HIGH_NUMBER_OF_BYTES_USED 21297
524 execute dump_accounts;
525 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
526 execute dump_users;
527 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
528 execute dump_hosts;
529 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
530 localhost 5 5
531 "================== con4/con5 (both user4) connected =================="
532 "================== Step 8 =================="
533 call dump_thread();
534 username user1
535 EVENT_NAME memory/sql/user_var_entry::value
536 COUNT_ALLOC 3
537 COUNT_FREE 0
538 SUM_NUMBER_OF_BYTES_ALLOC 7099
539 SUM_NUMBER_OF_BYTES_FREE 0
540 LOW_COUNT_USED 3
541 CURRENT_COUNT_USED 3
542 HIGH_COUNT_USED 3
543 LOW_NUMBER_OF_BYTES_USED 7099
544 CURRENT_NUMBER_OF_BYTES_USED 7099
545 HIGH_NUMBER_OF_BYTES_USED 7099
546 username user2
547 EVENT_NAME memory/sql/user_var_entry::value
548 COUNT_ALLOC 3
549 COUNT_FREE 0
550 SUM_NUMBER_OF_BYTES_ALLOC 7099
551 SUM_NUMBER_OF_BYTES_FREE 0
552 LOW_COUNT_USED 3
553 CURRENT_COUNT_USED 3
554 HIGH_COUNT_USED 3
555 LOW_NUMBER_OF_BYTES_USED 7099
556 CURRENT_NUMBER_OF_BYTES_USED 7099
557 HIGH_NUMBER_OF_BYTES_USED 7099
558 username user3
559 EVENT_NAME memory/sql/user_var_entry::value
560 COUNT_ALLOC 3
561 COUNT_FREE 0
562 SUM_NUMBER_OF_BYTES_ALLOC 7099
563 SUM_NUMBER_OF_BYTES_FREE 0
564 LOW_COUNT_USED 0
565 CURRENT_COUNT_USED 3
566 HIGH_COUNT_USED 3
567 LOW_NUMBER_OF_BYTES_USED 0
568 CURRENT_NUMBER_OF_BYTES_USED 7099
569 HIGH_NUMBER_OF_BYTES_USED 7099
570 username user4
571 EVENT_NAME memory/sql/user_var_entry::value
572 COUNT_ALLOC 0
573 COUNT_FREE 0
574 SUM_NUMBER_OF_BYTES_ALLOC 0
575 SUM_NUMBER_OF_BYTES_FREE 0
576 LOW_COUNT_USED 0
577 CURRENT_COUNT_USED 0
578 HIGH_COUNT_USED 0
579 LOW_NUMBER_OF_BYTES_USED 0
580 CURRENT_NUMBER_OF_BYTES_USED 0
581 HIGH_NUMBER_OF_BYTES_USED 0
582 execute dump_memory_account;
583 execute dump_memory_user;
584 execute dump_memory_host;
585 HOST localhost
586 EVENT_NAME memory/sql/user_var_entry::value
587 COUNT_ALLOC 9
588 COUNT_FREE 0
589 SUM_NUMBER_OF_BYTES_ALLOC 21297
590 SUM_NUMBER_OF_BYTES_FREE 0
591 LOW_COUNT_USED 0
592 CURRENT_COUNT_USED 9
593 HIGH_COUNT_USED 9
594 LOW_NUMBER_OF_BYTES_USED 0
595 CURRENT_NUMBER_OF_BYTES_USED 21297
596 HIGH_NUMBER_OF_BYTES_USED 21297
597 execute dump_memory_global;
598 EVENT_NAME memory/sql/user_var_entry::value
599 COUNT_ALLOC 9
600 COUNT_FREE 0
601 SUM_NUMBER_OF_BYTES_ALLOC 21297
602 SUM_NUMBER_OF_BYTES_FREE 0
603 LOW_COUNT_USED 0
604 CURRENT_COUNT_USED 9
605 HIGH_COUNT_USED 9
606 LOW_NUMBER_OF_BYTES_USED 0
607 CURRENT_NUMBER_OF_BYTES_USED 21297
608 HIGH_NUMBER_OF_BYTES_USED 21297
609 execute dump_accounts;
610 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
611 execute dump_users;
612 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
613 execute dump_hosts;
614 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
615 localhost 7 7
616 select get_lock("marker_4", 10);
617 get_lock("marker_4", 10)
618 1
619 select release_lock("marker_4");
620 release_lock("marker_4")
621 1
622 set @v1 = repeat("a", 1000);
623 set @v2 = repeat("b", 2000);
624 set @v3 = repeat("c", 4000);
625 select get_lock("marker_5", 10);
626 get_lock("marker_5", 10)
627 1
628 select release_lock("marker_5");
629 release_lock("marker_5")
630 1
631 set @v1 = repeat("a", 1000);
632 set @v2 = repeat("b", 2000);
633 set @v3 = repeat("c", 4000);
634 "================== con4/con5 marker =================="
635 "================== Step 9 =================="
636 call dump_thread();
637 username user1
638 EVENT_NAME memory/sql/user_var_entry::value
639 COUNT_ALLOC 3
640 COUNT_FREE 0
641 SUM_NUMBER_OF_BYTES_ALLOC 7099
642 SUM_NUMBER_OF_BYTES_FREE 0
643 LOW_COUNT_USED 3
644 CURRENT_COUNT_USED 3
645 HIGH_COUNT_USED 3
646 LOW_NUMBER_OF_BYTES_USED 7099
647 CURRENT_NUMBER_OF_BYTES_USED 7099
648 HIGH_NUMBER_OF_BYTES_USED 7099
649 username user2
650 EVENT_NAME memory/sql/user_var_entry::value
651 COUNT_ALLOC 3
652 COUNT_FREE 0
653 SUM_NUMBER_OF_BYTES_ALLOC 7099
654 SUM_NUMBER_OF_BYTES_FREE 0
655 LOW_COUNT_USED 3
656 CURRENT_COUNT_USED 3
657 HIGH_COUNT_USED 3
658 LOW_NUMBER_OF_BYTES_USED 7099
659 CURRENT_NUMBER_OF_BYTES_USED 7099
660 HIGH_NUMBER_OF_BYTES_USED 7099
661 username user3
662 EVENT_NAME memory/sql/user_var_entry::value
663 COUNT_ALLOC 3
664 COUNT_FREE 0
665 SUM_NUMBER_OF_BYTES_ALLOC 7099
666 SUM_NUMBER_OF_BYTES_FREE 0
667 LOW_COUNT_USED 0
668 CURRENT_COUNT_USED 3
669 HIGH_COUNT_USED 3
670 LOW_NUMBER_OF_BYTES_USED 0
671 CURRENT_NUMBER_OF_BYTES_USED 7099
672 HIGH_NUMBER_OF_BYTES_USED 7099
673 username user4
674 EVENT_NAME memory/sql/user_var_entry::value
675 COUNT_ALLOC 3
676 COUNT_FREE 0
677 SUM_NUMBER_OF_BYTES_ALLOC 7099
678 SUM_NUMBER_OF_BYTES_FREE 0
679 LOW_COUNT_USED 0
680 CURRENT_COUNT_USED 3
681 HIGH_COUNT_USED 3
682 LOW_NUMBER_OF_BYTES_USED 0
683 CURRENT_NUMBER_OF_BYTES_USED 7099
684 HIGH_NUMBER_OF_BYTES_USED 7099
685 execute dump_memory_account;
686 execute dump_memory_user;
687 execute dump_memory_host;
688 HOST localhost
689 EVENT_NAME memory/sql/user_var_entry::value
690 COUNT_ALLOC 15
691 COUNT_FREE 0
692 SUM_NUMBER_OF_BYTES_ALLOC 35495
693 SUM_NUMBER_OF_BYTES_FREE 0
694 LOW_COUNT_USED 0
695 CURRENT_COUNT_USED 15
696 HIGH_COUNT_USED 15
697 LOW_NUMBER_OF_BYTES_USED 0
698 CURRENT_NUMBER_OF_BYTES_USED 35495
699 HIGH_NUMBER_OF_BYTES_USED 35495
700 execute dump_memory_global;
701 EVENT_NAME memory/sql/user_var_entry::value
702 COUNT_ALLOC 15
703 COUNT_FREE 0
704 SUM_NUMBER_OF_BYTES_ALLOC 35495
705 SUM_NUMBER_OF_BYTES_FREE 0
706 LOW_COUNT_USED 0
707 CURRENT_COUNT_USED 15
708 HIGH_COUNT_USED 15
709 LOW_NUMBER_OF_BYTES_USED 0
710 CURRENT_NUMBER_OF_BYTES_USED 35495
711 HIGH_NUMBER_OF_BYTES_USED 35495
712 execute dump_accounts;
713 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
714 execute dump_users;
715 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
716 execute dump_hosts;
717 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
718 localhost 7 7
719 "================== con1/con5 disconnected =================="
720 "================== Step 10 =================="
721 call dump_thread();
722 username user1
723 status not found
724 username user2
725 EVENT_NAME memory/sql/user_var_entry::value
726 COUNT_ALLOC 3
727 COUNT_FREE 0
728 SUM_NUMBER_OF_BYTES_ALLOC 7099
729 SUM_NUMBER_OF_BYTES_FREE 0
730 LOW_COUNT_USED 3
731 CURRENT_COUNT_USED 3
732 HIGH_COUNT_USED 3
733 LOW_NUMBER_OF_BYTES_USED 7099
734 CURRENT_NUMBER_OF_BYTES_USED 7099
735 HIGH_NUMBER_OF_BYTES_USED 7099
736 username user3
737 EVENT_NAME memory/sql/user_var_entry::value
738 COUNT_ALLOC 3
739 COUNT_FREE 0
740 SUM_NUMBER_OF_BYTES_ALLOC 7099
741 SUM_NUMBER_OF_BYTES_FREE 0
742 LOW_COUNT_USED 0
743 CURRENT_COUNT_USED 3
744 HIGH_COUNT_USED 3
745 LOW_NUMBER_OF_BYTES_USED 0
746 CURRENT_NUMBER_OF_BYTES_USED 7099
747 HIGH_NUMBER_OF_BYTES_USED 7099
748 username user4
749 EVENT_NAME memory/sql/user_var_entry::value
750 COUNT_ALLOC 3
751 COUNT_FREE 0
752 SUM_NUMBER_OF_BYTES_ALLOC 7099
753 SUM_NUMBER_OF_BYTES_FREE 0
754 LOW_COUNT_USED 0
755 CURRENT_COUNT_USED 3
756 HIGH_COUNT_USED 3
757 LOW_NUMBER_OF_BYTES_USED 0
758 CURRENT_NUMBER_OF_BYTES_USED 7099
759 HIGH_NUMBER_OF_BYTES_USED 7099
760 execute dump_memory_account;
761 execute dump_memory_user;
762 execute dump_memory_host;
763 HOST localhost
764 EVENT_NAME memory/sql/user_var_entry::value
765 COUNT_ALLOC 15
766 COUNT_FREE 6
767 SUM_NUMBER_OF_BYTES_ALLOC 35495
768 SUM_NUMBER_OF_BYTES_FREE 14198
769 LOW_COUNT_USED 0
770 CURRENT_COUNT_USED 9
771 HIGH_COUNT_USED 15
772 LOW_NUMBER_OF_BYTES_USED 0
773 CURRENT_NUMBER_OF_BYTES_USED 21297
774 HIGH_NUMBER_OF_BYTES_USED 35495
775 execute dump_memory_global;
776 EVENT_NAME memory/sql/user_var_entry::value
777 COUNT_ALLOC 15
778 COUNT_FREE 6
779 SUM_NUMBER_OF_BYTES_ALLOC 35495
780 SUM_NUMBER_OF_BYTES_FREE 14198
781 LOW_COUNT_USED 0
782 CURRENT_COUNT_USED 9
783 HIGH_COUNT_USED 15
784 LOW_NUMBER_OF_BYTES_USED 0
785 CURRENT_NUMBER_OF_BYTES_USED 21297
786 HIGH_NUMBER_OF_BYTES_USED 35495
787 execute dump_accounts;
788 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
789 execute dump_users;
790 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
791 execute dump_hosts;
792 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
793 localhost 5 7
794 "================== con2 disconnected =================="
795 "================== Step 11 =================="
796 call dump_thread();
797 username user1
798 status not found
799 username user2
800 status not found
801 username user3
802 EVENT_NAME memory/sql/user_var_entry::value
803 COUNT_ALLOC 3
804 COUNT_FREE 0
805 SUM_NUMBER_OF_BYTES_ALLOC 7099
806 SUM_NUMBER_OF_BYTES_FREE 0
807 LOW_COUNT_USED 0
808 CURRENT_COUNT_USED 3
809 HIGH_COUNT_USED 3
810 LOW_NUMBER_OF_BYTES_USED 0
811 CURRENT_NUMBER_OF_BYTES_USED 7099
812 HIGH_NUMBER_OF_BYTES_USED 7099
813 username user4
814 EVENT_NAME memory/sql/user_var_entry::value
815 COUNT_ALLOC 3
816 COUNT_FREE 0
817 SUM_NUMBER_OF_BYTES_ALLOC 7099
818 SUM_NUMBER_OF_BYTES_FREE 0
819 LOW_COUNT_USED 0
820 CURRENT_COUNT_USED 3
821 HIGH_COUNT_USED 3
822 LOW_NUMBER_OF_BYTES_USED 0
823 CURRENT_NUMBER_OF_BYTES_USED 7099
824 HIGH_NUMBER_OF_BYTES_USED 7099
825 execute dump_memory_account;
826 execute dump_memory_user;
827 execute dump_memory_host;
828 HOST localhost
829 EVENT_NAME memory/sql/user_var_entry::value
830 COUNT_ALLOC 15
831 COUNT_FREE 9
832 SUM_NUMBER_OF_BYTES_ALLOC 35495
833 SUM_NUMBER_OF_BYTES_FREE 21297
834 LOW_COUNT_USED 0
835 CURRENT_COUNT_USED 6
836 HIGH_COUNT_USED 15
837 LOW_NUMBER_OF_BYTES_USED 0
838 CURRENT_NUMBER_OF_BYTES_USED 14198
839 HIGH_NUMBER_OF_BYTES_USED 35495
840 execute dump_memory_global;
841 EVENT_NAME memory/sql/user_var_entry::value
842 COUNT_ALLOC 15
843 COUNT_FREE 9
844 SUM_NUMBER_OF_BYTES_ALLOC 35495
845 SUM_NUMBER_OF_BYTES_FREE 21297
846 LOW_COUNT_USED 0
847 CURRENT_COUNT_USED 6
848 HIGH_COUNT_USED 15
849 LOW_NUMBER_OF_BYTES_USED 0
850 CURRENT_NUMBER_OF_BYTES_USED 14198
851 HIGH_NUMBER_OF_BYTES_USED 35495
852 execute dump_accounts;
853 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
854 execute dump_users;
855 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
856 execute dump_hosts;
857 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
858 localhost 4 7
859 "================== con3 disconnected =================="
860 "================== Step 12 =================="
861 call dump_thread();
862 username user1
863 status not found
864 username user2
865 status not found
866 username user3
867 status not found
868 username user4
869 EVENT_NAME memory/sql/user_var_entry::value
870 COUNT_ALLOC 3
871 COUNT_FREE 0
872 SUM_NUMBER_OF_BYTES_ALLOC 7099
873 SUM_NUMBER_OF_BYTES_FREE 0
874 LOW_COUNT_USED 0
875 CURRENT_COUNT_USED 3
876 HIGH_COUNT_USED 3
877 LOW_NUMBER_OF_BYTES_USED 0
878 CURRENT_NUMBER_OF_BYTES_USED 7099
879 HIGH_NUMBER_OF_BYTES_USED 7099
880 execute dump_memory_account;
881 execute dump_memory_user;
882 execute dump_memory_host;
883 HOST localhost
884 EVENT_NAME memory/sql/user_var_entry::value
885 COUNT_ALLOC 15
886 COUNT_FREE 12
887 SUM_NUMBER_OF_BYTES_ALLOC 35495
888 SUM_NUMBER_OF_BYTES_FREE 28396
889 LOW_COUNT_USED 0
890 CURRENT_COUNT_USED 3
891 HIGH_COUNT_USED 15
892 LOW_NUMBER_OF_BYTES_USED 0
893 CURRENT_NUMBER_OF_BYTES_USED 7099
894 HIGH_NUMBER_OF_BYTES_USED 35495
895 execute dump_memory_global;
896 EVENT_NAME memory/sql/user_var_entry::value
897 COUNT_ALLOC 15
898 COUNT_FREE 12
899 SUM_NUMBER_OF_BYTES_ALLOC 35495
900 SUM_NUMBER_OF_BYTES_FREE 28396
901 LOW_COUNT_USED 0
902 CURRENT_COUNT_USED 3
903 HIGH_COUNT_USED 15
904 LOW_NUMBER_OF_BYTES_USED 0
905 CURRENT_NUMBER_OF_BYTES_USED 7099
906 HIGH_NUMBER_OF_BYTES_USED 35495
907 execute dump_accounts;
908 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
909 execute dump_users;
910 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
911 execute dump_hosts;
912 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
913 localhost 3 7
914 "================== con4 disconnected =================="
915 "================== Step 13 =================="
916 call dump_thread();
917 username user1
918 status not found
919 username user2
920 status not found
921 username user3
922 status not found
923 username user4
924 status not found
925 execute dump_memory_account;
926 execute dump_memory_user;
927 execute dump_memory_host;
928 HOST localhost
929 EVENT_NAME memory/sql/user_var_entry::value
930 COUNT_ALLOC 15
931 COUNT_FREE 15
932 SUM_NUMBER_OF_BYTES_ALLOC 35495
933 SUM_NUMBER_OF_BYTES_FREE 35495
934 LOW_COUNT_USED 0
935 CURRENT_COUNT_USED 0
936 HIGH_COUNT_USED 15
937 LOW_NUMBER_OF_BYTES_USED 0
938 CURRENT_NUMBER_OF_BYTES_USED 0
939 HIGH_NUMBER_OF_BYTES_USED 35495
940 execute dump_memory_global;
941 EVENT_NAME memory/sql/user_var_entry::value
942 COUNT_ALLOC 15
943 COUNT_FREE 15
944 SUM_NUMBER_OF_BYTES_ALLOC 35495
945 SUM_NUMBER_OF_BYTES_FREE 35495
946 LOW_COUNT_USED 0
947 CURRENT_COUNT_USED 0
948 HIGH_COUNT_USED 15
949 LOW_NUMBER_OF_BYTES_USED 0
950 CURRENT_NUMBER_OF_BYTES_USED 0
951 HIGH_NUMBER_OF_BYTES_USED 35495
952 execute dump_accounts;
953 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
954 execute dump_users;
955 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
956 execute dump_hosts;
957 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
958 localhost 2 7
959 truncate performance_schema.memory_summary_by_thread_by_event_name;
960 "================== MEMORY_BY_THREAD truncated =================="
961 "================== Step 14 =================="
962 call dump_thread();
963 username user1
964 status not found
965 username user2
966 status not found
967 username user3
968 status not found
969 username user4
970 status not found
971 execute dump_memory_account;
972 execute dump_memory_user;
973 execute dump_memory_host;
974 HOST localhost
975 EVENT_NAME memory/sql/user_var_entry::value
976 COUNT_ALLOC 15
977 COUNT_FREE 15
978 SUM_NUMBER_OF_BYTES_ALLOC 35495
979 SUM_NUMBER_OF_BYTES_FREE 35495
980 LOW_COUNT_USED 0
981 CURRENT_COUNT_USED 0
982 HIGH_COUNT_USED 15
983 LOW_NUMBER_OF_BYTES_USED 0
984 CURRENT_NUMBER_OF_BYTES_USED 0
985 HIGH_NUMBER_OF_BYTES_USED 35495
986 execute dump_memory_global;
987 EVENT_NAME memory/sql/user_var_entry::value
988 COUNT_ALLOC 15
989 COUNT_FREE 15
990 SUM_NUMBER_OF_BYTES_ALLOC 35495
991 SUM_NUMBER_OF_BYTES_FREE 35495
992 LOW_COUNT_USED 0
993 CURRENT_COUNT_USED 0
994 HIGH_COUNT_USED 15
995 LOW_NUMBER_OF_BYTES_USED 0
996 CURRENT_NUMBER_OF_BYTES_USED 0
997 HIGH_NUMBER_OF_BYTES_USED 35495
998 execute dump_accounts;
999 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1000 execute dump_users;
1001 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1002 execute dump_hosts;
1003 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1004 localhost 2 7
1005 truncate performance_schema.memory_summary_by_account_by_event_name;
1006 "================== MEMORY_BY_ACCOUNT truncated =================="
1007 "================== Step 15 =================="
1008 call dump_thread();
1009 username user1
1010 status not found
1011 username user2
1012 status not found
1013 username user3
1014 status not found
1015 username user4
1016 status not found
1017 execute dump_memory_account;
1018 execute dump_memory_user;
1019 execute dump_memory_host;
1020 HOST localhost
1021 EVENT_NAME memory/sql/user_var_entry::value
1022 COUNT_ALLOC 15
1023 COUNT_FREE 15
1024 SUM_NUMBER_OF_BYTES_ALLOC 35495
1025 SUM_NUMBER_OF_BYTES_FREE 35495
1026 LOW_COUNT_USED 0
1027 CURRENT_COUNT_USED 0
1028 HIGH_COUNT_USED 15
1029 LOW_NUMBER_OF_BYTES_USED 0
1030 CURRENT_NUMBER_OF_BYTES_USED 0
1031 HIGH_NUMBER_OF_BYTES_USED 35495
1032 execute dump_memory_global;
1033 EVENT_NAME memory/sql/user_var_entry::value
1034 COUNT_ALLOC 15
1035 COUNT_FREE 15
1036 SUM_NUMBER_OF_BYTES_ALLOC 35495
1037 SUM_NUMBER_OF_BYTES_FREE 35495
1038 LOW_COUNT_USED 0
1039 CURRENT_COUNT_USED 0
1040 HIGH_COUNT_USED 15
1041 LOW_NUMBER_OF_BYTES_USED 0
1042 CURRENT_NUMBER_OF_BYTES_USED 0
1043 HIGH_NUMBER_OF_BYTES_USED 35495
1044 execute dump_accounts;
1045 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1046 execute dump_users;
1047 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1048 execute dump_hosts;
1049 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1050 localhost 2 7
1051 truncate performance_schema.memory_summary_by_user_by_event_name;
1052 "================== MEMORY_BY_USER truncated =================="
1053 "================== Step 16 =================="
1054 call dump_thread();
1055 username user1
1056 status not found
1057 username user2
1058 status not found
1059 username user3
1060 status not found
1061 username user4
1062 status not found
1063 execute dump_memory_account;
1064 execute dump_memory_user;
1065 execute dump_memory_host;
1066 HOST localhost
1067 EVENT_NAME memory/sql/user_var_entry::value
1068 COUNT_ALLOC 15
1069 COUNT_FREE 15
1070 SUM_NUMBER_OF_BYTES_ALLOC 35495
1071 SUM_NUMBER_OF_BYTES_FREE 35495
1072 LOW_COUNT_USED 0
1073 CURRENT_COUNT_USED 0
1074 HIGH_COUNT_USED 15
1075 LOW_NUMBER_OF_BYTES_USED 0
1076 CURRENT_NUMBER_OF_BYTES_USED 0
1077 HIGH_NUMBER_OF_BYTES_USED 35495
1078 execute dump_memory_global;
1079 EVENT_NAME memory/sql/user_var_entry::value
1080 COUNT_ALLOC 15
1081 COUNT_FREE 15
1082 SUM_NUMBER_OF_BYTES_ALLOC 35495
1083 SUM_NUMBER_OF_BYTES_FREE 35495
1084 LOW_COUNT_USED 0
1085 CURRENT_COUNT_USED 0
1086 HIGH_COUNT_USED 15
1087 LOW_NUMBER_OF_BYTES_USED 0
1088 CURRENT_NUMBER_OF_BYTES_USED 0
1089 HIGH_NUMBER_OF_BYTES_USED 35495
1090 execute dump_accounts;
1091 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1092 execute dump_users;
1093 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1094 execute dump_hosts;
1095 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1096 localhost 2 7
1097 truncate performance_schema.memory_summary_by_host_by_event_name;
1098 "================== MEMORY_BY_HOST truncated =================="
1099 "================== Step 17 =================="
1100 call dump_thread();
1101 username user1
1102 status not found
1103 username user2
1104 status not found
1105 username user3
1106 status not found
1107 username user4
1108 status not found
1109 execute dump_memory_account;
1110 execute dump_memory_user;
1111 execute dump_memory_host;
1112 HOST localhost
1113 EVENT_NAME memory/sql/user_var_entry::value
1114 COUNT_ALLOC 0
1115 COUNT_FREE 0
1116 SUM_NUMBER_OF_BYTES_ALLOC 0
1117 SUM_NUMBER_OF_BYTES_FREE 0
1118 LOW_COUNT_USED 0
1119 CURRENT_COUNT_USED 0
1120 HIGH_COUNT_USED 0
1121 LOW_NUMBER_OF_BYTES_USED 0
1122 CURRENT_NUMBER_OF_BYTES_USED 0
1123 HIGH_NUMBER_OF_BYTES_USED 0
1124 execute dump_memory_global;
1125 EVENT_NAME memory/sql/user_var_entry::value
1126 COUNT_ALLOC 15
1127 COUNT_FREE 15
1128 SUM_NUMBER_OF_BYTES_ALLOC 35495
1129 SUM_NUMBER_OF_BYTES_FREE 35495
1130 LOW_COUNT_USED 0
1131 CURRENT_COUNT_USED 0
1132 HIGH_COUNT_USED 15
1133 LOW_NUMBER_OF_BYTES_USED 0
1134 CURRENT_NUMBER_OF_BYTES_USED 0
1135 HIGH_NUMBER_OF_BYTES_USED 35495
1136 execute dump_accounts;
1137 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1138 execute dump_users;
1139 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1140 execute dump_hosts;
1141 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1142 localhost 2 7
1143 truncate performance_schema.memory_summary_global_by_event_name;
1144 "================== MEMORY_GLOBAL truncated =================="
1145 "================== Step 18 =================="
1146 call dump_thread();
1147 username user1
1148 status not found
1149 username user2
1150 status not found
1151 username user3
1152 status not found
1153 username user4
1154 status not found
1155 execute dump_memory_account;
1156 execute dump_memory_user;
1157 execute dump_memory_host;
1158 HOST localhost
1159 EVENT_NAME memory/sql/user_var_entry::value
1160 COUNT_ALLOC 0
1161 COUNT_FREE 0
1162 SUM_NUMBER_OF_BYTES_ALLOC 0
1163 SUM_NUMBER_OF_BYTES_FREE 0
1164 LOW_COUNT_USED 0
1165 CURRENT_COUNT_USED 0
1166 HIGH_COUNT_USED 0
1167 LOW_NUMBER_OF_BYTES_USED 0
1168 CURRENT_NUMBER_OF_BYTES_USED 0
1169 HIGH_NUMBER_OF_BYTES_USED 0
1170 execute dump_memory_global;
1171 EVENT_NAME memory/sql/user_var_entry::value
1172 COUNT_ALLOC 0
1173 COUNT_FREE 0
1174 SUM_NUMBER_OF_BYTES_ALLOC 0
1175 SUM_NUMBER_OF_BYTES_FREE 0
1176 LOW_COUNT_USED 0
1177 CURRENT_COUNT_USED 0
1178 HIGH_COUNT_USED 0
1179 LOW_NUMBER_OF_BYTES_USED 0
1180 CURRENT_NUMBER_OF_BYTES_USED 0
1181 HIGH_NUMBER_OF_BYTES_USED 0
1182 execute dump_accounts;
1183 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1184 execute dump_users;
1185 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1186 execute dump_hosts;
1187 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1188 localhost 2 7
1189 truncate performance_schema.accounts;
1190 "================== ACCOUNTS truncated =================="
1191 "================== Step 19 =================="
1192 call dump_thread();
1193 username user1
1194 status not found
1195 username user2
1196 status not found
1197 username user3
1198 status not found
1199 username user4
1200 status not found
1201 execute dump_memory_account;
1202 execute dump_memory_user;
1203 execute dump_memory_host;
1204 HOST localhost
1205 EVENT_NAME memory/sql/user_var_entry::value
1206 COUNT_ALLOC 0
1207 COUNT_FREE 0
1208 SUM_NUMBER_OF_BYTES_ALLOC 0
1209 SUM_NUMBER_OF_BYTES_FREE 0
1210 LOW_COUNT_USED 0
1211 CURRENT_COUNT_USED 0
1212 HIGH_COUNT_USED 0
1213 LOW_NUMBER_OF_BYTES_USED 0
1214 CURRENT_NUMBER_OF_BYTES_USED 0
1215 HIGH_NUMBER_OF_BYTES_USED 0
1216 execute dump_memory_global;
1217 EVENT_NAME memory/sql/user_var_entry::value
1218 COUNT_ALLOC 0
1219 COUNT_FREE 0
1220 SUM_NUMBER_OF_BYTES_ALLOC 0
1221 SUM_NUMBER_OF_BYTES_FREE 0
1222 LOW_COUNT_USED 0
1223 CURRENT_COUNT_USED 0
1224 HIGH_COUNT_USED 0
1225 LOW_NUMBER_OF_BYTES_USED 0
1226 CURRENT_NUMBER_OF_BYTES_USED 0
1227 HIGH_NUMBER_OF_BYTES_USED 0
1228 execute dump_accounts;
1229 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1230 execute dump_users;
1231 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1232 execute dump_hosts;
1233 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1234 localhost 2 7
1235 truncate performance_schema.users;
1236 "================== USERS truncated =================="
1237 "================== Step 20 =================="
1238 call dump_thread();
1239 username user1
1240 status not found
1241 username user2
1242 status not found
1243 username user3
1244 status not found
1245 username user4
1246 status not found
1247 execute dump_memory_account;
1248 execute dump_memory_user;
1249 execute dump_memory_host;
1250 HOST localhost
1251 EVENT_NAME memory/sql/user_var_entry::value
1252 COUNT_ALLOC 0
1253 COUNT_FREE 0
1254 SUM_NUMBER_OF_BYTES_ALLOC 0
1255 SUM_NUMBER_OF_BYTES_FREE 0
1256 LOW_COUNT_USED 0
1257 CURRENT_COUNT_USED 0
1258 HIGH_COUNT_USED 0
1259 LOW_NUMBER_OF_BYTES_USED 0
1260 CURRENT_NUMBER_OF_BYTES_USED 0
1261 HIGH_NUMBER_OF_BYTES_USED 0
1262 execute dump_memory_global;
1263 EVENT_NAME memory/sql/user_var_entry::value
1264 COUNT_ALLOC 0
1265 COUNT_FREE 0
1266 SUM_NUMBER_OF_BYTES_ALLOC 0
1267 SUM_NUMBER_OF_BYTES_FREE 0
1268 LOW_COUNT_USED 0
1269 CURRENT_COUNT_USED 0
1270 HIGH_COUNT_USED 0
1271 LOW_NUMBER_OF_BYTES_USED 0
1272 CURRENT_NUMBER_OF_BYTES_USED 0
1273 HIGH_NUMBER_OF_BYTES_USED 0
1274 execute dump_accounts;
1275 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1276 execute dump_users;
1277 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1278 execute dump_hosts;
1279 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1280 localhost 2 7
1281 truncate performance_schema.hosts;
1282 "================== HOSTS truncated =================="
1283 "================== Step 21 =================="
1284 call dump_thread();
1285 username user1
1286 status not found
1287 username user2
1288 status not found
1289 username user3
1290 status not found
1291 username user4
1292 status not found
1293 execute dump_memory_account;
1294 execute dump_memory_user;
1295 execute dump_memory_host;
1296 HOST localhost
1297 EVENT_NAME memory/sql/user_var_entry::value
1298 COUNT_ALLOC 0
1299 COUNT_FREE 0
1300 SUM_NUMBER_OF_BYTES_ALLOC 0
1301 SUM_NUMBER_OF_BYTES_FREE 0
1302 LOW_COUNT_USED 0
1303 CURRENT_COUNT_USED 0
1304 HIGH_COUNT_USED 0
1305 LOW_NUMBER_OF_BYTES_USED 0
1306 CURRENT_NUMBER_OF_BYTES_USED 0
1307 HIGH_NUMBER_OF_BYTES_USED 0
1308 execute dump_memory_global;
1309 EVENT_NAME memory/sql/user_var_entry::value
1310 COUNT_ALLOC 0
1311 COUNT_FREE 0
1312 SUM_NUMBER_OF_BYTES_ALLOC 0
1313 SUM_NUMBER_OF_BYTES_FREE 0
1314 LOW_COUNT_USED 0
1315 CURRENT_COUNT_USED 0
1316 HIGH_COUNT_USED 0
1317 LOW_NUMBER_OF_BYTES_USED 0
1318 CURRENT_NUMBER_OF_BYTES_USED 0
1319 HIGH_NUMBER_OF_BYTES_USED 0
1320 execute dump_accounts;
1321 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1322 execute dump_users;
1323 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1324 execute dump_hosts;
1325 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1326 localhost 2 2