Debian Codegraph @

mysql-test/suite/perfschema/r/memory_aggregate_32bit.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 event_scheduler localhost 1 1
44 root localhost 1 1
45 execute dump_users;
46 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
47 event_scheduler 1 1
48 root 1 1
49 execute dump_hosts;
50 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
51 localhost 2 2
52 "================== con1 connected =================="
53 "================== Step 2 =================="
54 call dump_thread();
55 username user1
56 EVENT_NAME memory/sql/user_var_entry::value
57 COUNT_ALLOC 0
58 COUNT_FREE 0
59 SUM_NUMBER_OF_BYTES_ALLOC 0
60 SUM_NUMBER_OF_BYTES_FREE 0
61 LOW_COUNT_USED 0
62 CURRENT_COUNT_USED 0
63 HIGH_COUNT_USED 0
64 LOW_NUMBER_OF_BYTES_USED 0
65 CURRENT_NUMBER_OF_BYTES_USED 0
66 HIGH_NUMBER_OF_BYTES_USED 0
67 username user2
68 status not found
69 username user3
70 status not found
71 username user4
72 status not found
73 execute dump_memory_account;
74 USER user1
75 HOST localhost
76 EVENT_NAME memory/sql/user_var_entry::value
77 COUNT_ALLOC 0
78 COUNT_FREE 0
79 SUM_NUMBER_OF_BYTES_ALLOC 0
80 SUM_NUMBER_OF_BYTES_FREE 0
81 LOW_COUNT_USED 0
82 CURRENT_COUNT_USED 0
83 HIGH_COUNT_USED 0
84 LOW_NUMBER_OF_BYTES_USED 0
85 CURRENT_NUMBER_OF_BYTES_USED 0
86 HIGH_NUMBER_OF_BYTES_USED 0
87 execute dump_memory_user;
88 USER user1
89 EVENT_NAME memory/sql/user_var_entry::value
90 COUNT_ALLOC 0
91 COUNT_FREE 0
92 SUM_NUMBER_OF_BYTES_ALLOC 0
93 SUM_NUMBER_OF_BYTES_FREE 0
94 LOW_COUNT_USED 0
95 CURRENT_COUNT_USED 0
96 HIGH_COUNT_USED 0
97 LOW_NUMBER_OF_BYTES_USED 0
98 CURRENT_NUMBER_OF_BYTES_USED 0
99 HIGH_NUMBER_OF_BYTES_USED 0
100 execute dump_memory_host;
101 HOST localhost
102 EVENT_NAME memory/sql/user_var_entry::value
103 COUNT_ALLOC 0
104 COUNT_FREE 0
105 SUM_NUMBER_OF_BYTES_ALLOC 0
106 SUM_NUMBER_OF_BYTES_FREE 0
107 LOW_COUNT_USED 0
108 CURRENT_COUNT_USED 0
109 HIGH_COUNT_USED 0
110 LOW_NUMBER_OF_BYTES_USED 0
111 CURRENT_NUMBER_OF_BYTES_USED 0
112 HIGH_NUMBER_OF_BYTES_USED 0
113 execute dump_memory_global;
114 EVENT_NAME memory/sql/user_var_entry::value
115 COUNT_ALLOC 0
116 COUNT_FREE 0
117 SUM_NUMBER_OF_BYTES_ALLOC 0
118 SUM_NUMBER_OF_BYTES_FREE 0
119 LOW_COUNT_USED 0
120 CURRENT_COUNT_USED 0
121 HIGH_COUNT_USED 0
122 LOW_NUMBER_OF_BYTES_USED 0
123 CURRENT_NUMBER_OF_BYTES_USED 0
124 HIGH_NUMBER_OF_BYTES_USED 0
125 execute dump_accounts;
126 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
127 event_scheduler localhost 1 1
128 root localhost 1 1
129 user1 localhost 1 1
130 execute dump_users;
131 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
132 event_scheduler 1 1
133 root 1 1
134 user1 1 1
135 execute dump_hosts;
136 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
137 localhost 3 3
138 select get_lock("marker_1", 10);
139 get_lock("marker_1", 10)
140 1
141 select release_lock("marker_1");
142 release_lock("marker_1")
143 1
144 set @v1 = repeat("a", 1000);
145 set @v2 = repeat("b", 2000);
146 set @v3 = repeat("c", 4000);
147 "================== con1 marker =================="
148 "================== Step 3 =================="
149 call dump_thread();
150 username user1
151 EVENT_NAME memory/sql/user_var_entry::value
152 COUNT_ALLOC 3
153 COUNT_FREE 0
154 SUM_NUMBER_OF_BYTES_ALLOC 7099
155 SUM_NUMBER_OF_BYTES_FREE 0
156 LOW_COUNT_USED 0
157 CURRENT_COUNT_USED 3
158 HIGH_COUNT_USED 3
159 LOW_NUMBER_OF_BYTES_USED 0
160 CURRENT_NUMBER_OF_BYTES_USED 7099
161 HIGH_NUMBER_OF_BYTES_USED 7099
162 username user2
163 status not found
164 username user3
165 status not found
166 username user4
167 status not found
168 execute dump_memory_account;
169 USER user1
170 HOST localhost
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 execute dump_memory_user;
183 USER user1
184 EVENT_NAME memory/sql/user_var_entry::value
185 COUNT_ALLOC 3
186 COUNT_FREE 0
187 SUM_NUMBER_OF_BYTES_ALLOC 7099
188 SUM_NUMBER_OF_BYTES_FREE 0
189 LOW_COUNT_USED 0
190 CURRENT_COUNT_USED 3
191 HIGH_COUNT_USED 3
192 LOW_NUMBER_OF_BYTES_USED 0
193 CURRENT_NUMBER_OF_BYTES_USED 7099
194 HIGH_NUMBER_OF_BYTES_USED 7099
195 execute dump_memory_host;
196 HOST localhost
197 EVENT_NAME memory/sql/user_var_entry::value
198 COUNT_ALLOC 3
199 COUNT_FREE 0
200 SUM_NUMBER_OF_BYTES_ALLOC 7099
201 SUM_NUMBER_OF_BYTES_FREE 0
202 LOW_COUNT_USED 0
203 CURRENT_COUNT_USED 3
204 HIGH_COUNT_USED 3
205 LOW_NUMBER_OF_BYTES_USED 0
206 CURRENT_NUMBER_OF_BYTES_USED 7099
207 HIGH_NUMBER_OF_BYTES_USED 7099
208 execute dump_memory_global;
209 EVENT_NAME memory/sql/user_var_entry::value
210 COUNT_ALLOC 3
211 COUNT_FREE 0
212 SUM_NUMBER_OF_BYTES_ALLOC 7099
213 SUM_NUMBER_OF_BYTES_FREE 0
214 LOW_COUNT_USED 0
215 CURRENT_COUNT_USED 3
216 HIGH_COUNT_USED 3
217 LOW_NUMBER_OF_BYTES_USED 0
218 CURRENT_NUMBER_OF_BYTES_USED 7099
219 HIGH_NUMBER_OF_BYTES_USED 7099
220 execute dump_accounts;
221 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
222 event_scheduler localhost 1 1
223 root localhost 1 1
224 user1 localhost 1 1
225 execute dump_users;
226 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
227 event_scheduler 1 1
228 root 1 1
229 user1 1 1
230 execute dump_hosts;
231 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
232 localhost 3 3
233 "================== con2 connected =================="
234 "================== Step 4 =================="
235 call dump_thread();
236 username user1
237 EVENT_NAME memory/sql/user_var_entry::value
238 COUNT_ALLOC 3
239 COUNT_FREE 0
240 SUM_NUMBER_OF_BYTES_ALLOC 7099
241 SUM_NUMBER_OF_BYTES_FREE 0
242 LOW_COUNT_USED 0
243 CURRENT_COUNT_USED 3
244 HIGH_COUNT_USED 3
245 LOW_NUMBER_OF_BYTES_USED 0
246 CURRENT_NUMBER_OF_BYTES_USED 7099
247 HIGH_NUMBER_OF_BYTES_USED 7099
248 username user2
249 EVENT_NAME memory/sql/user_var_entry::value
250 COUNT_ALLOC 0
251 COUNT_FREE 0
252 SUM_NUMBER_OF_BYTES_ALLOC 0
253 SUM_NUMBER_OF_BYTES_FREE 0
254 LOW_COUNT_USED 0
255 CURRENT_COUNT_USED 0
256 HIGH_COUNT_USED 0
257 LOW_NUMBER_OF_BYTES_USED 0
258 CURRENT_NUMBER_OF_BYTES_USED 0
259 HIGH_NUMBER_OF_BYTES_USED 0
260 username user3
261 status not found
262 username user4
263 status not found
264 execute dump_memory_account;
265 USER user1
266 HOST localhost
267 EVENT_NAME memory/sql/user_var_entry::value
268 COUNT_ALLOC 3
269 COUNT_FREE 0
270 SUM_NUMBER_OF_BYTES_ALLOC 7099
271 SUM_NUMBER_OF_BYTES_FREE 0
272 LOW_COUNT_USED 0
273 CURRENT_COUNT_USED 3
274 HIGH_COUNT_USED 3
275 LOW_NUMBER_OF_BYTES_USED 0
276 CURRENT_NUMBER_OF_BYTES_USED 7099
277 HIGH_NUMBER_OF_BYTES_USED 7099
278 USER user2
279 HOST localhost
280 EVENT_NAME memory/sql/user_var_entry::value
281 COUNT_ALLOC 0
282 COUNT_FREE 0
283 SUM_NUMBER_OF_BYTES_ALLOC 0
284 SUM_NUMBER_OF_BYTES_FREE 0
285 LOW_COUNT_USED 0
286 CURRENT_COUNT_USED 0
287 HIGH_COUNT_USED 0
288 LOW_NUMBER_OF_BYTES_USED 0
289 CURRENT_NUMBER_OF_BYTES_USED 0
290 HIGH_NUMBER_OF_BYTES_USED 0
291 execute dump_memory_user;
292 USER user1
293 EVENT_NAME memory/sql/user_var_entry::value
294 COUNT_ALLOC 3
295 COUNT_FREE 0
296 SUM_NUMBER_OF_BYTES_ALLOC 7099
297 SUM_NUMBER_OF_BYTES_FREE 0
298 LOW_COUNT_USED 0
299 CURRENT_COUNT_USED 3
300 HIGH_COUNT_USED 3
301 LOW_NUMBER_OF_BYTES_USED 0
302 CURRENT_NUMBER_OF_BYTES_USED 7099
303 HIGH_NUMBER_OF_BYTES_USED 7099
304 USER user2
305 EVENT_NAME memory/sql/user_var_entry::value
306 COUNT_ALLOC 0
307 COUNT_FREE 0
308 SUM_NUMBER_OF_BYTES_ALLOC 0
309 SUM_NUMBER_OF_BYTES_FREE 0
310 LOW_COUNT_USED 0
311 CURRENT_COUNT_USED 0
312 HIGH_COUNT_USED 0
313 LOW_NUMBER_OF_BYTES_USED 0
314 CURRENT_NUMBER_OF_BYTES_USED 0
315 HIGH_NUMBER_OF_BYTES_USED 0
316 execute dump_memory_host;
317 HOST localhost
318 EVENT_NAME memory/sql/user_var_entry::value
319 COUNT_ALLOC 3
320 COUNT_FREE 0
321 SUM_NUMBER_OF_BYTES_ALLOC 7099
322 SUM_NUMBER_OF_BYTES_FREE 0
323 LOW_COUNT_USED 0
324 CURRENT_COUNT_USED 3
325 HIGH_COUNT_USED 3
326 LOW_NUMBER_OF_BYTES_USED 0
327 CURRENT_NUMBER_OF_BYTES_USED 7099
328 HIGH_NUMBER_OF_BYTES_USED 7099
329 execute dump_memory_global;
330 EVENT_NAME memory/sql/user_var_entry::value
331 COUNT_ALLOC 3
332 COUNT_FREE 0
333 SUM_NUMBER_OF_BYTES_ALLOC 7099
334 SUM_NUMBER_OF_BYTES_FREE 0
335 LOW_COUNT_USED 0
336 CURRENT_COUNT_USED 3
337 HIGH_COUNT_USED 3
338 LOW_NUMBER_OF_BYTES_USED 0
339 CURRENT_NUMBER_OF_BYTES_USED 7099
340 HIGH_NUMBER_OF_BYTES_USED 7099
341 execute dump_accounts;
342 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
343 event_scheduler localhost 1 1
344 root localhost 1 1
345 user1 localhost 1 1
346 user2 localhost 1 1
347 execute dump_users;
348 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
349 event_scheduler 1 1
350 root 1 1
351 user1 1 1
352 user2 1 1
353 execute dump_hosts;
354 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
355 localhost 4 4
356 select get_lock("marker_2", 10);
357 get_lock("marker_2", 10)
358 1
359 select release_lock("marker_2");
360 release_lock("marker_2")
361 1
362 set @v1 = repeat("a", 1000);
363 set @v2 = repeat("b", 2000);
364 set @v3 = repeat("c", 4000);
365 "================== con2 marker =================="
366 "================== Step 5 =================="
367 call dump_thread();
368 username user1
369 EVENT_NAME memory/sql/user_var_entry::value
370 COUNT_ALLOC 3
371 COUNT_FREE 0
372 SUM_NUMBER_OF_BYTES_ALLOC 7099
373 SUM_NUMBER_OF_BYTES_FREE 0
374 LOW_COUNT_USED 0
375 CURRENT_COUNT_USED 3
376 HIGH_COUNT_USED 3
377 LOW_NUMBER_OF_BYTES_USED 0
378 CURRENT_NUMBER_OF_BYTES_USED 7099
379 HIGH_NUMBER_OF_BYTES_USED 7099
380 username user2
381 EVENT_NAME memory/sql/user_var_entry::value
382 COUNT_ALLOC 3
383 COUNT_FREE 0
384 SUM_NUMBER_OF_BYTES_ALLOC 7099
385 SUM_NUMBER_OF_BYTES_FREE 0
386 LOW_COUNT_USED 0
387 CURRENT_COUNT_USED 3
388 HIGH_COUNT_USED 3
389 LOW_NUMBER_OF_BYTES_USED 0
390 CURRENT_NUMBER_OF_BYTES_USED 7099
391 HIGH_NUMBER_OF_BYTES_USED 7099
392 username user3
393 status not found
394 username user4
395 status not found
396 execute dump_memory_account;
397 USER user1
398 HOST localhost
399 EVENT_NAME memory/sql/user_var_entry::value
400 COUNT_ALLOC 3
401 COUNT_FREE 0
402 SUM_NUMBER_OF_BYTES_ALLOC 7099
403 SUM_NUMBER_OF_BYTES_FREE 0
404 LOW_COUNT_USED 0
405 CURRENT_COUNT_USED 3
406 HIGH_COUNT_USED 3
407 LOW_NUMBER_OF_BYTES_USED 0
408 CURRENT_NUMBER_OF_BYTES_USED 7099
409 HIGH_NUMBER_OF_BYTES_USED 7099
410 USER user2
411 HOST localhost
412 EVENT_NAME memory/sql/user_var_entry::value
413 COUNT_ALLOC 3
414 COUNT_FREE 0
415 SUM_NUMBER_OF_BYTES_ALLOC 7099
416 SUM_NUMBER_OF_BYTES_FREE 0
417 LOW_COUNT_USED 0
418 CURRENT_COUNT_USED 3
419 HIGH_COUNT_USED 3
420 LOW_NUMBER_OF_BYTES_USED 0
421 CURRENT_NUMBER_OF_BYTES_USED 7099
422 HIGH_NUMBER_OF_BYTES_USED 7099
423 execute dump_memory_user;
424 USER user1
425 EVENT_NAME memory/sql/user_var_entry::value
426 COUNT_ALLOC 3
427 COUNT_FREE 0
428 SUM_NUMBER_OF_BYTES_ALLOC 7099
429 SUM_NUMBER_OF_BYTES_FREE 0
430 LOW_COUNT_USED 0
431 CURRENT_COUNT_USED 3
432 HIGH_COUNT_USED 3
433 LOW_NUMBER_OF_BYTES_USED 0
434 CURRENT_NUMBER_OF_BYTES_USED 7099
435 HIGH_NUMBER_OF_BYTES_USED 7099
436 USER user2
437 EVENT_NAME memory/sql/user_var_entry::value
438 COUNT_ALLOC 3
439 COUNT_FREE 0
440 SUM_NUMBER_OF_BYTES_ALLOC 7099
441 SUM_NUMBER_OF_BYTES_FREE 0
442 LOW_COUNT_USED 0
443 CURRENT_COUNT_USED 3
444 HIGH_COUNT_USED 3
445 LOW_NUMBER_OF_BYTES_USED 0
446 CURRENT_NUMBER_OF_BYTES_USED 7099
447 HIGH_NUMBER_OF_BYTES_USED 7099
448 execute dump_memory_host;
449 HOST localhost
450 EVENT_NAME memory/sql/user_var_entry::value
451 COUNT_ALLOC 6
452 COUNT_FREE 0
453 SUM_NUMBER_OF_BYTES_ALLOC 14198
454 SUM_NUMBER_OF_BYTES_FREE 0
455 LOW_COUNT_USED 0
456 CURRENT_COUNT_USED 6
457 HIGH_COUNT_USED 6
458 LOW_NUMBER_OF_BYTES_USED 0
459 CURRENT_NUMBER_OF_BYTES_USED 14198
460 HIGH_NUMBER_OF_BYTES_USED 14198
461 execute dump_memory_global;
462 EVENT_NAME memory/sql/user_var_entry::value
463 COUNT_ALLOC 6
464 COUNT_FREE 0
465 SUM_NUMBER_OF_BYTES_ALLOC 14198
466 SUM_NUMBER_OF_BYTES_FREE 0
467 LOW_COUNT_USED 0
468 CURRENT_COUNT_USED 6
469 HIGH_COUNT_USED 6
470 LOW_NUMBER_OF_BYTES_USED 0
471 CURRENT_NUMBER_OF_BYTES_USED 14198
472 HIGH_NUMBER_OF_BYTES_USED 14198
473 execute dump_accounts;
474 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
475 event_scheduler localhost 1 1
476 root localhost 1 1
477 user1 localhost 1 1
478 user2 localhost 1 1
479 execute dump_users;
480 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
481 event_scheduler 1 1
482 root 1 1
483 user1 1 1
484 user2 1 1
485 execute dump_hosts;
486 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
487 localhost 4 4
488 truncate table performance_schema.memory_summary_by_thread_by_event_name;
489 "================== MEMORY_BY_THREAD truncated =================="
490 "================== Step 5b =================="
491 call dump_thread();
492 username user1
493 EVENT_NAME memory/sql/user_var_entry::value
494 COUNT_ALLOC 3
495 COUNT_FREE 0
496 SUM_NUMBER_OF_BYTES_ALLOC 7099
497 SUM_NUMBER_OF_BYTES_FREE 0
498 LOW_COUNT_USED 3
499 CURRENT_COUNT_USED 3
500 HIGH_COUNT_USED 3
501 LOW_NUMBER_OF_BYTES_USED 7099
502 CURRENT_NUMBER_OF_BYTES_USED 7099
503 HIGH_NUMBER_OF_BYTES_USED 7099
504 username user2
505 EVENT_NAME memory/sql/user_var_entry::value
506 COUNT_ALLOC 3
507 COUNT_FREE 0
508 SUM_NUMBER_OF_BYTES_ALLOC 7099
509 SUM_NUMBER_OF_BYTES_FREE 0
510 LOW_COUNT_USED 3
511 CURRENT_COUNT_USED 3
512 HIGH_COUNT_USED 3
513 LOW_NUMBER_OF_BYTES_USED 7099
514 CURRENT_NUMBER_OF_BYTES_USED 7099
515 HIGH_NUMBER_OF_BYTES_USED 7099
516 username user3
517 status not found
518 username user4
519 status not found
520 execute dump_memory_account;
521 USER user1
522 HOST localhost
523 EVENT_NAME memory/sql/user_var_entry::value
524 COUNT_ALLOC 3
525 COUNT_FREE 0
526 SUM_NUMBER_OF_BYTES_ALLOC 7099
527 SUM_NUMBER_OF_BYTES_FREE 0
528 LOW_COUNT_USED 0
529 CURRENT_COUNT_USED 3
530 HIGH_COUNT_USED 3
531 LOW_NUMBER_OF_BYTES_USED 0
532 CURRENT_NUMBER_OF_BYTES_USED 7099
533 HIGH_NUMBER_OF_BYTES_USED 7099
534 USER user2
535 HOST localhost
536 EVENT_NAME memory/sql/user_var_entry::value
537 COUNT_ALLOC 3
538 COUNT_FREE 0
539 SUM_NUMBER_OF_BYTES_ALLOC 7099
540 SUM_NUMBER_OF_BYTES_FREE 0
541 LOW_COUNT_USED 0
542 CURRENT_COUNT_USED 3
543 HIGH_COUNT_USED 3
544 LOW_NUMBER_OF_BYTES_USED 0
545 CURRENT_NUMBER_OF_BYTES_USED 7099
546 HIGH_NUMBER_OF_BYTES_USED 7099
547 execute dump_memory_user;
548 USER user1
549 EVENT_NAME memory/sql/user_var_entry::value
550 COUNT_ALLOC 3
551 COUNT_FREE 0
552 SUM_NUMBER_OF_BYTES_ALLOC 7099
553 SUM_NUMBER_OF_BYTES_FREE 0
554 LOW_COUNT_USED 0
555 CURRENT_COUNT_USED 3
556 HIGH_COUNT_USED 3
557 LOW_NUMBER_OF_BYTES_USED 0
558 CURRENT_NUMBER_OF_BYTES_USED 7099
559 HIGH_NUMBER_OF_BYTES_USED 7099
560 USER user2
561 EVENT_NAME memory/sql/user_var_entry::value
562 COUNT_ALLOC 3
563 COUNT_FREE 0
564 SUM_NUMBER_OF_BYTES_ALLOC 7099
565 SUM_NUMBER_OF_BYTES_FREE 0
566 LOW_COUNT_USED 0
567 CURRENT_COUNT_USED 3
568 HIGH_COUNT_USED 3
569 LOW_NUMBER_OF_BYTES_USED 0
570 CURRENT_NUMBER_OF_BYTES_USED 7099
571 HIGH_NUMBER_OF_BYTES_USED 7099
572 execute dump_memory_host;
573 HOST localhost
574 EVENT_NAME memory/sql/user_var_entry::value
575 COUNT_ALLOC 6
576 COUNT_FREE 0
577 SUM_NUMBER_OF_BYTES_ALLOC 14198
578 SUM_NUMBER_OF_BYTES_FREE 0
579 LOW_COUNT_USED 0
580 CURRENT_COUNT_USED 6
581 HIGH_COUNT_USED 6
582 LOW_NUMBER_OF_BYTES_USED 0
583 CURRENT_NUMBER_OF_BYTES_USED 14198
584 HIGH_NUMBER_OF_BYTES_USED 14198
585 execute dump_memory_global;
586 EVENT_NAME memory/sql/user_var_entry::value
587 COUNT_ALLOC 6
588 COUNT_FREE 0
589 SUM_NUMBER_OF_BYTES_ALLOC 14198
590 SUM_NUMBER_OF_BYTES_FREE 0
591 LOW_COUNT_USED 0
592 CURRENT_COUNT_USED 6
593 HIGH_COUNT_USED 6
594 LOW_NUMBER_OF_BYTES_USED 0
595 CURRENT_NUMBER_OF_BYTES_USED 14198
596 HIGH_NUMBER_OF_BYTES_USED 14198
597 execute dump_accounts;
598 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
599 event_scheduler localhost 1 1
600 root localhost 1 1
601 user1 localhost 1 1
602 user2 localhost 1 1
603 execute dump_users;
604 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
605 event_scheduler 1 1
606 root 1 1
607 user1 1 1
608 user2 1 1
609 execute dump_hosts;
610 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
611 localhost 4 4
612 "================== con3 connected =================="
613 "================== Step 6 =================="
614 call dump_thread();
615 username user1
616 EVENT_NAME memory/sql/user_var_entry::value
617 COUNT_ALLOC 3
618 COUNT_FREE 0
619 SUM_NUMBER_OF_BYTES_ALLOC 7099
620 SUM_NUMBER_OF_BYTES_FREE 0
621 LOW_COUNT_USED 3
622 CURRENT_COUNT_USED 3
623 HIGH_COUNT_USED 3
624 LOW_NUMBER_OF_BYTES_USED 7099
625 CURRENT_NUMBER_OF_BYTES_USED 7099
626 HIGH_NUMBER_OF_BYTES_USED 7099
627 username user2
628 EVENT_NAME memory/sql/user_var_entry::value
629 COUNT_ALLOC 3
630 COUNT_FREE 0
631 SUM_NUMBER_OF_BYTES_ALLOC 7099
632 SUM_NUMBER_OF_BYTES_FREE 0
633 LOW_COUNT_USED 3
634 CURRENT_COUNT_USED 3
635 HIGH_COUNT_USED 3
636 LOW_NUMBER_OF_BYTES_USED 7099
637 CURRENT_NUMBER_OF_BYTES_USED 7099
638 HIGH_NUMBER_OF_BYTES_USED 7099
639 username user3
640 EVENT_NAME memory/sql/user_var_entry::value
641 COUNT_ALLOC 0
642 COUNT_FREE 0
643 SUM_NUMBER_OF_BYTES_ALLOC 0
644 SUM_NUMBER_OF_BYTES_FREE 0
645 LOW_COUNT_USED 0
646 CURRENT_COUNT_USED 0
647 HIGH_COUNT_USED 0
648 LOW_NUMBER_OF_BYTES_USED 0
649 CURRENT_NUMBER_OF_BYTES_USED 0
650 HIGH_NUMBER_OF_BYTES_USED 0
651 username user4
652 status not found
653 execute dump_memory_account;
654 USER user1
655 HOST localhost
656 EVENT_NAME memory/sql/user_var_entry::value
657 COUNT_ALLOC 3
658 COUNT_FREE 0
659 SUM_NUMBER_OF_BYTES_ALLOC 7099
660 SUM_NUMBER_OF_BYTES_FREE 0
661 LOW_COUNT_USED 0
662 CURRENT_COUNT_USED 3
663 HIGH_COUNT_USED 3
664 LOW_NUMBER_OF_BYTES_USED 0
665 CURRENT_NUMBER_OF_BYTES_USED 7099
666 HIGH_NUMBER_OF_BYTES_USED 7099
667 USER user2
668 HOST localhost
669 EVENT_NAME memory/sql/user_var_entry::value
670 COUNT_ALLOC 3
671 COUNT_FREE 0
672 SUM_NUMBER_OF_BYTES_ALLOC 7099
673 SUM_NUMBER_OF_BYTES_FREE 0
674 LOW_COUNT_USED 0
675 CURRENT_COUNT_USED 3
676 HIGH_COUNT_USED 3
677 LOW_NUMBER_OF_BYTES_USED 0
678 CURRENT_NUMBER_OF_BYTES_USED 7099
679 HIGH_NUMBER_OF_BYTES_USED 7099
680 USER user3
681 HOST localhost
682 EVENT_NAME memory/sql/user_var_entry::value
683 COUNT_ALLOC 0
684 COUNT_FREE 0
685 SUM_NUMBER_OF_BYTES_ALLOC 0
686 SUM_NUMBER_OF_BYTES_FREE 0
687 LOW_COUNT_USED 0
688 CURRENT_COUNT_USED 0
689 HIGH_COUNT_USED 0
690 LOW_NUMBER_OF_BYTES_USED 0
691 CURRENT_NUMBER_OF_BYTES_USED 0
692 HIGH_NUMBER_OF_BYTES_USED 0
693 execute dump_memory_user;
694 USER user1
695 EVENT_NAME memory/sql/user_var_entry::value
696 COUNT_ALLOC 3
697 COUNT_FREE 0
698 SUM_NUMBER_OF_BYTES_ALLOC 7099
699 SUM_NUMBER_OF_BYTES_FREE 0
700 LOW_COUNT_USED 0
701 CURRENT_COUNT_USED 3
702 HIGH_COUNT_USED 3
703 LOW_NUMBER_OF_BYTES_USED 0
704 CURRENT_NUMBER_OF_BYTES_USED 7099
705 HIGH_NUMBER_OF_BYTES_USED 7099
706 USER user2
707 EVENT_NAME memory/sql/user_var_entry::value
708 COUNT_ALLOC 3
709 COUNT_FREE 0
710 SUM_NUMBER_OF_BYTES_ALLOC 7099
711 SUM_NUMBER_OF_BYTES_FREE 0
712 LOW_COUNT_USED 0
713 CURRENT_COUNT_USED 3
714 HIGH_COUNT_USED 3
715 LOW_NUMBER_OF_BYTES_USED 0
716 CURRENT_NUMBER_OF_BYTES_USED 7099
717 HIGH_NUMBER_OF_BYTES_USED 7099
718 USER user3
719 EVENT_NAME memory/sql/user_var_entry::value
720 COUNT_ALLOC 0
721 COUNT_FREE 0
722 SUM_NUMBER_OF_BYTES_ALLOC 0
723 SUM_NUMBER_OF_BYTES_FREE 0
724 LOW_COUNT_USED 0
725 CURRENT_COUNT_USED 0
726 HIGH_COUNT_USED 0
727 LOW_NUMBER_OF_BYTES_USED 0
728 CURRENT_NUMBER_OF_BYTES_USED 0
729 HIGH_NUMBER_OF_BYTES_USED 0
730 execute dump_memory_host;
731 HOST localhost
732 EVENT_NAME memory/sql/user_var_entry::value
733 COUNT_ALLOC 6
734 COUNT_FREE 0
735 SUM_NUMBER_OF_BYTES_ALLOC 14198
736 SUM_NUMBER_OF_BYTES_FREE 0
737 LOW_COUNT_USED 0
738 CURRENT_COUNT_USED 6
739 HIGH_COUNT_USED 6
740 LOW_NUMBER_OF_BYTES_USED 0
741 CURRENT_NUMBER_OF_BYTES_USED 14198
742 HIGH_NUMBER_OF_BYTES_USED 14198
743 execute dump_memory_global;
744 EVENT_NAME memory/sql/user_var_entry::value
745 COUNT_ALLOC 6
746 COUNT_FREE 0
747 SUM_NUMBER_OF_BYTES_ALLOC 14198
748 SUM_NUMBER_OF_BYTES_FREE 0
749 LOW_COUNT_USED 0
750 CURRENT_COUNT_USED 6
751 HIGH_COUNT_USED 6
752 LOW_NUMBER_OF_BYTES_USED 0
753 CURRENT_NUMBER_OF_BYTES_USED 14198
754 HIGH_NUMBER_OF_BYTES_USED 14198
755 execute dump_accounts;
756 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
757 event_scheduler localhost 1 1
758 root localhost 1 1
759 user1 localhost 1 1
760 user2 localhost 1 1
761 user3 localhost 1 1
762 execute dump_users;
763 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
764 event_scheduler 1 1
765 root 1 1
766 user1 1 1
767 user2 1 1
768 user3 1 1
769 execute dump_hosts;
770 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
771 localhost 5 5
772 select get_lock("marker_3", 10);
773 get_lock("marker_3", 10)
774 1
775 select release_lock("marker_3");
776 release_lock("marker_3")
777 1
778 set @v1 = repeat("a", 1000);
779 set @v2 = repeat("b", 2000);
780 set @v3 = repeat("c", 4000);
781 "================== con3 marker =================="
782 "================== Step 7 =================="
783 call dump_thread();
784 username user1
785 EVENT_NAME memory/sql/user_var_entry::value
786 COUNT_ALLOC 3
787 COUNT_FREE 0
788 SUM_NUMBER_OF_BYTES_ALLOC 7099
789 SUM_NUMBER_OF_BYTES_FREE 0
790 LOW_COUNT_USED 3
791 CURRENT_COUNT_USED 3
792 HIGH_COUNT_USED 3
793 LOW_NUMBER_OF_BYTES_USED 7099
794 CURRENT_NUMBER_OF_BYTES_USED 7099
795 HIGH_NUMBER_OF_BYTES_USED 7099
796 username user2
797 EVENT_NAME memory/sql/user_var_entry::value
798 COUNT_ALLOC 3
799 COUNT_FREE 0
800 SUM_NUMBER_OF_BYTES_ALLOC 7099
801 SUM_NUMBER_OF_BYTES_FREE 0
802 LOW_COUNT_USED 3
803 CURRENT_COUNT_USED 3
804 HIGH_COUNT_USED 3
805 LOW_NUMBER_OF_BYTES_USED 7099
806 CURRENT_NUMBER_OF_BYTES_USED 7099
807 HIGH_NUMBER_OF_BYTES_USED 7099
808 username user3
809 EVENT_NAME memory/sql/user_var_entry::value
810 COUNT_ALLOC 3
811 COUNT_FREE 0
812 SUM_NUMBER_OF_BYTES_ALLOC 7099
813 SUM_NUMBER_OF_BYTES_FREE 0
814 LOW_COUNT_USED 0
815 CURRENT_COUNT_USED 3
816 HIGH_COUNT_USED 3
817 LOW_NUMBER_OF_BYTES_USED 0
818 CURRENT_NUMBER_OF_BYTES_USED 7099
819 HIGH_NUMBER_OF_BYTES_USED 7099
820 username user4
821 status not found
822 execute dump_memory_account;
823 USER user1
824 HOST localhost
825 EVENT_NAME memory/sql/user_var_entry::value
826 COUNT_ALLOC 3
827 COUNT_FREE 0
828 SUM_NUMBER_OF_BYTES_ALLOC 7099
829 SUM_NUMBER_OF_BYTES_FREE 0
830 LOW_COUNT_USED 0
831 CURRENT_COUNT_USED 3
832 HIGH_COUNT_USED 3
833 LOW_NUMBER_OF_BYTES_USED 0
834 CURRENT_NUMBER_OF_BYTES_USED 7099
835 HIGH_NUMBER_OF_BYTES_USED 7099
836 USER user2
837 HOST localhost
838 EVENT_NAME memory/sql/user_var_entry::value
839 COUNT_ALLOC 3
840 COUNT_FREE 0
841 SUM_NUMBER_OF_BYTES_ALLOC 7099
842 SUM_NUMBER_OF_BYTES_FREE 0
843 LOW_COUNT_USED 0
844 CURRENT_COUNT_USED 3
845 HIGH_COUNT_USED 3
846 LOW_NUMBER_OF_BYTES_USED 0
847 CURRENT_NUMBER_OF_BYTES_USED 7099
848 HIGH_NUMBER_OF_BYTES_USED 7099
849 USER user3
850 HOST localhost
851 EVENT_NAME memory/sql/user_var_entry::value
852 COUNT_ALLOC 3
853 COUNT_FREE 0
854 SUM_NUMBER_OF_BYTES_ALLOC 7099
855 SUM_NUMBER_OF_BYTES_FREE 0
856 LOW_COUNT_USED 0
857 CURRENT_COUNT_USED 3
858 HIGH_COUNT_USED 3
859 LOW_NUMBER_OF_BYTES_USED 0
860 CURRENT_NUMBER_OF_BYTES_USED 7099
861 HIGH_NUMBER_OF_BYTES_USED 7099
862 execute dump_memory_user;
863 USER user1
864 EVENT_NAME memory/sql/user_var_entry::value
865 COUNT_ALLOC 3
866 COUNT_FREE 0
867 SUM_NUMBER_OF_BYTES_ALLOC 7099
868 SUM_NUMBER_OF_BYTES_FREE 0
869 LOW_COUNT_USED 0
870 CURRENT_COUNT_USED 3
871 HIGH_COUNT_USED 3
872 LOW_NUMBER_OF_BYTES_USED 0
873 CURRENT_NUMBER_OF_BYTES_USED 7099
874 HIGH_NUMBER_OF_BYTES_USED 7099
875 USER user2
876 EVENT_NAME memory/sql/user_var_entry::value
877 COUNT_ALLOC 3
878 COUNT_FREE 0
879 SUM_NUMBER_OF_BYTES_ALLOC 7099
880 SUM_NUMBER_OF_BYTES_FREE 0
881 LOW_COUNT_USED 0
882 CURRENT_COUNT_USED 3
883 HIGH_COUNT_USED 3
884 LOW_NUMBER_OF_BYTES_USED 0
885 CURRENT_NUMBER_OF_BYTES_USED 7099
886 HIGH_NUMBER_OF_BYTES_USED 7099
887 USER user3
888 EVENT_NAME memory/sql/user_var_entry::value
889 COUNT_ALLOC 3
890 COUNT_FREE 0
891 SUM_NUMBER_OF_BYTES_ALLOC 7099
892 SUM_NUMBER_OF_BYTES_FREE 0
893 LOW_COUNT_USED 0
894 CURRENT_COUNT_USED 3
895 HIGH_COUNT_USED 3
896 LOW_NUMBER_OF_BYTES_USED 0
897 CURRENT_NUMBER_OF_BYTES_USED 7099
898 HIGH_NUMBER_OF_BYTES_USED 7099
899 execute dump_memory_host;
900 HOST localhost
901 EVENT_NAME memory/sql/user_var_entry::value
902 COUNT_ALLOC 9
903 COUNT_FREE 0
904 SUM_NUMBER_OF_BYTES_ALLOC 21297
905 SUM_NUMBER_OF_BYTES_FREE 0
906 LOW_COUNT_USED 0
907 CURRENT_COUNT_USED 9
908 HIGH_COUNT_USED 9
909 LOW_NUMBER_OF_BYTES_USED 0
910 CURRENT_NUMBER_OF_BYTES_USED 21297
911 HIGH_NUMBER_OF_BYTES_USED 21297
912 execute dump_memory_global;
913 EVENT_NAME memory/sql/user_var_entry::value
914 COUNT_ALLOC 9
915 COUNT_FREE 0
916 SUM_NUMBER_OF_BYTES_ALLOC 21297
917 SUM_NUMBER_OF_BYTES_FREE 0
918 LOW_COUNT_USED 0
919 CURRENT_COUNT_USED 9
920 HIGH_COUNT_USED 9
921 LOW_NUMBER_OF_BYTES_USED 0
922 CURRENT_NUMBER_OF_BYTES_USED 21297
923 HIGH_NUMBER_OF_BYTES_USED 21297
924 execute dump_accounts;
925 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
926 event_scheduler localhost 1 1
927 root localhost 1 1
928 user1 localhost 1 1
929 user2 localhost 1 1
930 user3 localhost 1 1
931 execute dump_users;
932 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
933 event_scheduler 1 1
934 root 1 1
935 user1 1 1
936 user2 1 1
937 user3 1 1
938 execute dump_hosts;
939 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
940 localhost 5 5
941 "================== con4/con5 (both user4) connected =================="
942 "================== Step 8 =================="
943 call dump_thread();
944 username user1
945 EVENT_NAME memory/sql/user_var_entry::value
946 COUNT_ALLOC 3
947 COUNT_FREE 0
948 SUM_NUMBER_OF_BYTES_ALLOC 7099
949 SUM_NUMBER_OF_BYTES_FREE 0
950 LOW_COUNT_USED 3
951 CURRENT_COUNT_USED 3
952 HIGH_COUNT_USED 3
953 LOW_NUMBER_OF_BYTES_USED 7099
954 CURRENT_NUMBER_OF_BYTES_USED 7099
955 HIGH_NUMBER_OF_BYTES_USED 7099
956 username user2
957 EVENT_NAME memory/sql/user_var_entry::value
958 COUNT_ALLOC 3
959 COUNT_FREE 0
960 SUM_NUMBER_OF_BYTES_ALLOC 7099
961 SUM_NUMBER_OF_BYTES_FREE 0
962 LOW_COUNT_USED 3
963 CURRENT_COUNT_USED 3
964 HIGH_COUNT_USED 3
965 LOW_NUMBER_OF_BYTES_USED 7099
966 CURRENT_NUMBER_OF_BYTES_USED 7099
967 HIGH_NUMBER_OF_BYTES_USED 7099
968 username user3
969 EVENT_NAME memory/sql/user_var_entry::value
970 COUNT_ALLOC 3
971 COUNT_FREE 0
972 SUM_NUMBER_OF_BYTES_ALLOC 7099
973 SUM_NUMBER_OF_BYTES_FREE 0
974 LOW_COUNT_USED 0
975 CURRENT_COUNT_USED 3
976 HIGH_COUNT_USED 3
977 LOW_NUMBER_OF_BYTES_USED 0
978 CURRENT_NUMBER_OF_BYTES_USED 7099
979 HIGH_NUMBER_OF_BYTES_USED 7099
980 username user4
981 EVENT_NAME memory/sql/user_var_entry::value
982 COUNT_ALLOC 0
983 COUNT_FREE 0
984 SUM_NUMBER_OF_BYTES_ALLOC 0
985 SUM_NUMBER_OF_BYTES_FREE 0
986 LOW_COUNT_USED 0
987 CURRENT_COUNT_USED 0
988 HIGH_COUNT_USED 0
989 LOW_NUMBER_OF_BYTES_USED 0
990 CURRENT_NUMBER_OF_BYTES_USED 0
991 HIGH_NUMBER_OF_BYTES_USED 0
992 execute dump_memory_account;
993 USER user1
994 HOST localhost
995 EVENT_NAME memory/sql/user_var_entry::value
996 COUNT_ALLOC 3
997 COUNT_FREE 0
998 SUM_NUMBER_OF_BYTES_ALLOC 7099
999 SUM_NUMBER_OF_BYTES_FREE 0
1000 LOW_COUNT_USED 0
1001 CURRENT_COUNT_USED 3
1002 HIGH_COUNT_USED 3
1003 LOW_NUMBER_OF_BYTES_USED 0
1004 CURRENT_NUMBER_OF_BYTES_USED 7099
1005 HIGH_NUMBER_OF_BYTES_USED 7099
1006 USER user2
1007 HOST localhost
1008 EVENT_NAME memory/sql/user_var_entry::value
1009 COUNT_ALLOC 3
1010 COUNT_FREE 0
1011 SUM_NUMBER_OF_BYTES_ALLOC 7099
1012 SUM_NUMBER_OF_BYTES_FREE 0
1013 LOW_COUNT_USED 0
1014 CURRENT_COUNT_USED 3
1015 HIGH_COUNT_USED 3
1016 LOW_NUMBER_OF_BYTES_USED 0
1017 CURRENT_NUMBER_OF_BYTES_USED 7099
1018 HIGH_NUMBER_OF_BYTES_USED 7099
1019 USER user3
1020 HOST localhost
1021 EVENT_NAME memory/sql/user_var_entry::value
1022 COUNT_ALLOC 3
1023 COUNT_FREE 0
1024 SUM_NUMBER_OF_BYTES_ALLOC 7099
1025 SUM_NUMBER_OF_BYTES_FREE 0
1026 LOW_COUNT_USED 0
1027 CURRENT_COUNT_USED 3
1028 HIGH_COUNT_USED 3
1029 LOW_NUMBER_OF_BYTES_USED 0
1030 CURRENT_NUMBER_OF_BYTES_USED 7099
1031 HIGH_NUMBER_OF_BYTES_USED 7099
1032 USER user4
1033 HOST localhost
1034 EVENT_NAME memory/sql/user_var_entry::value
1035 COUNT_ALLOC 0
1036 COUNT_FREE 0
1037 SUM_NUMBER_OF_BYTES_ALLOC 0
1038 SUM_NUMBER_OF_BYTES_FREE 0
1039 LOW_COUNT_USED 0
1040 CURRENT_COUNT_USED 0
1041 HIGH_COUNT_USED 0
1042 LOW_NUMBER_OF_BYTES_USED 0
1043 CURRENT_NUMBER_OF_BYTES_USED 0
1044 HIGH_NUMBER_OF_BYTES_USED 0
1045 execute dump_memory_user;
1046 USER user1
1047 EVENT_NAME memory/sql/user_var_entry::value
1048 COUNT_ALLOC 3
1049 COUNT_FREE 0
1050 SUM_NUMBER_OF_BYTES_ALLOC 7099
1051 SUM_NUMBER_OF_BYTES_FREE 0
1052 LOW_COUNT_USED 0
1053 CURRENT_COUNT_USED 3
1054 HIGH_COUNT_USED 3
1055 LOW_NUMBER_OF_BYTES_USED 0
1056 CURRENT_NUMBER_OF_BYTES_USED 7099
1057 HIGH_NUMBER_OF_BYTES_USED 7099
1058 USER user2
1059 EVENT_NAME memory/sql/user_var_entry::value
1060 COUNT_ALLOC 3
1061 COUNT_FREE 0
1062 SUM_NUMBER_OF_BYTES_ALLOC 7099
1063 SUM_NUMBER_OF_BYTES_FREE 0
1064 LOW_COUNT_USED 0
1065 CURRENT_COUNT_USED 3
1066 HIGH_COUNT_USED 3
1067 LOW_NUMBER_OF_BYTES_USED 0
1068 CURRENT_NUMBER_OF_BYTES_USED 7099
1069 HIGH_NUMBER_OF_BYTES_USED 7099
1070 USER user3
1071 EVENT_NAME memory/sql/user_var_entry::value
1072 COUNT_ALLOC 3
1073 COUNT_FREE 0
1074 SUM_NUMBER_OF_BYTES_ALLOC 7099
1075 SUM_NUMBER_OF_BYTES_FREE 0
1076 LOW_COUNT_USED 0
1077 CURRENT_COUNT_USED 3
1078 HIGH_COUNT_USED 3
1079 LOW_NUMBER_OF_BYTES_USED 0
1080 CURRENT_NUMBER_OF_BYTES_USED 7099
1081 HIGH_NUMBER_OF_BYTES_USED 7099
1082 USER user4
1083 EVENT_NAME memory/sql/user_var_entry::value
1084 COUNT_ALLOC 0
1085 COUNT_FREE 0
1086 SUM_NUMBER_OF_BYTES_ALLOC 0
1087 SUM_NUMBER_OF_BYTES_FREE 0
1088 LOW_COUNT_USED 0
1089 CURRENT_COUNT_USED 0
1090 HIGH_COUNT_USED 0
1091 LOW_NUMBER_OF_BYTES_USED 0
1092 CURRENT_NUMBER_OF_BYTES_USED 0
1093 HIGH_NUMBER_OF_BYTES_USED 0
1094 execute dump_memory_host;
1095 HOST localhost
1096 EVENT_NAME memory/sql/user_var_entry::value
1097 COUNT_ALLOC 9
1098 COUNT_FREE 0
1099 SUM_NUMBER_OF_BYTES_ALLOC 21297
1100 SUM_NUMBER_OF_BYTES_FREE 0
1101 LOW_COUNT_USED 0
1102 CURRENT_COUNT_USED 9
1103 HIGH_COUNT_USED 9
1104 LOW_NUMBER_OF_BYTES_USED 0
1105 CURRENT_NUMBER_OF_BYTES_USED 21297
1106 HIGH_NUMBER_OF_BYTES_USED 21297
1107 execute dump_memory_global;
1108 EVENT_NAME memory/sql/user_var_entry::value
1109 COUNT_ALLOC 9
1110 COUNT_FREE 0
1111 SUM_NUMBER_OF_BYTES_ALLOC 21297
1112 SUM_NUMBER_OF_BYTES_FREE 0
1113 LOW_COUNT_USED 0
1114 CURRENT_COUNT_USED 9
1115 HIGH_COUNT_USED 9
1116 LOW_NUMBER_OF_BYTES_USED 0
1117 CURRENT_NUMBER_OF_BYTES_USED 21297
1118 HIGH_NUMBER_OF_BYTES_USED 21297
1119 execute dump_accounts;
1120 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1121 event_scheduler localhost 1 1
1122 root localhost 1 1
1123 user1 localhost 1 1
1124 user2 localhost 1 1
1125 user3 localhost 1 1
1126 user4 localhost 2 2
1127 execute dump_users;
1128 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1129 event_scheduler 1 1
1130 root 1 1
1131 user1 1 1
1132 user2 1 1
1133 user3 1 1
1134 user4 2 2
1135 execute dump_hosts;
1136 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1137 localhost 7 7
1138 select get_lock("marker_4", 10);
1139 get_lock("marker_4", 10)
1140 1
1141 select release_lock("marker_4");
1142 release_lock("marker_4")
1143 1
1144 set @v1 = repeat("a", 1000);
1145 set @v2 = repeat("b", 2000);
1146 set @v3 = repeat("c", 4000);
1147 select get_lock("marker_5", 10);
1148 get_lock("marker_5", 10)
1149 1
1150 select release_lock("marker_5");
1151 release_lock("marker_5")
1152 1
1153 set @v1 = repeat("a", 1000);
1154 set @v2 = repeat("b", 2000);
1155 set @v3 = repeat("c", 4000);
1156 "================== con4/con5 marker =================="
1157 "================== Step 9 =================="
1158 call dump_thread();
1159 username user1
1160 EVENT_NAME memory/sql/user_var_entry::value
1161 COUNT_ALLOC 3
1162 COUNT_FREE 0
1163 SUM_NUMBER_OF_BYTES_ALLOC 7099
1164 SUM_NUMBER_OF_BYTES_FREE 0
1165 LOW_COUNT_USED 3
1166 CURRENT_COUNT_USED 3
1167 HIGH_COUNT_USED 3
1168 LOW_NUMBER_OF_BYTES_USED 7099
1169 CURRENT_NUMBER_OF_BYTES_USED 7099
1170 HIGH_NUMBER_OF_BYTES_USED 7099
1171 username user2
1172 EVENT_NAME memory/sql/user_var_entry::value
1173 COUNT_ALLOC 3
1174 COUNT_FREE 0
1175 SUM_NUMBER_OF_BYTES_ALLOC 7099
1176 SUM_NUMBER_OF_BYTES_FREE 0
1177 LOW_COUNT_USED 3
1178 CURRENT_COUNT_USED 3
1179 HIGH_COUNT_USED 3
1180 LOW_NUMBER_OF_BYTES_USED 7099
1181 CURRENT_NUMBER_OF_BYTES_USED 7099
1182 HIGH_NUMBER_OF_BYTES_USED 7099
1183 username user3
1184 EVENT_NAME memory/sql/user_var_entry::value
1185 COUNT_ALLOC 3
1186 COUNT_FREE 0
1187 SUM_NUMBER_OF_BYTES_ALLOC 7099
1188 SUM_NUMBER_OF_BYTES_FREE 0
1189 LOW_COUNT_USED 0
1190 CURRENT_COUNT_USED 3
1191 HIGH_COUNT_USED 3
1192 LOW_NUMBER_OF_BYTES_USED 0
1193 CURRENT_NUMBER_OF_BYTES_USED 7099
1194 HIGH_NUMBER_OF_BYTES_USED 7099
1195 username user4
1196 EVENT_NAME memory/sql/user_var_entry::value
1197 COUNT_ALLOC 3
1198 COUNT_FREE 0
1199 SUM_NUMBER_OF_BYTES_ALLOC 7099
1200 SUM_NUMBER_OF_BYTES_FREE 0
1201 LOW_COUNT_USED 0
1202 CURRENT_COUNT_USED 3
1203 HIGH_COUNT_USED 3
1204 LOW_NUMBER_OF_BYTES_USED 0
1205 CURRENT_NUMBER_OF_BYTES_USED 7099
1206 HIGH_NUMBER_OF_BYTES_USED 7099
1207 execute dump_memory_account;
1208 USER user1
1209 HOST localhost
1210 EVENT_NAME memory/sql/user_var_entry::value
1211 COUNT_ALLOC 3
1212 COUNT_FREE 0
1213 SUM_NUMBER_OF_BYTES_ALLOC 7099
1214 SUM_NUMBER_OF_BYTES_FREE 0
1215 LOW_COUNT_USED 0
1216 CURRENT_COUNT_USED 3
1217 HIGH_COUNT_USED 3
1218 LOW_NUMBER_OF_BYTES_USED 0
1219 CURRENT_NUMBER_OF_BYTES_USED 7099
1220 HIGH_NUMBER_OF_BYTES_USED 7099
1221 USER user2
1222 HOST localhost
1223 EVENT_NAME memory/sql/user_var_entry::value
1224 COUNT_ALLOC 3
1225 COUNT_FREE 0
1226 SUM_NUMBER_OF_BYTES_ALLOC 7099
1227 SUM_NUMBER_OF_BYTES_FREE 0
1228 LOW_COUNT_USED 0
1229 CURRENT_COUNT_USED 3
1230 HIGH_COUNT_USED 3
1231 LOW_NUMBER_OF_BYTES_USED 0
1232 CURRENT_NUMBER_OF_BYTES_USED 7099
1233 HIGH_NUMBER_OF_BYTES_USED 7099
1234 USER user3
1235 HOST localhost
1236 EVENT_NAME memory/sql/user_var_entry::value
1237 COUNT_ALLOC 3
1238 COUNT_FREE 0
1239 SUM_NUMBER_OF_BYTES_ALLOC 7099
1240 SUM_NUMBER_OF_BYTES_FREE 0
1241 LOW_COUNT_USED 0
1242 CURRENT_COUNT_USED 3
1243 HIGH_COUNT_USED 3
1244 LOW_NUMBER_OF_BYTES_USED 0
1245 CURRENT_NUMBER_OF_BYTES_USED 7099
1246 HIGH_NUMBER_OF_BYTES_USED 7099
1247 USER user4
1248 HOST localhost
1249 EVENT_NAME memory/sql/user_var_entry::value
1250 COUNT_ALLOC 6
1251 COUNT_FREE 0
1252 SUM_NUMBER_OF_BYTES_ALLOC 14198
1253 SUM_NUMBER_OF_BYTES_FREE 0
1254 LOW_COUNT_USED 0
1255 CURRENT_COUNT_USED 6
1256 HIGH_COUNT_USED 6
1257 LOW_NUMBER_OF_BYTES_USED 0
1258 CURRENT_NUMBER_OF_BYTES_USED 14198
1259 HIGH_NUMBER_OF_BYTES_USED 14198
1260 execute dump_memory_user;
1261 USER user1
1262 EVENT_NAME memory/sql/user_var_entry::value
1263 COUNT_ALLOC 3
1264 COUNT_FREE 0
1265 SUM_NUMBER_OF_BYTES_ALLOC 7099
1266 SUM_NUMBER_OF_BYTES_FREE 0
1267 LOW_COUNT_USED 0
1268 CURRENT_COUNT_USED 3
1269 HIGH_COUNT_USED 3
1270 LOW_NUMBER_OF_BYTES_USED 0
1271 CURRENT_NUMBER_OF_BYTES_USED 7099
1272 HIGH_NUMBER_OF_BYTES_USED 7099
1273 USER user2
1274 EVENT_NAME memory/sql/user_var_entry::value
1275 COUNT_ALLOC 3
1276 COUNT_FREE 0
1277 SUM_NUMBER_OF_BYTES_ALLOC 7099
1278 SUM_NUMBER_OF_BYTES_FREE 0
1279 LOW_COUNT_USED 0
1280 CURRENT_COUNT_USED 3
1281 HIGH_COUNT_USED 3
1282 LOW_NUMBER_OF_BYTES_USED 0
1283 CURRENT_NUMBER_OF_BYTES_USED 7099
1284 HIGH_NUMBER_OF_BYTES_USED 7099
1285 USER user3
1286 EVENT_NAME memory/sql/user_var_entry::value
1287 COUNT_ALLOC 3
1288 COUNT_FREE 0
1289 SUM_NUMBER_OF_BYTES_ALLOC 7099
1290 SUM_NUMBER_OF_BYTES_FREE 0
1291 LOW_COUNT_USED 0
1292 CURRENT_COUNT_USED 3
1293 HIGH_COUNT_USED 3
1294 LOW_NUMBER_OF_BYTES_USED 0
1295 CURRENT_NUMBER_OF_BYTES_USED 7099
1296 HIGH_NUMBER_OF_BYTES_USED 7099
1297 USER user4
1298 EVENT_NAME memory/sql/user_var_entry::value
1299 COUNT_ALLOC 6
1300 COUNT_FREE 0
1301 SUM_NUMBER_OF_BYTES_ALLOC 14198
1302 SUM_NUMBER_OF_BYTES_FREE 0
1303 LOW_COUNT_USED 0
1304 CURRENT_COUNT_USED 6
1305 HIGH_COUNT_USED 6
1306 LOW_NUMBER_OF_BYTES_USED 0
1307 CURRENT_NUMBER_OF_BYTES_USED 14198
1308 HIGH_NUMBER_OF_BYTES_USED 14198
1309 execute dump_memory_host;
1310 HOST localhost
1311 EVENT_NAME memory/sql/user_var_entry::value
1312 COUNT_ALLOC 15
1313 COUNT_FREE 0
1314 SUM_NUMBER_OF_BYTES_ALLOC 35495
1315 SUM_NUMBER_OF_BYTES_FREE 0
1316 LOW_COUNT_USED 0
1317 CURRENT_COUNT_USED 15
1318 HIGH_COUNT_USED 15
1319 LOW_NUMBER_OF_BYTES_USED 0
1320 CURRENT_NUMBER_OF_BYTES_USED 35495
1321 HIGH_NUMBER_OF_BYTES_USED 35495
1322 execute dump_memory_global;
1323 EVENT_NAME memory/sql/user_var_entry::value
1324 COUNT_ALLOC 15
1325 COUNT_FREE 0
1326 SUM_NUMBER_OF_BYTES_ALLOC 35495
1327 SUM_NUMBER_OF_BYTES_FREE 0
1328 LOW_COUNT_USED 0
1329 CURRENT_COUNT_USED 15
1330 HIGH_COUNT_USED 15
1331 LOW_NUMBER_OF_BYTES_USED 0
1332 CURRENT_NUMBER_OF_BYTES_USED 35495
1333 HIGH_NUMBER_OF_BYTES_USED 35495
1334 execute dump_accounts;
1335 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1336 event_scheduler localhost 1 1
1337 root localhost 1 1
1338 user1 localhost 1 1
1339 user2 localhost 1 1
1340 user3 localhost 1 1
1341 user4 localhost 2 2
1342 execute dump_users;
1343 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1344 event_scheduler 1 1
1345 root 1 1
1346 user1 1 1
1347 user2 1 1
1348 user3 1 1
1349 user4 2 2
1350 execute dump_hosts;
1351 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1352 localhost 7 7
1353 "================== con1/con5 disconnected =================="
1354 "================== Step 10 =================="
1355 call dump_thread();
1356 username user1
1357 status not found
1358 username user2
1359 EVENT_NAME memory/sql/user_var_entry::value
1360 COUNT_ALLOC 3
1361 COUNT_FREE 0
1362 SUM_NUMBER_OF_BYTES_ALLOC 7099
1363 SUM_NUMBER_OF_BYTES_FREE 0
1364 LOW_COUNT_USED 3
1365 CURRENT_COUNT_USED 3
1366 HIGH_COUNT_USED 3
1367 LOW_NUMBER_OF_BYTES_USED 7099
1368 CURRENT_NUMBER_OF_BYTES_USED 7099
1369 HIGH_NUMBER_OF_BYTES_USED 7099
1370 username user3
1371 EVENT_NAME memory/sql/user_var_entry::value
1372 COUNT_ALLOC 3
1373 COUNT_FREE 0
1374 SUM_NUMBER_OF_BYTES_ALLOC 7099
1375 SUM_NUMBER_OF_BYTES_FREE 0
1376 LOW_COUNT_USED 0
1377 CURRENT_COUNT_USED 3
1378 HIGH_COUNT_USED 3
1379 LOW_NUMBER_OF_BYTES_USED 0
1380 CURRENT_NUMBER_OF_BYTES_USED 7099
1381 HIGH_NUMBER_OF_BYTES_USED 7099
1382 username user4
1383 EVENT_NAME memory/sql/user_var_entry::value
1384 COUNT_ALLOC 3
1385 COUNT_FREE 0
1386 SUM_NUMBER_OF_BYTES_ALLOC 7099
1387 SUM_NUMBER_OF_BYTES_FREE 0
1388 LOW_COUNT_USED 0
1389 CURRENT_COUNT_USED 3
1390 HIGH_COUNT_USED 3
1391 LOW_NUMBER_OF_BYTES_USED 0
1392 CURRENT_NUMBER_OF_BYTES_USED 7099
1393 HIGH_NUMBER_OF_BYTES_USED 7099
1394 execute dump_memory_account;
1395 USER user1
1396 HOST localhost
1397 EVENT_NAME memory/sql/user_var_entry::value
1398 COUNT_ALLOC 3
1399 COUNT_FREE 3
1400 SUM_NUMBER_OF_BYTES_ALLOC 7099
1401 SUM_NUMBER_OF_BYTES_FREE 7099
1402 LOW_COUNT_USED 0
1403 CURRENT_COUNT_USED 0
1404 HIGH_COUNT_USED 3
1405 LOW_NUMBER_OF_BYTES_USED 0
1406 CURRENT_NUMBER_OF_BYTES_USED 0
1407 HIGH_NUMBER_OF_BYTES_USED 7099
1408 USER user2
1409 HOST localhost
1410 EVENT_NAME memory/sql/user_var_entry::value
1411 COUNT_ALLOC 3
1412 COUNT_FREE 0
1413 SUM_NUMBER_OF_BYTES_ALLOC 7099
1414 SUM_NUMBER_OF_BYTES_FREE 0
1415 LOW_COUNT_USED 0
1416 CURRENT_COUNT_USED 3
1417 HIGH_COUNT_USED 3
1418 LOW_NUMBER_OF_BYTES_USED 0
1419 CURRENT_NUMBER_OF_BYTES_USED 7099
1420 HIGH_NUMBER_OF_BYTES_USED 7099
1421 USER user3
1422 HOST localhost
1423 EVENT_NAME memory/sql/user_var_entry::value
1424 COUNT_ALLOC 3
1425 COUNT_FREE 0
1426 SUM_NUMBER_OF_BYTES_ALLOC 7099
1427 SUM_NUMBER_OF_BYTES_FREE 0
1428 LOW_COUNT_USED 0
1429 CURRENT_COUNT_USED 3
1430 HIGH_COUNT_USED 3
1431 LOW_NUMBER_OF_BYTES_USED 0
1432 CURRENT_NUMBER_OF_BYTES_USED 7099
1433 HIGH_NUMBER_OF_BYTES_USED 7099
1434 USER user4
1435 HOST localhost
1436 EVENT_NAME memory/sql/user_var_entry::value
1437 COUNT_ALLOC 6
1438 COUNT_FREE 3
1439 SUM_NUMBER_OF_BYTES_ALLOC 14198
1440 SUM_NUMBER_OF_BYTES_FREE 7099
1441 LOW_COUNT_USED 0
1442 CURRENT_COUNT_USED 3
1443 HIGH_COUNT_USED 6
1444 LOW_NUMBER_OF_BYTES_USED 0
1445 CURRENT_NUMBER_OF_BYTES_USED 7099
1446 HIGH_NUMBER_OF_BYTES_USED 14198
1447 execute dump_memory_user;
1448 USER user1
1449 EVENT_NAME memory/sql/user_var_entry::value
1450 COUNT_ALLOC 3
1451 COUNT_FREE 3
1452 SUM_NUMBER_OF_BYTES_ALLOC 7099
1453 SUM_NUMBER_OF_BYTES_FREE 7099
1454 LOW_COUNT_USED 0
1455 CURRENT_COUNT_USED 0
1456 HIGH_COUNT_USED 3
1457 LOW_NUMBER_OF_BYTES_USED 0
1458 CURRENT_NUMBER_OF_BYTES_USED 0
1459 HIGH_NUMBER_OF_BYTES_USED 7099
1460 USER user2
1461 EVENT_NAME memory/sql/user_var_entry::value
1462 COUNT_ALLOC 3
1463 COUNT_FREE 0
1464 SUM_NUMBER_OF_BYTES_ALLOC 7099
1465 SUM_NUMBER_OF_BYTES_FREE 0
1466 LOW_COUNT_USED 0
1467 CURRENT_COUNT_USED 3
1468 HIGH_COUNT_USED 3
1469 LOW_NUMBER_OF_BYTES_USED 0
1470 CURRENT_NUMBER_OF_BYTES_USED 7099
1471 HIGH_NUMBER_OF_BYTES_USED 7099
1472 USER user3
1473 EVENT_NAME memory/sql/user_var_entry::value
1474 COUNT_ALLOC 3
1475 COUNT_FREE 0
1476 SUM_NUMBER_OF_BYTES_ALLOC 7099
1477 SUM_NUMBER_OF_BYTES_FREE 0
1478 LOW_COUNT_USED 0
1479 CURRENT_COUNT_USED 3
1480 HIGH_COUNT_USED 3
1481 LOW_NUMBER_OF_BYTES_USED 0
1482 CURRENT_NUMBER_OF_BYTES_USED 7099
1483 HIGH_NUMBER_OF_BYTES_USED 7099
1484 USER user4
1485 EVENT_NAME memory/sql/user_var_entry::value
1486 COUNT_ALLOC 6
1487 COUNT_FREE 3
1488 SUM_NUMBER_OF_BYTES_ALLOC 14198
1489 SUM_NUMBER_OF_BYTES_FREE 7099
1490 LOW_COUNT_USED 0
1491 CURRENT_COUNT_USED 3
1492 HIGH_COUNT_USED 6
1493 LOW_NUMBER_OF_BYTES_USED 0
1494 CURRENT_NUMBER_OF_BYTES_USED 7099
1495 HIGH_NUMBER_OF_BYTES_USED 14198
1496 execute dump_memory_host;
1497 HOST localhost
1498 EVENT_NAME memory/sql/user_var_entry::value
1499 COUNT_ALLOC 15
1500 COUNT_FREE 6
1501 SUM_NUMBER_OF_BYTES_ALLOC 35495
1502 SUM_NUMBER_OF_BYTES_FREE 14198
1503 LOW_COUNT_USED 0
1504 CURRENT_COUNT_USED 9
1505 HIGH_COUNT_USED 15
1506 LOW_NUMBER_OF_BYTES_USED 0
1507 CURRENT_NUMBER_OF_BYTES_USED 21297
1508 HIGH_NUMBER_OF_BYTES_USED 35495
1509 execute dump_memory_global;
1510 EVENT_NAME memory/sql/user_var_entry::value
1511 COUNT_ALLOC 15
1512 COUNT_FREE 6
1513 SUM_NUMBER_OF_BYTES_ALLOC 35495
1514 SUM_NUMBER_OF_BYTES_FREE 14198
1515 LOW_COUNT_USED 0
1516 CURRENT_COUNT_USED 9
1517 HIGH_COUNT_USED 15
1518 LOW_NUMBER_OF_BYTES_USED 0
1519 CURRENT_NUMBER_OF_BYTES_USED 21297
1520 HIGH_NUMBER_OF_BYTES_USED 35495
1521 execute dump_accounts;
1522 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1523 event_scheduler localhost 1 1
1524 root localhost 1 1
1525 user1 localhost 0 1
1526 user2 localhost 1 1
1527 user3 localhost 1 1
1528 user4 localhost 1 2
1529 execute dump_users;
1530 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1531 event_scheduler 1 1
1532 root 1 1
1533 user1 0 1
1534 user2 1 1
1535 user3 1 1
1536 user4 1 2
1537 execute dump_hosts;
1538 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1539 localhost 5 7
1540 "================== con2 disconnected =================="
1541 "================== Step 11 =================="
1542 call dump_thread();
1543 username user1
1544 status not found
1545 username user2
1546 status not found
1547 username user3
1548 EVENT_NAME memory/sql/user_var_entry::value
1549 COUNT_ALLOC 3
1550 COUNT_FREE 0
1551 SUM_NUMBER_OF_BYTES_ALLOC 7099
1552 SUM_NUMBER_OF_BYTES_FREE 0
1553 LOW_COUNT_USED 0
1554 CURRENT_COUNT_USED 3
1555 HIGH_COUNT_USED 3
1556 LOW_NUMBER_OF_BYTES_USED 0
1557 CURRENT_NUMBER_OF_BYTES_USED 7099
1558 HIGH_NUMBER_OF_BYTES_USED 7099
1559 username user4
1560 EVENT_NAME memory/sql/user_var_entry::value
1561 COUNT_ALLOC 3
1562 COUNT_FREE 0
1563 SUM_NUMBER_OF_BYTES_ALLOC 7099
1564 SUM_NUMBER_OF_BYTES_FREE 0
1565 LOW_COUNT_USED 0
1566 CURRENT_COUNT_USED 3
1567 HIGH_COUNT_USED 3
1568 LOW_NUMBER_OF_BYTES_USED 0
1569 CURRENT_NUMBER_OF_BYTES_USED 7099
1570 HIGH_NUMBER_OF_BYTES_USED 7099
1571 execute dump_memory_account;
1572 USER user1
1573 HOST localhost
1574 EVENT_NAME memory/sql/user_var_entry::value
1575 COUNT_ALLOC 3
1576 COUNT_FREE 3
1577 SUM_NUMBER_OF_BYTES_ALLOC 7099
1578 SUM_NUMBER_OF_BYTES_FREE 7099
1579 LOW_COUNT_USED 0
1580 CURRENT_COUNT_USED 0
1581 HIGH_COUNT_USED 3
1582 LOW_NUMBER_OF_BYTES_USED 0
1583 CURRENT_NUMBER_OF_BYTES_USED 0
1584 HIGH_NUMBER_OF_BYTES_USED 7099
1585 USER user2
1586 HOST localhost
1587 EVENT_NAME memory/sql/user_var_entry::value
1588 COUNT_ALLOC 3
1589 COUNT_FREE 3
1590 SUM_NUMBER_OF_BYTES_ALLOC 7099
1591 SUM_NUMBER_OF_BYTES_FREE 7099
1592 LOW_COUNT_USED 0
1593 CURRENT_COUNT_USED 0
1594 HIGH_COUNT_USED 3
1595 LOW_NUMBER_OF_BYTES_USED 0
1596 CURRENT_NUMBER_OF_BYTES_USED 0
1597 HIGH_NUMBER_OF_BYTES_USED 7099
1598 USER user3
1599 HOST localhost
1600 EVENT_NAME memory/sql/user_var_entry::value
1601 COUNT_ALLOC 3
1602 COUNT_FREE 0
1603 SUM_NUMBER_OF_BYTES_ALLOC 7099
1604 SUM_NUMBER_OF_BYTES_FREE 0
1605 LOW_COUNT_USED 0
1606 CURRENT_COUNT_USED 3
1607 HIGH_COUNT_USED 3
1608 LOW_NUMBER_OF_BYTES_USED 0
1609 CURRENT_NUMBER_OF_BYTES_USED 7099
1610 HIGH_NUMBER_OF_BYTES_USED 7099
1611 USER user4
1612 HOST localhost
1613 EVENT_NAME memory/sql/user_var_entry::value
1614 COUNT_ALLOC 6
1615 COUNT_FREE 3
1616 SUM_NUMBER_OF_BYTES_ALLOC 14198
1617 SUM_NUMBER_OF_BYTES_FREE 7099
1618 LOW_COUNT_USED 0
1619 CURRENT_COUNT_USED 3
1620 HIGH_COUNT_USED 6
1621 LOW_NUMBER_OF_BYTES_USED 0
1622 CURRENT_NUMBER_OF_BYTES_USED 7099
1623 HIGH_NUMBER_OF_BYTES_USED 14198
1624 execute dump_memory_user;
1625 USER user1
1626 EVENT_NAME memory/sql/user_var_entry::value
1627 COUNT_ALLOC 3
1628 COUNT_FREE 3
1629 SUM_NUMBER_OF_BYTES_ALLOC 7099
1630 SUM_NUMBER_OF_BYTES_FREE 7099
1631 LOW_COUNT_USED 0
1632 CURRENT_COUNT_USED 0
1633 HIGH_COUNT_USED 3
1634 LOW_NUMBER_OF_BYTES_USED 0
1635 CURRENT_NUMBER_OF_BYTES_USED 0
1636 HIGH_NUMBER_OF_BYTES_USED 7099
1637 USER user2
1638 EVENT_NAME memory/sql/user_var_entry::value
1639 COUNT_ALLOC 3
1640 COUNT_FREE 3
1641 SUM_NUMBER_OF_BYTES_ALLOC 7099
1642 SUM_NUMBER_OF_BYTES_FREE 7099
1643 LOW_COUNT_USED 0
1644 CURRENT_COUNT_USED 0
1645 HIGH_COUNT_USED 3
1646 LOW_NUMBER_OF_BYTES_USED 0
1647 CURRENT_NUMBER_OF_BYTES_USED 0
1648 HIGH_NUMBER_OF_BYTES_USED 7099
1649 USER user3
1650 EVENT_NAME memory/sql/user_var_entry::value
1651 COUNT_ALLOC 3
1652 COUNT_FREE 0
1653 SUM_NUMBER_OF_BYTES_ALLOC 7099
1654 SUM_NUMBER_OF_BYTES_FREE 0
1655 LOW_COUNT_USED 0
1656 CURRENT_COUNT_USED 3
1657 HIGH_COUNT_USED 3
1658 LOW_NUMBER_OF_BYTES_USED 0
1659 CURRENT_NUMBER_OF_BYTES_USED 7099
1660 HIGH_NUMBER_OF_BYTES_USED 7099
1661 USER user4
1662 EVENT_NAME memory/sql/user_var_entry::value
1663 COUNT_ALLOC 6
1664 COUNT_FREE 3
1665 SUM_NUMBER_OF_BYTES_ALLOC 14198
1666 SUM_NUMBER_OF_BYTES_FREE 7099
1667 LOW_COUNT_USED 0
1668 CURRENT_COUNT_USED 3
1669 HIGH_COUNT_USED 6
1670 LOW_NUMBER_OF_BYTES_USED 0
1671 CURRENT_NUMBER_OF_BYTES_USED 7099
1672 HIGH_NUMBER_OF_BYTES_USED 14198
1673 execute dump_memory_host;
1674 HOST localhost
1675 EVENT_NAME memory/sql/user_var_entry::value
1676 COUNT_ALLOC 15
1677 COUNT_FREE 9
1678 SUM_NUMBER_OF_BYTES_ALLOC 35495
1679 SUM_NUMBER_OF_BYTES_FREE 21297
1680 LOW_COUNT_USED 0
1681 CURRENT_COUNT_USED 6
1682 HIGH_COUNT_USED 15
1683 LOW_NUMBER_OF_BYTES_USED 0
1684 CURRENT_NUMBER_OF_BYTES_USED 14198
1685 HIGH_NUMBER_OF_BYTES_USED 35495
1686 execute dump_memory_global;
1687 EVENT_NAME memory/sql/user_var_entry::value
1688 COUNT_ALLOC 15
1689 COUNT_FREE 9
1690 SUM_NUMBER_OF_BYTES_ALLOC 35495
1691 SUM_NUMBER_OF_BYTES_FREE 21297
1692 LOW_COUNT_USED 0
1693 CURRENT_COUNT_USED 6
1694 HIGH_COUNT_USED 15
1695 LOW_NUMBER_OF_BYTES_USED 0
1696 CURRENT_NUMBER_OF_BYTES_USED 14198
1697 HIGH_NUMBER_OF_BYTES_USED 35495
1698 execute dump_accounts;
1699 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1700 event_scheduler localhost 1 1
1701 root localhost 1 1
1702 user1 localhost 0 1
1703 user2 localhost 0 1
1704 user3 localhost 1 1
1705 user4 localhost 1 2
1706 execute dump_users;
1707 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1708 event_scheduler 1 1
1709 root 1 1
1710 user1 0 1
1711 user2 0 1
1712 user3 1 1
1713 user4 1 2
1714 execute dump_hosts;
1715 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1716 localhost 4 7
1717 "================== con3 disconnected =================="
1718 "================== Step 12 =================="
1719 call dump_thread();
1720 username user1
1721 status not found
1722 username user2
1723 status not found
1724 username user3
1725 status not found
1726 username user4
1727 EVENT_NAME memory/sql/user_var_entry::value
1728 COUNT_ALLOC 3
1729 COUNT_FREE 0
1730 SUM_NUMBER_OF_BYTES_ALLOC 7099
1731 SUM_NUMBER_OF_BYTES_FREE 0
1732 LOW_COUNT_USED 0
1733 CURRENT_COUNT_USED 3
1734 HIGH_COUNT_USED 3
1735 LOW_NUMBER_OF_BYTES_USED 0
1736 CURRENT_NUMBER_OF_BYTES_USED 7099
1737 HIGH_NUMBER_OF_BYTES_USED 7099
1738 execute dump_memory_account;
1739 USER user1
1740 HOST localhost
1741 EVENT_NAME memory/sql/user_var_entry::value
1742 COUNT_ALLOC 3
1743 COUNT_FREE 3
1744 SUM_NUMBER_OF_BYTES_ALLOC 7099
1745 SUM_NUMBER_OF_BYTES_FREE 7099
1746 LOW_COUNT_USED 0
1747 CURRENT_COUNT_USED 0
1748 HIGH_COUNT_USED 3
1749 LOW_NUMBER_OF_BYTES_USED 0
1750 CURRENT_NUMBER_OF_BYTES_USED 0
1751 HIGH_NUMBER_OF_BYTES_USED 7099
1752 USER user2
1753 HOST localhost
1754 EVENT_NAME memory/sql/user_var_entry::value
1755 COUNT_ALLOC 3
1756 COUNT_FREE 3
1757 SUM_NUMBER_OF_BYTES_ALLOC 7099
1758 SUM_NUMBER_OF_BYTES_FREE 7099
1759 LOW_COUNT_USED 0
1760 CURRENT_COUNT_USED 0
1761 HIGH_COUNT_USED 3
1762 LOW_NUMBER_OF_BYTES_USED 0
1763 CURRENT_NUMBER_OF_BYTES_USED 0
1764 HIGH_NUMBER_OF_BYTES_USED 7099
1765 USER user3
1766 HOST localhost
1767 EVENT_NAME memory/sql/user_var_entry::value
1768 COUNT_ALLOC 3
1769 COUNT_FREE 3
1770 SUM_NUMBER_OF_BYTES_ALLOC 7099
1771 SUM_NUMBER_OF_BYTES_FREE 7099
1772 LOW_COUNT_USED 0
1773 CURRENT_COUNT_USED 0
1774 HIGH_COUNT_USED 3
1775 LOW_NUMBER_OF_BYTES_USED 0
1776 CURRENT_NUMBER_OF_BYTES_USED 0
1777 HIGH_NUMBER_OF_BYTES_USED 7099
1778 USER user4
1779 HOST localhost
1780 EVENT_NAME memory/sql/user_var_entry::value
1781 COUNT_ALLOC 6
1782 COUNT_FREE 3
1783 SUM_NUMBER_OF_BYTES_ALLOC 14198
1784 SUM_NUMBER_OF_BYTES_FREE 7099
1785 LOW_COUNT_USED 0
1786 CURRENT_COUNT_USED 3
1787 HIGH_COUNT_USED 6
1788 LOW_NUMBER_OF_BYTES_USED 0
1789 CURRENT_NUMBER_OF_BYTES_USED 7099
1790 HIGH_NUMBER_OF_BYTES_USED 14198
1791 execute dump_memory_user;
1792 USER user1
1793 EVENT_NAME memory/sql/user_var_entry::value
1794 COUNT_ALLOC 3
1795 COUNT_FREE 3
1796 SUM_NUMBER_OF_BYTES_ALLOC 7099
1797 SUM_NUMBER_OF_BYTES_FREE 7099
1798 LOW_COUNT_USED 0
1799 CURRENT_COUNT_USED 0
1800 HIGH_COUNT_USED 3
1801 LOW_NUMBER_OF_BYTES_USED 0
1802 CURRENT_NUMBER_OF_BYTES_USED 0
1803 HIGH_NUMBER_OF_BYTES_USED 7099
1804 USER user2
1805 EVENT_NAME memory/sql/user_var_entry::value
1806 COUNT_ALLOC 3
1807 COUNT_FREE 3
1808 SUM_NUMBER_OF_BYTES_ALLOC 7099
1809 SUM_NUMBER_OF_BYTES_FREE 7099
1810 LOW_COUNT_USED 0
1811 CURRENT_COUNT_USED 0
1812 HIGH_COUNT_USED 3
1813 LOW_NUMBER_OF_BYTES_USED 0
1814 CURRENT_NUMBER_OF_BYTES_USED 0
1815 HIGH_NUMBER_OF_BYTES_USED 7099
1816 USER user3
1817 EVENT_NAME memory/sql/user_var_entry::value
1818 COUNT_ALLOC 3
1819 COUNT_FREE 3
1820 SUM_NUMBER_OF_BYTES_ALLOC 7099
1821 SUM_NUMBER_OF_BYTES_FREE 7099
1822 LOW_COUNT_USED 0
1823 CURRENT_COUNT_USED 0
1824 HIGH_COUNT_USED 3
1825 LOW_NUMBER_OF_BYTES_USED 0
1826 CURRENT_NUMBER_OF_BYTES_USED 0
1827 HIGH_NUMBER_OF_BYTES_USED 7099
1828 USER user4
1829 EVENT_NAME memory/sql/user_var_entry::value
1830 COUNT_ALLOC 6
1831 COUNT_FREE 3
1832 SUM_NUMBER_OF_BYTES_ALLOC 14198
1833 SUM_NUMBER_OF_BYTES_FREE 7099
1834 LOW_COUNT_USED 0
1835 CURRENT_COUNT_USED 3
1836 HIGH_COUNT_USED 6
1837 LOW_NUMBER_OF_BYTES_USED 0
1838 CURRENT_NUMBER_OF_BYTES_USED 7099
1839 HIGH_NUMBER_OF_BYTES_USED 14198
1840 execute dump_memory_host;
1841 HOST localhost
1842 EVENT_NAME memory/sql/user_var_entry::value
1843 COUNT_ALLOC 15
1844 COUNT_FREE 12
1845 SUM_NUMBER_OF_BYTES_ALLOC 35495
1846 SUM_NUMBER_OF_BYTES_FREE 28396
1847 LOW_COUNT_USED 0
1848 CURRENT_COUNT_USED 3
1849 HIGH_COUNT_USED 15
1850 LOW_NUMBER_OF_BYTES_USED 0
1851 CURRENT_NUMBER_OF_BYTES_USED 7099
1852 HIGH_NUMBER_OF_BYTES_USED 35495
1853 execute dump_memory_global;
1854 EVENT_NAME memory/sql/user_var_entry::value
1855 COUNT_ALLOC 15
1856 COUNT_FREE 12
1857 SUM_NUMBER_OF_BYTES_ALLOC 35495
1858 SUM_NUMBER_OF_BYTES_FREE 28396
1859 LOW_COUNT_USED 0
1860 CURRENT_COUNT_USED 3
1861 HIGH_COUNT_USED 15
1862 LOW_NUMBER_OF_BYTES_USED 0
1863 CURRENT_NUMBER_OF_BYTES_USED 7099
1864 HIGH_NUMBER_OF_BYTES_USED 35495
1865 execute dump_accounts;
1866 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1867 event_scheduler localhost 1 1
1868 root localhost 1 1
1869 user1 localhost 0 1
1870 user2 localhost 0 1
1871 user3 localhost 0 1
1872 user4 localhost 1 2
1873 execute dump_users;
1874 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1875 event_scheduler 1 1
1876 root 1 1
1877 user1 0 1
1878 user2 0 1
1879 user3 0 1
1880 user4 1 2
1881 execute dump_hosts;
1882 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1883 localhost 3 7
1884 "================== con4 disconnected =================="
1885 "================== Step 13 =================="
1886 call dump_thread();
1887 username user1
1888 status not found
1889 username user2
1890 status not found
1891 username user3
1892 status not found
1893 username user4
1894 status not found
1895 execute dump_memory_account;
1896 USER user1
1897 HOST localhost
1898 EVENT_NAME memory/sql/user_var_entry::value
1899 COUNT_ALLOC 3
1900 COUNT_FREE 3
1901 SUM_NUMBER_OF_BYTES_ALLOC 7099
1902 SUM_NUMBER_OF_BYTES_FREE 7099
1903 LOW_COUNT_USED 0
1904 CURRENT_COUNT_USED 0
1905 HIGH_COUNT_USED 3
1906 LOW_NUMBER_OF_BYTES_USED 0
1907 CURRENT_NUMBER_OF_BYTES_USED 0
1908 HIGH_NUMBER_OF_BYTES_USED 7099
1909 USER user2
1910 HOST localhost
1911 EVENT_NAME memory/sql/user_var_entry::value
1912 COUNT_ALLOC 3
1913 COUNT_FREE 3
1914 SUM_NUMBER_OF_BYTES_ALLOC 7099
1915 SUM_NUMBER_OF_BYTES_FREE 7099
1916 LOW_COUNT_USED 0
1917 CURRENT_COUNT_USED 0
1918 HIGH_COUNT_USED 3
1919 LOW_NUMBER_OF_BYTES_USED 0
1920 CURRENT_NUMBER_OF_BYTES_USED 0
1921 HIGH_NUMBER_OF_BYTES_USED 7099
1922 USER user3
1923 HOST localhost
1924 EVENT_NAME memory/sql/user_var_entry::value
1925 COUNT_ALLOC 3
1926 COUNT_FREE 3
1927 SUM_NUMBER_OF_BYTES_ALLOC 7099
1928 SUM_NUMBER_OF_BYTES_FREE 7099
1929 LOW_COUNT_USED 0
1930 CURRENT_COUNT_USED 0
1931 HIGH_COUNT_USED 3
1932 LOW_NUMBER_OF_BYTES_USED 0
1933 CURRENT_NUMBER_OF_BYTES_USED 0
1934 HIGH_NUMBER_OF_BYTES_USED 7099
1935 USER user4
1936 HOST localhost
1937 EVENT_NAME memory/sql/user_var_entry::value
1938 COUNT_ALLOC 6
1939 COUNT_FREE 6
1940 SUM_NUMBER_OF_BYTES_ALLOC 14198
1941 SUM_NUMBER_OF_BYTES_FREE 14198
1942 LOW_COUNT_USED 0
1943 CURRENT_COUNT_USED 0
1944 HIGH_COUNT_USED 6
1945 LOW_NUMBER_OF_BYTES_USED 0
1946 CURRENT_NUMBER_OF_BYTES_USED 0
1947 HIGH_NUMBER_OF_BYTES_USED 14198
1948 execute dump_memory_user;
1949 USER user1
1950 EVENT_NAME memory/sql/user_var_entry::value
1951 COUNT_ALLOC 3
1952 COUNT_FREE 3
1953 SUM_NUMBER_OF_BYTES_ALLOC 7099
1954 SUM_NUMBER_OF_BYTES_FREE 7099
1955 LOW_COUNT_USED 0
1956 CURRENT_COUNT_USED 0
1957 HIGH_COUNT_USED 3
1958 LOW_NUMBER_OF_BYTES_USED 0
1959 CURRENT_NUMBER_OF_BYTES_USED 0
1960 HIGH_NUMBER_OF_BYTES_USED 7099
1961 USER user2
1962 EVENT_NAME memory/sql/user_var_entry::value
1963 COUNT_ALLOC 3
1964 COUNT_FREE 3
1965 SUM_NUMBER_OF_BYTES_ALLOC 7099
1966 SUM_NUMBER_OF_BYTES_FREE 7099
1967 LOW_COUNT_USED 0
1968 CURRENT_COUNT_USED 0
1969 HIGH_COUNT_USED 3
1970 LOW_NUMBER_OF_BYTES_USED 0
1971 CURRENT_NUMBER_OF_BYTES_USED 0
1972 HIGH_NUMBER_OF_BYTES_USED 7099
1973 USER user3
1974 EVENT_NAME memory/sql/user_var_entry::value
1975 COUNT_ALLOC 3
1976 COUNT_FREE 3
1977 SUM_NUMBER_OF_BYTES_ALLOC 7099
1978 SUM_NUMBER_OF_BYTES_FREE 7099
1979 LOW_COUNT_USED 0
1980 CURRENT_COUNT_USED 0
1981 HIGH_COUNT_USED 3
1982 LOW_NUMBER_OF_BYTES_USED 0
1983 CURRENT_NUMBER_OF_BYTES_USED 0
1984 HIGH_NUMBER_OF_BYTES_USED 7099
1985 USER user4
1986 EVENT_NAME memory/sql/user_var_entry::value
1987 COUNT_ALLOC 6
1988 COUNT_FREE 6
1989 SUM_NUMBER_OF_BYTES_ALLOC 14198
1990 SUM_NUMBER_OF_BYTES_FREE 14198
1991 LOW_COUNT_USED 0
1992 CURRENT_COUNT_USED 0
1993 HIGH_COUNT_USED 6
1994 LOW_NUMBER_OF_BYTES_USED 0
1995 CURRENT_NUMBER_OF_BYTES_USED 0
1996 HIGH_NUMBER_OF_BYTES_USED 14198
1997 execute dump_memory_host;
1998 HOST localhost
1999 EVENT_NAME memory/sql/user_var_entry::value
2000 COUNT_ALLOC 15
2001 COUNT_FREE 15
2002 SUM_NUMBER_OF_BYTES_ALLOC 35495
2003 SUM_NUMBER_OF_BYTES_FREE 35495
2004 LOW_COUNT_USED 0
2005 CURRENT_COUNT_USED 0
2006 HIGH_COUNT_USED 15
2007 LOW_NUMBER_OF_BYTES_USED 0
2008 CURRENT_NUMBER_OF_BYTES_USED 0
2009 HIGH_NUMBER_OF_BYTES_USED 35495
2010 execute dump_memory_global;
2011 EVENT_NAME memory/sql/user_var_entry::value
2012 COUNT_ALLOC 15
2013 COUNT_FREE 15
2014 SUM_NUMBER_OF_BYTES_ALLOC 35495
2015 SUM_NUMBER_OF_BYTES_FREE 35495
2016 LOW_COUNT_USED 0
2017 CURRENT_COUNT_USED 0
2018 HIGH_COUNT_USED 15
2019 LOW_NUMBER_OF_BYTES_USED 0
2020 CURRENT_NUMBER_OF_BYTES_USED 0
2021 HIGH_NUMBER_OF_BYTES_USED 35495
2022 execute dump_accounts;
2023 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2024 event_scheduler localhost 1 1
2025 root localhost 1 1
2026 user1 localhost 0 1
2027 user2 localhost 0 1
2028 user3 localhost 0 1
2029 user4 localhost 0 2
2030 execute dump_users;
2031 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2032 event_scheduler 1 1
2033 root 1 1
2034 user1 0 1
2035 user2 0 1
2036 user3 0 1
2037 user4 0 2
2038 execute dump_hosts;
2039 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2040 localhost 2 7
2041 truncate performance_schema.memory_summary_by_thread_by_event_name;
2042 "================== MEMORY_BY_THREAD truncated =================="
2043 "================== Step 14 =================="
2044 call dump_thread();
2045 username user1
2046 status not found
2047 username user2
2048 status not found
2049 username user3
2050 status not found
2051 username user4
2052 status not found
2053 execute dump_memory_account;
2054 USER user1
2055 HOST localhost
2056 EVENT_NAME memory/sql/user_var_entry::value
2057 COUNT_ALLOC 3
2058 COUNT_FREE 3
2059 SUM_NUMBER_OF_BYTES_ALLOC 7099
2060 SUM_NUMBER_OF_BYTES_FREE 7099
2061 LOW_COUNT_USED 0
2062 CURRENT_COUNT_USED 0
2063 HIGH_COUNT_USED 3
2064 LOW_NUMBER_OF_BYTES_USED 0
2065 CURRENT_NUMBER_OF_BYTES_USED 0
2066 HIGH_NUMBER_OF_BYTES_USED 7099
2067 USER user2
2068 HOST localhost
2069 EVENT_NAME memory/sql/user_var_entry::value
2070 COUNT_ALLOC 3
2071 COUNT_FREE 3
2072 SUM_NUMBER_OF_BYTES_ALLOC 7099
2073 SUM_NUMBER_OF_BYTES_FREE 7099
2074 LOW_COUNT_USED 0
2075 CURRENT_COUNT_USED 0
2076 HIGH_COUNT_USED 3
2077 LOW_NUMBER_OF_BYTES_USED 0
2078 CURRENT_NUMBER_OF_BYTES_USED 0
2079 HIGH_NUMBER_OF_BYTES_USED 7099
2080 USER user3
2081 HOST localhost
2082 EVENT_NAME memory/sql/user_var_entry::value
2083 COUNT_ALLOC 3
2084 COUNT_FREE 3
2085 SUM_NUMBER_OF_BYTES_ALLOC 7099
2086 SUM_NUMBER_OF_BYTES_FREE 7099
2087 LOW_COUNT_USED 0
2088 CURRENT_COUNT_USED 0
2089 HIGH_COUNT_USED 3
2090 LOW_NUMBER_OF_BYTES_USED 0
2091 CURRENT_NUMBER_OF_BYTES_USED 0
2092 HIGH_NUMBER_OF_BYTES_USED 7099
2093 USER user4
2094 HOST localhost
2095 EVENT_NAME memory/sql/user_var_entry::value
2096 COUNT_ALLOC 6
2097 COUNT_FREE 6
2098 SUM_NUMBER_OF_BYTES_ALLOC 14198
2099 SUM_NUMBER_OF_BYTES_FREE 14198
2100 LOW_COUNT_USED 0
2101 CURRENT_COUNT_USED 0
2102 HIGH_COUNT_USED 6
2103 LOW_NUMBER_OF_BYTES_USED 0
2104 CURRENT_NUMBER_OF_BYTES_USED 0
2105 HIGH_NUMBER_OF_BYTES_USED 14198
2106 execute dump_memory_user;
2107 USER user1
2108 EVENT_NAME memory/sql/user_var_entry::value
2109 COUNT_ALLOC 3
2110 COUNT_FREE 3
2111 SUM_NUMBER_OF_BYTES_ALLOC 7099
2112 SUM_NUMBER_OF_BYTES_FREE 7099
2113 LOW_COUNT_USED 0
2114 CURRENT_COUNT_USED 0
2115 HIGH_COUNT_USED 3
2116 LOW_NUMBER_OF_BYTES_USED 0
2117 CURRENT_NUMBER_OF_BYTES_USED 0
2118 HIGH_NUMBER_OF_BYTES_USED 7099
2119 USER user2
2120 EVENT_NAME memory/sql/user_var_entry::value
2121 COUNT_ALLOC 3
2122 COUNT_FREE 3
2123 SUM_NUMBER_OF_BYTES_ALLOC 7099
2124 SUM_NUMBER_OF_BYTES_FREE 7099
2125 LOW_COUNT_USED 0
2126 CURRENT_COUNT_USED 0
2127 HIGH_COUNT_USED 3
2128 LOW_NUMBER_OF_BYTES_USED 0
2129 CURRENT_NUMBER_OF_BYTES_USED 0
2130 HIGH_NUMBER_OF_BYTES_USED 7099
2131 USER user3
2132 EVENT_NAME memory/sql/user_var_entry::value
2133 COUNT_ALLOC 3
2134 COUNT_FREE 3
2135 SUM_NUMBER_OF_BYTES_ALLOC 7099
2136 SUM_NUMBER_OF_BYTES_FREE 7099
2137 LOW_COUNT_USED 0
2138 CURRENT_COUNT_USED 0
2139 HIGH_COUNT_USED 3
2140 LOW_NUMBER_OF_BYTES_USED 0
2141 CURRENT_NUMBER_OF_BYTES_USED 0
2142 HIGH_NUMBER_OF_BYTES_USED 7099
2143 USER user4
2144 EVENT_NAME memory/sql/user_var_entry::value
2145 COUNT_ALLOC 6
2146 COUNT_FREE 6
2147 SUM_NUMBER_OF_BYTES_ALLOC 14198
2148 SUM_NUMBER_OF_BYTES_FREE 14198
2149 LOW_COUNT_USED 0
2150 CURRENT_COUNT_USED 0
2151 HIGH_COUNT_USED 6
2152 LOW_NUMBER_OF_BYTES_USED 0
2153 CURRENT_NUMBER_OF_BYTES_USED 0
2154 HIGH_NUMBER_OF_BYTES_USED 14198
2155 execute dump_memory_host;
2156 HOST localhost
2157 EVENT_NAME memory/sql/user_var_entry::value
2158 COUNT_ALLOC 15
2159 COUNT_FREE 15
2160 SUM_NUMBER_OF_BYTES_ALLOC 35495
2161 SUM_NUMBER_OF_BYTES_FREE 35495
2162 LOW_COUNT_USED 0
2163 CURRENT_COUNT_USED 0
2164 HIGH_COUNT_USED 15
2165 LOW_NUMBER_OF_BYTES_USED 0
2166 CURRENT_NUMBER_OF_BYTES_USED 0
2167 HIGH_NUMBER_OF_BYTES_USED 35495
2168 execute dump_memory_global;
2169 EVENT_NAME memory/sql/user_var_entry::value
2170 COUNT_ALLOC 15
2171 COUNT_FREE 15
2172 SUM_NUMBER_OF_BYTES_ALLOC 35495
2173 SUM_NUMBER_OF_BYTES_FREE 35495
2174 LOW_COUNT_USED 0
2175 CURRENT_COUNT_USED 0
2176 HIGH_COUNT_USED 15
2177 LOW_NUMBER_OF_BYTES_USED 0
2178 CURRENT_NUMBER_OF_BYTES_USED 0
2179 HIGH_NUMBER_OF_BYTES_USED 35495
2180 execute dump_accounts;
2181 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2182 event_scheduler localhost 1 1
2183 root localhost 1 1
2184 user1 localhost 0 1
2185 user2 localhost 0 1
2186 user3 localhost 0 1
2187 user4 localhost 0 2
2188 execute dump_users;
2189 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2190 event_scheduler 1 1
2191 root 1 1
2192 user1 0 1
2193 user2 0 1
2194 user3 0 1
2195 user4 0 2
2196 execute dump_hosts;
2197 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2198 localhost 2 7
2199 truncate performance_schema.memory_summary_by_account_by_event_name;
2200 "================== MEMORY_BY_ACCOUNT truncated =================="
2201 "================== Step 15 =================="
2202 call dump_thread();
2203 username user1
2204 status not found
2205 username user2
2206 status not found
2207 username user3
2208 status not found
2209 username user4
2210 status not found
2211 execute dump_memory_account;
2212 USER user1
2213 HOST localhost
2214 EVENT_NAME memory/sql/user_var_entry::value
2215 COUNT_ALLOC 0
2216 COUNT_FREE 0
2217 SUM_NUMBER_OF_BYTES_ALLOC 0
2218 SUM_NUMBER_OF_BYTES_FREE 0
2219 LOW_COUNT_USED 0
2220 CURRENT_COUNT_USED 0
2221 HIGH_COUNT_USED 0
2222 LOW_NUMBER_OF_BYTES_USED 0
2223 CURRENT_NUMBER_OF_BYTES_USED 0
2224 HIGH_NUMBER_OF_BYTES_USED 0
2225 USER user2
2226 HOST localhost
2227 EVENT_NAME memory/sql/user_var_entry::value
2228 COUNT_ALLOC 0
2229 COUNT_FREE 0
2230 SUM_NUMBER_OF_BYTES_ALLOC 0
2231 SUM_NUMBER_OF_BYTES_FREE 0
2232 LOW_COUNT_USED 0
2233 CURRENT_COUNT_USED 0
2234 HIGH_COUNT_USED 0
2235 LOW_NUMBER_OF_BYTES_USED 0
2236 CURRENT_NUMBER_OF_BYTES_USED 0
2237 HIGH_NUMBER_OF_BYTES_USED 0
2238 USER user3
2239 HOST localhost
2240 EVENT_NAME memory/sql/user_var_entry::value
2241 COUNT_ALLOC 0
2242 COUNT_FREE 0
2243 SUM_NUMBER_OF_BYTES_ALLOC 0
2244 SUM_NUMBER_OF_BYTES_FREE 0
2245 LOW_COUNT_USED 0
2246 CURRENT_COUNT_USED 0
2247 HIGH_COUNT_USED 0
2248 LOW_NUMBER_OF_BYTES_USED 0
2249 CURRENT_NUMBER_OF_BYTES_USED 0
2250 HIGH_NUMBER_OF_BYTES_USED 0
2251 USER user4
2252 HOST localhost
2253 EVENT_NAME memory/sql/user_var_entry::value
2254 COUNT_ALLOC 0
2255 COUNT_FREE 0
2256 SUM_NUMBER_OF_BYTES_ALLOC 0
2257 SUM_NUMBER_OF_BYTES_FREE 0
2258 LOW_COUNT_USED 0
2259 CURRENT_COUNT_USED 0
2260 HIGH_COUNT_USED 0
2261 LOW_NUMBER_OF_BYTES_USED 0
2262 CURRENT_NUMBER_OF_BYTES_USED 0
2263 HIGH_NUMBER_OF_BYTES_USED 0
2264 execute dump_memory_user;
2265 USER user1
2266 EVENT_NAME memory/sql/user_var_entry::value
2267 COUNT_ALLOC 3
2268 COUNT_FREE 3
2269 SUM_NUMBER_OF_BYTES_ALLOC 7099
2270 SUM_NUMBER_OF_BYTES_FREE 7099
2271 LOW_COUNT_USED 0
2272 CURRENT_COUNT_USED 0
2273 HIGH_COUNT_USED 3
2274 LOW_NUMBER_OF_BYTES_USED 0
2275 CURRENT_NUMBER_OF_BYTES_USED 0
2276 HIGH_NUMBER_OF_BYTES_USED 7099
2277 USER user2
2278 EVENT_NAME memory/sql/user_var_entry::value
2279 COUNT_ALLOC 3
2280 COUNT_FREE 3
2281 SUM_NUMBER_OF_BYTES_ALLOC 7099
2282 SUM_NUMBER_OF_BYTES_FREE 7099
2283 LOW_COUNT_USED 0
2284 CURRENT_COUNT_USED 0
2285 HIGH_COUNT_USED 3
2286 LOW_NUMBER_OF_BYTES_USED 0
2287 CURRENT_NUMBER_OF_BYTES_USED 0
2288 HIGH_NUMBER_OF_BYTES_USED 7099
2289 USER user3
2290 EVENT_NAME memory/sql/user_var_entry::value
2291 COUNT_ALLOC 3
2292 COUNT_FREE 3
2293 SUM_NUMBER_OF_BYTES_ALLOC 7099
2294 SUM_NUMBER_OF_BYTES_FREE 7099
2295 LOW_COUNT_USED 0
2296 CURRENT_COUNT_USED 0
2297 HIGH_COUNT_USED 3
2298 LOW_NUMBER_OF_BYTES_USED 0
2299 CURRENT_NUMBER_OF_BYTES_USED 0
2300 HIGH_NUMBER_OF_BYTES_USED 7099
2301 USER user4
2302 EVENT_NAME memory/sql/user_var_entry::value
2303 COUNT_ALLOC 6
2304 COUNT_FREE 6
2305 SUM_NUMBER_OF_BYTES_ALLOC 14198
2306 SUM_NUMBER_OF_BYTES_FREE 14198
2307 LOW_COUNT_USED 0
2308 CURRENT_COUNT_USED 0
2309 HIGH_COUNT_USED 6
2310 LOW_NUMBER_OF_BYTES_USED 0
2311 CURRENT_NUMBER_OF_BYTES_USED 0
2312 HIGH_NUMBER_OF_BYTES_USED 14198
2313 execute dump_memory_host;
2314 HOST localhost
2315 EVENT_NAME memory/sql/user_var_entry::value
2316 COUNT_ALLOC 15
2317 COUNT_FREE 15
2318 SUM_NUMBER_OF_BYTES_ALLOC 35495
2319 SUM_NUMBER_OF_BYTES_FREE 35495
2320 LOW_COUNT_USED 0
2321 CURRENT_COUNT_USED 0
2322 HIGH_COUNT_USED 15
2323 LOW_NUMBER_OF_BYTES_USED 0
2324 CURRENT_NUMBER_OF_BYTES_USED 0
2325 HIGH_NUMBER_OF_BYTES_USED 35495
2326 execute dump_memory_global;
2327 EVENT_NAME memory/sql/user_var_entry::value
2328 COUNT_ALLOC 15
2329 COUNT_FREE 15
2330 SUM_NUMBER_OF_BYTES_ALLOC 35495
2331 SUM_NUMBER_OF_BYTES_FREE 35495
2332 LOW_COUNT_USED 0
2333 CURRENT_COUNT_USED 0
2334 HIGH_COUNT_USED 15
2335 LOW_NUMBER_OF_BYTES_USED 0
2336 CURRENT_NUMBER_OF_BYTES_USED 0
2337 HIGH_NUMBER_OF_BYTES_USED 35495
2338 execute dump_accounts;
2339 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2340 event_scheduler localhost 1 1
2341 root localhost 1 1
2342 user1 localhost 0 1
2343 user2 localhost 0 1
2344 user3 localhost 0 1
2345 user4 localhost 0 2
2346 execute dump_users;
2347 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2348 event_scheduler 1 1
2349 root 1 1
2350 user1 0 1
2351 user2 0 1
2352 user3 0 1
2353 user4 0 2
2354 execute dump_hosts;
2355 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2356 localhost 2 7
2357 truncate performance_schema.memory_summary_by_user_by_event_name;
2358 "================== MEMORY_BY_USER truncated =================="
2359 "================== Step 16 =================="
2360 call dump_thread();
2361 username user1
2362 status not found
2363 username user2
2364 status not found
2365 username user3
2366 status not found
2367 username user4
2368 status not found
2369 execute dump_memory_account;
2370 USER user1
2371 HOST localhost
2372 EVENT_NAME memory/sql/user_var_entry::value
2373 COUNT_ALLOC 0
2374 COUNT_FREE 0
2375 SUM_NUMBER_OF_BYTES_ALLOC 0
2376 SUM_NUMBER_OF_BYTES_FREE 0
2377 LOW_COUNT_USED 0
2378 CURRENT_COUNT_USED 0
2379 HIGH_COUNT_USED 0
2380 LOW_NUMBER_OF_BYTES_USED 0
2381 CURRENT_NUMBER_OF_BYTES_USED 0
2382 HIGH_NUMBER_OF_BYTES_USED 0
2383 USER user2
2384 HOST localhost
2385 EVENT_NAME memory/sql/user_var_entry::value
2386 COUNT_ALLOC 0
2387 COUNT_FREE 0
2388 SUM_NUMBER_OF_BYTES_ALLOC 0
2389 SUM_NUMBER_OF_BYTES_FREE 0
2390 LOW_COUNT_USED 0
2391 CURRENT_COUNT_USED 0
2392 HIGH_COUNT_USED 0
2393 LOW_NUMBER_OF_BYTES_USED 0
2394 CURRENT_NUMBER_OF_BYTES_USED 0
2395 HIGH_NUMBER_OF_BYTES_USED 0
2396 USER user3
2397 HOST localhost
2398 EVENT_NAME memory/sql/user_var_entry::value
2399 COUNT_ALLOC 0
2400 COUNT_FREE 0
2401 SUM_NUMBER_OF_BYTES_ALLOC 0
2402 SUM_NUMBER_OF_BYTES_FREE 0
2403 LOW_COUNT_USED 0
2404 CURRENT_COUNT_USED 0
2405 HIGH_COUNT_USED 0
2406 LOW_NUMBER_OF_BYTES_USED 0
2407 CURRENT_NUMBER_OF_BYTES_USED 0
2408 HIGH_NUMBER_OF_BYTES_USED 0
2409 USER user4
2410 HOST localhost
2411 EVENT_NAME memory/sql/user_var_entry::value
2412 COUNT_ALLOC 0
2413 COUNT_FREE 0
2414 SUM_NUMBER_OF_BYTES_ALLOC 0
2415 SUM_NUMBER_OF_BYTES_FREE 0
2416 LOW_COUNT_USED 0
2417 CURRENT_COUNT_USED 0
2418 HIGH_COUNT_USED 0
2419 LOW_NUMBER_OF_BYTES_USED 0
2420 CURRENT_NUMBER_OF_BYTES_USED 0
2421 HIGH_NUMBER_OF_BYTES_USED 0
2422 execute dump_memory_user;
2423 USER user1
2424 EVENT_NAME memory/sql/user_var_entry::value
2425 COUNT_ALLOC 0
2426 COUNT_FREE 0
2427 SUM_NUMBER_OF_BYTES_ALLOC 0
2428 SUM_NUMBER_OF_BYTES_FREE 0
2429 LOW_COUNT_USED 0
2430 CURRENT_COUNT_USED 0
2431 HIGH_COUNT_USED 0
2432 LOW_NUMBER_OF_BYTES_USED 0
2433 CURRENT_NUMBER_OF_BYTES_USED 0
2434 HIGH_NUMBER_OF_BYTES_USED 0
2435 USER user2
2436 EVENT_NAME memory/sql/user_var_entry::value
2437 COUNT_ALLOC 0
2438 COUNT_FREE 0
2439 SUM_NUMBER_OF_BYTES_ALLOC 0
2440 SUM_NUMBER_OF_BYTES_FREE 0
2441 LOW_COUNT_USED 0
2442 CURRENT_COUNT_USED 0
2443 HIGH_COUNT_USED 0
2444 LOW_NUMBER_OF_BYTES_USED 0
2445 CURRENT_NUMBER_OF_BYTES_USED 0
2446 HIGH_NUMBER_OF_BYTES_USED 0
2447 USER user3
2448 EVENT_NAME memory/sql/user_var_entry::value
2449 COUNT_ALLOC 0
2450 COUNT_FREE 0
2451 SUM_NUMBER_OF_BYTES_ALLOC 0
2452 SUM_NUMBER_OF_BYTES_FREE 0
2453 LOW_COUNT_USED 0
2454 CURRENT_COUNT_USED 0
2455 HIGH_COUNT_USED 0
2456 LOW_NUMBER_OF_BYTES_USED 0
2457 CURRENT_NUMBER_OF_BYTES_USED 0
2458 HIGH_NUMBER_OF_BYTES_USED 0
2459 USER user4
2460 EVENT_NAME memory/sql/user_var_entry::value
2461 COUNT_ALLOC 0
2462 COUNT_FREE 0
2463 SUM_NUMBER_OF_BYTES_ALLOC 0
2464 SUM_NUMBER_OF_BYTES_FREE 0
2465 LOW_COUNT_USED 0
2466 CURRENT_COUNT_USED 0
2467 HIGH_COUNT_USED 0
2468 LOW_NUMBER_OF_BYTES_USED 0
2469 CURRENT_NUMBER_OF_BYTES_USED 0
2470 HIGH_NUMBER_OF_BYTES_USED 0
2471 execute dump_memory_host;
2472 HOST localhost
2473 EVENT_NAME memory/sql/user_var_entry::value
2474 COUNT_ALLOC 15
2475 COUNT_FREE 15
2476 SUM_NUMBER_OF_BYTES_ALLOC 35495
2477 SUM_NUMBER_OF_BYTES_FREE 35495
2478 LOW_COUNT_USED 0
2479 CURRENT_COUNT_USED 0
2480 HIGH_COUNT_USED 15
2481 LOW_NUMBER_OF_BYTES_USED 0
2482 CURRENT_NUMBER_OF_BYTES_USED 0
2483 HIGH_NUMBER_OF_BYTES_USED 35495
2484 execute dump_memory_global;
2485 EVENT_NAME memory/sql/user_var_entry::value
2486 COUNT_ALLOC 15
2487 COUNT_FREE 15
2488 SUM_NUMBER_OF_BYTES_ALLOC 35495
2489 SUM_NUMBER_OF_BYTES_FREE 35495
2490 LOW_COUNT_USED 0
2491 CURRENT_COUNT_USED 0
2492 HIGH_COUNT_USED 15
2493 LOW_NUMBER_OF_BYTES_USED 0
2494 CURRENT_NUMBER_OF_BYTES_USED 0
2495 HIGH_NUMBER_OF_BYTES_USED 35495
2496 execute dump_accounts;
2497 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2498 event_scheduler localhost 1 1
2499 root localhost 1 1
2500 user1 localhost 0 1
2501 user2 localhost 0 1
2502 user3 localhost 0 1
2503 user4 localhost 0 2
2504 execute dump_users;
2505 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2506 event_scheduler 1 1
2507 root 1 1
2508 user1 0 1
2509 user2 0 1
2510 user3 0 1
2511 user4 0 2
2512 execute dump_hosts;
2513 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2514 localhost 2 7
2515 truncate performance_schema.memory_summary_by_host_by_event_name;
2516 "================== MEMORY_BY_HOST truncated =================="
2517 "================== Step 17 =================="
2518 call dump_thread();
2519 username user1
2520 status not found
2521 username user2
2522 status not found
2523 username user3
2524 status not found
2525 username user4
2526 status not found
2527 execute dump_memory_account;
2528 USER user1
2529 HOST localhost
2530 EVENT_NAME memory/sql/user_var_entry::value
2531 COUNT_ALLOC 0
2532 COUNT_FREE 0
2533 SUM_NUMBER_OF_BYTES_ALLOC 0
2534 SUM_NUMBER_OF_BYTES_FREE 0
2535 LOW_COUNT_USED 0
2536 CURRENT_COUNT_USED 0
2537 HIGH_COUNT_USED 0
2538 LOW_NUMBER_OF_BYTES_USED 0
2539 CURRENT_NUMBER_OF_BYTES_USED 0
2540 HIGH_NUMBER_OF_BYTES_USED 0
2541 USER user2
2542 HOST localhost
2543 EVENT_NAME memory/sql/user_var_entry::value
2544 COUNT_ALLOC 0
2545 COUNT_FREE 0
2546 SUM_NUMBER_OF_BYTES_ALLOC 0
2547 SUM_NUMBER_OF_BYTES_FREE 0
2548 LOW_COUNT_USED 0
2549 CURRENT_COUNT_USED 0
2550 HIGH_COUNT_USED 0
2551 LOW_NUMBER_OF_BYTES_USED 0
2552 CURRENT_NUMBER_OF_BYTES_USED 0
2553 HIGH_NUMBER_OF_BYTES_USED 0
2554 USER user3
2555 HOST localhost
2556 EVENT_NAME memory/sql/user_var_entry::value
2557 COUNT_ALLOC 0
2558 COUNT_FREE 0
2559 SUM_NUMBER_OF_BYTES_ALLOC 0
2560 SUM_NUMBER_OF_BYTES_FREE 0
2561 LOW_COUNT_USED 0
2562 CURRENT_COUNT_USED 0
2563 HIGH_COUNT_USED 0
2564 LOW_NUMBER_OF_BYTES_USED 0
2565 CURRENT_NUMBER_OF_BYTES_USED 0
2566 HIGH_NUMBER_OF_BYTES_USED 0
2567 USER user4
2568 HOST localhost
2569 EVENT_NAME memory/sql/user_var_entry::value
2570 COUNT_ALLOC 0
2571 COUNT_FREE 0
2572 SUM_NUMBER_OF_BYTES_ALLOC 0
2573 SUM_NUMBER_OF_BYTES_FREE 0
2574 LOW_COUNT_USED 0
2575 CURRENT_COUNT_USED 0
2576 HIGH_COUNT_USED 0
2577 LOW_NUMBER_OF_BYTES_USED 0
2578 CURRENT_NUMBER_OF_BYTES_USED 0
2579 HIGH_NUMBER_OF_BYTES_USED 0
2580 execute dump_memory_user;
2581 USER user1
2582 EVENT_NAME memory/sql/user_var_entry::value
2583 COUNT_ALLOC 0
2584 COUNT_FREE 0
2585 SUM_NUMBER_OF_BYTES_ALLOC 0
2586 SUM_NUMBER_OF_BYTES_FREE 0
2587 LOW_COUNT_USED 0
2588 CURRENT_COUNT_USED 0
2589 HIGH_COUNT_USED 0
2590 LOW_NUMBER_OF_BYTES_USED 0
2591 CURRENT_NUMBER_OF_BYTES_USED 0
2592 HIGH_NUMBER_OF_BYTES_USED 0
2593 USER user2
2594 EVENT_NAME memory/sql/user_var_entry::value
2595 COUNT_ALLOC 0
2596 COUNT_FREE 0
2597 SUM_NUMBER_OF_BYTES_ALLOC 0
2598 SUM_NUMBER_OF_BYTES_FREE 0
2599 LOW_COUNT_USED 0
2600 CURRENT_COUNT_USED 0
2601 HIGH_COUNT_USED 0
2602 LOW_NUMBER_OF_BYTES_USED 0
2603 CURRENT_NUMBER_OF_BYTES_USED 0
2604 HIGH_NUMBER_OF_BYTES_USED 0
2605 USER user3
2606 EVENT_NAME memory/sql/user_var_entry::value
2607 COUNT_ALLOC 0
2608 COUNT_FREE 0
2609 SUM_NUMBER_OF_BYTES_ALLOC 0
2610 SUM_NUMBER_OF_BYTES_FREE 0
2611 LOW_COUNT_USED 0
2612 CURRENT_COUNT_USED 0
2613 HIGH_COUNT_USED 0
2614 LOW_NUMBER_OF_BYTES_USED 0
2615 CURRENT_NUMBER_OF_BYTES_USED 0
2616 HIGH_NUMBER_OF_BYTES_USED 0
2617 USER user4
2618 EVENT_NAME memory/sql/user_var_entry::value
2619 COUNT_ALLOC 0
2620 COUNT_FREE 0
2621 SUM_NUMBER_OF_BYTES_ALLOC 0
2622 SUM_NUMBER_OF_BYTES_FREE 0
2623 LOW_COUNT_USED 0
2624 CURRENT_COUNT_USED 0
2625 HIGH_COUNT_USED 0
2626 LOW_NUMBER_OF_BYTES_USED 0
2627 CURRENT_NUMBER_OF_BYTES_USED 0
2628 HIGH_NUMBER_OF_BYTES_USED 0
2629 execute dump_memory_host;
2630 HOST localhost
2631 EVENT_NAME memory/sql/user_var_entry::value
2632 COUNT_ALLOC 0
2633 COUNT_FREE 0
2634 SUM_NUMBER_OF_BYTES_ALLOC 0
2635 SUM_NUMBER_OF_BYTES_FREE 0
2636 LOW_COUNT_USED 0
2637 CURRENT_COUNT_USED 0
2638 HIGH_COUNT_USED 0
2639 LOW_NUMBER_OF_BYTES_USED 0
2640 CURRENT_NUMBER_OF_BYTES_USED 0
2641 HIGH_NUMBER_OF_BYTES_USED 0
2642 execute dump_memory_global;
2643 EVENT_NAME memory/sql/user_var_entry::value
2644 COUNT_ALLOC 15
2645 COUNT_FREE 15
2646 SUM_NUMBER_OF_BYTES_ALLOC 35495
2647 SUM_NUMBER_OF_BYTES_FREE 35495
2648 LOW_COUNT_USED 0
2649 CURRENT_COUNT_USED 0
2650 HIGH_COUNT_USED 15
2651 LOW_NUMBER_OF_BYTES_USED 0
2652 CURRENT_NUMBER_OF_BYTES_USED 0
2653 HIGH_NUMBER_OF_BYTES_USED 35495
2654 execute dump_accounts;
2655 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2656 event_scheduler localhost 1 1
2657 root localhost 1 1
2658 user1 localhost 0 1
2659 user2 localhost 0 1
2660 user3 localhost 0 1
2661 user4 localhost 0 2
2662 execute dump_users;
2663 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2664 event_scheduler 1 1
2665 root 1 1
2666 user1 0 1
2667 user2 0 1
2668 user3 0 1
2669 user4 0 2
2670 execute dump_hosts;
2671 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2672 localhost 2 7
2673 truncate performance_schema.memory_summary_global_by_event_name;
2674 "================== MEMORY_GLOBAL truncated =================="
2675 "================== Step 18 =================="
2676 call dump_thread();
2677 username user1
2678 status not found
2679 username user2
2680 status not found
2681 username user3
2682 status not found
2683 username user4
2684 status not found
2685 execute dump_memory_account;
2686 USER user1
2687 HOST localhost
2688 EVENT_NAME memory/sql/user_var_entry::value
2689 COUNT_ALLOC 0
2690 COUNT_FREE 0
2691 SUM_NUMBER_OF_BYTES_ALLOC 0
2692 SUM_NUMBER_OF_BYTES_FREE 0
2693 LOW_COUNT_USED 0
2694 CURRENT_COUNT_USED 0
2695 HIGH_COUNT_USED 0
2696 LOW_NUMBER_OF_BYTES_USED 0
2697 CURRENT_NUMBER_OF_BYTES_USED 0
2698 HIGH_NUMBER_OF_BYTES_USED 0
2699 USER user2
2700 HOST localhost
2701 EVENT_NAME memory/sql/user_var_entry::value
2702 COUNT_ALLOC 0
2703 COUNT_FREE 0
2704 SUM_NUMBER_OF_BYTES_ALLOC 0
2705 SUM_NUMBER_OF_BYTES_FREE 0
2706 LOW_COUNT_USED 0
2707 CURRENT_COUNT_USED 0
2708 HIGH_COUNT_USED 0
2709 LOW_NUMBER_OF_BYTES_USED 0
2710 CURRENT_NUMBER_OF_BYTES_USED 0
2711 HIGH_NUMBER_OF_BYTES_USED 0
2712 USER user3
2713 HOST localhost
2714 EVENT_NAME memory/sql/user_var_entry::value
2715 COUNT_ALLOC 0
2716 COUNT_FREE 0
2717 SUM_NUMBER_OF_BYTES_ALLOC 0
2718 SUM_NUMBER_OF_BYTES_FREE 0
2719 LOW_COUNT_USED 0
2720 CURRENT_COUNT_USED 0
2721 HIGH_COUNT_USED 0
2722 LOW_NUMBER_OF_BYTES_USED 0
2723 CURRENT_NUMBER_OF_BYTES_USED 0
2724 HIGH_NUMBER_OF_BYTES_USED 0
2725 USER user4
2726 HOST localhost
2727 EVENT_NAME memory/sql/user_var_entry::value
2728 COUNT_ALLOC 0
2729 COUNT_FREE 0
2730 SUM_NUMBER_OF_BYTES_ALLOC 0
2731 SUM_NUMBER_OF_BYTES_FREE 0
2732 LOW_COUNT_USED 0
2733 CURRENT_COUNT_USED 0
2734 HIGH_COUNT_USED 0
2735 LOW_NUMBER_OF_BYTES_USED 0
2736 CURRENT_NUMBER_OF_BYTES_USED 0
2737 HIGH_NUMBER_OF_BYTES_USED 0
2738 execute dump_memory_user;
2739 USER user1
2740 EVENT_NAME memory/sql/user_var_entry::value
2741 COUNT_ALLOC 0
2742 COUNT_FREE 0
2743 SUM_NUMBER_OF_BYTES_ALLOC 0
2744 SUM_NUMBER_OF_BYTES_FREE 0
2745 LOW_COUNT_USED 0
2746 CURRENT_COUNT_USED 0
2747 HIGH_COUNT_USED 0
2748 LOW_NUMBER_OF_BYTES_USED 0
2749 CURRENT_NUMBER_OF_BYTES_USED 0
2750 HIGH_NUMBER_OF_BYTES_USED 0
2751 USER user2
2752 EVENT_NAME memory/sql/user_var_entry::value
2753 COUNT_ALLOC 0
2754 COUNT_FREE 0
2755 SUM_NUMBER_OF_BYTES_ALLOC 0
2756 SUM_NUMBER_OF_BYTES_FREE 0
2757 LOW_COUNT_USED 0
2758 CURRENT_COUNT_USED 0
2759 HIGH_COUNT_USED 0
2760 LOW_NUMBER_OF_BYTES_USED 0
2761 CURRENT_NUMBER_OF_BYTES_USED 0
2762 HIGH_NUMBER_OF_BYTES_USED 0
2763 USER user3
2764 EVENT_NAME memory/sql/user_var_entry::value
2765 COUNT_ALLOC 0
2766 COUNT_FREE 0
2767 SUM_NUMBER_OF_BYTES_ALLOC 0
2768 SUM_NUMBER_OF_BYTES_FREE 0
2769 LOW_COUNT_USED 0
2770 CURRENT_COUNT_USED 0
2771 HIGH_COUNT_USED 0
2772 LOW_NUMBER_OF_BYTES_USED 0
2773 CURRENT_NUMBER_OF_BYTES_USED 0
2774 HIGH_NUMBER_OF_BYTES_USED 0
2775 USER user4
2776 EVENT_NAME memory/sql/user_var_entry::value
2777 COUNT_ALLOC 0
2778 COUNT_FREE 0
2779 SUM_NUMBER_OF_BYTES_ALLOC 0
2780 SUM_NUMBER_OF_BYTES_FREE 0
2781 LOW_COUNT_USED 0
2782 CURRENT_COUNT_USED 0
2783 HIGH_COUNT_USED 0
2784 LOW_NUMBER_OF_BYTES_USED 0
2785 CURRENT_NUMBER_OF_BYTES_USED 0
2786 HIGH_NUMBER_OF_BYTES_USED 0
2787 execute dump_memory_host;
2788 HOST localhost
2789 EVENT_NAME memory/sql/user_var_entry::value
2790 COUNT_ALLOC 0
2791 COUNT_FREE 0
2792 SUM_NUMBER_OF_BYTES_ALLOC 0
2793 SUM_NUMBER_OF_BYTES_FREE 0
2794 LOW_COUNT_USED 0
2795 CURRENT_COUNT_USED 0
2796 HIGH_COUNT_USED 0
2797 LOW_NUMBER_OF_BYTES_USED 0
2798 CURRENT_NUMBER_OF_BYTES_USED 0
2799 HIGH_NUMBER_OF_BYTES_USED 0
2800 execute dump_memory_global;
2801 EVENT_NAME memory/sql/user_var_entry::value
2802 COUNT_ALLOC 0
2803 COUNT_FREE 0
2804 SUM_NUMBER_OF_BYTES_ALLOC 0
2805 SUM_NUMBER_OF_BYTES_FREE 0
2806 LOW_COUNT_USED 0
2807 CURRENT_COUNT_USED 0
2808 HIGH_COUNT_USED 0
2809 LOW_NUMBER_OF_BYTES_USED 0
2810 CURRENT_NUMBER_OF_BYTES_USED 0
2811 HIGH_NUMBER_OF_BYTES_USED 0
2812 execute dump_accounts;
2813 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2814 event_scheduler localhost 1 1
2815 root localhost 1 1
2816 user1 localhost 0 1
2817 user2 localhost 0 1
2818 user3 localhost 0 1
2819 user4 localhost 0 2
2820 execute dump_users;
2821 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2822 event_scheduler 1 1
2823 root 1 1
2824 user1 0 1
2825 user2 0 1
2826 user3 0 1
2827 user4 0 2
2828 execute dump_hosts;
2829 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2830 localhost 2 7
2831 truncate performance_schema.accounts;
2832 "================== ACCOUNTS truncated =================="
2833 "================== Step 19 =================="
2834 call dump_thread();
2835 username user1
2836 status not found
2837 username user2
2838 status not found
2839 username user3
2840 status not found
2841 username user4
2842 status not found
2843 execute dump_memory_account;
2844 execute dump_memory_user;
2845 USER user1
2846 EVENT_NAME memory/sql/user_var_entry::value
2847 COUNT_ALLOC 0
2848 COUNT_FREE 0
2849 SUM_NUMBER_OF_BYTES_ALLOC 0
2850 SUM_NUMBER_OF_BYTES_FREE 0
2851 LOW_COUNT_USED 0
2852 CURRENT_COUNT_USED 0
2853 HIGH_COUNT_USED 0
2854 LOW_NUMBER_OF_BYTES_USED 0
2855 CURRENT_NUMBER_OF_BYTES_USED 0
2856 HIGH_NUMBER_OF_BYTES_USED 0
2857 USER user2
2858 EVENT_NAME memory/sql/user_var_entry::value
2859 COUNT_ALLOC 0
2860 COUNT_FREE 0
2861 SUM_NUMBER_OF_BYTES_ALLOC 0
2862 SUM_NUMBER_OF_BYTES_FREE 0
2863 LOW_COUNT_USED 0
2864 CURRENT_COUNT_USED 0
2865 HIGH_COUNT_USED 0
2866 LOW_NUMBER_OF_BYTES_USED 0
2867 CURRENT_NUMBER_OF_BYTES_USED 0
2868 HIGH_NUMBER_OF_BYTES_USED 0
2869 USER user3
2870 EVENT_NAME memory/sql/user_var_entry::value
2871 COUNT_ALLOC 0
2872 COUNT_FREE 0
2873 SUM_NUMBER_OF_BYTES_ALLOC 0
2874 SUM_NUMBER_OF_BYTES_FREE 0
2875 LOW_COUNT_USED 0
2876 CURRENT_COUNT_USED 0
2877 HIGH_COUNT_USED 0
2878 LOW_NUMBER_OF_BYTES_USED 0
2879 CURRENT_NUMBER_OF_BYTES_USED 0
2880 HIGH_NUMBER_OF_BYTES_USED 0
2881 USER user4
2882 EVENT_NAME memory/sql/user_var_entry::value
2883 COUNT_ALLOC 0
2884 COUNT_FREE 0
2885 SUM_NUMBER_OF_BYTES_ALLOC 0
2886 SUM_NUMBER_OF_BYTES_FREE 0
2887 LOW_COUNT_USED 0
2888 CURRENT_COUNT_USED 0
2889 HIGH_COUNT_USED 0
2890 LOW_NUMBER_OF_BYTES_USED 0
2891 CURRENT_NUMBER_OF_BYTES_USED 0
2892 HIGH_NUMBER_OF_BYTES_USED 0
2893 execute dump_memory_host;
2894 HOST localhost
2895 EVENT_NAME memory/sql/user_var_entry::value
2896 COUNT_ALLOC 0
2897 COUNT_FREE 0
2898 SUM_NUMBER_OF_BYTES_ALLOC 0
2899 SUM_NUMBER_OF_BYTES_FREE 0
2900 LOW_COUNT_USED 0
2901 CURRENT_COUNT_USED 0
2902 HIGH_COUNT_USED 0
2903 LOW_NUMBER_OF_BYTES_USED 0
2904 CURRENT_NUMBER_OF_BYTES_USED 0
2905 HIGH_NUMBER_OF_BYTES_USED 0
2906 execute dump_memory_global;
2907 EVENT_NAME memory/sql/user_var_entry::value
2908 COUNT_ALLOC 0
2909 COUNT_FREE 0
2910 SUM_NUMBER_OF_BYTES_ALLOC 0
2911 SUM_NUMBER_OF_BYTES_FREE 0
2912 LOW_COUNT_USED 0
2913 CURRENT_COUNT_USED 0
2914 HIGH_COUNT_USED 0
2915 LOW_NUMBER_OF_BYTES_USED 0
2916 CURRENT_NUMBER_OF_BYTES_USED 0
2917 HIGH_NUMBER_OF_BYTES_USED 0
2918 execute dump_accounts;
2919 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2920 event_scheduler localhost 1 1
2921 root localhost 1 1
2922 execute dump_users;
2923 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2924 event_scheduler 1 1
2925 root 1 1
2926 user1 0 1
2927 user2 0 1
2928 user3 0 1
2929 user4 0 2
2930 execute dump_hosts;
2931 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2932 localhost 2 7
2933 truncate performance_schema.users;
2934 "================== USERS truncated =================="
2935 "================== Step 20 =================="
2936 call dump_thread();
2937 username user1
2938 status not found
2939 username user2
2940 status not found
2941 username user3
2942 status not found
2943 username user4
2944 status not found
2945 execute dump_memory_account;
2946 execute dump_memory_user;
2947 execute dump_memory_host;
2948 HOST localhost
2949 EVENT_NAME memory/sql/user_var_entry::value
2950 COUNT_ALLOC 0
2951 COUNT_FREE 0
2952 SUM_NUMBER_OF_BYTES_ALLOC 0
2953 SUM_NUMBER_OF_BYTES_FREE 0
2954 LOW_COUNT_USED 0
2955 CURRENT_COUNT_USED 0
2956 HIGH_COUNT_USED 0
2957 LOW_NUMBER_OF_BYTES_USED 0
2958 CURRENT_NUMBER_OF_BYTES_USED 0
2959 HIGH_NUMBER_OF_BYTES_USED 0
2960 execute dump_memory_global;
2961 EVENT_NAME memory/sql/user_var_entry::value
2962 COUNT_ALLOC 0
2963 COUNT_FREE 0
2964 SUM_NUMBER_OF_BYTES_ALLOC 0
2965 SUM_NUMBER_OF_BYTES_FREE 0
2966 LOW_COUNT_USED 0
2967 CURRENT_COUNT_USED 0
2968 HIGH_COUNT_USED 0
2969 LOW_NUMBER_OF_BYTES_USED 0
2970 CURRENT_NUMBER_OF_BYTES_USED 0
2971 HIGH_NUMBER_OF_BYTES_USED 0
2972 execute dump_accounts;
2973 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2974 event_scheduler localhost 1 1
2975 root localhost 1 1
2976 execute dump_users;
2977 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2978 event_scheduler 1 1
2979 root 1 1
2980 execute dump_hosts;
2981 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2982 localhost 2 7
2983 truncate performance_schema.hosts;
2984 "================== HOSTS truncated =================="
2985 "================== Step 21 =================="
2986 call dump_thread();
2987 username user1
2988 status not found
2989 username user2
2990 status not found
2991 username user3
2992 status not found
2993 username user4
2994 status not found
2995 execute dump_memory_account;
2996 execute dump_memory_user;
2997 execute dump_memory_host;
2998 HOST localhost
2999 EVENT_NAME memory/sql/user_var_entry::value
3000 COUNT_ALLOC 0
3001 COUNT_FREE 0
3002 SUM_NUMBER_OF_BYTES_ALLOC 0
3003 SUM_NUMBER_OF_BYTES_FREE 0
3004 LOW_COUNT_USED 0
3005 CURRENT_COUNT_USED 0
3006 HIGH_COUNT_USED 0
3007 LOW_NUMBER_OF_BYTES_USED 0
3008 CURRENT_NUMBER_OF_BYTES_USED 0
3009 HIGH_NUMBER_OF_BYTES_USED 0
3010 execute dump_memory_global;
3011 EVENT_NAME memory/sql/user_var_entry::value
3012 COUNT_ALLOC 0
3013 COUNT_FREE 0
3014 SUM_NUMBER_OF_BYTES_ALLOC 0
3015 SUM_NUMBER_OF_BYTES_FREE 0
3016 LOW_COUNT_USED 0
3017 CURRENT_COUNT_USED 0
3018 HIGH_COUNT_USED 0
3019 LOW_NUMBER_OF_BYTES_USED 0
3020 CURRENT_NUMBER_OF_BYTES_USED 0
3021 HIGH_NUMBER_OF_BYTES_USED 0
3022 execute dump_accounts;
3023 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3024 event_scheduler localhost 1 1
3025 root localhost 1 1
3026 execute dump_users;
3027 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3028 event_scheduler 1 1
3029 root 1 1
3030 execute dump_hosts;
3031 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3032 localhost 2 2