Debian Codegraph @

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

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