Debian Codegraph @

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