Debian Codegraph @

mysql-test/suite/perfschema/r/memory_aggregate_no_a_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 execute dump_users;
32 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
33 event_scheduler 1 1
34 root 1 1
35 execute dump_hosts;
36 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
37 "================== con1 connected =================="
38 "================== Step 2 =================="
39 call dump_thread();
40 username user1
41 EVENT_NAME memory/sql/user_var_entry::value
42 COUNT_ALLOC 0
43 COUNT_FREE 0
44 SUM_NUMBER_OF_BYTES_ALLOC 0
45 SUM_NUMBER_OF_BYTES_FREE 0
46 LOW_COUNT_USED 0
47 CURRENT_COUNT_USED 0
48 HIGH_COUNT_USED 0
49 LOW_NUMBER_OF_BYTES_USED 0
50 CURRENT_NUMBER_OF_BYTES_USED 0
51 HIGH_NUMBER_OF_BYTES_USED 0
52 username user2
53 status not found
54 username user3
55 status not found
56 username user4
57 status not found
58 execute dump_memory_account;
59 execute dump_memory_user;
60 USER user1
61 EVENT_NAME memory/sql/user_var_entry::value
62 COUNT_ALLOC 0
63 COUNT_FREE 0
64 SUM_NUMBER_OF_BYTES_ALLOC 0
65 SUM_NUMBER_OF_BYTES_FREE 0
66 LOW_COUNT_USED 0
67 CURRENT_COUNT_USED 0
68 HIGH_COUNT_USED 0
69 LOW_NUMBER_OF_BYTES_USED 0
70 CURRENT_NUMBER_OF_BYTES_USED 0
71 HIGH_NUMBER_OF_BYTES_USED 0
72 execute dump_memory_host;
73 execute dump_memory_global;
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_accounts;
86 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
87 execute dump_users;
88 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
89 event_scheduler 1 1
90 root 1 1
91 user1 1 1
92 execute dump_hosts;
93 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
94 select get_lock("marker_1", 10);
95 get_lock("marker_1", 10)
96 1
97 select release_lock("marker_1");
98 release_lock("marker_1")
99 1
100 set @v1 = repeat("a", 1000);
101 set @v2 = repeat("b", 2000);
102 set @v3 = repeat("c", 4000);
103 "================== con1 marker =================="
104 "================== Step 3 =================="
105 call dump_thread();
106 username user1
107 EVENT_NAME memory/sql/user_var_entry::value
108 COUNT_ALLOC 3
109 COUNT_FREE 0
110 SUM_NUMBER_OF_BYTES_ALLOC 7099
111 SUM_NUMBER_OF_BYTES_FREE 0
112 LOW_COUNT_USED 0
113 CURRENT_COUNT_USED 3
114 HIGH_COUNT_USED 3
115 LOW_NUMBER_OF_BYTES_USED 0
116 CURRENT_NUMBER_OF_BYTES_USED 7099
117 HIGH_NUMBER_OF_BYTES_USED 7099
118 username user2
119 status not found
120 username user3
121 status not found
122 username user4
123 status not found
124 execute dump_memory_account;
125 execute dump_memory_user;
126 USER user1
127 EVENT_NAME memory/sql/user_var_entry::value
128 COUNT_ALLOC 3
129 COUNT_FREE 0
130 SUM_NUMBER_OF_BYTES_ALLOC 7099
131 SUM_NUMBER_OF_BYTES_FREE 0
132 LOW_COUNT_USED 0
133 CURRENT_COUNT_USED 3
134 HIGH_COUNT_USED 3
135 LOW_NUMBER_OF_BYTES_USED 0
136 CURRENT_NUMBER_OF_BYTES_USED 7099
137 HIGH_NUMBER_OF_BYTES_USED 7099
138 execute dump_memory_host;
139 execute dump_memory_global;
140 EVENT_NAME memory/sql/user_var_entry::value
141 COUNT_ALLOC 3
142 COUNT_FREE 0
143 SUM_NUMBER_OF_BYTES_ALLOC 7099
144 SUM_NUMBER_OF_BYTES_FREE 0
145 LOW_COUNT_USED 0
146 CURRENT_COUNT_USED 3
147 HIGH_COUNT_USED 3
148 LOW_NUMBER_OF_BYTES_USED 0
149 CURRENT_NUMBER_OF_BYTES_USED 7099
150 HIGH_NUMBER_OF_BYTES_USED 7099
151 execute dump_accounts;
152 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
153 execute dump_users;
154 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
155 event_scheduler 1 1
156 root 1 1
157 user1 1 1
158 execute dump_hosts;
159 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
160 "================== con2 connected =================="
161 "================== Step 4 =================="
162 call dump_thread();
163 username user1
164 EVENT_NAME memory/sql/user_var_entry::value
165 COUNT_ALLOC 3
166 COUNT_FREE 0
167 SUM_NUMBER_OF_BYTES_ALLOC 7099
168 SUM_NUMBER_OF_BYTES_FREE 0
169 LOW_COUNT_USED 0
170 CURRENT_COUNT_USED 3
171 HIGH_COUNT_USED 3
172 LOW_NUMBER_OF_BYTES_USED 0
173 CURRENT_NUMBER_OF_BYTES_USED 7099
174 HIGH_NUMBER_OF_BYTES_USED 7099
175 username user2
176 EVENT_NAME memory/sql/user_var_entry::value
177 COUNT_ALLOC 0
178 COUNT_FREE 0
179 SUM_NUMBER_OF_BYTES_ALLOC 0
180 SUM_NUMBER_OF_BYTES_FREE 0
181 LOW_COUNT_USED 0
182 CURRENT_COUNT_USED 0
183 HIGH_COUNT_USED 0
184 LOW_NUMBER_OF_BYTES_USED 0
185 CURRENT_NUMBER_OF_BYTES_USED 0
186 HIGH_NUMBER_OF_BYTES_USED 0
187 username user3
188 status not found
189 username user4
190 status not found
191 execute dump_memory_account;
192 execute dump_memory_user;
193 USER user1
194 EVENT_NAME memory/sql/user_var_entry::value
195 COUNT_ALLOC 3
196 COUNT_FREE 0
197 SUM_NUMBER_OF_BYTES_ALLOC 7099
198 SUM_NUMBER_OF_BYTES_FREE 0
199 LOW_COUNT_USED 0
200 CURRENT_COUNT_USED 3
201 HIGH_COUNT_USED 3
202 LOW_NUMBER_OF_BYTES_USED 0
203 CURRENT_NUMBER_OF_BYTES_USED 7099
204 HIGH_NUMBER_OF_BYTES_USED 7099
205 USER user2
206 EVENT_NAME memory/sql/user_var_entry::value
207 COUNT_ALLOC 0
208 COUNT_FREE 0
209 SUM_NUMBER_OF_BYTES_ALLOC 0
210 SUM_NUMBER_OF_BYTES_FREE 0
211 LOW_COUNT_USED 0
212 CURRENT_COUNT_USED 0
213 HIGH_COUNT_USED 0
214 LOW_NUMBER_OF_BYTES_USED 0
215 CURRENT_NUMBER_OF_BYTES_USED 0
216 HIGH_NUMBER_OF_BYTES_USED 0
217 execute dump_memory_host;
218 execute dump_memory_global;
219 EVENT_NAME memory/sql/user_var_entry::value
220 COUNT_ALLOC 3
221 COUNT_FREE 0
222 SUM_NUMBER_OF_BYTES_ALLOC 7099
223 SUM_NUMBER_OF_BYTES_FREE 0
224 LOW_COUNT_USED 0
225 CURRENT_COUNT_USED 3
226 HIGH_COUNT_USED 3
227 LOW_NUMBER_OF_BYTES_USED 0
228 CURRENT_NUMBER_OF_BYTES_USED 7099
229 HIGH_NUMBER_OF_BYTES_USED 7099
230 execute dump_accounts;
231 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
232 execute dump_users;
233 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
234 event_scheduler 1 1
235 root 1 1
236 user1 1 1
237 user2 1 1
238 execute dump_hosts;
239 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
240 select get_lock("marker_2", 10);
241 get_lock("marker_2", 10)
242 1
243 select release_lock("marker_2");
244 release_lock("marker_2")
245 1
246 set @v1 = repeat("a", 1000);
247 set @v2 = repeat("b", 2000);
248 set @v3 = repeat("c", 4000);
249 "================== con2 marker =================="
250 "================== Step 5 =================="
251 call dump_thread();
252 username user1
253 EVENT_NAME memory/sql/user_var_entry::value
254 COUNT_ALLOC 3
255 COUNT_FREE 0
256 SUM_NUMBER_OF_BYTES_ALLOC 7099
257 SUM_NUMBER_OF_BYTES_FREE 0
258 LOW_COUNT_USED 0
259 CURRENT_COUNT_USED 3
260 HIGH_COUNT_USED 3
261 LOW_NUMBER_OF_BYTES_USED 0
262 CURRENT_NUMBER_OF_BYTES_USED 7099
263 HIGH_NUMBER_OF_BYTES_USED 7099
264 username user2
265 EVENT_NAME memory/sql/user_var_entry::value
266 COUNT_ALLOC 3
267 COUNT_FREE 0
268 SUM_NUMBER_OF_BYTES_ALLOC 7099
269 SUM_NUMBER_OF_BYTES_FREE 0
270 LOW_COUNT_USED 0
271 CURRENT_COUNT_USED 3
272 HIGH_COUNT_USED 3
273 LOW_NUMBER_OF_BYTES_USED 0
274 CURRENT_NUMBER_OF_BYTES_USED 7099
275 HIGH_NUMBER_OF_BYTES_USED 7099
276 username user3
277 status not found
278 username user4
279 status not found
280 execute dump_memory_account;
281 execute dump_memory_user;
282 USER user1
283 EVENT_NAME memory/sql/user_var_entry::value
284 COUNT_ALLOC 3
285 COUNT_FREE 0
286 SUM_NUMBER_OF_BYTES_ALLOC 7099
287 SUM_NUMBER_OF_BYTES_FREE 0
288 LOW_COUNT_USED 0
289 CURRENT_COUNT_USED 3
290 HIGH_COUNT_USED 3
291 LOW_NUMBER_OF_BYTES_USED 0
292 CURRENT_NUMBER_OF_BYTES_USED 7099
293 HIGH_NUMBER_OF_BYTES_USED 7099
294 USER user2
295 EVENT_NAME memory/sql/user_var_entry::value
296 COUNT_ALLOC 3
297 COUNT_FREE 0
298 SUM_NUMBER_OF_BYTES_ALLOC 7099
299 SUM_NUMBER_OF_BYTES_FREE 0
300 LOW_COUNT_USED 0
301 CURRENT_COUNT_USED 3
302 HIGH_COUNT_USED 3
303 LOW_NUMBER_OF_BYTES_USED 0
304 CURRENT_NUMBER_OF_BYTES_USED 7099
305 HIGH_NUMBER_OF_BYTES_USED 7099
306 execute dump_memory_host;
307 execute dump_memory_global;
308 EVENT_NAME memory/sql/user_var_entry::value
309 COUNT_ALLOC 6
310 COUNT_FREE 0
311 SUM_NUMBER_OF_BYTES_ALLOC 14198
312 SUM_NUMBER_OF_BYTES_FREE 0
313 LOW_COUNT_USED 0
314 CURRENT_COUNT_USED 6
315 HIGH_COUNT_USED 6
316 LOW_NUMBER_OF_BYTES_USED 0
317 CURRENT_NUMBER_OF_BYTES_USED 14198
318 HIGH_NUMBER_OF_BYTES_USED 14198
319 execute dump_accounts;
320 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
321 execute dump_users;
322 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
323 event_scheduler 1 1
324 root 1 1
325 user1 1 1
326 user2 1 1
327 execute dump_hosts;
328 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
329 truncate table performance_schema.memory_summary_by_thread_by_event_name;
330 "================== MEMORY_BY_THREAD truncated =================="
331 "================== Step 5b =================="
332 call dump_thread();
333 username user1
334 EVENT_NAME memory/sql/user_var_entry::value
335 COUNT_ALLOC 3
336 COUNT_FREE 0
337 SUM_NUMBER_OF_BYTES_ALLOC 7099
338 SUM_NUMBER_OF_BYTES_FREE 0
339 LOW_COUNT_USED 3
340 CURRENT_COUNT_USED 3
341 HIGH_COUNT_USED 3
342 LOW_NUMBER_OF_BYTES_USED 7099
343 CURRENT_NUMBER_OF_BYTES_USED 7099
344 HIGH_NUMBER_OF_BYTES_USED 7099
345 username user2
346 EVENT_NAME memory/sql/user_var_entry::value
347 COUNT_ALLOC 3
348 COUNT_FREE 0
349 SUM_NUMBER_OF_BYTES_ALLOC 7099
350 SUM_NUMBER_OF_BYTES_FREE 0
351 LOW_COUNT_USED 3
352 CURRENT_COUNT_USED 3
353 HIGH_COUNT_USED 3
354 LOW_NUMBER_OF_BYTES_USED 7099
355 CURRENT_NUMBER_OF_BYTES_USED 7099
356 HIGH_NUMBER_OF_BYTES_USED 7099
357 username user3
358 status not found
359 username user4
360 status not found
361 execute dump_memory_account;
362 execute dump_memory_user;
363 USER user1
364 EVENT_NAME memory/sql/user_var_entry::value
365 COUNT_ALLOC 3
366 COUNT_FREE 0
367 SUM_NUMBER_OF_BYTES_ALLOC 7099
368 SUM_NUMBER_OF_BYTES_FREE 0
369 LOW_COUNT_USED 0
370 CURRENT_COUNT_USED 3
371 HIGH_COUNT_USED 3
372 LOW_NUMBER_OF_BYTES_USED 0
373 CURRENT_NUMBER_OF_BYTES_USED 7099
374 HIGH_NUMBER_OF_BYTES_USED 7099
375 USER user2
376 EVENT_NAME memory/sql/user_var_entry::value
377 COUNT_ALLOC 3
378 COUNT_FREE 0
379 SUM_NUMBER_OF_BYTES_ALLOC 7099
380 SUM_NUMBER_OF_BYTES_FREE 0
381 LOW_COUNT_USED 0
382 CURRENT_COUNT_USED 3
383 HIGH_COUNT_USED 3
384 LOW_NUMBER_OF_BYTES_USED 0
385 CURRENT_NUMBER_OF_BYTES_USED 7099
386 HIGH_NUMBER_OF_BYTES_USED 7099
387 execute dump_memory_host;
388 execute dump_memory_global;
389 EVENT_NAME memory/sql/user_var_entry::value
390 COUNT_ALLOC 6
391 COUNT_FREE 0
392 SUM_NUMBER_OF_BYTES_ALLOC 14198
393 SUM_NUMBER_OF_BYTES_FREE 0
394 LOW_COUNT_USED 0
395 CURRENT_COUNT_USED 6
396 HIGH_COUNT_USED 6
397 LOW_NUMBER_OF_BYTES_USED 0
398 CURRENT_NUMBER_OF_BYTES_USED 14198
399 HIGH_NUMBER_OF_BYTES_USED 14198
400 execute dump_accounts;
401 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
402 execute dump_users;
403 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
404 event_scheduler 1 1
405 root 1 1
406 user1 1 1
407 user2 1 1
408 execute dump_hosts;
409 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
410 "================== con3 connected =================="
411 "================== Step 6 =================="
412 call dump_thread();
413 username user1
414 EVENT_NAME memory/sql/user_var_entry::value
415 COUNT_ALLOC 3
416 COUNT_FREE 0
417 SUM_NUMBER_OF_BYTES_ALLOC 7099
418 SUM_NUMBER_OF_BYTES_FREE 0
419 LOW_COUNT_USED 3
420 CURRENT_COUNT_USED 3
421 HIGH_COUNT_USED 3
422 LOW_NUMBER_OF_BYTES_USED 7099
423 CURRENT_NUMBER_OF_BYTES_USED 7099
424 HIGH_NUMBER_OF_BYTES_USED 7099
425 username user2
426 EVENT_NAME memory/sql/user_var_entry::value
427 COUNT_ALLOC 3
428 COUNT_FREE 0
429 SUM_NUMBER_OF_BYTES_ALLOC 7099
430 SUM_NUMBER_OF_BYTES_FREE 0
431 LOW_COUNT_USED 3
432 CURRENT_COUNT_USED 3
433 HIGH_COUNT_USED 3
434 LOW_NUMBER_OF_BYTES_USED 7099
435 CURRENT_NUMBER_OF_BYTES_USED 7099
436 HIGH_NUMBER_OF_BYTES_USED 7099
437 username user3
438 EVENT_NAME memory/sql/user_var_entry::value
439 COUNT_ALLOC 0
440 COUNT_FREE 0
441 SUM_NUMBER_OF_BYTES_ALLOC 0
442 SUM_NUMBER_OF_BYTES_FREE 0
443 LOW_COUNT_USED 0
444 CURRENT_COUNT_USED 0
445 HIGH_COUNT_USED 0
446 LOW_NUMBER_OF_BYTES_USED 0
447 CURRENT_NUMBER_OF_BYTES_USED 0
448 HIGH_NUMBER_OF_BYTES_USED 0
449 username user4
450 status not found
451 execute dump_memory_account;
452 execute dump_memory_user;
453 USER user1
454 EVENT_NAME memory/sql/user_var_entry::value
455 COUNT_ALLOC 3
456 COUNT_FREE 0
457 SUM_NUMBER_OF_BYTES_ALLOC 7099
458 SUM_NUMBER_OF_BYTES_FREE 0
459 LOW_COUNT_USED 0
460 CURRENT_COUNT_USED 3
461 HIGH_COUNT_USED 3
462 LOW_NUMBER_OF_BYTES_USED 0
463 CURRENT_NUMBER_OF_BYTES_USED 7099
464 HIGH_NUMBER_OF_BYTES_USED 7099
465 USER user2
466 EVENT_NAME memory/sql/user_var_entry::value
467 COUNT_ALLOC 3
468 COUNT_FREE 0
469 SUM_NUMBER_OF_BYTES_ALLOC 7099
470 SUM_NUMBER_OF_BYTES_FREE 0
471 LOW_COUNT_USED 0
472 CURRENT_COUNT_USED 3
473 HIGH_COUNT_USED 3
474 LOW_NUMBER_OF_BYTES_USED 0
475 CURRENT_NUMBER_OF_BYTES_USED 7099
476 HIGH_NUMBER_OF_BYTES_USED 7099
477 USER user3
478 EVENT_NAME memory/sql/user_var_entry::value
479 COUNT_ALLOC 0
480 COUNT_FREE 0
481 SUM_NUMBER_OF_BYTES_ALLOC 0
482 SUM_NUMBER_OF_BYTES_FREE 0
483 LOW_COUNT_USED 0
484 CURRENT_COUNT_USED 0
485 HIGH_COUNT_USED 0
486 LOW_NUMBER_OF_BYTES_USED 0
487 CURRENT_NUMBER_OF_BYTES_USED 0
488 HIGH_NUMBER_OF_BYTES_USED 0
489 execute dump_memory_host;
490 execute dump_memory_global;
491 EVENT_NAME memory/sql/user_var_entry::value
492 COUNT_ALLOC 6
493 COUNT_FREE 0
494 SUM_NUMBER_OF_BYTES_ALLOC 14198
495 SUM_NUMBER_OF_BYTES_FREE 0
496 LOW_COUNT_USED 0
497 CURRENT_COUNT_USED 6
498 HIGH_COUNT_USED 6
499 LOW_NUMBER_OF_BYTES_USED 0
500 CURRENT_NUMBER_OF_BYTES_USED 14198
501 HIGH_NUMBER_OF_BYTES_USED 14198
502 execute dump_accounts;
503 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
504 execute dump_users;
505 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
506 event_scheduler 1 1
507 root 1 1
508 user1 1 1
509 user2 1 1
510 user3 1 1
511 execute dump_hosts;
512 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
513 select get_lock("marker_3", 10);
514 get_lock("marker_3", 10)
515 1
516 select release_lock("marker_3");
517 release_lock("marker_3")
518 1
519 set @v1 = repeat("a", 1000);
520 set @v2 = repeat("b", 2000);
521 set @v3 = repeat("c", 4000);
522 "================== con3 marker =================="
523 "================== Step 7 =================="
524 call dump_thread();
525 username user1
526 EVENT_NAME memory/sql/user_var_entry::value
527 COUNT_ALLOC 3
528 COUNT_FREE 0
529 SUM_NUMBER_OF_BYTES_ALLOC 7099
530 SUM_NUMBER_OF_BYTES_FREE 0
531 LOW_COUNT_USED 3
532 CURRENT_COUNT_USED 3
533 HIGH_COUNT_USED 3
534 LOW_NUMBER_OF_BYTES_USED 7099
535 CURRENT_NUMBER_OF_BYTES_USED 7099
536 HIGH_NUMBER_OF_BYTES_USED 7099
537 username user2
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 user3
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 0
556 CURRENT_COUNT_USED 3
557 HIGH_COUNT_USED 3
558 LOW_NUMBER_OF_BYTES_USED 0
559 CURRENT_NUMBER_OF_BYTES_USED 7099
560 HIGH_NUMBER_OF_BYTES_USED 7099
561 username user4
562 status not found
563 execute dump_memory_account;
564 execute dump_memory_user;
565 USER user1
566 EVENT_NAME memory/sql/user_var_entry::value
567 COUNT_ALLOC 3
568 COUNT_FREE 0
569 SUM_NUMBER_OF_BYTES_ALLOC 7099
570 SUM_NUMBER_OF_BYTES_FREE 0
571 LOW_COUNT_USED 0
572 CURRENT_COUNT_USED 3
573 HIGH_COUNT_USED 3
574 LOW_NUMBER_OF_BYTES_USED 0
575 CURRENT_NUMBER_OF_BYTES_USED 7099
576 HIGH_NUMBER_OF_BYTES_USED 7099
577 USER user2
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 user3
590 EVENT_NAME memory/sql/user_var_entry::value
591 COUNT_ALLOC 3
592 COUNT_FREE 0
593 SUM_NUMBER_OF_BYTES_ALLOC 7099
594 SUM_NUMBER_OF_BYTES_FREE 0
595 LOW_COUNT_USED 0
596 CURRENT_COUNT_USED 3
597 HIGH_COUNT_USED 3
598 LOW_NUMBER_OF_BYTES_USED 0
599 CURRENT_NUMBER_OF_BYTES_USED 7099
600 HIGH_NUMBER_OF_BYTES_USED 7099
601 execute dump_memory_host;
602 execute dump_memory_global;
603 EVENT_NAME memory/sql/user_var_entry::value
604 COUNT_ALLOC 9
605 COUNT_FREE 0
606 SUM_NUMBER_OF_BYTES_ALLOC 21297
607 SUM_NUMBER_OF_BYTES_FREE 0
608 LOW_COUNT_USED 0
609 CURRENT_COUNT_USED 9
610 HIGH_COUNT_USED 9
611 LOW_NUMBER_OF_BYTES_USED 0
612 CURRENT_NUMBER_OF_BYTES_USED 21297
613 HIGH_NUMBER_OF_BYTES_USED 21297
614 execute dump_accounts;
615 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
616 execute dump_users;
617 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
618 event_scheduler 1 1
619 root 1 1
620 user1 1 1
621 user2 1 1
622 user3 1 1
623 execute dump_hosts;
624 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
625 "================== con4/con5 (both user4) connected =================="
626 "================== Step 8 =================="
627 call dump_thread();
628 username user1
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 user2
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 3
647 CURRENT_COUNT_USED 3
648 HIGH_COUNT_USED 3
649 LOW_NUMBER_OF_BYTES_USED 7099
650 CURRENT_NUMBER_OF_BYTES_USED 7099
651 HIGH_NUMBER_OF_BYTES_USED 7099
652 username user3
653 EVENT_NAME memory/sql/user_var_entry::value
654 COUNT_ALLOC 3
655 COUNT_FREE 0
656 SUM_NUMBER_OF_BYTES_ALLOC 7099
657 SUM_NUMBER_OF_BYTES_FREE 0
658 LOW_COUNT_USED 0
659 CURRENT_COUNT_USED 3
660 HIGH_COUNT_USED 3
661 LOW_NUMBER_OF_BYTES_USED 0
662 CURRENT_NUMBER_OF_BYTES_USED 7099
663 HIGH_NUMBER_OF_BYTES_USED 7099
664 username user4
665 EVENT_NAME memory/sql/user_var_entry::value
666 COUNT_ALLOC 0
667 COUNT_FREE 0
668 SUM_NUMBER_OF_BYTES_ALLOC 0
669 SUM_NUMBER_OF_BYTES_FREE 0
670 LOW_COUNT_USED 0
671 CURRENT_COUNT_USED 0
672 HIGH_COUNT_USED 0
673 LOW_NUMBER_OF_BYTES_USED 0
674 CURRENT_NUMBER_OF_BYTES_USED 0
675 HIGH_NUMBER_OF_BYTES_USED 0
676 execute dump_memory_account;
677 execute dump_memory_user;
678 USER user1
679 EVENT_NAME memory/sql/user_var_entry::value
680 COUNT_ALLOC 3
681 COUNT_FREE 0
682 SUM_NUMBER_OF_BYTES_ALLOC 7099
683 SUM_NUMBER_OF_BYTES_FREE 0
684 LOW_COUNT_USED 0
685 CURRENT_COUNT_USED 3
686 HIGH_COUNT_USED 3
687 LOW_NUMBER_OF_BYTES_USED 0
688 CURRENT_NUMBER_OF_BYTES_USED 7099
689 HIGH_NUMBER_OF_BYTES_USED 7099
690 USER user2
691 EVENT_NAME memory/sql/user_var_entry::value
692 COUNT_ALLOC 3
693 COUNT_FREE 0
694 SUM_NUMBER_OF_BYTES_ALLOC 7099
695 SUM_NUMBER_OF_BYTES_FREE 0
696 LOW_COUNT_USED 0
697 CURRENT_COUNT_USED 3
698 HIGH_COUNT_USED 3
699 LOW_NUMBER_OF_BYTES_USED 0
700 CURRENT_NUMBER_OF_BYTES_USED 7099
701 HIGH_NUMBER_OF_BYTES_USED 7099
702 USER user3
703 EVENT_NAME memory/sql/user_var_entry::value
704 COUNT_ALLOC 3
705 COUNT_FREE 0
706 SUM_NUMBER_OF_BYTES_ALLOC 7099
707 SUM_NUMBER_OF_BYTES_FREE 0
708 LOW_COUNT_USED 0
709 CURRENT_COUNT_USED 3
710 HIGH_COUNT_USED 3
711 LOW_NUMBER_OF_BYTES_USED 0
712 CURRENT_NUMBER_OF_BYTES_USED 7099
713 HIGH_NUMBER_OF_BYTES_USED 7099
714 USER user4
715 EVENT_NAME memory/sql/user_var_entry::value
716 COUNT_ALLOC 0
717 COUNT_FREE 0
718 SUM_NUMBER_OF_BYTES_ALLOC 0
719 SUM_NUMBER_OF_BYTES_FREE 0
720 LOW_COUNT_USED 0
721 CURRENT_COUNT_USED 0
722 HIGH_COUNT_USED 0
723 LOW_NUMBER_OF_BYTES_USED 0
724 CURRENT_NUMBER_OF_BYTES_USED 0
725 HIGH_NUMBER_OF_BYTES_USED 0
726 execute dump_memory_host;
727 execute dump_memory_global;
728 EVENT_NAME memory/sql/user_var_entry::value
729 COUNT_ALLOC 9
730 COUNT_FREE 0
731 SUM_NUMBER_OF_BYTES_ALLOC 21297
732 SUM_NUMBER_OF_BYTES_FREE 0
733 LOW_COUNT_USED 0
734 CURRENT_COUNT_USED 9
735 HIGH_COUNT_USED 9
736 LOW_NUMBER_OF_BYTES_USED 0
737 CURRENT_NUMBER_OF_BYTES_USED 21297
738 HIGH_NUMBER_OF_BYTES_USED 21297
739 execute dump_accounts;
740 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
741 execute dump_users;
742 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
743 event_scheduler 1 1
744 root 1 1
745 user1 1 1
746 user2 1 1
747 user3 1 1
748 user4 2 2
749 execute dump_hosts;
750 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
751 select get_lock("marker_4", 10);
752 get_lock("marker_4", 10)
753 1
754 select release_lock("marker_4");
755 release_lock("marker_4")
756 1
757 set @v1 = repeat("a", 1000);
758 set @v2 = repeat("b", 2000);
759 set @v3 = repeat("c", 4000);
760 select get_lock("marker_5", 10);
761 get_lock("marker_5", 10)
762 1
763 select release_lock("marker_5");
764 release_lock("marker_5")
765 1
766 set @v1 = repeat("a", 1000);
767 set @v2 = repeat("b", 2000);
768 set @v3 = repeat("c", 4000);
769 "================== con4/con5 marker =================="
770 "================== Step 9 =================="
771 call dump_thread();
772 username 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 3
779 CURRENT_COUNT_USED 3
780 HIGH_COUNT_USED 3
781 LOW_NUMBER_OF_BYTES_USED 7099
782 CURRENT_NUMBER_OF_BYTES_USED 7099
783 HIGH_NUMBER_OF_BYTES_USED 7099
784 username 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 3
791 CURRENT_COUNT_USED 3
792 HIGH_COUNT_USED 3
793 LOW_NUMBER_OF_BYTES_USED 7099
794 CURRENT_NUMBER_OF_BYTES_USED 7099
795 HIGH_NUMBER_OF_BYTES_USED 7099
796 username 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 username user4
809 EVENT_NAME memory/sql/user_var_entry::value
810 COUNT_ALLOC 3
811 COUNT_FREE 0
812 SUM_NUMBER_OF_BYTES_ALLOC 7099
813 SUM_NUMBER_OF_BYTES_FREE 0
814 LOW_COUNT_USED 0
815 CURRENT_COUNT_USED 3
816 HIGH_COUNT_USED 3
817 LOW_NUMBER_OF_BYTES_USED 0
818 CURRENT_NUMBER_OF_BYTES_USED 7099
819 HIGH_NUMBER_OF_BYTES_USED 7099
820 execute dump_memory_account;
821 execute dump_memory_user;
822 USER user1
823 EVENT_NAME memory/sql/user_var_entry::value
824 COUNT_ALLOC 3
825 COUNT_FREE 0
826 SUM_NUMBER_OF_BYTES_ALLOC 7099
827 SUM_NUMBER_OF_BYTES_FREE 0
828 LOW_COUNT_USED 0
829 CURRENT_COUNT_USED 3
830 HIGH_COUNT_USED 3
831 LOW_NUMBER_OF_BYTES_USED 0
832 CURRENT_NUMBER_OF_BYTES_USED 7099
833 HIGH_NUMBER_OF_BYTES_USED 7099
834 USER user2
835 EVENT_NAME memory/sql/user_var_entry::value
836 COUNT_ALLOC 3
837 COUNT_FREE 0
838 SUM_NUMBER_OF_BYTES_ALLOC 7099
839 SUM_NUMBER_OF_BYTES_FREE 0
840 LOW_COUNT_USED 0
841 CURRENT_COUNT_USED 3
842 HIGH_COUNT_USED 3
843 LOW_NUMBER_OF_BYTES_USED 0
844 CURRENT_NUMBER_OF_BYTES_USED 7099
845 HIGH_NUMBER_OF_BYTES_USED 7099
846 USER user3
847 EVENT_NAME memory/sql/user_var_entry::value
848 COUNT_ALLOC 3
849 COUNT_FREE 0
850 SUM_NUMBER_OF_BYTES_ALLOC 7099
851 SUM_NUMBER_OF_BYTES_FREE 0
852 LOW_COUNT_USED 0
853 CURRENT_COUNT_USED 3
854 HIGH_COUNT_USED 3
855 LOW_NUMBER_OF_BYTES_USED 0
856 CURRENT_NUMBER_OF_BYTES_USED 7099
857 HIGH_NUMBER_OF_BYTES_USED 7099
858 USER user4
859 EVENT_NAME memory/sql/user_var_entry::value
860 COUNT_ALLOC 6
861 COUNT_FREE 0
862 SUM_NUMBER_OF_BYTES_ALLOC 14198
863 SUM_NUMBER_OF_BYTES_FREE 0
864 LOW_COUNT_USED 0
865 CURRENT_COUNT_USED 6
866 HIGH_COUNT_USED 6
867 LOW_NUMBER_OF_BYTES_USED 0
868 CURRENT_NUMBER_OF_BYTES_USED 14198
869 HIGH_NUMBER_OF_BYTES_USED 14198
870 execute dump_memory_host;
871 execute dump_memory_global;
872 EVENT_NAME memory/sql/user_var_entry::value
873 COUNT_ALLOC 15
874 COUNT_FREE 0
875 SUM_NUMBER_OF_BYTES_ALLOC 35495
876 SUM_NUMBER_OF_BYTES_FREE 0
877 LOW_COUNT_USED 0
878 CURRENT_COUNT_USED 15
879 HIGH_COUNT_USED 15
880 LOW_NUMBER_OF_BYTES_USED 0
881 CURRENT_NUMBER_OF_BYTES_USED 35495
882 HIGH_NUMBER_OF_BYTES_USED 35495
883 execute dump_accounts;
884 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
885 execute dump_users;
886 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
887 event_scheduler 1 1
888 root 1 1
889 user1 1 1
890 user2 1 1
891 user3 1 1
892 user4 2 2
893 execute dump_hosts;
894 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
895 "================== con1/con5 disconnected =================="
896 "================== Step 10 =================="
897 call dump_thread();
898 username user1
899 status not found
900 username user2
901 EVENT_NAME memory/sql/user_var_entry::value
902 COUNT_ALLOC 3
903 COUNT_FREE 0
904 SUM_NUMBER_OF_BYTES_ALLOC 7099
905 SUM_NUMBER_OF_BYTES_FREE 0
906 LOW_COUNT_USED 3
907 CURRENT_COUNT_USED 3
908 HIGH_COUNT_USED 3
909 LOW_NUMBER_OF_BYTES_USED 7099
910 CURRENT_NUMBER_OF_BYTES_USED 7099
911 HIGH_NUMBER_OF_BYTES_USED 7099
912 username user3
913 EVENT_NAME memory/sql/user_var_entry::value
914 COUNT_ALLOC 3
915 COUNT_FREE 0
916 SUM_NUMBER_OF_BYTES_ALLOC 7099
917 SUM_NUMBER_OF_BYTES_FREE 0
918 LOW_COUNT_USED 0
919 CURRENT_COUNT_USED 3
920 HIGH_COUNT_USED 3
921 LOW_NUMBER_OF_BYTES_USED 0
922 CURRENT_NUMBER_OF_BYTES_USED 7099
923 HIGH_NUMBER_OF_BYTES_USED 7099
924 username user4
925 EVENT_NAME memory/sql/user_var_entry::value
926 COUNT_ALLOC 3
927 COUNT_FREE 0
928 SUM_NUMBER_OF_BYTES_ALLOC 7099
929 SUM_NUMBER_OF_BYTES_FREE 0
930 LOW_COUNT_USED 0
931 CURRENT_COUNT_USED 3
932 HIGH_COUNT_USED 3
933 LOW_NUMBER_OF_BYTES_USED 0
934 CURRENT_NUMBER_OF_BYTES_USED 7099
935 HIGH_NUMBER_OF_BYTES_USED 7099
936 execute dump_memory_account;
937 execute dump_memory_user;
938 USER user1
939 EVENT_NAME memory/sql/user_var_entry::value
940 COUNT_ALLOC 3
941 COUNT_FREE 3
942 SUM_NUMBER_OF_BYTES_ALLOC 7099
943 SUM_NUMBER_OF_BYTES_FREE 7099
944 LOW_COUNT_USED 0
945 CURRENT_COUNT_USED 0
946 HIGH_COUNT_USED 3
947 LOW_NUMBER_OF_BYTES_USED 0
948 CURRENT_NUMBER_OF_BYTES_USED 0
949 HIGH_NUMBER_OF_BYTES_USED 7099
950 USER user2
951 EVENT_NAME memory/sql/user_var_entry::value
952 COUNT_ALLOC 3
953 COUNT_FREE 0
954 SUM_NUMBER_OF_BYTES_ALLOC 7099
955 SUM_NUMBER_OF_BYTES_FREE 0
956 LOW_COUNT_USED 0
957 CURRENT_COUNT_USED 3
958 HIGH_COUNT_USED 3
959 LOW_NUMBER_OF_BYTES_USED 0
960 CURRENT_NUMBER_OF_BYTES_USED 7099
961 HIGH_NUMBER_OF_BYTES_USED 7099
962 USER user3
963 EVENT_NAME memory/sql/user_var_entry::value
964 COUNT_ALLOC 3
965 COUNT_FREE 0
966 SUM_NUMBER_OF_BYTES_ALLOC 7099
967 SUM_NUMBER_OF_BYTES_FREE 0
968 LOW_COUNT_USED 0
969 CURRENT_COUNT_USED 3
970 HIGH_COUNT_USED 3
971 LOW_NUMBER_OF_BYTES_USED 0
972 CURRENT_NUMBER_OF_BYTES_USED 7099
973 HIGH_NUMBER_OF_BYTES_USED 7099
974 USER user4
975 EVENT_NAME memory/sql/user_var_entry::value
976 COUNT_ALLOC 6
977 COUNT_FREE 3
978 SUM_NUMBER_OF_BYTES_ALLOC 14198
979 SUM_NUMBER_OF_BYTES_FREE 7099
980 LOW_COUNT_USED 0
981 CURRENT_COUNT_USED 3
982 HIGH_COUNT_USED 6
983 LOW_NUMBER_OF_BYTES_USED 0
984 CURRENT_NUMBER_OF_BYTES_USED 7099
985 HIGH_NUMBER_OF_BYTES_USED 14198
986 execute dump_memory_host;
987 execute dump_memory_global;
988 EVENT_NAME memory/sql/user_var_entry::value
989 COUNT_ALLOC 15
990 COUNT_FREE 6
991 SUM_NUMBER_OF_BYTES_ALLOC 35495
992 SUM_NUMBER_OF_BYTES_FREE 14198
993 LOW_COUNT_USED 0
994 CURRENT_COUNT_USED 9
995 HIGH_COUNT_USED 15
996 LOW_NUMBER_OF_BYTES_USED 0
997 CURRENT_NUMBER_OF_BYTES_USED 21297
998 HIGH_NUMBER_OF_BYTES_USED 35495
999 execute dump_accounts;
1000 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1001 execute dump_users;
1002 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1003 event_scheduler 1 1
1004 root 1 1
1005 user1 0 1
1006 user2 1 1
1007 user3 1 1
1008 user4 1 2
1009 execute dump_hosts;
1010 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1011 "================== con2 disconnected =================="
1012 "================== Step 11 =================="
1013 call dump_thread();
1014 username user1
1015 status not found
1016 username user2
1017 status not found
1018 username user3
1019 EVENT_NAME memory/sql/user_var_entry::value
1020 COUNT_ALLOC 3
1021 COUNT_FREE 0
1022 SUM_NUMBER_OF_BYTES_ALLOC 7099
1023 SUM_NUMBER_OF_BYTES_FREE 0
1024 LOW_COUNT_USED 0
1025 CURRENT_COUNT_USED 3
1026 HIGH_COUNT_USED 3
1027 LOW_NUMBER_OF_BYTES_USED 0
1028 CURRENT_NUMBER_OF_BYTES_USED 7099
1029 HIGH_NUMBER_OF_BYTES_USED 7099
1030 username user4
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 0
1037 CURRENT_COUNT_USED 3
1038 HIGH_COUNT_USED 3
1039 LOW_NUMBER_OF_BYTES_USED 0
1040 CURRENT_NUMBER_OF_BYTES_USED 7099
1041 HIGH_NUMBER_OF_BYTES_USED 7099
1042 execute dump_memory_account;
1043 execute dump_memory_user;
1044 USER user1
1045 EVENT_NAME memory/sql/user_var_entry::value
1046 COUNT_ALLOC 3
1047 COUNT_FREE 3
1048 SUM_NUMBER_OF_BYTES_ALLOC 7099
1049 SUM_NUMBER_OF_BYTES_FREE 7099
1050 LOW_COUNT_USED 0
1051 CURRENT_COUNT_USED 0
1052 HIGH_COUNT_USED 3
1053 LOW_NUMBER_OF_BYTES_USED 0
1054 CURRENT_NUMBER_OF_BYTES_USED 0
1055 HIGH_NUMBER_OF_BYTES_USED 7099
1056 USER user2
1057 EVENT_NAME memory/sql/user_var_entry::value
1058 COUNT_ALLOC 3
1059 COUNT_FREE 3
1060 SUM_NUMBER_OF_BYTES_ALLOC 7099
1061 SUM_NUMBER_OF_BYTES_FREE 7099
1062 LOW_COUNT_USED 0
1063 CURRENT_COUNT_USED 0
1064 HIGH_COUNT_USED 3
1065 LOW_NUMBER_OF_BYTES_USED 0
1066 CURRENT_NUMBER_OF_BYTES_USED 0
1067 HIGH_NUMBER_OF_BYTES_USED 7099
1068 USER user3
1069 EVENT_NAME memory/sql/user_var_entry::value
1070 COUNT_ALLOC 3
1071 COUNT_FREE 0
1072 SUM_NUMBER_OF_BYTES_ALLOC 7099
1073 SUM_NUMBER_OF_BYTES_FREE 0
1074 LOW_COUNT_USED 0
1075 CURRENT_COUNT_USED 3
1076 HIGH_COUNT_USED 3
1077 LOW_NUMBER_OF_BYTES_USED 0
1078 CURRENT_NUMBER_OF_BYTES_USED 7099
1079 HIGH_NUMBER_OF_BYTES_USED 7099
1080 USER user4
1081 EVENT_NAME memory/sql/user_var_entry::value
1082 COUNT_ALLOC 6
1083 COUNT_FREE 3
1084 SUM_NUMBER_OF_BYTES_ALLOC 14198
1085 SUM_NUMBER_OF_BYTES_FREE 7099
1086 LOW_COUNT_USED 0
1087 CURRENT_COUNT_USED 3
1088 HIGH_COUNT_USED 6
1089 LOW_NUMBER_OF_BYTES_USED 0
1090 CURRENT_NUMBER_OF_BYTES_USED 7099
1091 HIGH_NUMBER_OF_BYTES_USED 14198
1092 execute dump_memory_host;
1093 execute dump_memory_global;
1094 EVENT_NAME memory/sql/user_var_entry::value
1095 COUNT_ALLOC 15
1096 COUNT_FREE 9
1097 SUM_NUMBER_OF_BYTES_ALLOC 35495
1098 SUM_NUMBER_OF_BYTES_FREE 21297
1099 LOW_COUNT_USED 0
1100 CURRENT_COUNT_USED 6
1101 HIGH_COUNT_USED 15
1102 LOW_NUMBER_OF_BYTES_USED 0
1103 CURRENT_NUMBER_OF_BYTES_USED 14198
1104 HIGH_NUMBER_OF_BYTES_USED 35495
1105 execute dump_accounts;
1106 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1107 execute dump_users;
1108 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1109 event_scheduler 1 1
1110 root 1 1
1111 user1 0 1
1112 user2 0 1
1113 user3 1 1
1114 user4 1 2
1115 execute dump_hosts;
1116 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1117 "================== con3 disconnected =================="
1118 "================== Step 12 =================="
1119 call dump_thread();
1120 username user1
1121 status not found
1122 username user2
1123 status not found
1124 username user3
1125 status not found
1126 username user4
1127 EVENT_NAME memory/sql/user_var_entry::value
1128 COUNT_ALLOC 3
1129 COUNT_FREE 0
1130 SUM_NUMBER_OF_BYTES_ALLOC 7099
1131 SUM_NUMBER_OF_BYTES_FREE 0
1132 LOW_COUNT_USED 0
1133 CURRENT_COUNT_USED 3
1134 HIGH_COUNT_USED 3
1135 LOW_NUMBER_OF_BYTES_USED 0
1136 CURRENT_NUMBER_OF_BYTES_USED 7099
1137 HIGH_NUMBER_OF_BYTES_USED 7099
1138 execute dump_memory_account;
1139 execute dump_memory_user;
1140 USER user1
1141 EVENT_NAME memory/sql/user_var_entry::value
1142 COUNT_ALLOC 3
1143 COUNT_FREE 3
1144 SUM_NUMBER_OF_BYTES_ALLOC 7099
1145 SUM_NUMBER_OF_BYTES_FREE 7099
1146 LOW_COUNT_USED 0
1147 CURRENT_COUNT_USED 0
1148 HIGH_COUNT_USED 3
1149 LOW_NUMBER_OF_BYTES_USED 0
1150 CURRENT_NUMBER_OF_BYTES_USED 0
1151 HIGH_NUMBER_OF_BYTES_USED 7099
1152 USER user2
1153 EVENT_NAME memory/sql/user_var_entry::value
1154 COUNT_ALLOC 3
1155 COUNT_FREE 3
1156 SUM_NUMBER_OF_BYTES_ALLOC 7099
1157 SUM_NUMBER_OF_BYTES_FREE 7099
1158 LOW_COUNT_USED 0
1159 CURRENT_COUNT_USED 0
1160 HIGH_COUNT_USED 3
1161 LOW_NUMBER_OF_BYTES_USED 0
1162 CURRENT_NUMBER_OF_BYTES_USED 0
1163 HIGH_NUMBER_OF_BYTES_USED 7099
1164 USER user3
1165 EVENT_NAME memory/sql/user_var_entry::value
1166 COUNT_ALLOC 3
1167 COUNT_FREE 3
1168 SUM_NUMBER_OF_BYTES_ALLOC 7099
1169 SUM_NUMBER_OF_BYTES_FREE 7099
1170 LOW_COUNT_USED 0
1171 CURRENT_COUNT_USED 0
1172 HIGH_COUNT_USED 3
1173 LOW_NUMBER_OF_BYTES_USED 0
1174 CURRENT_NUMBER_OF_BYTES_USED 0
1175 HIGH_NUMBER_OF_BYTES_USED 7099
1176 USER user4
1177 EVENT_NAME memory/sql/user_var_entry::value
1178 COUNT_ALLOC 6
1179 COUNT_FREE 3
1180 SUM_NUMBER_OF_BYTES_ALLOC 14198
1181 SUM_NUMBER_OF_BYTES_FREE 7099
1182 LOW_COUNT_USED 0
1183 CURRENT_COUNT_USED 3
1184 HIGH_COUNT_USED 6
1185 LOW_NUMBER_OF_BYTES_USED 0
1186 CURRENT_NUMBER_OF_BYTES_USED 7099
1187 HIGH_NUMBER_OF_BYTES_USED 14198
1188 execute dump_memory_host;
1189 execute dump_memory_global;
1190 EVENT_NAME memory/sql/user_var_entry::value
1191 COUNT_ALLOC 15
1192 COUNT_FREE 12
1193 SUM_NUMBER_OF_BYTES_ALLOC 35495
1194 SUM_NUMBER_OF_BYTES_FREE 28396
1195 LOW_COUNT_USED 0
1196 CURRENT_COUNT_USED 3
1197 HIGH_COUNT_USED 15
1198 LOW_NUMBER_OF_BYTES_USED 0
1199 CURRENT_NUMBER_OF_BYTES_USED 7099
1200 HIGH_NUMBER_OF_BYTES_USED 35495
1201 execute dump_accounts;
1202 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1203 execute dump_users;
1204 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1205 event_scheduler 1 1
1206 root 1 1
1207 user1 0 1
1208 user2 0 1
1209 user3 0 1
1210 user4 1 2
1211 execute dump_hosts;
1212 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1213 "================== con4 disconnected =================="
1214 "================== Step 13 =================="
1215 call dump_thread();
1216 username user1
1217 status not found
1218 username user2
1219 status not found
1220 username user3
1221 status not found
1222 username user4
1223 status not found
1224 execute dump_memory_account;
1225 execute dump_memory_user;
1226 USER user1
1227 EVENT_NAME memory/sql/user_var_entry::value
1228 COUNT_ALLOC 3
1229 COUNT_FREE 3
1230 SUM_NUMBER_OF_BYTES_ALLOC 7099
1231 SUM_NUMBER_OF_BYTES_FREE 7099
1232 LOW_COUNT_USED 0
1233 CURRENT_COUNT_USED 0
1234 HIGH_COUNT_USED 3
1235 LOW_NUMBER_OF_BYTES_USED 0
1236 CURRENT_NUMBER_OF_BYTES_USED 0
1237 HIGH_NUMBER_OF_BYTES_USED 7099
1238 USER user2
1239 EVENT_NAME memory/sql/user_var_entry::value
1240 COUNT_ALLOC 3
1241 COUNT_FREE 3
1242 SUM_NUMBER_OF_BYTES_ALLOC 7099
1243 SUM_NUMBER_OF_BYTES_FREE 7099
1244 LOW_COUNT_USED 0
1245 CURRENT_COUNT_USED 0
1246 HIGH_COUNT_USED 3
1247 LOW_NUMBER_OF_BYTES_USED 0
1248 CURRENT_NUMBER_OF_BYTES_USED 0
1249 HIGH_NUMBER_OF_BYTES_USED 7099
1250 USER user3
1251 EVENT_NAME memory/sql/user_var_entry::value
1252 COUNT_ALLOC 3
1253 COUNT_FREE 3
1254 SUM_NUMBER_OF_BYTES_ALLOC 7099
1255 SUM_NUMBER_OF_BYTES_FREE 7099
1256 LOW_COUNT_USED 0
1257 CURRENT_COUNT_USED 0
1258 HIGH_COUNT_USED 3
1259 LOW_NUMBER_OF_BYTES_USED 0
1260 CURRENT_NUMBER_OF_BYTES_USED 0
1261 HIGH_NUMBER_OF_BYTES_USED 7099
1262 USER user4
1263 EVENT_NAME memory/sql/user_var_entry::value
1264 COUNT_ALLOC 6
1265 COUNT_FREE 6
1266 SUM_NUMBER_OF_BYTES_ALLOC 14198
1267 SUM_NUMBER_OF_BYTES_FREE 14198
1268 LOW_COUNT_USED 0
1269 CURRENT_COUNT_USED 0
1270 HIGH_COUNT_USED 6
1271 LOW_NUMBER_OF_BYTES_USED 0
1272 CURRENT_NUMBER_OF_BYTES_USED 0
1273 HIGH_NUMBER_OF_BYTES_USED 14198
1274 execute dump_memory_host;
1275 execute dump_memory_global;
1276 EVENT_NAME memory/sql/user_var_entry::value
1277 COUNT_ALLOC 15
1278 COUNT_FREE 15
1279 SUM_NUMBER_OF_BYTES_ALLOC 35495
1280 SUM_NUMBER_OF_BYTES_FREE 35495
1281 LOW_COUNT_USED 0
1282 CURRENT_COUNT_USED 0
1283 HIGH_COUNT_USED 15
1284 LOW_NUMBER_OF_BYTES_USED 0
1285 CURRENT_NUMBER_OF_BYTES_USED 0
1286 HIGH_NUMBER_OF_BYTES_USED 35495
1287 execute dump_accounts;
1288 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1289 execute dump_users;
1290 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1291 event_scheduler 1 1
1292 root 1 1
1293 user1 0 1
1294 user2 0 1
1295 user3 0 1
1296 user4 0 2
1297 execute dump_hosts;
1298 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1299 truncate performance_schema.memory_summary_by_thread_by_event_name;
1300 "================== MEMORY_BY_THREAD truncated =================="
1301 "================== Step 14 =================="
1302 call dump_thread();
1303 username user1
1304 status not found
1305 username user2
1306 status not found
1307 username user3
1308 status not found
1309 username user4
1310 status not found
1311 execute dump_memory_account;
1312 execute dump_memory_user;
1313 USER user1
1314 EVENT_NAME memory/sql/user_var_entry::value
1315 COUNT_ALLOC 3
1316 COUNT_FREE 3
1317 SUM_NUMBER_OF_BYTES_ALLOC 7099
1318 SUM_NUMBER_OF_BYTES_FREE 7099
1319 LOW_COUNT_USED 0
1320 CURRENT_COUNT_USED 0
1321 HIGH_COUNT_USED 3
1322 LOW_NUMBER_OF_BYTES_USED 0
1323 CURRENT_NUMBER_OF_BYTES_USED 0
1324 HIGH_NUMBER_OF_BYTES_USED 7099
1325 USER user2
1326 EVENT_NAME memory/sql/user_var_entry::value
1327 COUNT_ALLOC 3
1328 COUNT_FREE 3
1329 SUM_NUMBER_OF_BYTES_ALLOC 7099
1330 SUM_NUMBER_OF_BYTES_FREE 7099
1331 LOW_COUNT_USED 0
1332 CURRENT_COUNT_USED 0
1333 HIGH_COUNT_USED 3
1334 LOW_NUMBER_OF_BYTES_USED 0
1335 CURRENT_NUMBER_OF_BYTES_USED 0
1336 HIGH_NUMBER_OF_BYTES_USED 7099
1337 USER user3
1338 EVENT_NAME memory/sql/user_var_entry::value
1339 COUNT_ALLOC 3
1340 COUNT_FREE 3
1341 SUM_NUMBER_OF_BYTES_ALLOC 7099
1342 SUM_NUMBER_OF_BYTES_FREE 7099
1343 LOW_COUNT_USED 0
1344 CURRENT_COUNT_USED 0
1345 HIGH_COUNT_USED 3
1346 LOW_NUMBER_OF_BYTES_USED 0
1347 CURRENT_NUMBER_OF_BYTES_USED 0
1348 HIGH_NUMBER_OF_BYTES_USED 7099
1349 USER user4
1350 EVENT_NAME memory/sql/user_var_entry::value
1351 COUNT_ALLOC 6
1352 COUNT_FREE 6
1353 SUM_NUMBER_OF_BYTES_ALLOC 14198
1354 SUM_NUMBER_OF_BYTES_FREE 14198
1355 LOW_COUNT_USED 0
1356 CURRENT_COUNT_USED 0
1357 HIGH_COUNT_USED 6
1358 LOW_NUMBER_OF_BYTES_USED 0
1359 CURRENT_NUMBER_OF_BYTES_USED 0
1360 HIGH_NUMBER_OF_BYTES_USED 14198
1361 execute dump_memory_host;
1362 execute dump_memory_global;
1363 EVENT_NAME memory/sql/user_var_entry::value
1364 COUNT_ALLOC 15
1365 COUNT_FREE 15
1366 SUM_NUMBER_OF_BYTES_ALLOC 35495
1367 SUM_NUMBER_OF_BYTES_FREE 35495
1368 LOW_COUNT_USED 0
1369 CURRENT_COUNT_USED 0
1370 HIGH_COUNT_USED 15
1371 LOW_NUMBER_OF_BYTES_USED 0
1372 CURRENT_NUMBER_OF_BYTES_USED 0
1373 HIGH_NUMBER_OF_BYTES_USED 35495
1374 execute dump_accounts;
1375 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1376 execute dump_users;
1377 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1378 event_scheduler 1 1
1379 root 1 1
1380 user1 0 1
1381 user2 0 1
1382 user3 0 1
1383 user4 0 2
1384 execute dump_hosts;
1385 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1386 truncate performance_schema.memory_summary_by_account_by_event_name;
1387 "================== MEMORY_BY_ACCOUNT truncated =================="
1388 "================== Step 15 =================="
1389 call dump_thread();
1390 username user1
1391 status not found
1392 username user2
1393 status not found
1394 username user3
1395 status not found
1396 username user4
1397 status not found
1398 execute dump_memory_account;
1399 execute dump_memory_user;
1400 USER user1
1401 EVENT_NAME memory/sql/user_var_entry::value
1402 COUNT_ALLOC 3
1403 COUNT_FREE 3
1404 SUM_NUMBER_OF_BYTES_ALLOC 7099
1405 SUM_NUMBER_OF_BYTES_FREE 7099
1406 LOW_COUNT_USED 0
1407 CURRENT_COUNT_USED 0
1408 HIGH_COUNT_USED 3
1409 LOW_NUMBER_OF_BYTES_USED 0
1410 CURRENT_NUMBER_OF_BYTES_USED 0
1411 HIGH_NUMBER_OF_BYTES_USED 7099
1412 USER user2
1413 EVENT_NAME memory/sql/user_var_entry::value
1414 COUNT_ALLOC 3
1415 COUNT_FREE 3
1416 SUM_NUMBER_OF_BYTES_ALLOC 7099
1417 SUM_NUMBER_OF_BYTES_FREE 7099
1418 LOW_COUNT_USED 0
1419 CURRENT_COUNT_USED 0
1420 HIGH_COUNT_USED 3
1421 LOW_NUMBER_OF_BYTES_USED 0
1422 CURRENT_NUMBER_OF_BYTES_USED 0
1423 HIGH_NUMBER_OF_BYTES_USED 7099
1424 USER user3
1425 EVENT_NAME memory/sql/user_var_entry::value
1426 COUNT_ALLOC 3
1427 COUNT_FREE 3
1428 SUM_NUMBER_OF_BYTES_ALLOC 7099
1429 SUM_NUMBER_OF_BYTES_FREE 7099
1430 LOW_COUNT_USED 0
1431 CURRENT_COUNT_USED 0
1432 HIGH_COUNT_USED 3
1433 LOW_NUMBER_OF_BYTES_USED 0
1434 CURRENT_NUMBER_OF_BYTES_USED 0
1435 HIGH_NUMBER_OF_BYTES_USED 7099
1436 USER user4
1437 EVENT_NAME memory/sql/user_var_entry::value
1438 COUNT_ALLOC 6
1439 COUNT_FREE 6
1440 SUM_NUMBER_OF_BYTES_ALLOC 14198
1441 SUM_NUMBER_OF_BYTES_FREE 14198
1442 LOW_COUNT_USED 0
1443 CURRENT_COUNT_USED 0
1444 HIGH_COUNT_USED 6
1445 LOW_NUMBER_OF_BYTES_USED 0
1446 CURRENT_NUMBER_OF_BYTES_USED 0
1447 HIGH_NUMBER_OF_BYTES_USED 14198
1448 execute dump_memory_host;
1449 execute dump_memory_global;
1450 EVENT_NAME memory/sql/user_var_entry::value
1451 COUNT_ALLOC 15
1452 COUNT_FREE 15
1453 SUM_NUMBER_OF_BYTES_ALLOC 35495
1454 SUM_NUMBER_OF_BYTES_FREE 35495
1455 LOW_COUNT_USED 0
1456 CURRENT_COUNT_USED 0
1457 HIGH_COUNT_USED 15
1458 LOW_NUMBER_OF_BYTES_USED 0
1459 CURRENT_NUMBER_OF_BYTES_USED 0
1460 HIGH_NUMBER_OF_BYTES_USED 35495
1461 execute dump_accounts;
1462 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1463 execute dump_users;
1464 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1465 event_scheduler 1 1
1466 root 1 1
1467 user1 0 1
1468 user2 0 1
1469 user3 0 1
1470 user4 0 2
1471 execute dump_hosts;
1472 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1473 truncate performance_schema.memory_summary_by_user_by_event_name;
1474 "================== MEMORY_BY_USER truncated =================="
1475 "================== Step 16 =================="
1476 call dump_thread();
1477 username user1
1478 status not found
1479 username user2
1480 status not found
1481 username user3
1482 status not found
1483 username user4
1484 status not found
1485 execute dump_memory_account;
1486 execute dump_memory_user;
1487 USER user1
1488 EVENT_NAME memory/sql/user_var_entry::value
1489 COUNT_ALLOC 0
1490 COUNT_FREE 0
1491 SUM_NUMBER_OF_BYTES_ALLOC 0
1492 SUM_NUMBER_OF_BYTES_FREE 0
1493 LOW_COUNT_USED 0
1494 CURRENT_COUNT_USED 0
1495 HIGH_COUNT_USED 0
1496 LOW_NUMBER_OF_BYTES_USED 0
1497 CURRENT_NUMBER_OF_BYTES_USED 0
1498 HIGH_NUMBER_OF_BYTES_USED 0
1499 USER user2
1500 EVENT_NAME memory/sql/user_var_entry::value
1501 COUNT_ALLOC 0
1502 COUNT_FREE 0
1503 SUM_NUMBER_OF_BYTES_ALLOC 0
1504 SUM_NUMBER_OF_BYTES_FREE 0
1505 LOW_COUNT_USED 0
1506 CURRENT_COUNT_USED 0
1507 HIGH_COUNT_USED 0
1508 LOW_NUMBER_OF_BYTES_USED 0
1509 CURRENT_NUMBER_OF_BYTES_USED 0
1510 HIGH_NUMBER_OF_BYTES_USED 0
1511 USER user3
1512 EVENT_NAME memory/sql/user_var_entry::value
1513 COUNT_ALLOC 0
1514 COUNT_FREE 0
1515 SUM_NUMBER_OF_BYTES_ALLOC 0
1516 SUM_NUMBER_OF_BYTES_FREE 0
1517 LOW_COUNT_USED 0
1518 CURRENT_COUNT_USED 0
1519 HIGH_COUNT_USED 0
1520 LOW_NUMBER_OF_BYTES_USED 0
1521 CURRENT_NUMBER_OF_BYTES_USED 0
1522 HIGH_NUMBER_OF_BYTES_USED 0
1523 USER user4
1524 EVENT_NAME memory/sql/user_var_entry::value
1525 COUNT_ALLOC 0
1526 COUNT_FREE 0
1527 SUM_NUMBER_OF_BYTES_ALLOC 0
1528 SUM_NUMBER_OF_BYTES_FREE 0
1529 LOW_COUNT_USED 0
1530 CURRENT_COUNT_USED 0
1531 HIGH_COUNT_USED 0
1532 LOW_NUMBER_OF_BYTES_USED 0
1533 CURRENT_NUMBER_OF_BYTES_USED 0
1534 HIGH_NUMBER_OF_BYTES_USED 0
1535 execute dump_memory_host;
1536 execute dump_memory_global;
1537 EVENT_NAME memory/sql/user_var_entry::value
1538 COUNT_ALLOC 15
1539 COUNT_FREE 15
1540 SUM_NUMBER_OF_BYTES_ALLOC 35495
1541 SUM_NUMBER_OF_BYTES_FREE 35495
1542 LOW_COUNT_USED 0
1543 CURRENT_COUNT_USED 0
1544 HIGH_COUNT_USED 15
1545 LOW_NUMBER_OF_BYTES_USED 0
1546 CURRENT_NUMBER_OF_BYTES_USED 0
1547 HIGH_NUMBER_OF_BYTES_USED 35495
1548 execute dump_accounts;
1549 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1550 execute dump_users;
1551 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1552 event_scheduler 1 1
1553 root 1 1
1554 user1 0 1
1555 user2 0 1
1556 user3 0 1
1557 user4 0 2
1558 execute dump_hosts;
1559 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1560 truncate performance_schema.memory_summary_by_host_by_event_name;
1561 "================== MEMORY_BY_HOST truncated =================="
1562 "================== Step 17 =================="
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 status not found
1572 execute dump_memory_account;
1573 execute dump_memory_user;
1574 USER user1
1575 EVENT_NAME memory/sql/user_var_entry::value
1576 COUNT_ALLOC 0
1577 COUNT_FREE 0
1578 SUM_NUMBER_OF_BYTES_ALLOC 0
1579 SUM_NUMBER_OF_BYTES_FREE 0
1580 LOW_COUNT_USED 0
1581 CURRENT_COUNT_USED 0
1582 HIGH_COUNT_USED 0
1583 LOW_NUMBER_OF_BYTES_USED 0
1584 CURRENT_NUMBER_OF_BYTES_USED 0
1585 HIGH_NUMBER_OF_BYTES_USED 0
1586 USER user2
1587 EVENT_NAME memory/sql/user_var_entry::value
1588 COUNT_ALLOC 0
1589 COUNT_FREE 0
1590 SUM_NUMBER_OF_BYTES_ALLOC 0
1591 SUM_NUMBER_OF_BYTES_FREE 0
1592 LOW_COUNT_USED 0
1593 CURRENT_COUNT_USED 0
1594 HIGH_COUNT_USED 0
1595 LOW_NUMBER_OF_BYTES_USED 0
1596 CURRENT_NUMBER_OF_BYTES_USED 0
1597 HIGH_NUMBER_OF_BYTES_USED 0
1598 USER user3
1599 EVENT_NAME memory/sql/user_var_entry::value
1600 COUNT_ALLOC 0
1601 COUNT_FREE 0
1602 SUM_NUMBER_OF_BYTES_ALLOC 0
1603 SUM_NUMBER_OF_BYTES_FREE 0
1604 LOW_COUNT_USED 0
1605 CURRENT_COUNT_USED 0
1606 HIGH_COUNT_USED 0
1607 LOW_NUMBER_OF_BYTES_USED 0
1608 CURRENT_NUMBER_OF_BYTES_USED 0
1609 HIGH_NUMBER_OF_BYTES_USED 0
1610 USER user4
1611 EVENT_NAME memory/sql/user_var_entry::value
1612 COUNT_ALLOC 0
1613 COUNT_FREE 0
1614 SUM_NUMBER_OF_BYTES_ALLOC 0
1615 SUM_NUMBER_OF_BYTES_FREE 0
1616 LOW_COUNT_USED 0
1617 CURRENT_COUNT_USED 0
1618 HIGH_COUNT_USED 0
1619 LOW_NUMBER_OF_BYTES_USED 0
1620 CURRENT_NUMBER_OF_BYTES_USED 0
1621 HIGH_NUMBER_OF_BYTES_USED 0
1622 execute dump_memory_host;
1623 execute dump_memory_global;
1624 EVENT_NAME memory/sql/user_var_entry::value
1625 COUNT_ALLOC 15
1626 COUNT_FREE 15
1627 SUM_NUMBER_OF_BYTES_ALLOC 35495
1628 SUM_NUMBER_OF_BYTES_FREE 35495
1629 LOW_COUNT_USED 0
1630 CURRENT_COUNT_USED 0
1631 HIGH_COUNT_USED 15
1632 LOW_NUMBER_OF_BYTES_USED 0
1633 CURRENT_NUMBER_OF_BYTES_USED 0
1634 HIGH_NUMBER_OF_BYTES_USED 35495
1635 execute dump_accounts;
1636 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1637 execute dump_users;
1638 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1639 event_scheduler 1 1
1640 root 1 1
1641 user1 0 1
1642 user2 0 1
1643 user3 0 1
1644 user4 0 2
1645 execute dump_hosts;
1646 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1647 truncate performance_schema.memory_summary_global_by_event_name;
1648 "================== MEMORY_GLOBAL truncated =================="
1649 "================== Step 18 =================="
1650 call dump_thread();
1651 username user1
1652 status not found
1653 username user2
1654 status not found
1655 username user3
1656 status not found
1657 username user4
1658 status not found
1659 execute dump_memory_account;
1660 execute dump_memory_user;
1661 USER user1
1662 EVENT_NAME memory/sql/user_var_entry::value
1663 COUNT_ALLOC 0
1664 COUNT_FREE 0
1665 SUM_NUMBER_OF_BYTES_ALLOC 0
1666 SUM_NUMBER_OF_BYTES_FREE 0
1667 LOW_COUNT_USED 0
1668 CURRENT_COUNT_USED 0
1669 HIGH_COUNT_USED 0
1670 LOW_NUMBER_OF_BYTES_USED 0
1671 CURRENT_NUMBER_OF_BYTES_USED 0
1672 HIGH_NUMBER_OF_BYTES_USED 0
1673 USER user2
1674 EVENT_NAME memory/sql/user_var_entry::value
1675 COUNT_ALLOC 0
1676 COUNT_FREE 0
1677 SUM_NUMBER_OF_BYTES_ALLOC 0
1678 SUM_NUMBER_OF_BYTES_FREE 0
1679 LOW_COUNT_USED 0
1680 CURRENT_COUNT_USED 0
1681 HIGH_COUNT_USED 0
1682 LOW_NUMBER_OF_BYTES_USED 0
1683 CURRENT_NUMBER_OF_BYTES_USED 0
1684 HIGH_NUMBER_OF_BYTES_USED 0
1685 USER user3
1686 EVENT_NAME memory/sql/user_var_entry::value
1687 COUNT_ALLOC 0
1688 COUNT_FREE 0
1689 SUM_NUMBER_OF_BYTES_ALLOC 0
1690 SUM_NUMBER_OF_BYTES_FREE 0
1691 LOW_COUNT_USED 0
1692 CURRENT_COUNT_USED 0
1693 HIGH_COUNT_USED 0
1694 LOW_NUMBER_OF_BYTES_USED 0
1695 CURRENT_NUMBER_OF_BYTES_USED 0
1696 HIGH_NUMBER_OF_BYTES_USED 0
1697 USER user4
1698 EVENT_NAME memory/sql/user_var_entry::value
1699 COUNT_ALLOC 0
1700 COUNT_FREE 0
1701 SUM_NUMBER_OF_BYTES_ALLOC 0
1702 SUM_NUMBER_OF_BYTES_FREE 0
1703 LOW_COUNT_USED 0
1704 CURRENT_COUNT_USED 0
1705 HIGH_COUNT_USED 0
1706 LOW_NUMBER_OF_BYTES_USED 0
1707 CURRENT_NUMBER_OF_BYTES_USED 0
1708 HIGH_NUMBER_OF_BYTES_USED 0
1709 execute dump_memory_host;
1710 execute dump_memory_global;
1711 EVENT_NAME memory/sql/user_var_entry::value
1712 COUNT_ALLOC 0
1713 COUNT_FREE 0
1714 SUM_NUMBER_OF_BYTES_ALLOC 0
1715 SUM_NUMBER_OF_BYTES_FREE 0
1716 LOW_COUNT_USED 0
1717 CURRENT_COUNT_USED 0
1718 HIGH_COUNT_USED 0
1719 LOW_NUMBER_OF_BYTES_USED 0
1720 CURRENT_NUMBER_OF_BYTES_USED 0
1721 HIGH_NUMBER_OF_BYTES_USED 0
1722 execute dump_accounts;
1723 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1724 execute dump_users;
1725 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1726 event_scheduler 1 1
1727 root 1 1
1728 user1 0 1
1729 user2 0 1
1730 user3 0 1
1731 user4 0 2
1732 execute dump_hosts;
1733 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1734 truncate performance_schema.accounts;
1735 "================== ACCOUNTS truncated =================="
1736 "================== Step 19 =================="
1737 call dump_thread();
1738 username user1
1739 status not found
1740 username user2
1741 status not found
1742 username user3
1743 status not found
1744 username user4
1745 status not found
1746 execute dump_memory_account;
1747 execute dump_memory_user;
1748 USER user1
1749 EVENT_NAME memory/sql/user_var_entry::value
1750 COUNT_ALLOC 0
1751 COUNT_FREE 0
1752 SUM_NUMBER_OF_BYTES_ALLOC 0
1753 SUM_NUMBER_OF_BYTES_FREE 0
1754 LOW_COUNT_USED 0
1755 CURRENT_COUNT_USED 0
1756 HIGH_COUNT_USED 0
1757 LOW_NUMBER_OF_BYTES_USED 0
1758 CURRENT_NUMBER_OF_BYTES_USED 0
1759 HIGH_NUMBER_OF_BYTES_USED 0
1760 USER user2
1761 EVENT_NAME memory/sql/user_var_entry::value
1762 COUNT_ALLOC 0
1763 COUNT_FREE 0
1764 SUM_NUMBER_OF_BYTES_ALLOC 0
1765 SUM_NUMBER_OF_BYTES_FREE 0
1766 LOW_COUNT_USED 0
1767 CURRENT_COUNT_USED 0
1768 HIGH_COUNT_USED 0
1769 LOW_NUMBER_OF_BYTES_USED 0
1770 CURRENT_NUMBER_OF_BYTES_USED 0
1771 HIGH_NUMBER_OF_BYTES_USED 0
1772 USER user3
1773 EVENT_NAME memory/sql/user_var_entry::value
1774 COUNT_ALLOC 0
1775 COUNT_FREE 0
1776 SUM_NUMBER_OF_BYTES_ALLOC 0
1777 SUM_NUMBER_OF_BYTES_FREE 0
1778 LOW_COUNT_USED 0
1779 CURRENT_COUNT_USED 0
1780 HIGH_COUNT_USED 0
1781 LOW_NUMBER_OF_BYTES_USED 0
1782 CURRENT_NUMBER_OF_BYTES_USED 0
1783 HIGH_NUMBER_OF_BYTES_USED 0
1784 USER user4
1785 EVENT_NAME memory/sql/user_var_entry::value
1786 COUNT_ALLOC 0
1787 COUNT_FREE 0
1788 SUM_NUMBER_OF_BYTES_ALLOC 0
1789 SUM_NUMBER_OF_BYTES_FREE 0
1790 LOW_COUNT_USED 0
1791 CURRENT_COUNT_USED 0
1792 HIGH_COUNT_USED 0
1793 LOW_NUMBER_OF_BYTES_USED 0
1794 CURRENT_NUMBER_OF_BYTES_USED 0
1795 HIGH_NUMBER_OF_BYTES_USED 0
1796 execute dump_memory_host;
1797 execute dump_memory_global;
1798 EVENT_NAME memory/sql/user_var_entry::value
1799 COUNT_ALLOC 0
1800 COUNT_FREE 0
1801 SUM_NUMBER_OF_BYTES_ALLOC 0
1802 SUM_NUMBER_OF_BYTES_FREE 0
1803 LOW_COUNT_USED 0
1804 CURRENT_COUNT_USED 0
1805 HIGH_COUNT_USED 0
1806 LOW_NUMBER_OF_BYTES_USED 0
1807 CURRENT_NUMBER_OF_BYTES_USED 0
1808 HIGH_NUMBER_OF_BYTES_USED 0
1809 execute dump_accounts;
1810 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1811 execute dump_users;
1812 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1813 event_scheduler 1 1
1814 root 1 1
1815 user1 0 1
1816 user2 0 1
1817 user3 0 1
1818 user4 0 2
1819 execute dump_hosts;
1820 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1821 truncate performance_schema.users;
1822 "================== USERS truncated =================="
1823 "================== Step 20 =================="
1824 call dump_thread();
1825 username user1
1826 status not found
1827 username user2
1828 status not found
1829 username user3
1830 status not found
1831 username user4
1832 status not found
1833 execute dump_memory_account;
1834 execute dump_memory_user;
1835 execute dump_memory_host;
1836 execute dump_memory_global;
1837 EVENT_NAME memory/sql/user_var_entry::value
1838 COUNT_ALLOC 0
1839 COUNT_FREE 0
1840 SUM_NUMBER_OF_BYTES_ALLOC 0
1841 SUM_NUMBER_OF_BYTES_FREE 0
1842 LOW_COUNT_USED 0
1843 CURRENT_COUNT_USED 0
1844 HIGH_COUNT_USED 0
1845 LOW_NUMBER_OF_BYTES_USED 0
1846 CURRENT_NUMBER_OF_BYTES_USED 0
1847 HIGH_NUMBER_OF_BYTES_USED 0
1848 execute dump_accounts;
1849 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1850 execute dump_users;
1851 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1852 event_scheduler 1 1
1853 root 1 1
1854 execute dump_hosts;
1855 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1856 truncate performance_schema.hosts;
1857 "================== HOSTS truncated =================="
1858 "================== Step 21 =================="
1859 call dump_thread();
1860 username user1
1861 status not found
1862 username user2
1863 status not found
1864 username user3
1865 status not found
1866 username user4
1867 status not found
1868 execute dump_memory_account;
1869 execute dump_memory_user;
1870 execute dump_memory_host;
1871 execute dump_memory_global;
1872 EVENT_NAME memory/sql/user_var_entry::value
1873 COUNT_ALLOC 0
1874 COUNT_FREE 0
1875 SUM_NUMBER_OF_BYTES_ALLOC 0
1876 SUM_NUMBER_OF_BYTES_FREE 0
1877 LOW_COUNT_USED 0
1878 CURRENT_COUNT_USED 0
1879 HIGH_COUNT_USED 0
1880 LOW_NUMBER_OF_BYTES_USED 0
1881 CURRENT_NUMBER_OF_BYTES_USED 0
1882 HIGH_NUMBER_OF_BYTES_USED 0
1883 execute dump_accounts;
1884 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1885 execute dump_users;
1886 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1887 event_scheduler 1 1
1888 root 1 1
1889 execute dump_hosts;
1890 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS