Debian Codegraph @

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

raw
1 show global status like "performance_schema_memory_classes_lost";
2 Variable_name Value
3 Performance_schema_memory_classes_lost 0
4 "================== Step 1 =================="
5 call dump_thread();
6 username user1
7 status not found
8 username user2
9 status not found
10 username user3
11 status not found
12 username user4
13 status not found
14 execute dump_memory_account;
15 execute dump_memory_user;
16 execute dump_memory_host;
17 HOST localhost
18 EVENT_NAME memory/sql/user_var_entry::value
19 COUNT_ALLOC 0
20 COUNT_FREE 0
21 SUM_NUMBER_OF_BYTES_ALLOC 0
22 SUM_NUMBER_OF_BYTES_FREE 0
23 LOW_COUNT_USED 0
24 CURRENT_COUNT_USED 0
25 HIGH_COUNT_USED 0
26 LOW_NUMBER_OF_BYTES_USED 0
27 CURRENT_NUMBER_OF_BYTES_USED 0
28 HIGH_NUMBER_OF_BYTES_USED 0
29 execute dump_memory_global;
30 EVENT_NAME memory/sql/user_var_entry::value
31 COUNT_ALLOC 0
32 COUNT_FREE 0
33 SUM_NUMBER_OF_BYTES_ALLOC 0
34 SUM_NUMBER_OF_BYTES_FREE 0
35 LOW_COUNT_USED 0
36 CURRENT_COUNT_USED 0
37 HIGH_COUNT_USED 0
38 LOW_NUMBER_OF_BYTES_USED 0
39 CURRENT_NUMBER_OF_BYTES_USED 0
40 HIGH_NUMBER_OF_BYTES_USED 0
41 execute dump_accounts;
42 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
43 execute dump_users;
44 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
45 event_scheduler 1 1
46 root 1 1
47 execute dump_hosts;
48 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
49 localhost 2 2
50 "================== con1 connected =================="
51 "================== Step 2 =================="
52 call dump_thread();
53 username user1
54 EVENT_NAME memory/sql/user_var_entry::value
55 COUNT_ALLOC 0
56 COUNT_FREE 0
57 SUM_NUMBER_OF_BYTES_ALLOC 0
58 SUM_NUMBER_OF_BYTES_FREE 0
59 LOW_COUNT_USED 0
60 CURRENT_COUNT_USED 0
61 HIGH_COUNT_USED 0
62 LOW_NUMBER_OF_BYTES_USED 0
63 CURRENT_NUMBER_OF_BYTES_USED 0
64 HIGH_NUMBER_OF_BYTES_USED 0
65 username user2
66 status not found
67 username user3
68 status not found
69 username user4
70 status not found
71 execute dump_memory_account;
72 execute dump_memory_user;
73 USER user1
74 EVENT_NAME memory/sql/user_var_entry::value
75 COUNT_ALLOC 0
76 COUNT_FREE 0
77 SUM_NUMBER_OF_BYTES_ALLOC 0
78 SUM_NUMBER_OF_BYTES_FREE 0
79 LOW_COUNT_USED 0
80 CURRENT_COUNT_USED 0
81 HIGH_COUNT_USED 0
82 LOW_NUMBER_OF_BYTES_USED 0
83 CURRENT_NUMBER_OF_BYTES_USED 0
84 HIGH_NUMBER_OF_BYTES_USED 0
85 execute dump_memory_host;
86 HOST localhost
87 EVENT_NAME memory/sql/user_var_entry::value
88 COUNT_ALLOC 0
89 COUNT_FREE 0
90 SUM_NUMBER_OF_BYTES_ALLOC 0
91 SUM_NUMBER_OF_BYTES_FREE 0
92 LOW_COUNT_USED 0
93 CURRENT_COUNT_USED 0
94 HIGH_COUNT_USED 0
95 LOW_NUMBER_OF_BYTES_USED 0
96 CURRENT_NUMBER_OF_BYTES_USED 0
97 HIGH_NUMBER_OF_BYTES_USED 0
98 execute dump_memory_global;
99 EVENT_NAME memory/sql/user_var_entry::value
100 COUNT_ALLOC 0
101 COUNT_FREE 0
102 SUM_NUMBER_OF_BYTES_ALLOC 0
103 SUM_NUMBER_OF_BYTES_FREE 0
104 LOW_COUNT_USED 0
105 CURRENT_COUNT_USED 0
106 HIGH_COUNT_USED 0
107 LOW_NUMBER_OF_BYTES_USED 0
108 CURRENT_NUMBER_OF_BYTES_USED 0
109 HIGH_NUMBER_OF_BYTES_USED 0
110 execute dump_accounts;
111 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
112 execute dump_users;
113 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
114 event_scheduler 1 1
115 root 1 1
116 user1 1 1
117 execute dump_hosts;
118 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
119 localhost 3 3
120 select get_lock("marker_1", 10);
121 get_lock("marker_1", 10)
122 1
123 select release_lock("marker_1");
124 release_lock("marker_1")
125 1
126 set @v1 = repeat("a", 1000);
127 set @v2 = repeat("b", 2000);
128 set @v3 = repeat("c", 4000);
129 "================== con1 marker =================="
130 "================== Step 3 =================="
131 call dump_thread();
132 username user1
133 EVENT_NAME memory/sql/user_var_entry::value
134 COUNT_ALLOC 3
135 COUNT_FREE 0
136 SUM_NUMBER_OF_BYTES_ALLOC 7099
137 SUM_NUMBER_OF_BYTES_FREE 0
138 LOW_COUNT_USED 0
139 CURRENT_COUNT_USED 3
140 HIGH_COUNT_USED 3
141 LOW_NUMBER_OF_BYTES_USED 0
142 CURRENT_NUMBER_OF_BYTES_USED 7099
143 HIGH_NUMBER_OF_BYTES_USED 7099
144 username user2
145 status not found
146 username user3
147 status not found
148 username user4
149 status not found
150 execute dump_memory_account;
151 execute dump_memory_user;
152 USER user1
153 EVENT_NAME memory/sql/user_var_entry::value
154 COUNT_ALLOC 3
155 COUNT_FREE 0
156 SUM_NUMBER_OF_BYTES_ALLOC 7099
157 SUM_NUMBER_OF_BYTES_FREE 0
158 LOW_COUNT_USED 0
159 CURRENT_COUNT_USED 3
160 HIGH_COUNT_USED 3
161 LOW_NUMBER_OF_BYTES_USED 0
162 CURRENT_NUMBER_OF_BYTES_USED 7099
163 HIGH_NUMBER_OF_BYTES_USED 7099
164 execute dump_memory_host;
165 HOST localhost
166 EVENT_NAME memory/sql/user_var_entry::value
167 COUNT_ALLOC 3
168 COUNT_FREE 0
169 SUM_NUMBER_OF_BYTES_ALLOC 7099
170 SUM_NUMBER_OF_BYTES_FREE 0
171 LOW_COUNT_USED 0
172 CURRENT_COUNT_USED 3
173 HIGH_COUNT_USED 3
174 LOW_NUMBER_OF_BYTES_USED 0
175 CURRENT_NUMBER_OF_BYTES_USED 7099
176 HIGH_NUMBER_OF_BYTES_USED 7099
177 execute dump_memory_global;
178 EVENT_NAME memory/sql/user_var_entry::value
179 COUNT_ALLOC 3
180 COUNT_FREE 0
181 SUM_NUMBER_OF_BYTES_ALLOC 7099
182 SUM_NUMBER_OF_BYTES_FREE 0
183 LOW_COUNT_USED 0
184 CURRENT_COUNT_USED 3
185 HIGH_COUNT_USED 3
186 LOW_NUMBER_OF_BYTES_USED 0
187 CURRENT_NUMBER_OF_BYTES_USED 7099
188 HIGH_NUMBER_OF_BYTES_USED 7099
189 execute dump_accounts;
190 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
191 execute dump_users;
192 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
193 event_scheduler 1 1
194 root 1 1
195 user1 1 1
196 execute dump_hosts;
197 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
198 localhost 3 3
199 "================== con2 connected =================="
200 "================== Step 4 =================="
201 call dump_thread();
202 username user1
203 EVENT_NAME memory/sql/user_var_entry::value
204 COUNT_ALLOC 3
205 COUNT_FREE 0
206 SUM_NUMBER_OF_BYTES_ALLOC 7099
207 SUM_NUMBER_OF_BYTES_FREE 0
208 LOW_COUNT_USED 0
209 CURRENT_COUNT_USED 3
210 HIGH_COUNT_USED 3
211 LOW_NUMBER_OF_BYTES_USED 0
212 CURRENT_NUMBER_OF_BYTES_USED 7099
213 HIGH_NUMBER_OF_BYTES_USED 7099
214 username user2
215 EVENT_NAME memory/sql/user_var_entry::value
216 COUNT_ALLOC 0
217 COUNT_FREE 0
218 SUM_NUMBER_OF_BYTES_ALLOC 0
219 SUM_NUMBER_OF_BYTES_FREE 0
220 LOW_COUNT_USED 0
221 CURRENT_COUNT_USED 0
222 HIGH_COUNT_USED 0
223 LOW_NUMBER_OF_BYTES_USED 0
224 CURRENT_NUMBER_OF_BYTES_USED 0
225 HIGH_NUMBER_OF_BYTES_USED 0
226 username user3
227 status not found
228 username user4
229 status not found
230 execute dump_memory_account;
231 execute dump_memory_user;
232 USER user1
233 EVENT_NAME memory/sql/user_var_entry::value
234 COUNT_ALLOC 3
235 COUNT_FREE 0
236 SUM_NUMBER_OF_BYTES_ALLOC 7099
237 SUM_NUMBER_OF_BYTES_FREE 0
238 LOW_COUNT_USED 0
239 CURRENT_COUNT_USED 3
240 HIGH_COUNT_USED 3
241 LOW_NUMBER_OF_BYTES_USED 0
242 CURRENT_NUMBER_OF_BYTES_USED 7099
243 HIGH_NUMBER_OF_BYTES_USED 7099
244 USER user2
245 EVENT_NAME memory/sql/user_var_entry::value
246 COUNT_ALLOC 0
247 COUNT_FREE 0
248 SUM_NUMBER_OF_BYTES_ALLOC 0
249 SUM_NUMBER_OF_BYTES_FREE 0
250 LOW_COUNT_USED 0
251 CURRENT_COUNT_USED 0
252 HIGH_COUNT_USED 0
253 LOW_NUMBER_OF_BYTES_USED 0
254 CURRENT_NUMBER_OF_BYTES_USED 0
255 HIGH_NUMBER_OF_BYTES_USED 0
256 execute dump_memory_host;
257 HOST localhost
258 EVENT_NAME memory/sql/user_var_entry::value
259 COUNT_ALLOC 3
260 COUNT_FREE 0
261 SUM_NUMBER_OF_BYTES_ALLOC 7099
262 SUM_NUMBER_OF_BYTES_FREE 0
263 LOW_COUNT_USED 0
264 CURRENT_COUNT_USED 3
265 HIGH_COUNT_USED 3
266 LOW_NUMBER_OF_BYTES_USED 0
267 CURRENT_NUMBER_OF_BYTES_USED 7099
268 HIGH_NUMBER_OF_BYTES_USED 7099
269 execute dump_memory_global;
270 EVENT_NAME memory/sql/user_var_entry::value
271 COUNT_ALLOC 3
272 COUNT_FREE 0
273 SUM_NUMBER_OF_BYTES_ALLOC 7099
274 SUM_NUMBER_OF_BYTES_FREE 0
275 LOW_COUNT_USED 0
276 CURRENT_COUNT_USED 3
277 HIGH_COUNT_USED 3
278 LOW_NUMBER_OF_BYTES_USED 0
279 CURRENT_NUMBER_OF_BYTES_USED 7099
280 HIGH_NUMBER_OF_BYTES_USED 7099
281 execute dump_accounts;
282 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
283 execute dump_users;
284 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
285 event_scheduler 1 1
286 root 1 1
287 user1 1 1
288 user2 1 1
289 execute dump_hosts;
290 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
291 localhost 4 4
292 select get_lock("marker_2", 10);
293 get_lock("marker_2", 10)
294 1
295 select release_lock("marker_2");
296 release_lock("marker_2")
297 1
298 set @v1 = repeat("a", 1000);
299 set @v2 = repeat("b", 2000);
300 set @v3 = repeat("c", 4000);
301 "================== con2 marker =================="
302 "================== Step 5 =================="
303 call dump_thread();
304 username user1
305 EVENT_NAME memory/sql/user_var_entry::value
306 COUNT_ALLOC 3
307 COUNT_FREE 0
308 SUM_NUMBER_OF_BYTES_ALLOC 7099
309 SUM_NUMBER_OF_BYTES_FREE 0
310 LOW_COUNT_USED 0
311 CURRENT_COUNT_USED 3
312 HIGH_COUNT_USED 3
313 LOW_NUMBER_OF_BYTES_USED 0
314 CURRENT_NUMBER_OF_BYTES_USED 7099
315 HIGH_NUMBER_OF_BYTES_USED 7099
316 username user2
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 user3
329 status not found
330 username user4
331 status not found
332 execute dump_memory_account;
333 execute dump_memory_user;
334 USER user1
335 EVENT_NAME memory/sql/user_var_entry::value
336 COUNT_ALLOC 3
337 COUNT_FREE 0
338 SUM_NUMBER_OF_BYTES_ALLOC 7099
339 SUM_NUMBER_OF_BYTES_FREE 0
340 LOW_COUNT_USED 0
341 CURRENT_COUNT_USED 3
342 HIGH_COUNT_USED 3
343 LOW_NUMBER_OF_BYTES_USED 0
344 CURRENT_NUMBER_OF_BYTES_USED 7099
345 HIGH_NUMBER_OF_BYTES_USED 7099
346 USER user2
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 execute dump_memory_host;
359 HOST localhost
360 EVENT_NAME memory/sql/user_var_entry::value
361 COUNT_ALLOC 6
362 COUNT_FREE 0
363 SUM_NUMBER_OF_BYTES_ALLOC 14198
364 SUM_NUMBER_OF_BYTES_FREE 0
365 LOW_COUNT_USED 0
366 CURRENT_COUNT_USED 6
367 HIGH_COUNT_USED 6
368 LOW_NUMBER_OF_BYTES_USED 0
369 CURRENT_NUMBER_OF_BYTES_USED 14198
370 HIGH_NUMBER_OF_BYTES_USED 14198
371 execute dump_memory_global;
372 EVENT_NAME memory/sql/user_var_entry::value
373 COUNT_ALLOC 6
374 COUNT_FREE 0
375 SUM_NUMBER_OF_BYTES_ALLOC 14198
376 SUM_NUMBER_OF_BYTES_FREE 0
377 LOW_COUNT_USED 0
378 CURRENT_COUNT_USED 6
379 HIGH_COUNT_USED 6
380 LOW_NUMBER_OF_BYTES_USED 0
381 CURRENT_NUMBER_OF_BYTES_USED 14198
382 HIGH_NUMBER_OF_BYTES_USED 14198
383 execute dump_accounts;
384 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
385 execute dump_users;
386 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
387 event_scheduler 1 1
388 root 1 1
389 user1 1 1
390 user2 1 1
391 execute dump_hosts;
392 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
393 localhost 4 4
394 truncate table performance_schema.memory_summary_by_thread_by_event_name;
395 "================== MEMORY_BY_THREAD truncated =================="
396 "================== Step 5b =================="
397 call dump_thread();
398 username user1
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 3
405 CURRENT_COUNT_USED 3
406 HIGH_COUNT_USED 3
407 LOW_NUMBER_OF_BYTES_USED 7099
408 CURRENT_NUMBER_OF_BYTES_USED 7099
409 HIGH_NUMBER_OF_BYTES_USED 7099
410 username user2
411 EVENT_NAME memory/sql/user_var_entry::value
412 COUNT_ALLOC 3
413 COUNT_FREE 0
414 SUM_NUMBER_OF_BYTES_ALLOC 7099
415 SUM_NUMBER_OF_BYTES_FREE 0
416 LOW_COUNT_USED 3
417 CURRENT_COUNT_USED 3
418 HIGH_COUNT_USED 3
419 LOW_NUMBER_OF_BYTES_USED 7099
420 CURRENT_NUMBER_OF_BYTES_USED 7099
421 HIGH_NUMBER_OF_BYTES_USED 7099
422 username user3
423 status not found
424 username user4
425 status not found
426 execute dump_memory_account;
427 execute dump_memory_user;
428 USER user1
429 EVENT_NAME memory/sql/user_var_entry::value
430 COUNT_ALLOC 3
431 COUNT_FREE 0
432 SUM_NUMBER_OF_BYTES_ALLOC 7099
433 SUM_NUMBER_OF_BYTES_FREE 0
434 LOW_COUNT_USED 0
435 CURRENT_COUNT_USED 3
436 HIGH_COUNT_USED 3
437 LOW_NUMBER_OF_BYTES_USED 0
438 CURRENT_NUMBER_OF_BYTES_USED 7099
439 HIGH_NUMBER_OF_BYTES_USED 7099
440 USER user2
441 EVENT_NAME memory/sql/user_var_entry::value
442 COUNT_ALLOC 3
443 COUNT_FREE 0
444 SUM_NUMBER_OF_BYTES_ALLOC 7099
445 SUM_NUMBER_OF_BYTES_FREE 0
446 LOW_COUNT_USED 0
447 CURRENT_COUNT_USED 3
448 HIGH_COUNT_USED 3
449 LOW_NUMBER_OF_BYTES_USED 0
450 CURRENT_NUMBER_OF_BYTES_USED 7099
451 HIGH_NUMBER_OF_BYTES_USED 7099
452 execute dump_memory_host;
453 HOST localhost
454 EVENT_NAME memory/sql/user_var_entry::value
455 COUNT_ALLOC 6
456 COUNT_FREE 0
457 SUM_NUMBER_OF_BYTES_ALLOC 14198
458 SUM_NUMBER_OF_BYTES_FREE 0
459 LOW_COUNT_USED 0
460 CURRENT_COUNT_USED 6
461 HIGH_COUNT_USED 6
462 LOW_NUMBER_OF_BYTES_USED 0
463 CURRENT_NUMBER_OF_BYTES_USED 14198
464 HIGH_NUMBER_OF_BYTES_USED 14198
465 execute dump_memory_global;
466 EVENT_NAME memory/sql/user_var_entry::value
467 COUNT_ALLOC 6
468 COUNT_FREE 0
469 SUM_NUMBER_OF_BYTES_ALLOC 14198
470 SUM_NUMBER_OF_BYTES_FREE 0
471 LOW_COUNT_USED 0
472 CURRENT_COUNT_USED 6
473 HIGH_COUNT_USED 6
474 LOW_NUMBER_OF_BYTES_USED 0
475 CURRENT_NUMBER_OF_BYTES_USED 14198
476 HIGH_NUMBER_OF_BYTES_USED 14198
477 execute dump_accounts;
478 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
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 "================== con3 connected =================="
489 "================== Step 6 =================="
490 call dump_thread();
491 username user1
492 EVENT_NAME memory/sql/user_var_entry::value
493 COUNT_ALLOC 3
494 COUNT_FREE 0
495 SUM_NUMBER_OF_BYTES_ALLOC 7099
496 SUM_NUMBER_OF_BYTES_FREE 0
497 LOW_COUNT_USED 3
498 CURRENT_COUNT_USED 3
499 HIGH_COUNT_USED 3
500 LOW_NUMBER_OF_BYTES_USED 7099
501 CURRENT_NUMBER_OF_BYTES_USED 7099
502 HIGH_NUMBER_OF_BYTES_USED 7099
503 username user2
504 EVENT_NAME memory/sql/user_var_entry::value
505 COUNT_ALLOC 3
506 COUNT_FREE 0
507 SUM_NUMBER_OF_BYTES_ALLOC 7099
508 SUM_NUMBER_OF_BYTES_FREE 0
509 LOW_COUNT_USED 3
510 CURRENT_COUNT_USED 3
511 HIGH_COUNT_USED 3
512 LOW_NUMBER_OF_BYTES_USED 7099
513 CURRENT_NUMBER_OF_BYTES_USED 7099
514 HIGH_NUMBER_OF_BYTES_USED 7099
515 username user3
516 EVENT_NAME memory/sql/user_var_entry::value
517 COUNT_ALLOC 0
518 COUNT_FREE 0
519 SUM_NUMBER_OF_BYTES_ALLOC 0
520 SUM_NUMBER_OF_BYTES_FREE 0
521 LOW_COUNT_USED 0
522 CURRENT_COUNT_USED 0
523 HIGH_COUNT_USED 0
524 LOW_NUMBER_OF_BYTES_USED 0
525 CURRENT_NUMBER_OF_BYTES_USED 0
526 HIGH_NUMBER_OF_BYTES_USED 0
527 username user4
528 status not found
529 execute dump_memory_account;
530 execute dump_memory_user;
531 USER user1
532 EVENT_NAME memory/sql/user_var_entry::value
533 COUNT_ALLOC 3
534 COUNT_FREE 0
535 SUM_NUMBER_OF_BYTES_ALLOC 7099
536 SUM_NUMBER_OF_BYTES_FREE 0
537 LOW_COUNT_USED 0
538 CURRENT_COUNT_USED 3
539 HIGH_COUNT_USED 3
540 LOW_NUMBER_OF_BYTES_USED 0
541 CURRENT_NUMBER_OF_BYTES_USED 7099
542 HIGH_NUMBER_OF_BYTES_USED 7099
543 USER user2
544 EVENT_NAME memory/sql/user_var_entry::value
545 COUNT_ALLOC 3
546 COUNT_FREE 0
547 SUM_NUMBER_OF_BYTES_ALLOC 7099
548 SUM_NUMBER_OF_BYTES_FREE 0
549 LOW_COUNT_USED 0
550 CURRENT_COUNT_USED 3
551 HIGH_COUNT_USED 3
552 LOW_NUMBER_OF_BYTES_USED 0
553 CURRENT_NUMBER_OF_BYTES_USED 7099
554 HIGH_NUMBER_OF_BYTES_USED 7099
555 USER user3
556 EVENT_NAME memory/sql/user_var_entry::value
557 COUNT_ALLOC 0
558 COUNT_FREE 0
559 SUM_NUMBER_OF_BYTES_ALLOC 0
560 SUM_NUMBER_OF_BYTES_FREE 0
561 LOW_COUNT_USED 0
562 CURRENT_COUNT_USED 0
563 HIGH_COUNT_USED 0
564 LOW_NUMBER_OF_BYTES_USED 0
565 CURRENT_NUMBER_OF_BYTES_USED 0
566 HIGH_NUMBER_OF_BYTES_USED 0
567 execute dump_memory_host;
568 HOST localhost
569 EVENT_NAME memory/sql/user_var_entry::value
570 COUNT_ALLOC 6
571 COUNT_FREE 0
572 SUM_NUMBER_OF_BYTES_ALLOC 14198
573 SUM_NUMBER_OF_BYTES_FREE 0
574 LOW_COUNT_USED 0
575 CURRENT_COUNT_USED 6
576 HIGH_COUNT_USED 6
577 LOW_NUMBER_OF_BYTES_USED 0
578 CURRENT_NUMBER_OF_BYTES_USED 14198
579 HIGH_NUMBER_OF_BYTES_USED 14198
580 execute dump_memory_global;
581 EVENT_NAME memory/sql/user_var_entry::value
582 COUNT_ALLOC 6
583 COUNT_FREE 0
584 SUM_NUMBER_OF_BYTES_ALLOC 14198
585 SUM_NUMBER_OF_BYTES_FREE 0
586 LOW_COUNT_USED 0
587 CURRENT_COUNT_USED 6
588 HIGH_COUNT_USED 6
589 LOW_NUMBER_OF_BYTES_USED 0
590 CURRENT_NUMBER_OF_BYTES_USED 14198
591 HIGH_NUMBER_OF_BYTES_USED 14198
592 execute dump_accounts;
593 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
594 execute dump_users;
595 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
596 event_scheduler 1 1
597 root 1 1
598 user1 1 1
599 user2 1 1
600 user3 1 1
601 execute dump_hosts;
602 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
603 localhost 5 5
604 select get_lock("marker_3", 10);
605 get_lock("marker_3", 10)
606 1
607 select release_lock("marker_3");
608 release_lock("marker_3")
609 1
610 set @v1 = repeat("a", 1000);
611 set @v2 = repeat("b", 2000);
612 set @v3 = repeat("c", 4000);
613 "================== con3 marker =================="
614 "================== Step 7 =================="
615 call dump_thread();
616 username 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 3
623 CURRENT_COUNT_USED 3
624 HIGH_COUNT_USED 3
625 LOW_NUMBER_OF_BYTES_USED 7099
626 CURRENT_NUMBER_OF_BYTES_USED 7099
627 HIGH_NUMBER_OF_BYTES_USED 7099
628 username 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 3
635 CURRENT_COUNT_USED 3
636 HIGH_COUNT_USED 3
637 LOW_NUMBER_OF_BYTES_USED 7099
638 CURRENT_NUMBER_OF_BYTES_USED 7099
639 HIGH_NUMBER_OF_BYTES_USED 7099
640 username user3
641 EVENT_NAME memory/sql/user_var_entry::value
642 COUNT_ALLOC 3
643 COUNT_FREE 0
644 SUM_NUMBER_OF_BYTES_ALLOC 7099
645 SUM_NUMBER_OF_BYTES_FREE 0
646 LOW_COUNT_USED 0
647 CURRENT_COUNT_USED 3
648 HIGH_COUNT_USED 3
649 LOW_NUMBER_OF_BYTES_USED 0
650 CURRENT_NUMBER_OF_BYTES_USED 7099
651 HIGH_NUMBER_OF_BYTES_USED 7099
652 username user4
653 status not found
654 execute dump_memory_account;
655 execute dump_memory_user;
656 USER user1
657 EVENT_NAME memory/sql/user_var_entry::value
658 COUNT_ALLOC 3
659 COUNT_FREE 0
660 SUM_NUMBER_OF_BYTES_ALLOC 7099
661 SUM_NUMBER_OF_BYTES_FREE 0
662 LOW_COUNT_USED 0
663 CURRENT_COUNT_USED 3
664 HIGH_COUNT_USED 3
665 LOW_NUMBER_OF_BYTES_USED 0
666 CURRENT_NUMBER_OF_BYTES_USED 7099
667 HIGH_NUMBER_OF_BYTES_USED 7099
668 USER user2
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 EVENT_NAME memory/sql/user_var_entry::value
682 COUNT_ALLOC 3
683 COUNT_FREE 0
684 SUM_NUMBER_OF_BYTES_ALLOC 7099
685 SUM_NUMBER_OF_BYTES_FREE 0
686 LOW_COUNT_USED 0
687 CURRENT_COUNT_USED 3
688 HIGH_COUNT_USED 3
689 LOW_NUMBER_OF_BYTES_USED 0
690 CURRENT_NUMBER_OF_BYTES_USED 7099
691 HIGH_NUMBER_OF_BYTES_USED 7099
692 execute dump_memory_host;
693 HOST localhost
694 EVENT_NAME memory/sql/user_var_entry::value
695 COUNT_ALLOC 9
696 COUNT_FREE 0
697 SUM_NUMBER_OF_BYTES_ALLOC 21297
698 SUM_NUMBER_OF_BYTES_FREE 0
699 LOW_COUNT_USED 0
700 CURRENT_COUNT_USED 9
701 HIGH_COUNT_USED 9
702 LOW_NUMBER_OF_BYTES_USED 0
703 CURRENT_NUMBER_OF_BYTES_USED 21297
704 HIGH_NUMBER_OF_BYTES_USED 21297
705 execute dump_memory_global;
706 EVENT_NAME memory/sql/user_var_entry::value
707 COUNT_ALLOC 9
708 COUNT_FREE 0
709 SUM_NUMBER_OF_BYTES_ALLOC 21297
710 SUM_NUMBER_OF_BYTES_FREE 0
711 LOW_COUNT_USED 0
712 CURRENT_COUNT_USED 9
713 HIGH_COUNT_USED 9
714 LOW_NUMBER_OF_BYTES_USED 0
715 CURRENT_NUMBER_OF_BYTES_USED 21297
716 HIGH_NUMBER_OF_BYTES_USED 21297
717 execute dump_accounts;
718 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
719 execute dump_users;
720 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
721 event_scheduler 1 1
722 root 1 1
723 user1 1 1
724 user2 1 1
725 user3 1 1
726 execute dump_hosts;
727 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
728 localhost 5 5
729 "================== con4/con5 (both user4) connected =================="
730 "================== Step 8 =================="
731 call dump_thread();
732 username user1
733 EVENT_NAME memory/sql/user_var_entry::value
734 COUNT_ALLOC 3
735 COUNT_FREE 0
736 SUM_NUMBER_OF_BYTES_ALLOC 7099
737 SUM_NUMBER_OF_BYTES_FREE 0
738 LOW_COUNT_USED 3
739 CURRENT_COUNT_USED 3
740 HIGH_COUNT_USED 3
741 LOW_NUMBER_OF_BYTES_USED 7099
742 CURRENT_NUMBER_OF_BYTES_USED 7099
743 HIGH_NUMBER_OF_BYTES_USED 7099
744 username user2
745 EVENT_NAME memory/sql/user_var_entry::value
746 COUNT_ALLOC 3
747 COUNT_FREE 0
748 SUM_NUMBER_OF_BYTES_ALLOC 7099
749 SUM_NUMBER_OF_BYTES_FREE 0
750 LOW_COUNT_USED 3
751 CURRENT_COUNT_USED 3
752 HIGH_COUNT_USED 3
753 LOW_NUMBER_OF_BYTES_USED 7099
754 CURRENT_NUMBER_OF_BYTES_USED 7099
755 HIGH_NUMBER_OF_BYTES_USED 7099
756 username user3
757 EVENT_NAME memory/sql/user_var_entry::value
758 COUNT_ALLOC 3
759 COUNT_FREE 0
760 SUM_NUMBER_OF_BYTES_ALLOC 7099
761 SUM_NUMBER_OF_BYTES_FREE 0
762 LOW_COUNT_USED 0
763 CURRENT_COUNT_USED 3
764 HIGH_COUNT_USED 3
765 LOW_NUMBER_OF_BYTES_USED 0
766 CURRENT_NUMBER_OF_BYTES_USED 7099
767 HIGH_NUMBER_OF_BYTES_USED 7099
768 username user4
769 EVENT_NAME memory/sql/user_var_entry::value
770 COUNT_ALLOC 0
771 COUNT_FREE 0
772 SUM_NUMBER_OF_BYTES_ALLOC 0
773 SUM_NUMBER_OF_BYTES_FREE 0
774 LOW_COUNT_USED 0
775 CURRENT_COUNT_USED 0
776 HIGH_COUNT_USED 0
777 LOW_NUMBER_OF_BYTES_USED 0
778 CURRENT_NUMBER_OF_BYTES_USED 0
779 HIGH_NUMBER_OF_BYTES_USED 0
780 execute dump_memory_account;
781 execute dump_memory_user;
782 USER user1
783 EVENT_NAME memory/sql/user_var_entry::value
784 COUNT_ALLOC 3
785 COUNT_FREE 0
786 SUM_NUMBER_OF_BYTES_ALLOC 7099
787 SUM_NUMBER_OF_BYTES_FREE 0
788 LOW_COUNT_USED 0
789 CURRENT_COUNT_USED 3
790 HIGH_COUNT_USED 3
791 LOW_NUMBER_OF_BYTES_USED 0
792 CURRENT_NUMBER_OF_BYTES_USED 7099
793 HIGH_NUMBER_OF_BYTES_USED 7099
794 USER user2
795 EVENT_NAME memory/sql/user_var_entry::value
796 COUNT_ALLOC 3
797 COUNT_FREE 0
798 SUM_NUMBER_OF_BYTES_ALLOC 7099
799 SUM_NUMBER_OF_BYTES_FREE 0
800 LOW_COUNT_USED 0
801 CURRENT_COUNT_USED 3
802 HIGH_COUNT_USED 3
803 LOW_NUMBER_OF_BYTES_USED 0
804 CURRENT_NUMBER_OF_BYTES_USED 7099
805 HIGH_NUMBER_OF_BYTES_USED 7099
806 USER user3
807 EVENT_NAME memory/sql/user_var_entry::value
808 COUNT_ALLOC 3
809 COUNT_FREE 0
810 SUM_NUMBER_OF_BYTES_ALLOC 7099
811 SUM_NUMBER_OF_BYTES_FREE 0
812 LOW_COUNT_USED 0
813 CURRENT_COUNT_USED 3
814 HIGH_COUNT_USED 3
815 LOW_NUMBER_OF_BYTES_USED 0
816 CURRENT_NUMBER_OF_BYTES_USED 7099
817 HIGH_NUMBER_OF_BYTES_USED 7099
818 USER user4
819 EVENT_NAME memory/sql/user_var_entry::value
820 COUNT_ALLOC 0
821 COUNT_FREE 0
822 SUM_NUMBER_OF_BYTES_ALLOC 0
823 SUM_NUMBER_OF_BYTES_FREE 0
824 LOW_COUNT_USED 0
825 CURRENT_COUNT_USED 0
826 HIGH_COUNT_USED 0
827 LOW_NUMBER_OF_BYTES_USED 0
828 CURRENT_NUMBER_OF_BYTES_USED 0
829 HIGH_NUMBER_OF_BYTES_USED 0
830 execute dump_memory_host;
831 HOST localhost
832 EVENT_NAME memory/sql/user_var_entry::value
833 COUNT_ALLOC 9
834 COUNT_FREE 0
835 SUM_NUMBER_OF_BYTES_ALLOC 21297
836 SUM_NUMBER_OF_BYTES_FREE 0
837 LOW_COUNT_USED 0
838 CURRENT_COUNT_USED 9
839 HIGH_COUNT_USED 9
840 LOW_NUMBER_OF_BYTES_USED 0
841 CURRENT_NUMBER_OF_BYTES_USED 21297
842 HIGH_NUMBER_OF_BYTES_USED 21297
843 execute dump_memory_global;
844 EVENT_NAME memory/sql/user_var_entry::value
845 COUNT_ALLOC 9
846 COUNT_FREE 0
847 SUM_NUMBER_OF_BYTES_ALLOC 21297
848 SUM_NUMBER_OF_BYTES_FREE 0
849 LOW_COUNT_USED 0
850 CURRENT_COUNT_USED 9
851 HIGH_COUNT_USED 9
852 LOW_NUMBER_OF_BYTES_USED 0
853 CURRENT_NUMBER_OF_BYTES_USED 21297
854 HIGH_NUMBER_OF_BYTES_USED 21297
855 execute dump_accounts;
856 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
857 execute dump_users;
858 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
859 event_scheduler 1 1
860 root 1 1
861 user1 1 1
862 user2 1 1
863 user3 1 1
864 user4 2 2
865 execute dump_hosts;
866 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
867 localhost 7 7
868 select get_lock("marker_4", 10);
869 get_lock("marker_4", 10)
870 1
871 select release_lock("marker_4");
872 release_lock("marker_4")
873 1
874 set @v1 = repeat("a", 1000);
875 set @v2 = repeat("b", 2000);
876 set @v3 = repeat("c", 4000);
877 select get_lock("marker_5", 10);
878 get_lock("marker_5", 10)
879 1
880 select release_lock("marker_5");
881 release_lock("marker_5")
882 1
883 set @v1 = repeat("a", 1000);
884 set @v2 = repeat("b", 2000);
885 set @v3 = repeat("c", 4000);
886 "================== con4/con5 marker =================="
887 "================== Step 9 =================="
888 call dump_thread();
889 username user1
890 EVENT_NAME memory/sql/user_var_entry::value
891 COUNT_ALLOC 3
892 COUNT_FREE 0
893 SUM_NUMBER_OF_BYTES_ALLOC 7099
894 SUM_NUMBER_OF_BYTES_FREE 0
895 LOW_COUNT_USED 3
896 CURRENT_COUNT_USED 3
897 HIGH_COUNT_USED 3
898 LOW_NUMBER_OF_BYTES_USED 7099
899 CURRENT_NUMBER_OF_BYTES_USED 7099
900 HIGH_NUMBER_OF_BYTES_USED 7099
901 username user2
902 EVENT_NAME memory/sql/user_var_entry::value
903 COUNT_ALLOC 3
904 COUNT_FREE 0
905 SUM_NUMBER_OF_BYTES_ALLOC 7099
906 SUM_NUMBER_OF_BYTES_FREE 0
907 LOW_COUNT_USED 3
908 CURRENT_COUNT_USED 3
909 HIGH_COUNT_USED 3
910 LOW_NUMBER_OF_BYTES_USED 7099
911 CURRENT_NUMBER_OF_BYTES_USED 7099
912 HIGH_NUMBER_OF_BYTES_USED 7099
913 username user3
914 EVENT_NAME memory/sql/user_var_entry::value
915 COUNT_ALLOC 3
916 COUNT_FREE 0
917 SUM_NUMBER_OF_BYTES_ALLOC 7099
918 SUM_NUMBER_OF_BYTES_FREE 0
919 LOW_COUNT_USED 0
920 CURRENT_COUNT_USED 3
921 HIGH_COUNT_USED 3
922 LOW_NUMBER_OF_BYTES_USED 0
923 CURRENT_NUMBER_OF_BYTES_USED 7099
924 HIGH_NUMBER_OF_BYTES_USED 7099
925 username user4
926 EVENT_NAME memory/sql/user_var_entry::value
927 COUNT_ALLOC 3
928 COUNT_FREE 0
929 SUM_NUMBER_OF_BYTES_ALLOC 7099
930 SUM_NUMBER_OF_BYTES_FREE 0
931 LOW_COUNT_USED 0
932 CURRENT_COUNT_USED 3
933 HIGH_COUNT_USED 3
934 LOW_NUMBER_OF_BYTES_USED 0
935 CURRENT_NUMBER_OF_BYTES_USED 7099
936 HIGH_NUMBER_OF_BYTES_USED 7099
937 execute dump_memory_account;
938 execute dump_memory_user;
939 USER user1
940 EVENT_NAME memory/sql/user_var_entry::value
941 COUNT_ALLOC 3
942 COUNT_FREE 0
943 SUM_NUMBER_OF_BYTES_ALLOC 7099
944 SUM_NUMBER_OF_BYTES_FREE 0
945 LOW_COUNT_USED 0
946 CURRENT_COUNT_USED 3
947 HIGH_COUNT_USED 3
948 LOW_NUMBER_OF_BYTES_USED 0
949 CURRENT_NUMBER_OF_BYTES_USED 7099
950 HIGH_NUMBER_OF_BYTES_USED 7099
951 USER user2
952 EVENT_NAME memory/sql/user_var_entry::value
953 COUNT_ALLOC 3
954 COUNT_FREE 0
955 SUM_NUMBER_OF_BYTES_ALLOC 7099
956 SUM_NUMBER_OF_BYTES_FREE 0
957 LOW_COUNT_USED 0
958 CURRENT_COUNT_USED 3
959 HIGH_COUNT_USED 3
960 LOW_NUMBER_OF_BYTES_USED 0
961 CURRENT_NUMBER_OF_BYTES_USED 7099
962 HIGH_NUMBER_OF_BYTES_USED 7099
963 USER user3
964 EVENT_NAME memory/sql/user_var_entry::value
965 COUNT_ALLOC 3
966 COUNT_FREE 0
967 SUM_NUMBER_OF_BYTES_ALLOC 7099
968 SUM_NUMBER_OF_BYTES_FREE 0
969 LOW_COUNT_USED 0
970 CURRENT_COUNT_USED 3
971 HIGH_COUNT_USED 3
972 LOW_NUMBER_OF_BYTES_USED 0
973 CURRENT_NUMBER_OF_BYTES_USED 7099
974 HIGH_NUMBER_OF_BYTES_USED 7099
975 USER user4
976 EVENT_NAME memory/sql/user_var_entry::value
977 COUNT_ALLOC 6
978 COUNT_FREE 0
979 SUM_NUMBER_OF_BYTES_ALLOC 14198
980 SUM_NUMBER_OF_BYTES_FREE 0
981 LOW_COUNT_USED 0
982 CURRENT_COUNT_USED 6
983 HIGH_COUNT_USED 6
984 LOW_NUMBER_OF_BYTES_USED 0
985 CURRENT_NUMBER_OF_BYTES_USED 14198
986 HIGH_NUMBER_OF_BYTES_USED 14198
987 execute dump_memory_host;
988 HOST localhost
989 EVENT_NAME memory/sql/user_var_entry::value
990 COUNT_ALLOC 15
991 COUNT_FREE 0
992 SUM_NUMBER_OF_BYTES_ALLOC 35495
993 SUM_NUMBER_OF_BYTES_FREE 0
994 LOW_COUNT_USED 0
995 CURRENT_COUNT_USED 15
996 HIGH_COUNT_USED 15
997 LOW_NUMBER_OF_BYTES_USED 0
998 CURRENT_NUMBER_OF_BYTES_USED 35495
999 HIGH_NUMBER_OF_BYTES_USED 35495
1000 execute dump_memory_global;
1001 EVENT_NAME memory/sql/user_var_entry::value
1002 COUNT_ALLOC 15
1003 COUNT_FREE 0
1004 SUM_NUMBER_OF_BYTES_ALLOC 35495
1005 SUM_NUMBER_OF_BYTES_FREE 0
1006 LOW_COUNT_USED 0
1007 CURRENT_COUNT_USED 15
1008 HIGH_COUNT_USED 15
1009 LOW_NUMBER_OF_BYTES_USED 0
1010 CURRENT_NUMBER_OF_BYTES_USED 35495
1011 HIGH_NUMBER_OF_BYTES_USED 35495
1012 execute dump_accounts;
1013 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1014 execute dump_users;
1015 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1016 event_scheduler 1 1
1017 root 1 1
1018 user1 1 1
1019 user2 1 1
1020 user3 1 1
1021 user4 2 2
1022 execute dump_hosts;
1023 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1024 localhost 7 7
1025 "================== con1/con5 disconnected =================="
1026 "================== Step 10 =================="
1027 call dump_thread();
1028 username user1
1029 status not found
1030 username user2
1031 EVENT_NAME memory/sql/user_var_entry::value
1032 COUNT_ALLOC 3
1033 COUNT_FREE 0
1034 SUM_NUMBER_OF_BYTES_ALLOC 7099
1035 SUM_NUMBER_OF_BYTES_FREE 0
1036 LOW_COUNT_USED 3
1037 CURRENT_COUNT_USED 3
1038 HIGH_COUNT_USED 3
1039 LOW_NUMBER_OF_BYTES_USED 7099
1040 CURRENT_NUMBER_OF_BYTES_USED 7099
1041 HIGH_NUMBER_OF_BYTES_USED 7099
1042 username user3
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 0
1049 CURRENT_COUNT_USED 3
1050 HIGH_COUNT_USED 3
1051 LOW_NUMBER_OF_BYTES_USED 0
1052 CURRENT_NUMBER_OF_BYTES_USED 7099
1053 HIGH_NUMBER_OF_BYTES_USED 7099
1054 username user4
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 0
1061 CURRENT_COUNT_USED 3
1062 HIGH_COUNT_USED 3
1063 LOW_NUMBER_OF_BYTES_USED 0
1064 CURRENT_NUMBER_OF_BYTES_USED 7099
1065 HIGH_NUMBER_OF_BYTES_USED 7099
1066 execute dump_memory_account;
1067 execute dump_memory_user;
1068 USER user1
1069 EVENT_NAME memory/sql/user_var_entry::value
1070 COUNT_ALLOC 3
1071 COUNT_FREE 3
1072 SUM_NUMBER_OF_BYTES_ALLOC 7099
1073 SUM_NUMBER_OF_BYTES_FREE 7099
1074 LOW_COUNT_USED 0
1075 CURRENT_COUNT_USED 0
1076 HIGH_COUNT_USED 3
1077 LOW_NUMBER_OF_BYTES_USED 0
1078 CURRENT_NUMBER_OF_BYTES_USED 0
1079 HIGH_NUMBER_OF_BYTES_USED 7099
1080 USER user2
1081 EVENT_NAME memory/sql/user_var_entry::value
1082 COUNT_ALLOC 3
1083 COUNT_FREE 0
1084 SUM_NUMBER_OF_BYTES_ALLOC 7099
1085 SUM_NUMBER_OF_BYTES_FREE 0
1086 LOW_COUNT_USED 0
1087 CURRENT_COUNT_USED 3
1088 HIGH_COUNT_USED 3
1089 LOW_NUMBER_OF_BYTES_USED 0
1090 CURRENT_NUMBER_OF_BYTES_USED 7099
1091 HIGH_NUMBER_OF_BYTES_USED 7099
1092 USER user3
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 user4
1105 EVENT_NAME memory/sql/user_var_entry::value
1106 COUNT_ALLOC 6
1107 COUNT_FREE 3
1108 SUM_NUMBER_OF_BYTES_ALLOC 14198
1109 SUM_NUMBER_OF_BYTES_FREE 7099
1110 LOW_COUNT_USED 0
1111 CURRENT_COUNT_USED 3
1112 HIGH_COUNT_USED 6
1113 LOW_NUMBER_OF_BYTES_USED 0
1114 CURRENT_NUMBER_OF_BYTES_USED 7099
1115 HIGH_NUMBER_OF_BYTES_USED 14198
1116 execute dump_memory_host;
1117 HOST localhost
1118 EVENT_NAME memory/sql/user_var_entry::value
1119 COUNT_ALLOC 15
1120 COUNT_FREE 6
1121 SUM_NUMBER_OF_BYTES_ALLOC 35495
1122 SUM_NUMBER_OF_BYTES_FREE 14198
1123 LOW_COUNT_USED 0
1124 CURRENT_COUNT_USED 9
1125 HIGH_COUNT_USED 15
1126 LOW_NUMBER_OF_BYTES_USED 0
1127 CURRENT_NUMBER_OF_BYTES_USED 21297
1128 HIGH_NUMBER_OF_BYTES_USED 35495
1129 execute dump_memory_global;
1130 EVENT_NAME memory/sql/user_var_entry::value
1131 COUNT_ALLOC 15
1132 COUNT_FREE 6
1133 SUM_NUMBER_OF_BYTES_ALLOC 35495
1134 SUM_NUMBER_OF_BYTES_FREE 14198
1135 LOW_COUNT_USED 0
1136 CURRENT_COUNT_USED 9
1137 HIGH_COUNT_USED 15
1138 LOW_NUMBER_OF_BYTES_USED 0
1139 CURRENT_NUMBER_OF_BYTES_USED 21297
1140 HIGH_NUMBER_OF_BYTES_USED 35495
1141 execute dump_accounts;
1142 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1143 execute dump_users;
1144 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1145 event_scheduler 1 1
1146 root 1 1
1147 user1 0 1
1148 user2 1 1
1149 user3 1 1
1150 user4 1 2
1151 execute dump_hosts;
1152 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1153 localhost 5 7
1154 "================== con2 disconnected =================="
1155 "================== Step 11 =================="
1156 call dump_thread();
1157 username user1
1158 status not found
1159 username user2
1160 status not found
1161 username user3
1162 EVENT_NAME memory/sql/user_var_entry::value
1163 COUNT_ALLOC 3
1164 COUNT_FREE 0
1165 SUM_NUMBER_OF_BYTES_ALLOC 7099
1166 SUM_NUMBER_OF_BYTES_FREE 0
1167 LOW_COUNT_USED 0
1168 CURRENT_COUNT_USED 3
1169 HIGH_COUNT_USED 3
1170 LOW_NUMBER_OF_BYTES_USED 0
1171 CURRENT_NUMBER_OF_BYTES_USED 7099
1172 HIGH_NUMBER_OF_BYTES_USED 7099
1173 username user4
1174 EVENT_NAME memory/sql/user_var_entry::value
1175 COUNT_ALLOC 3
1176 COUNT_FREE 0
1177 SUM_NUMBER_OF_BYTES_ALLOC 7099
1178 SUM_NUMBER_OF_BYTES_FREE 0
1179 LOW_COUNT_USED 0
1180 CURRENT_COUNT_USED 3
1181 HIGH_COUNT_USED 3
1182 LOW_NUMBER_OF_BYTES_USED 0
1183 CURRENT_NUMBER_OF_BYTES_USED 7099
1184 HIGH_NUMBER_OF_BYTES_USED 7099
1185 execute dump_memory_account;
1186 execute dump_memory_user;
1187 USER user1
1188 EVENT_NAME memory/sql/user_var_entry::value
1189 COUNT_ALLOC 3
1190 COUNT_FREE 3
1191 SUM_NUMBER_OF_BYTES_ALLOC 7099
1192 SUM_NUMBER_OF_BYTES_FREE 7099
1193 LOW_COUNT_USED 0
1194 CURRENT_COUNT_USED 0
1195 HIGH_COUNT_USED 3
1196 LOW_NUMBER_OF_BYTES_USED 0
1197 CURRENT_NUMBER_OF_BYTES_USED 0
1198 HIGH_NUMBER_OF_BYTES_USED 7099
1199 USER user2
1200 EVENT_NAME memory/sql/user_var_entry::value
1201 COUNT_ALLOC 3
1202 COUNT_FREE 3
1203 SUM_NUMBER_OF_BYTES_ALLOC 7099
1204 SUM_NUMBER_OF_BYTES_FREE 7099
1205 LOW_COUNT_USED 0
1206 CURRENT_COUNT_USED 0
1207 HIGH_COUNT_USED 3
1208 LOW_NUMBER_OF_BYTES_USED 0
1209 CURRENT_NUMBER_OF_BYTES_USED 0
1210 HIGH_NUMBER_OF_BYTES_USED 7099
1211 USER user3
1212 EVENT_NAME memory/sql/user_var_entry::value
1213 COUNT_ALLOC 3
1214 COUNT_FREE 0
1215 SUM_NUMBER_OF_BYTES_ALLOC 7099
1216 SUM_NUMBER_OF_BYTES_FREE 0
1217 LOW_COUNT_USED 0
1218 CURRENT_COUNT_USED 3
1219 HIGH_COUNT_USED 3
1220 LOW_NUMBER_OF_BYTES_USED 0
1221 CURRENT_NUMBER_OF_BYTES_USED 7099
1222 HIGH_NUMBER_OF_BYTES_USED 7099
1223 USER user4
1224 EVENT_NAME memory/sql/user_var_entry::value
1225 COUNT_ALLOC 6
1226 COUNT_FREE 3
1227 SUM_NUMBER_OF_BYTES_ALLOC 14198
1228 SUM_NUMBER_OF_BYTES_FREE 7099
1229 LOW_COUNT_USED 0
1230 CURRENT_COUNT_USED 3
1231 HIGH_COUNT_USED 6
1232 LOW_NUMBER_OF_BYTES_USED 0
1233 CURRENT_NUMBER_OF_BYTES_USED 7099
1234 HIGH_NUMBER_OF_BYTES_USED 14198
1235 execute dump_memory_host;
1236 HOST localhost
1237 EVENT_NAME memory/sql/user_var_entry::value
1238 COUNT_ALLOC 15
1239 COUNT_FREE 9
1240 SUM_NUMBER_OF_BYTES_ALLOC 35495
1241 SUM_NUMBER_OF_BYTES_FREE 21297
1242 LOW_COUNT_USED 0
1243 CURRENT_COUNT_USED 6
1244 HIGH_COUNT_USED 15
1245 LOW_NUMBER_OF_BYTES_USED 0
1246 CURRENT_NUMBER_OF_BYTES_USED 14198
1247 HIGH_NUMBER_OF_BYTES_USED 35495
1248 execute dump_memory_global;
1249 EVENT_NAME memory/sql/user_var_entry::value
1250 COUNT_ALLOC 15
1251 COUNT_FREE 9
1252 SUM_NUMBER_OF_BYTES_ALLOC 35495
1253 SUM_NUMBER_OF_BYTES_FREE 21297
1254 LOW_COUNT_USED 0
1255 CURRENT_COUNT_USED 6
1256 HIGH_COUNT_USED 15
1257 LOW_NUMBER_OF_BYTES_USED 0
1258 CURRENT_NUMBER_OF_BYTES_USED 14198
1259 HIGH_NUMBER_OF_BYTES_USED 35495
1260 execute dump_accounts;
1261 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1262 execute dump_users;
1263 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1264 event_scheduler 1 1
1265 root 1 1
1266 user1 0 1
1267 user2 0 1
1268 user3 1 1
1269 user4 1 2
1270 execute dump_hosts;
1271 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1272 localhost 4 7
1273 "================== con3 disconnected =================="
1274 "================== Step 12 =================="
1275 call dump_thread();
1276 username user1
1277 status not found
1278 username user2
1279 status not found
1280 username user3
1281 status not found
1282 username user4
1283 EVENT_NAME memory/sql/user_var_entry::value
1284 COUNT_ALLOC 3
1285 COUNT_FREE 0
1286 SUM_NUMBER_OF_BYTES_ALLOC 7099
1287 SUM_NUMBER_OF_BYTES_FREE 0
1288 LOW_COUNT_USED 0
1289 CURRENT_COUNT_USED 3
1290 HIGH_COUNT_USED 3
1291 LOW_NUMBER_OF_BYTES_USED 0
1292 CURRENT_NUMBER_OF_BYTES_USED 7099
1293 HIGH_NUMBER_OF_BYTES_USED 7099
1294 execute dump_memory_account;
1295 execute dump_memory_user;
1296 USER user1
1297 EVENT_NAME memory/sql/user_var_entry::value
1298 COUNT_ALLOC 3
1299 COUNT_FREE 3
1300 SUM_NUMBER_OF_BYTES_ALLOC 7099
1301 SUM_NUMBER_OF_BYTES_FREE 7099
1302 LOW_COUNT_USED 0
1303 CURRENT_COUNT_USED 0
1304 HIGH_COUNT_USED 3
1305 LOW_NUMBER_OF_BYTES_USED 0
1306 CURRENT_NUMBER_OF_BYTES_USED 0
1307 HIGH_NUMBER_OF_BYTES_USED 7099
1308 USER user2
1309 EVENT_NAME memory/sql/user_var_entry::value
1310 COUNT_ALLOC 3
1311 COUNT_FREE 3
1312 SUM_NUMBER_OF_BYTES_ALLOC 7099
1313 SUM_NUMBER_OF_BYTES_FREE 7099
1314 LOW_COUNT_USED 0
1315 CURRENT_COUNT_USED 0
1316 HIGH_COUNT_USED 3
1317 LOW_NUMBER_OF_BYTES_USED 0
1318 CURRENT_NUMBER_OF_BYTES_USED 0
1319 HIGH_NUMBER_OF_BYTES_USED 7099
1320 USER user3
1321 EVENT_NAME memory/sql/user_var_entry::value
1322 COUNT_ALLOC 3
1323 COUNT_FREE 3
1324 SUM_NUMBER_OF_BYTES_ALLOC 7099
1325 SUM_NUMBER_OF_BYTES_FREE 7099
1326 LOW_COUNT_USED 0
1327 CURRENT_COUNT_USED 0
1328 HIGH_COUNT_USED 3
1329 LOW_NUMBER_OF_BYTES_USED 0
1330 CURRENT_NUMBER_OF_BYTES_USED 0
1331 HIGH_NUMBER_OF_BYTES_USED 7099
1332 USER user4
1333 EVENT_NAME memory/sql/user_var_entry::value
1334 COUNT_ALLOC 6
1335 COUNT_FREE 3
1336 SUM_NUMBER_OF_BYTES_ALLOC 14198
1337 SUM_NUMBER_OF_BYTES_FREE 7099
1338 LOW_COUNT_USED 0
1339 CURRENT_COUNT_USED 3
1340 HIGH_COUNT_USED 6
1341 LOW_NUMBER_OF_BYTES_USED 0
1342 CURRENT_NUMBER_OF_BYTES_USED 7099
1343 HIGH_NUMBER_OF_BYTES_USED 14198
1344 execute dump_memory_host;
1345 HOST localhost
1346 EVENT_NAME memory/sql/user_var_entry::value
1347 COUNT_ALLOC 15
1348 COUNT_FREE 12
1349 SUM_NUMBER_OF_BYTES_ALLOC 35495
1350 SUM_NUMBER_OF_BYTES_FREE 28396
1351 LOW_COUNT_USED 0
1352 CURRENT_COUNT_USED 3
1353 HIGH_COUNT_USED 15
1354 LOW_NUMBER_OF_BYTES_USED 0
1355 CURRENT_NUMBER_OF_BYTES_USED 7099
1356 HIGH_NUMBER_OF_BYTES_USED 35495
1357 execute dump_memory_global;
1358 EVENT_NAME memory/sql/user_var_entry::value
1359 COUNT_ALLOC 15
1360 COUNT_FREE 12
1361 SUM_NUMBER_OF_BYTES_ALLOC 35495
1362 SUM_NUMBER_OF_BYTES_FREE 28396
1363 LOW_COUNT_USED 0
1364 CURRENT_COUNT_USED 3
1365 HIGH_COUNT_USED 15
1366 LOW_NUMBER_OF_BYTES_USED 0
1367 CURRENT_NUMBER_OF_BYTES_USED 7099
1368 HIGH_NUMBER_OF_BYTES_USED 35495
1369 execute dump_accounts;
1370 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1371 execute dump_users;
1372 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1373 event_scheduler 1 1
1374 root 1 1
1375 user1 0 1
1376 user2 0 1
1377 user3 0 1
1378 user4 1 2
1379 execute dump_hosts;
1380 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1381 localhost 3 7
1382 "================== con4 disconnected =================="
1383 "================== Step 13 =================="
1384 call dump_thread();
1385 username user1
1386 status not found
1387 username user2
1388 status not found
1389 username user3
1390 status not found
1391 username user4
1392 status not found
1393 execute dump_memory_account;
1394 execute dump_memory_user;
1395 USER user1
1396 EVENT_NAME memory/sql/user_var_entry::value
1397 COUNT_ALLOC 3
1398 COUNT_FREE 3
1399 SUM_NUMBER_OF_BYTES_ALLOC 7099
1400 SUM_NUMBER_OF_BYTES_FREE 7099
1401 LOW_COUNT_USED 0
1402 CURRENT_COUNT_USED 0
1403 HIGH_COUNT_USED 3
1404 LOW_NUMBER_OF_BYTES_USED 0
1405 CURRENT_NUMBER_OF_BYTES_USED 0
1406 HIGH_NUMBER_OF_BYTES_USED 7099
1407 USER user2
1408 EVENT_NAME memory/sql/user_var_entry::value
1409 COUNT_ALLOC 3
1410 COUNT_FREE 3
1411 SUM_NUMBER_OF_BYTES_ALLOC 7099
1412 SUM_NUMBER_OF_BYTES_FREE 7099
1413 LOW_COUNT_USED 0
1414 CURRENT_COUNT_USED 0
1415 HIGH_COUNT_USED 3
1416 LOW_NUMBER_OF_BYTES_USED 0
1417 CURRENT_NUMBER_OF_BYTES_USED 0
1418 HIGH_NUMBER_OF_BYTES_USED 7099
1419 USER user3
1420 EVENT_NAME memory/sql/user_var_entry::value
1421 COUNT_ALLOC 3
1422 COUNT_FREE 3
1423 SUM_NUMBER_OF_BYTES_ALLOC 7099
1424 SUM_NUMBER_OF_BYTES_FREE 7099
1425 LOW_COUNT_USED 0
1426 CURRENT_COUNT_USED 0
1427 HIGH_COUNT_USED 3
1428 LOW_NUMBER_OF_BYTES_USED 0
1429 CURRENT_NUMBER_OF_BYTES_USED 0
1430 HIGH_NUMBER_OF_BYTES_USED 7099
1431 USER user4
1432 EVENT_NAME memory/sql/user_var_entry::value
1433 COUNT_ALLOC 6
1434 COUNT_FREE 6
1435 SUM_NUMBER_OF_BYTES_ALLOC 14198
1436 SUM_NUMBER_OF_BYTES_FREE 14198
1437 LOW_COUNT_USED 0
1438 CURRENT_COUNT_USED 0
1439 HIGH_COUNT_USED 6
1440 LOW_NUMBER_OF_BYTES_USED 0
1441 CURRENT_NUMBER_OF_BYTES_USED 0
1442 HIGH_NUMBER_OF_BYTES_USED 14198
1443 execute dump_memory_host;
1444 HOST localhost
1445 EVENT_NAME memory/sql/user_var_entry::value
1446 COUNT_ALLOC 15
1447 COUNT_FREE 15
1448 SUM_NUMBER_OF_BYTES_ALLOC 35495
1449 SUM_NUMBER_OF_BYTES_FREE 35495
1450 LOW_COUNT_USED 0
1451 CURRENT_COUNT_USED 0
1452 HIGH_COUNT_USED 15
1453 LOW_NUMBER_OF_BYTES_USED 0
1454 CURRENT_NUMBER_OF_BYTES_USED 0
1455 HIGH_NUMBER_OF_BYTES_USED 35495
1456 execute dump_memory_global;
1457 EVENT_NAME memory/sql/user_var_entry::value
1458 COUNT_ALLOC 15
1459 COUNT_FREE 15
1460 SUM_NUMBER_OF_BYTES_ALLOC 35495
1461 SUM_NUMBER_OF_BYTES_FREE 35495
1462 LOW_COUNT_USED 0
1463 CURRENT_COUNT_USED 0
1464 HIGH_COUNT_USED 15
1465 LOW_NUMBER_OF_BYTES_USED 0
1466 CURRENT_NUMBER_OF_BYTES_USED 0
1467 HIGH_NUMBER_OF_BYTES_USED 35495
1468 execute dump_accounts;
1469 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1470 execute dump_users;
1471 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1472 event_scheduler 1 1
1473 root 1 1
1474 user1 0 1
1475 user2 0 1
1476 user3 0 1
1477 user4 0 2
1478 execute dump_hosts;
1479 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1480 localhost 2 7
1481 truncate performance_schema.memory_summary_by_thread_by_event_name;
1482 "================== MEMORY_BY_THREAD truncated =================="
1483 "================== Step 14 =================="
1484 call dump_thread();
1485 username user1
1486 status not found
1487 username user2
1488 status not found
1489 username user3
1490 status not found
1491 username user4
1492 status not found
1493 execute dump_memory_account;
1494 execute dump_memory_user;
1495 USER user1
1496 EVENT_NAME memory/sql/user_var_entry::value
1497 COUNT_ALLOC 3
1498 COUNT_FREE 3
1499 SUM_NUMBER_OF_BYTES_ALLOC 7099
1500 SUM_NUMBER_OF_BYTES_FREE 7099
1501 LOW_COUNT_USED 0
1502 CURRENT_COUNT_USED 0
1503 HIGH_COUNT_USED 3
1504 LOW_NUMBER_OF_BYTES_USED 0
1505 CURRENT_NUMBER_OF_BYTES_USED 0
1506 HIGH_NUMBER_OF_BYTES_USED 7099
1507 USER user2
1508 EVENT_NAME memory/sql/user_var_entry::value
1509 COUNT_ALLOC 3
1510 COUNT_FREE 3
1511 SUM_NUMBER_OF_BYTES_ALLOC 7099
1512 SUM_NUMBER_OF_BYTES_FREE 7099
1513 LOW_COUNT_USED 0
1514 CURRENT_COUNT_USED 0
1515 HIGH_COUNT_USED 3
1516 LOW_NUMBER_OF_BYTES_USED 0
1517 CURRENT_NUMBER_OF_BYTES_USED 0
1518 HIGH_NUMBER_OF_BYTES_USED 7099
1519 USER user3
1520 EVENT_NAME memory/sql/user_var_entry::value
1521 COUNT_ALLOC 3
1522 COUNT_FREE 3
1523 SUM_NUMBER_OF_BYTES_ALLOC 7099
1524 SUM_NUMBER_OF_BYTES_FREE 7099
1525 LOW_COUNT_USED 0
1526 CURRENT_COUNT_USED 0
1527 HIGH_COUNT_USED 3
1528 LOW_NUMBER_OF_BYTES_USED 0
1529 CURRENT_NUMBER_OF_BYTES_USED 0
1530 HIGH_NUMBER_OF_BYTES_USED 7099
1531 USER user4
1532 EVENT_NAME memory/sql/user_var_entry::value
1533 COUNT_ALLOC 6
1534 COUNT_FREE 6
1535 SUM_NUMBER_OF_BYTES_ALLOC 14198
1536 SUM_NUMBER_OF_BYTES_FREE 14198
1537 LOW_COUNT_USED 0
1538 CURRENT_COUNT_USED 0
1539 HIGH_COUNT_USED 6
1540 LOW_NUMBER_OF_BYTES_USED 0
1541 CURRENT_NUMBER_OF_BYTES_USED 0
1542 HIGH_NUMBER_OF_BYTES_USED 14198
1543 execute dump_memory_host;
1544 HOST localhost
1545 EVENT_NAME memory/sql/user_var_entry::value
1546 COUNT_ALLOC 15
1547 COUNT_FREE 15
1548 SUM_NUMBER_OF_BYTES_ALLOC 35495
1549 SUM_NUMBER_OF_BYTES_FREE 35495
1550 LOW_COUNT_USED 0
1551 CURRENT_COUNT_USED 0
1552 HIGH_COUNT_USED 15
1553 LOW_NUMBER_OF_BYTES_USED 0
1554 CURRENT_NUMBER_OF_BYTES_USED 0
1555 HIGH_NUMBER_OF_BYTES_USED 35495
1556 execute dump_memory_global;
1557 EVENT_NAME memory/sql/user_var_entry::value
1558 COUNT_ALLOC 15
1559 COUNT_FREE 15
1560 SUM_NUMBER_OF_BYTES_ALLOC 35495
1561 SUM_NUMBER_OF_BYTES_FREE 35495
1562 LOW_COUNT_USED 0
1563 CURRENT_COUNT_USED 0
1564 HIGH_COUNT_USED 15
1565 LOW_NUMBER_OF_BYTES_USED 0
1566 CURRENT_NUMBER_OF_BYTES_USED 0
1567 HIGH_NUMBER_OF_BYTES_USED 35495
1568 execute dump_accounts;
1569 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1570 execute dump_users;
1571 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1572 event_scheduler 1 1
1573 root 1 1
1574 user1 0 1
1575 user2 0 1
1576 user3 0 1
1577 user4 0 2
1578 execute dump_hosts;
1579 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1580 localhost 2 7
1581 truncate performance_schema.memory_summary_by_account_by_event_name;
1582 "================== MEMORY_BY_ACCOUNT truncated =================="
1583 "================== Step 15 =================="
1584 call dump_thread();
1585 username user1
1586 status not found
1587 username user2
1588 status not found
1589 username user3
1590 status not found
1591 username user4
1592 status not found
1593 execute dump_memory_account;
1594 execute dump_memory_user;
1595 USER user1
1596 EVENT_NAME memory/sql/user_var_entry::value
1597 COUNT_ALLOC 3
1598 COUNT_FREE 3
1599 SUM_NUMBER_OF_BYTES_ALLOC 7099
1600 SUM_NUMBER_OF_BYTES_FREE 7099
1601 LOW_COUNT_USED 0
1602 CURRENT_COUNT_USED 0
1603 HIGH_COUNT_USED 3
1604 LOW_NUMBER_OF_BYTES_USED 0
1605 CURRENT_NUMBER_OF_BYTES_USED 0
1606 HIGH_NUMBER_OF_BYTES_USED 7099
1607 USER user2
1608 EVENT_NAME memory/sql/user_var_entry::value
1609 COUNT_ALLOC 3
1610 COUNT_FREE 3
1611 SUM_NUMBER_OF_BYTES_ALLOC 7099
1612 SUM_NUMBER_OF_BYTES_FREE 7099
1613 LOW_COUNT_USED 0
1614 CURRENT_COUNT_USED 0
1615 HIGH_COUNT_USED 3
1616 LOW_NUMBER_OF_BYTES_USED 0
1617 CURRENT_NUMBER_OF_BYTES_USED 0
1618 HIGH_NUMBER_OF_BYTES_USED 7099
1619 USER user3
1620 EVENT_NAME memory/sql/user_var_entry::value
1621 COUNT_ALLOC 3
1622 COUNT_FREE 3
1623 SUM_NUMBER_OF_BYTES_ALLOC 7099
1624 SUM_NUMBER_OF_BYTES_FREE 7099
1625 LOW_COUNT_USED 0
1626 CURRENT_COUNT_USED 0
1627 HIGH_COUNT_USED 3
1628 LOW_NUMBER_OF_BYTES_USED 0
1629 CURRENT_NUMBER_OF_BYTES_USED 0
1630 HIGH_NUMBER_OF_BYTES_USED 7099
1631 USER user4
1632 EVENT_NAME memory/sql/user_var_entry::value
1633 COUNT_ALLOC 6
1634 COUNT_FREE 6
1635 SUM_NUMBER_OF_BYTES_ALLOC 14198
1636 SUM_NUMBER_OF_BYTES_FREE 14198
1637 LOW_COUNT_USED 0
1638 CURRENT_COUNT_USED 0
1639 HIGH_COUNT_USED 6
1640 LOW_NUMBER_OF_BYTES_USED 0
1641 CURRENT_NUMBER_OF_BYTES_USED 0
1642 HIGH_NUMBER_OF_BYTES_USED 14198
1643 execute dump_memory_host;
1644 HOST localhost
1645 EVENT_NAME memory/sql/user_var_entry::value
1646 COUNT_ALLOC 15
1647 COUNT_FREE 15
1648 SUM_NUMBER_OF_BYTES_ALLOC 35495
1649 SUM_NUMBER_OF_BYTES_FREE 35495
1650 LOW_COUNT_USED 0
1651 CURRENT_COUNT_USED 0
1652 HIGH_COUNT_USED 15
1653 LOW_NUMBER_OF_BYTES_USED 0
1654 CURRENT_NUMBER_OF_BYTES_USED 0
1655 HIGH_NUMBER_OF_BYTES_USED 35495
1656 execute dump_memory_global;
1657 EVENT_NAME memory/sql/user_var_entry::value
1658 COUNT_ALLOC 15
1659 COUNT_FREE 15
1660 SUM_NUMBER_OF_BYTES_ALLOC 35495
1661 SUM_NUMBER_OF_BYTES_FREE 35495
1662 LOW_COUNT_USED 0
1663 CURRENT_COUNT_USED 0
1664 HIGH_COUNT_USED 15
1665 LOW_NUMBER_OF_BYTES_USED 0
1666 CURRENT_NUMBER_OF_BYTES_USED 0
1667 HIGH_NUMBER_OF_BYTES_USED 35495
1668 execute dump_accounts;
1669 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1670 execute dump_users;
1671 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1672 event_scheduler 1 1
1673 root 1 1
1674 user1 0 1
1675 user2 0 1
1676 user3 0 1
1677 user4 0 2
1678 execute dump_hosts;
1679 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1680 localhost 2 7
1681 truncate performance_schema.memory_summary_by_user_by_event_name;
1682 "================== MEMORY_BY_USER truncated =================="
1683 "================== Step 16 =================="
1684 call dump_thread();
1685 username user1
1686 status not found
1687 username user2
1688 status not found
1689 username user3
1690 status not found
1691 username user4
1692 status not found
1693 execute dump_memory_account;
1694 execute dump_memory_user;
1695 USER user1
1696 EVENT_NAME memory/sql/user_var_entry::value
1697 COUNT_ALLOC 0
1698 COUNT_FREE 0
1699 SUM_NUMBER_OF_BYTES_ALLOC 0
1700 SUM_NUMBER_OF_BYTES_FREE 0
1701 LOW_COUNT_USED 0
1702 CURRENT_COUNT_USED 0
1703 HIGH_COUNT_USED 0
1704 LOW_NUMBER_OF_BYTES_USED 0
1705 CURRENT_NUMBER_OF_BYTES_USED 0
1706 HIGH_NUMBER_OF_BYTES_USED 0
1707 USER user2
1708 EVENT_NAME memory/sql/user_var_entry::value
1709 COUNT_ALLOC 0
1710 COUNT_FREE 0
1711 SUM_NUMBER_OF_BYTES_ALLOC 0
1712 SUM_NUMBER_OF_BYTES_FREE 0
1713 LOW_COUNT_USED 0
1714 CURRENT_COUNT_USED 0
1715 HIGH_COUNT_USED 0
1716 LOW_NUMBER_OF_BYTES_USED 0
1717 CURRENT_NUMBER_OF_BYTES_USED 0
1718 HIGH_NUMBER_OF_BYTES_USED 0
1719 USER user3
1720 EVENT_NAME memory/sql/user_var_entry::value
1721 COUNT_ALLOC 0
1722 COUNT_FREE 0
1723 SUM_NUMBER_OF_BYTES_ALLOC 0
1724 SUM_NUMBER_OF_BYTES_FREE 0
1725 LOW_COUNT_USED 0
1726 CURRENT_COUNT_USED 0
1727 HIGH_COUNT_USED 0
1728 LOW_NUMBER_OF_BYTES_USED 0
1729 CURRENT_NUMBER_OF_BYTES_USED 0
1730 HIGH_NUMBER_OF_BYTES_USED 0
1731 USER user4
1732 EVENT_NAME memory/sql/user_var_entry::value
1733 COUNT_ALLOC 0
1734 COUNT_FREE 0
1735 SUM_NUMBER_OF_BYTES_ALLOC 0
1736 SUM_NUMBER_OF_BYTES_FREE 0
1737 LOW_COUNT_USED 0
1738 CURRENT_COUNT_USED 0
1739 HIGH_COUNT_USED 0
1740 LOW_NUMBER_OF_BYTES_USED 0
1741 CURRENT_NUMBER_OF_BYTES_USED 0
1742 HIGH_NUMBER_OF_BYTES_USED 0
1743 execute dump_memory_host;
1744 HOST localhost
1745 EVENT_NAME memory/sql/user_var_entry::value
1746 COUNT_ALLOC 15
1747 COUNT_FREE 15
1748 SUM_NUMBER_OF_BYTES_ALLOC 35495
1749 SUM_NUMBER_OF_BYTES_FREE 35495
1750 LOW_COUNT_USED 0
1751 CURRENT_COUNT_USED 0
1752 HIGH_COUNT_USED 15
1753 LOW_NUMBER_OF_BYTES_USED 0
1754 CURRENT_NUMBER_OF_BYTES_USED 0
1755 HIGH_NUMBER_OF_BYTES_USED 35495
1756 execute dump_memory_global;
1757 EVENT_NAME memory/sql/user_var_entry::value
1758 COUNT_ALLOC 15
1759 COUNT_FREE 15
1760 SUM_NUMBER_OF_BYTES_ALLOC 35495
1761 SUM_NUMBER_OF_BYTES_FREE 35495
1762 LOW_COUNT_USED 0
1763 CURRENT_COUNT_USED 0
1764 HIGH_COUNT_USED 15
1765 LOW_NUMBER_OF_BYTES_USED 0
1766 CURRENT_NUMBER_OF_BYTES_USED 0
1767 HIGH_NUMBER_OF_BYTES_USED 35495
1768 execute dump_accounts;
1769 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1770 execute dump_users;
1771 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1772 event_scheduler 1 1
1773 root 1 1
1774 user1 0 1
1775 user2 0 1
1776 user3 0 1
1777 user4 0 2
1778 execute dump_hosts;
1779 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1780 localhost 2 7
1781 truncate performance_schema.memory_summary_by_host_by_event_name;
1782 "================== MEMORY_BY_HOST truncated =================="
1783 "================== Step 17 =================="
1784 call dump_thread();
1785 username user1
1786 status not found
1787 username user2
1788 status not found
1789 username user3
1790 status not found
1791 username user4
1792 status not found
1793 execute dump_memory_account;
1794 execute dump_memory_user;
1795 USER user1
1796 EVENT_NAME memory/sql/user_var_entry::value
1797 COUNT_ALLOC 0
1798 COUNT_FREE 0
1799 SUM_NUMBER_OF_BYTES_ALLOC 0
1800 SUM_NUMBER_OF_BYTES_FREE 0
1801 LOW_COUNT_USED 0
1802 CURRENT_COUNT_USED 0
1803 HIGH_COUNT_USED 0
1804 LOW_NUMBER_OF_BYTES_USED 0
1805 CURRENT_NUMBER_OF_BYTES_USED 0
1806 HIGH_NUMBER_OF_BYTES_USED 0
1807 USER user2
1808 EVENT_NAME memory/sql/user_var_entry::value
1809 COUNT_ALLOC 0
1810 COUNT_FREE 0
1811 SUM_NUMBER_OF_BYTES_ALLOC 0
1812 SUM_NUMBER_OF_BYTES_FREE 0
1813 LOW_COUNT_USED 0
1814 CURRENT_COUNT_USED 0
1815 HIGH_COUNT_USED 0
1816 LOW_NUMBER_OF_BYTES_USED 0
1817 CURRENT_NUMBER_OF_BYTES_USED 0
1818 HIGH_NUMBER_OF_BYTES_USED 0
1819 USER user3
1820 EVENT_NAME memory/sql/user_var_entry::value
1821 COUNT_ALLOC 0
1822 COUNT_FREE 0
1823 SUM_NUMBER_OF_BYTES_ALLOC 0
1824 SUM_NUMBER_OF_BYTES_FREE 0
1825 LOW_COUNT_USED 0
1826 CURRENT_COUNT_USED 0
1827 HIGH_COUNT_USED 0
1828 LOW_NUMBER_OF_BYTES_USED 0
1829 CURRENT_NUMBER_OF_BYTES_USED 0
1830 HIGH_NUMBER_OF_BYTES_USED 0
1831 USER user4
1832 EVENT_NAME memory/sql/user_var_entry::value
1833 COUNT_ALLOC 0
1834 COUNT_FREE 0
1835 SUM_NUMBER_OF_BYTES_ALLOC 0
1836 SUM_NUMBER_OF_BYTES_FREE 0
1837 LOW_COUNT_USED 0
1838 CURRENT_COUNT_USED 0
1839 HIGH_COUNT_USED 0
1840 LOW_NUMBER_OF_BYTES_USED 0
1841 CURRENT_NUMBER_OF_BYTES_USED 0
1842 HIGH_NUMBER_OF_BYTES_USED 0
1843 execute dump_memory_host;
1844 HOST localhost
1845 EVENT_NAME memory/sql/user_var_entry::value
1846 COUNT_ALLOC 0
1847 COUNT_FREE 0
1848 SUM_NUMBER_OF_BYTES_ALLOC 0
1849 SUM_NUMBER_OF_BYTES_FREE 0
1850 LOW_COUNT_USED 0
1851 CURRENT_COUNT_USED 0
1852 HIGH_COUNT_USED 0
1853 LOW_NUMBER_OF_BYTES_USED 0
1854 CURRENT_NUMBER_OF_BYTES_USED 0
1855 HIGH_NUMBER_OF_BYTES_USED 0
1856 execute dump_memory_global;
1857 EVENT_NAME memory/sql/user_var_entry::value
1858 COUNT_ALLOC 15
1859 COUNT_FREE 15
1860 SUM_NUMBER_OF_BYTES_ALLOC 35495
1861 SUM_NUMBER_OF_BYTES_FREE 35495
1862 LOW_COUNT_USED 0
1863 CURRENT_COUNT_USED 0
1864 HIGH_COUNT_USED 15
1865 LOW_NUMBER_OF_BYTES_USED 0
1866 CURRENT_NUMBER_OF_BYTES_USED 0
1867 HIGH_NUMBER_OF_BYTES_USED 35495
1868 execute dump_accounts;
1869 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1870 execute dump_users;
1871 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1872 event_scheduler 1 1
1873 root 1 1
1874 user1 0 1
1875 user2 0 1
1876 user3 0 1
1877 user4 0 2
1878 execute dump_hosts;
1879 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1880 localhost 2 7
1881 truncate performance_schema.memory_summary_global_by_event_name;
1882 "================== MEMORY_GLOBAL truncated =================="
1883 "================== Step 18 =================="
1884 call dump_thread();
1885 username user1
1886 status not found
1887 username user2
1888 status not found
1889 username user3
1890 status not found
1891 username user4
1892 status not found
1893 execute dump_memory_account;
1894 execute dump_memory_user;
1895 USER user1
1896 EVENT_NAME memory/sql/user_var_entry::value
1897 COUNT_ALLOC 0
1898 COUNT_FREE 0
1899 SUM_NUMBER_OF_BYTES_ALLOC 0
1900 SUM_NUMBER_OF_BYTES_FREE 0
1901 LOW_COUNT_USED 0
1902 CURRENT_COUNT_USED 0
1903 HIGH_COUNT_USED 0
1904 LOW_NUMBER_OF_BYTES_USED 0
1905 CURRENT_NUMBER_OF_BYTES_USED 0
1906 HIGH_NUMBER_OF_BYTES_USED 0
1907 USER user2
1908 EVENT_NAME memory/sql/user_var_entry::value
1909 COUNT_ALLOC 0
1910 COUNT_FREE 0
1911 SUM_NUMBER_OF_BYTES_ALLOC 0
1912 SUM_NUMBER_OF_BYTES_FREE 0
1913 LOW_COUNT_USED 0
1914 CURRENT_COUNT_USED 0
1915 HIGH_COUNT_USED 0
1916 LOW_NUMBER_OF_BYTES_USED 0
1917 CURRENT_NUMBER_OF_BYTES_USED 0
1918 HIGH_NUMBER_OF_BYTES_USED 0
1919 USER user3
1920 EVENT_NAME memory/sql/user_var_entry::value
1921 COUNT_ALLOC 0
1922 COUNT_FREE 0
1923 SUM_NUMBER_OF_BYTES_ALLOC 0
1924 SUM_NUMBER_OF_BYTES_FREE 0
1925 LOW_COUNT_USED 0
1926 CURRENT_COUNT_USED 0
1927 HIGH_COUNT_USED 0
1928 LOW_NUMBER_OF_BYTES_USED 0
1929 CURRENT_NUMBER_OF_BYTES_USED 0
1930 HIGH_NUMBER_OF_BYTES_USED 0
1931 USER user4
1932 EVENT_NAME memory/sql/user_var_entry::value
1933 COUNT_ALLOC 0
1934 COUNT_FREE 0
1935 SUM_NUMBER_OF_BYTES_ALLOC 0
1936 SUM_NUMBER_OF_BYTES_FREE 0
1937 LOW_COUNT_USED 0
1938 CURRENT_COUNT_USED 0
1939 HIGH_COUNT_USED 0
1940 LOW_NUMBER_OF_BYTES_USED 0
1941 CURRENT_NUMBER_OF_BYTES_USED 0
1942 HIGH_NUMBER_OF_BYTES_USED 0
1943 execute dump_memory_host;
1944 HOST localhost
1945 EVENT_NAME memory/sql/user_var_entry::value
1946 COUNT_ALLOC 0
1947 COUNT_FREE 0
1948 SUM_NUMBER_OF_BYTES_ALLOC 0
1949 SUM_NUMBER_OF_BYTES_FREE 0
1950 LOW_COUNT_USED 0
1951 CURRENT_COUNT_USED 0
1952 HIGH_COUNT_USED 0
1953 LOW_NUMBER_OF_BYTES_USED 0
1954 CURRENT_NUMBER_OF_BYTES_USED 0
1955 HIGH_NUMBER_OF_BYTES_USED 0
1956 execute dump_memory_global;
1957 EVENT_NAME memory/sql/user_var_entry::value
1958 COUNT_ALLOC 0
1959 COUNT_FREE 0
1960 SUM_NUMBER_OF_BYTES_ALLOC 0
1961 SUM_NUMBER_OF_BYTES_FREE 0
1962 LOW_COUNT_USED 0
1963 CURRENT_COUNT_USED 0
1964 HIGH_COUNT_USED 0
1965 LOW_NUMBER_OF_BYTES_USED 0
1966 CURRENT_NUMBER_OF_BYTES_USED 0
1967 HIGH_NUMBER_OF_BYTES_USED 0
1968 execute dump_accounts;
1969 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1970 execute dump_users;
1971 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1972 event_scheduler 1 1
1973 root 1 1
1974 user1 0 1
1975 user2 0 1
1976 user3 0 1
1977 user4 0 2
1978 execute dump_hosts;
1979 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1980 localhost 2 7
1981 truncate performance_schema.accounts;
1982 "================== ACCOUNTS truncated =================="
1983 "================== Step 19 =================="
1984 call dump_thread();
1985 username user1
1986 status not found
1987 username user2
1988 status not found
1989 username user3
1990 status not found
1991 username user4
1992 status not found
1993 execute dump_memory_account;
1994 execute dump_memory_user;
1995 USER user1
1996 EVENT_NAME memory/sql/user_var_entry::value
1997 COUNT_ALLOC 0
1998 COUNT_FREE 0
1999 SUM_NUMBER_OF_BYTES_ALLOC 0
2000 SUM_NUMBER_OF_BYTES_FREE 0
2001 LOW_COUNT_USED 0
2002 CURRENT_COUNT_USED 0
2003 HIGH_COUNT_USED 0
2004 LOW_NUMBER_OF_BYTES_USED 0
2005 CURRENT_NUMBER_OF_BYTES_USED 0
2006 HIGH_NUMBER_OF_BYTES_USED 0
2007 USER user2
2008 EVENT_NAME memory/sql/user_var_entry::value
2009 COUNT_ALLOC 0
2010 COUNT_FREE 0
2011 SUM_NUMBER_OF_BYTES_ALLOC 0
2012 SUM_NUMBER_OF_BYTES_FREE 0
2013 LOW_COUNT_USED 0
2014 CURRENT_COUNT_USED 0
2015 HIGH_COUNT_USED 0
2016 LOW_NUMBER_OF_BYTES_USED 0
2017 CURRENT_NUMBER_OF_BYTES_USED 0
2018 HIGH_NUMBER_OF_BYTES_USED 0
2019 USER user3
2020 EVENT_NAME memory/sql/user_var_entry::value
2021 COUNT_ALLOC 0
2022 COUNT_FREE 0
2023 SUM_NUMBER_OF_BYTES_ALLOC 0
2024 SUM_NUMBER_OF_BYTES_FREE 0
2025 LOW_COUNT_USED 0
2026 CURRENT_COUNT_USED 0
2027 HIGH_COUNT_USED 0
2028 LOW_NUMBER_OF_BYTES_USED 0
2029 CURRENT_NUMBER_OF_BYTES_USED 0
2030 HIGH_NUMBER_OF_BYTES_USED 0
2031 USER user4
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 execute dump_memory_host;
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 execute dump_memory_global;
2057 EVENT_NAME memory/sql/user_var_entry::value
2058 COUNT_ALLOC 0
2059 COUNT_FREE 0
2060 SUM_NUMBER_OF_BYTES_ALLOC 0
2061 SUM_NUMBER_OF_BYTES_FREE 0
2062 LOW_COUNT_USED 0
2063 CURRENT_COUNT_USED 0
2064 HIGH_COUNT_USED 0
2065 LOW_NUMBER_OF_BYTES_USED 0
2066 CURRENT_NUMBER_OF_BYTES_USED 0
2067 HIGH_NUMBER_OF_BYTES_USED 0
2068 execute dump_accounts;
2069 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2070 execute dump_users;
2071 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2072 event_scheduler 1 1
2073 root 1 1
2074 user1 0 1
2075 user2 0 1
2076 user3 0 1
2077 user4 0 2
2078 execute dump_hosts;
2079 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2080 localhost 2 7
2081 truncate performance_schema.users;
2082 "================== USERS truncated =================="
2083 "================== Step 20 =================="
2084 call dump_thread();
2085 username user1
2086 status not found
2087 username user2
2088 status not found
2089 username user3
2090 status not found
2091 username user4
2092 status not found
2093 execute dump_memory_account;
2094 execute dump_memory_user;
2095 execute dump_memory_host;
2096 HOST localhost
2097 EVENT_NAME memory/sql/user_var_entry::value
2098 COUNT_ALLOC 0
2099 COUNT_FREE 0
2100 SUM_NUMBER_OF_BYTES_ALLOC 0
2101 SUM_NUMBER_OF_BYTES_FREE 0
2102 LOW_COUNT_USED 0
2103 CURRENT_COUNT_USED 0
2104 HIGH_COUNT_USED 0
2105 LOW_NUMBER_OF_BYTES_USED 0
2106 CURRENT_NUMBER_OF_BYTES_USED 0
2107 HIGH_NUMBER_OF_BYTES_USED 0
2108 execute dump_memory_global;
2109 EVENT_NAME memory/sql/user_var_entry::value
2110 COUNT_ALLOC 0
2111 COUNT_FREE 0
2112 SUM_NUMBER_OF_BYTES_ALLOC 0
2113 SUM_NUMBER_OF_BYTES_FREE 0
2114 LOW_COUNT_USED 0
2115 CURRENT_COUNT_USED 0
2116 HIGH_COUNT_USED 0
2117 LOW_NUMBER_OF_BYTES_USED 0
2118 CURRENT_NUMBER_OF_BYTES_USED 0
2119 HIGH_NUMBER_OF_BYTES_USED 0
2120 execute dump_accounts;
2121 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2122 execute dump_users;
2123 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2124 event_scheduler 1 1
2125 root 1 1
2126 execute dump_hosts;
2127 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2128 localhost 2 7
2129 truncate performance_schema.hosts;
2130 "================== HOSTS truncated =================="
2131 "================== Step 21 =================="
2132 call dump_thread();
2133 username user1
2134 status not found
2135 username user2
2136 status not found
2137 username user3
2138 status not found
2139 username user4
2140 status not found
2141 execute dump_memory_account;
2142 execute dump_memory_user;
2143 execute dump_memory_host;
2144 HOST localhost
2145 EVENT_NAME memory/sql/user_var_entry::value
2146 COUNT_ALLOC 0
2147 COUNT_FREE 0
2148 SUM_NUMBER_OF_BYTES_ALLOC 0
2149 SUM_NUMBER_OF_BYTES_FREE 0
2150 LOW_COUNT_USED 0
2151 CURRENT_COUNT_USED 0
2152 HIGH_COUNT_USED 0
2153 LOW_NUMBER_OF_BYTES_USED 0
2154 CURRENT_NUMBER_OF_BYTES_USED 0
2155 HIGH_NUMBER_OF_BYTES_USED 0
2156 execute dump_memory_global;
2157 EVENT_NAME memory/sql/user_var_entry::value
2158 COUNT_ALLOC 0
2159 COUNT_FREE 0
2160 SUM_NUMBER_OF_BYTES_ALLOC 0
2161 SUM_NUMBER_OF_BYTES_FREE 0
2162 LOW_COUNT_USED 0
2163 CURRENT_COUNT_USED 0
2164 HIGH_COUNT_USED 0
2165 LOW_NUMBER_OF_BYTES_USED 0
2166 CURRENT_NUMBER_OF_BYTES_USED 0
2167 HIGH_NUMBER_OF_BYTES_USED 0
2168 execute dump_accounts;
2169 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2170 execute dump_users;
2171 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2172 event_scheduler 1 1
2173 root 1 1
2174 execute dump_hosts;
2175 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2176 localhost 2 2