Debian Codegraph @

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

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