Debian Codegraph @

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

raw
1 show global status like "performance_schema_memory_classes_lost";
2 Variable_name Value
3 Performance_schema_memory_classes_lost 0
4 "================== Step 1 =================="
5 call dump_thread();
6 username user1
7 status not found
8 username user2
9 status not found
10 username user3
11 status not found
12 username user4
13 status not found
14 execute dump_memory_account;
15 execute dump_memory_user;
16 execute dump_memory_host;
17 execute dump_memory_global;
18 EVENT_NAME memory/sql/Query_cache
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 EVENT_NAME memory/sql/User_level_lock
30 COUNT_ALLOC 0
31 COUNT_FREE 0
32 SUM_NUMBER_OF_BYTES_ALLOC 0
33 SUM_NUMBER_OF_BYTES_FREE 0
34 LOW_COUNT_USED 0
35 CURRENT_COUNT_USED 0
36 HIGH_COUNT_USED 0
37 LOW_NUMBER_OF_BYTES_USED 0
38 CURRENT_NUMBER_OF_BYTES_USED 0
39 HIGH_NUMBER_OF_BYTES_USED 0
40 EVENT_NAME memory/sql/user_var_entry::value
41 COUNT_ALLOC 1
42 COUNT_FREE 0
43 SUM_NUMBER_OF_BYTES_ALLOC 96
44 SUM_NUMBER_OF_BYTES_FREE 0
45 LOW_COUNT_USED 1
46 CURRENT_COUNT_USED 1
47 HIGH_COUNT_USED 1
48 LOW_NUMBER_OF_BYTES_USED 96
49 CURRENT_NUMBER_OF_BYTES_USED 96
50 HIGH_NUMBER_OF_BYTES_USED 96
51 execute dump_accounts;
52 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
53 execute dump_users;
54 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
55 root 1 1
56 execute dump_hosts;
57 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
58 connect con1, localhost, user1, , ;
59 "================== con1 connected =================="
60 connection default;
61 "================== Step 2 =================="
62 call dump_thread();
63 username user1
64 EVENT_NAME memory/sql/User_level_lock
65 COUNT_ALLOC 0
66 COUNT_FREE 0
67 SUM_NUMBER_OF_BYTES_ALLOC 0
68 SUM_NUMBER_OF_BYTES_FREE 0
69 LOW_COUNT_USED 0
70 CURRENT_COUNT_USED 0
71 HIGH_COUNT_USED 0
72 LOW_NUMBER_OF_BYTES_USED 0
73 CURRENT_NUMBER_OF_BYTES_USED 0
74 HIGH_NUMBER_OF_BYTES_USED 0
75 username user1
76 EVENT_NAME memory/sql/user_var_entry::value
77 COUNT_ALLOC 0
78 COUNT_FREE 0
79 SUM_NUMBER_OF_BYTES_ALLOC 0
80 SUM_NUMBER_OF_BYTES_FREE 0
81 LOW_COUNT_USED 0
82 CURRENT_COUNT_USED 0
83 HIGH_COUNT_USED 0
84 LOW_NUMBER_OF_BYTES_USED 0
85 CURRENT_NUMBER_OF_BYTES_USED 0
86 HIGH_NUMBER_OF_BYTES_USED 0
87 username user2
88 status not found
89 username user3
90 status not found
91 username user4
92 status not found
93 execute dump_memory_account;
94 execute dump_memory_user;
95 USER user1
96 EVENT_NAME memory/sql/User_level_lock
97 COUNT_ALLOC 0
98 COUNT_FREE 0
99 SUM_NUMBER_OF_BYTES_ALLOC 0
100 SUM_NUMBER_OF_BYTES_FREE 0
101 LOW_COUNT_USED 0
102 CURRENT_COUNT_USED 0
103 HIGH_COUNT_USED 0
104 LOW_NUMBER_OF_BYTES_USED 0
105 CURRENT_NUMBER_OF_BYTES_USED 0
106 HIGH_NUMBER_OF_BYTES_USED 0
107 USER user1
108 EVENT_NAME memory/sql/user_var_entry::value
109 COUNT_ALLOC 0
110 COUNT_FREE 0
111 SUM_NUMBER_OF_BYTES_ALLOC 0
112 SUM_NUMBER_OF_BYTES_FREE 0
113 LOW_COUNT_USED 0
114 CURRENT_COUNT_USED 0
115 HIGH_COUNT_USED 0
116 LOW_NUMBER_OF_BYTES_USED 0
117 CURRENT_NUMBER_OF_BYTES_USED 0
118 HIGH_NUMBER_OF_BYTES_USED 0
119 execute dump_memory_host;
120 execute dump_memory_global;
121 EVENT_NAME memory/sql/Query_cache
122 COUNT_ALLOC 0
123 COUNT_FREE 0
124 SUM_NUMBER_OF_BYTES_ALLOC 0
125 SUM_NUMBER_OF_BYTES_FREE 0
126 LOW_COUNT_USED 0
127 CURRENT_COUNT_USED 0
128 HIGH_COUNT_USED 0
129 LOW_NUMBER_OF_BYTES_USED 0
130 CURRENT_NUMBER_OF_BYTES_USED 0
131 HIGH_NUMBER_OF_BYTES_USED 0
132 EVENT_NAME memory/sql/User_level_lock
133 COUNT_ALLOC 0
134 COUNT_FREE 0
135 SUM_NUMBER_OF_BYTES_ALLOC 0
136 SUM_NUMBER_OF_BYTES_FREE 0
137 LOW_COUNT_USED 0
138 CURRENT_COUNT_USED 0
139 HIGH_COUNT_USED 0
140 LOW_NUMBER_OF_BYTES_USED 0
141 CURRENT_NUMBER_OF_BYTES_USED 0
142 HIGH_NUMBER_OF_BYTES_USED 0
143 EVENT_NAME memory/sql/user_var_entry::value
144 COUNT_ALLOC 1
145 COUNT_FREE 0
146 SUM_NUMBER_OF_BYTES_ALLOC 96
147 SUM_NUMBER_OF_BYTES_FREE 0
148 LOW_COUNT_USED 1
149 CURRENT_COUNT_USED 1
150 HIGH_COUNT_USED 1
151 LOW_NUMBER_OF_BYTES_USED 96
152 CURRENT_NUMBER_OF_BYTES_USED 96
153 HIGH_NUMBER_OF_BYTES_USED 96
154 execute dump_accounts;
155 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
156 execute dump_users;
157 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
158 root 1 1
159 user1 1 1
160 execute dump_hosts;
161 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
162 connection con1;
163 set GLOBAL query_cache_size=1000*1024;
164 select get_lock("marker_1", 10);
165 get_lock("marker_1", 10)
166 1
167 select release_lock("marker_1");
168 release_lock("marker_1")
169 1
170 set @v1 = repeat("a", 1000);
171 set @v2 = repeat("b", 2000);
172 set @v3 = repeat("c", 4000);
173 "================== con1 marker =================="
174 connection default;
175 "================== Step 3 =================="
176 call dump_thread();
177 username user1
178 EVENT_NAME memory/sql/User_level_lock
179 COUNT_ALLOC 2
180 COUNT_FREE 1
181 SUM_NUMBER_OF_BYTES_ALLOC 272
182 SUM_NUMBER_OF_BYTES_FREE 16
183 LOW_COUNT_USED 0
184 CURRENT_COUNT_USED 1
185 HIGH_COUNT_USED 2
186 LOW_NUMBER_OF_BYTES_USED 0
187 CURRENT_NUMBER_OF_BYTES_USED 256
188 HIGH_NUMBER_OF_BYTES_USED 272
189 username user1
190 EVENT_NAME memory/sql/user_var_entry::value
191 COUNT_ALLOC 3
192 COUNT_FREE 0
193 SUM_NUMBER_OF_BYTES_ALLOC 7024
194 SUM_NUMBER_OF_BYTES_FREE 0
195 LOW_COUNT_USED 0
196 CURRENT_COUNT_USED 3
197 HIGH_COUNT_USED 3
198 LOW_NUMBER_OF_BYTES_USED 0
199 CURRENT_NUMBER_OF_BYTES_USED 7024
200 HIGH_NUMBER_OF_BYTES_USED 7024
201 username user2
202 status not found
203 username user3
204 status not found
205 username user4
206 status not found
207 execute dump_memory_account;
208 execute dump_memory_user;
209 USER user1
210 EVENT_NAME memory/sql/User_level_lock
211 COUNT_ALLOC 2
212 COUNT_FREE 1
213 SUM_NUMBER_OF_BYTES_ALLOC 272
214 SUM_NUMBER_OF_BYTES_FREE 16
215 LOW_COUNT_USED 0
216 CURRENT_COUNT_USED 1
217 HIGH_COUNT_USED 2
218 LOW_NUMBER_OF_BYTES_USED 0
219 CURRENT_NUMBER_OF_BYTES_USED 256
220 HIGH_NUMBER_OF_BYTES_USED 272
221 USER user1
222 EVENT_NAME memory/sql/user_var_entry::value
223 COUNT_ALLOC 3
224 COUNT_FREE 0
225 SUM_NUMBER_OF_BYTES_ALLOC 7024
226 SUM_NUMBER_OF_BYTES_FREE 0
227 LOW_COUNT_USED 0
228 CURRENT_COUNT_USED 3
229 HIGH_COUNT_USED 3
230 LOW_NUMBER_OF_BYTES_USED 0
231 CURRENT_NUMBER_OF_BYTES_USED 7024
232 HIGH_NUMBER_OF_BYTES_USED 7024
233 execute dump_memory_host;
234 execute dump_memory_global;
235 EVENT_NAME memory/sql/Query_cache
236 COUNT_ALLOC 2
237 COUNT_FREE 0
238 SUM_NUMBER_OF_BYTES_ALLOC 32768
239 SUM_NUMBER_OF_BYTES_FREE 0
240 LOW_COUNT_USED 0
241 CURRENT_COUNT_USED 2
242 HIGH_COUNT_USED 2
243 LOW_NUMBER_OF_BYTES_USED 0
244 CURRENT_NUMBER_OF_BYTES_USED 32768
245 HIGH_NUMBER_OF_BYTES_USED 32768
246 EVENT_NAME memory/sql/User_level_lock
247 COUNT_ALLOC 2
248 COUNT_FREE 1
249 SUM_NUMBER_OF_BYTES_ALLOC 272
250 SUM_NUMBER_OF_BYTES_FREE 16
251 LOW_COUNT_USED 0
252 CURRENT_COUNT_USED 1
253 HIGH_COUNT_USED 2
254 LOW_NUMBER_OF_BYTES_USED 0
255 CURRENT_NUMBER_OF_BYTES_USED 256
256 HIGH_NUMBER_OF_BYTES_USED 272
257 EVENT_NAME memory/sql/user_var_entry::value
258 COUNT_ALLOC 4
259 COUNT_FREE 0
260 SUM_NUMBER_OF_BYTES_ALLOC 7120
261 SUM_NUMBER_OF_BYTES_FREE 0
262 LOW_COUNT_USED 1
263 CURRENT_COUNT_USED 4
264 HIGH_COUNT_USED 4
265 LOW_NUMBER_OF_BYTES_USED 96
266 CURRENT_NUMBER_OF_BYTES_USED 7120
267 HIGH_NUMBER_OF_BYTES_USED 7120
268 execute dump_accounts;
269 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
270 execute dump_users;
271 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
272 root 1 1
273 user1 1 1
274 execute dump_hosts;
275 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
276 connect con2, localhost, user2, , ;
277 "================== con2 connected =================="
278 connection default;
279 "================== Step 4 =================="
280 call dump_thread();
281 username user1
282 EVENT_NAME memory/sql/User_level_lock
283 COUNT_ALLOC 2
284 COUNT_FREE 1
285 SUM_NUMBER_OF_BYTES_ALLOC 272
286 SUM_NUMBER_OF_BYTES_FREE 16
287 LOW_COUNT_USED 0
288 CURRENT_COUNT_USED 1
289 HIGH_COUNT_USED 2
290 LOW_NUMBER_OF_BYTES_USED 0
291 CURRENT_NUMBER_OF_BYTES_USED 256
292 HIGH_NUMBER_OF_BYTES_USED 272
293 username user1
294 EVENT_NAME memory/sql/user_var_entry::value
295 COUNT_ALLOC 3
296 COUNT_FREE 0
297 SUM_NUMBER_OF_BYTES_ALLOC 7024
298 SUM_NUMBER_OF_BYTES_FREE 0
299 LOW_COUNT_USED 0
300 CURRENT_COUNT_USED 3
301 HIGH_COUNT_USED 3
302 LOW_NUMBER_OF_BYTES_USED 0
303 CURRENT_NUMBER_OF_BYTES_USED 7024
304 HIGH_NUMBER_OF_BYTES_USED 7024
305 username user2
306 EVENT_NAME memory/sql/User_level_lock
307 COUNT_ALLOC 0
308 COUNT_FREE 0
309 SUM_NUMBER_OF_BYTES_ALLOC 0
310 SUM_NUMBER_OF_BYTES_FREE 0
311 LOW_COUNT_USED 0
312 CURRENT_COUNT_USED 0
313 HIGH_COUNT_USED 0
314 LOW_NUMBER_OF_BYTES_USED 0
315 CURRENT_NUMBER_OF_BYTES_USED 0
316 HIGH_NUMBER_OF_BYTES_USED 0
317 username user2
318 EVENT_NAME memory/sql/user_var_entry::value
319 COUNT_ALLOC 0
320 COUNT_FREE 0
321 SUM_NUMBER_OF_BYTES_ALLOC 0
322 SUM_NUMBER_OF_BYTES_FREE 0
323 LOW_COUNT_USED 0
324 CURRENT_COUNT_USED 0
325 HIGH_COUNT_USED 0
326 LOW_NUMBER_OF_BYTES_USED 0
327 CURRENT_NUMBER_OF_BYTES_USED 0
328 HIGH_NUMBER_OF_BYTES_USED 0
329 username user3
330 status not found
331 username user4
332 status not found
333 execute dump_memory_account;
334 execute dump_memory_user;
335 USER user1
336 EVENT_NAME memory/sql/User_level_lock
337 COUNT_ALLOC 2
338 COUNT_FREE 1
339 SUM_NUMBER_OF_BYTES_ALLOC 272
340 SUM_NUMBER_OF_BYTES_FREE 16
341 LOW_COUNT_USED 0
342 CURRENT_COUNT_USED 1
343 HIGH_COUNT_USED 2
344 LOW_NUMBER_OF_BYTES_USED 0
345 CURRENT_NUMBER_OF_BYTES_USED 256
346 HIGH_NUMBER_OF_BYTES_USED 272
347 USER user1
348 EVENT_NAME memory/sql/user_var_entry::value
349 COUNT_ALLOC 3
350 COUNT_FREE 0
351 SUM_NUMBER_OF_BYTES_ALLOC 7024
352 SUM_NUMBER_OF_BYTES_FREE 0
353 LOW_COUNT_USED 0
354 CURRENT_COUNT_USED 3
355 HIGH_COUNT_USED 3
356 LOW_NUMBER_OF_BYTES_USED 0
357 CURRENT_NUMBER_OF_BYTES_USED 7024
358 HIGH_NUMBER_OF_BYTES_USED 7024
359 USER user2
360 EVENT_NAME memory/sql/User_level_lock
361 COUNT_ALLOC 0
362 COUNT_FREE 0
363 SUM_NUMBER_OF_BYTES_ALLOC 0
364 SUM_NUMBER_OF_BYTES_FREE 0
365 LOW_COUNT_USED 0
366 CURRENT_COUNT_USED 0
367 HIGH_COUNT_USED 0
368 LOW_NUMBER_OF_BYTES_USED 0
369 CURRENT_NUMBER_OF_BYTES_USED 0
370 HIGH_NUMBER_OF_BYTES_USED 0
371 USER user2
372 EVENT_NAME memory/sql/user_var_entry::value
373 COUNT_ALLOC 0
374 COUNT_FREE 0
375 SUM_NUMBER_OF_BYTES_ALLOC 0
376 SUM_NUMBER_OF_BYTES_FREE 0
377 LOW_COUNT_USED 0
378 CURRENT_COUNT_USED 0
379 HIGH_COUNT_USED 0
380 LOW_NUMBER_OF_BYTES_USED 0
381 CURRENT_NUMBER_OF_BYTES_USED 0
382 HIGH_NUMBER_OF_BYTES_USED 0
383 execute dump_memory_host;
384 execute dump_memory_global;
385 EVENT_NAME memory/sql/Query_cache
386 COUNT_ALLOC 2
387 COUNT_FREE 0
388 SUM_NUMBER_OF_BYTES_ALLOC 32768
389 SUM_NUMBER_OF_BYTES_FREE 0
390 LOW_COUNT_USED 0
391 CURRENT_COUNT_USED 2
392 HIGH_COUNT_USED 2
393 LOW_NUMBER_OF_BYTES_USED 0
394 CURRENT_NUMBER_OF_BYTES_USED 32768
395 HIGH_NUMBER_OF_BYTES_USED 32768
396 EVENT_NAME memory/sql/User_level_lock
397 COUNT_ALLOC 2
398 COUNT_FREE 1
399 SUM_NUMBER_OF_BYTES_ALLOC 272
400 SUM_NUMBER_OF_BYTES_FREE 16
401 LOW_COUNT_USED 0
402 CURRENT_COUNT_USED 1
403 HIGH_COUNT_USED 2
404 LOW_NUMBER_OF_BYTES_USED 0
405 CURRENT_NUMBER_OF_BYTES_USED 256
406 HIGH_NUMBER_OF_BYTES_USED 272
407 EVENT_NAME memory/sql/user_var_entry::value
408 COUNT_ALLOC 4
409 COUNT_FREE 0
410 SUM_NUMBER_OF_BYTES_ALLOC 7120
411 SUM_NUMBER_OF_BYTES_FREE 0
412 LOW_COUNT_USED 1
413 CURRENT_COUNT_USED 4
414 HIGH_COUNT_USED 4
415 LOW_NUMBER_OF_BYTES_USED 96
416 CURRENT_NUMBER_OF_BYTES_USED 7120
417 HIGH_NUMBER_OF_BYTES_USED 7120
418 execute dump_accounts;
419 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
420 execute dump_users;
421 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
422 root 1 1
423 user1 1 1
424 user2 1 1
425 execute dump_hosts;
426 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
427 connection con2;
428 set GLOBAL query_cache_size=2000*1024;
429 select get_lock("marker_2", 10);
430 get_lock("marker_2", 10)
431 1
432 select release_lock("marker_2");
433 release_lock("marker_2")
434 1
435 set @v1 = repeat("a", 1000);
436 set @v2 = repeat("b", 2000);
437 set @v3 = repeat("c", 4000);
438 "================== con2 marker =================="
439 connection default;
440 "================== Step 5 =================="
441 call dump_thread();
442 username user1
443 EVENT_NAME memory/sql/User_level_lock
444 COUNT_ALLOC 2
445 COUNT_FREE 1
446 SUM_NUMBER_OF_BYTES_ALLOC 272
447 SUM_NUMBER_OF_BYTES_FREE 16
448 LOW_COUNT_USED 0
449 CURRENT_COUNT_USED 1
450 HIGH_COUNT_USED 2
451 LOW_NUMBER_OF_BYTES_USED 0
452 CURRENT_NUMBER_OF_BYTES_USED 256
453 HIGH_NUMBER_OF_BYTES_USED 272
454 username user1
455 EVENT_NAME memory/sql/user_var_entry::value
456 COUNT_ALLOC 3
457 COUNT_FREE 0
458 SUM_NUMBER_OF_BYTES_ALLOC 7024
459 SUM_NUMBER_OF_BYTES_FREE 0
460 LOW_COUNT_USED 0
461 CURRENT_COUNT_USED 3
462 HIGH_COUNT_USED 3
463 LOW_NUMBER_OF_BYTES_USED 0
464 CURRENT_NUMBER_OF_BYTES_USED 7024
465 HIGH_NUMBER_OF_BYTES_USED 7024
466 username user2
467 EVENT_NAME memory/sql/User_level_lock
468 COUNT_ALLOC 2
469 COUNT_FREE 1
470 SUM_NUMBER_OF_BYTES_ALLOC 272
471 SUM_NUMBER_OF_BYTES_FREE 16
472 LOW_COUNT_USED 0
473 CURRENT_COUNT_USED 1
474 HIGH_COUNT_USED 2
475 LOW_NUMBER_OF_BYTES_USED 0
476 CURRENT_NUMBER_OF_BYTES_USED 256
477 HIGH_NUMBER_OF_BYTES_USED 272
478 username user2
479 EVENT_NAME memory/sql/user_var_entry::value
480 COUNT_ALLOC 3
481 COUNT_FREE 0
482 SUM_NUMBER_OF_BYTES_ALLOC 7024
483 SUM_NUMBER_OF_BYTES_FREE 0
484 LOW_COUNT_USED 0
485 CURRENT_COUNT_USED 3
486 HIGH_COUNT_USED 3
487 LOW_NUMBER_OF_BYTES_USED 0
488 CURRENT_NUMBER_OF_BYTES_USED 7024
489 HIGH_NUMBER_OF_BYTES_USED 7024
490 username user3
491 status not found
492 username user4
493 status not found
494 execute dump_memory_account;
495 execute dump_memory_user;
496 USER user1
497 EVENT_NAME memory/sql/User_level_lock
498 COUNT_ALLOC 2
499 COUNT_FREE 1
500 SUM_NUMBER_OF_BYTES_ALLOC 272
501 SUM_NUMBER_OF_BYTES_FREE 16
502 LOW_COUNT_USED 0
503 CURRENT_COUNT_USED 1
504 HIGH_COUNT_USED 2
505 LOW_NUMBER_OF_BYTES_USED 0
506 CURRENT_NUMBER_OF_BYTES_USED 256
507 HIGH_NUMBER_OF_BYTES_USED 272
508 USER user1
509 EVENT_NAME memory/sql/user_var_entry::value
510 COUNT_ALLOC 3
511 COUNT_FREE 0
512 SUM_NUMBER_OF_BYTES_ALLOC 7024
513 SUM_NUMBER_OF_BYTES_FREE 0
514 LOW_COUNT_USED 0
515 CURRENT_COUNT_USED 3
516 HIGH_COUNT_USED 3
517 LOW_NUMBER_OF_BYTES_USED 0
518 CURRENT_NUMBER_OF_BYTES_USED 7024
519 HIGH_NUMBER_OF_BYTES_USED 7024
520 USER user2
521 EVENT_NAME memory/sql/User_level_lock
522 COUNT_ALLOC 2
523 COUNT_FREE 1
524 SUM_NUMBER_OF_BYTES_ALLOC 272
525 SUM_NUMBER_OF_BYTES_FREE 16
526 LOW_COUNT_USED 0
527 CURRENT_COUNT_USED 1
528 HIGH_COUNT_USED 2
529 LOW_NUMBER_OF_BYTES_USED 0
530 CURRENT_NUMBER_OF_BYTES_USED 256
531 HIGH_NUMBER_OF_BYTES_USED 272
532 USER user2
533 EVENT_NAME memory/sql/user_var_entry::value
534 COUNT_ALLOC 3
535 COUNT_FREE 0
536 SUM_NUMBER_OF_BYTES_ALLOC 7024
537 SUM_NUMBER_OF_BYTES_FREE 0
538 LOW_COUNT_USED 0
539 CURRENT_COUNT_USED 3
540 HIGH_COUNT_USED 3
541 LOW_NUMBER_OF_BYTES_USED 0
542 CURRENT_NUMBER_OF_BYTES_USED 7024
543 HIGH_NUMBER_OF_BYTES_USED 7024
544 execute dump_memory_host;
545 execute dump_memory_global;
546 EVENT_NAME memory/sql/Query_cache
547 COUNT_ALLOC 4
548 COUNT_FREE 2
549 SUM_NUMBER_OF_BYTES_ALLOC 65536
550 SUM_NUMBER_OF_BYTES_FREE 32768
551 LOW_COUNT_USED 0
552 CURRENT_COUNT_USED 2
553 HIGH_COUNT_USED 2
554 LOW_NUMBER_OF_BYTES_USED 0
555 CURRENT_NUMBER_OF_BYTES_USED 32768
556 HIGH_NUMBER_OF_BYTES_USED 32768
557 EVENT_NAME memory/sql/User_level_lock
558 COUNT_ALLOC 4
559 COUNT_FREE 2
560 SUM_NUMBER_OF_BYTES_ALLOC 544
561 SUM_NUMBER_OF_BYTES_FREE 32
562 LOW_COUNT_USED 0
563 CURRENT_COUNT_USED 2
564 HIGH_COUNT_USED 4
565 LOW_NUMBER_OF_BYTES_USED 0
566 CURRENT_NUMBER_OF_BYTES_USED 512
567 HIGH_NUMBER_OF_BYTES_USED 544
568 EVENT_NAME memory/sql/user_var_entry::value
569 COUNT_ALLOC 7
570 COUNT_FREE 0
571 SUM_NUMBER_OF_BYTES_ALLOC 14144
572 SUM_NUMBER_OF_BYTES_FREE 0
573 LOW_COUNT_USED 1
574 CURRENT_COUNT_USED 7
575 HIGH_COUNT_USED 7
576 LOW_NUMBER_OF_BYTES_USED 96
577 CURRENT_NUMBER_OF_BYTES_USED 14144
578 HIGH_NUMBER_OF_BYTES_USED 14144
579 execute dump_accounts;
580 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
581 execute dump_users;
582 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
583 root 1 1
584 user1 1 1
585 user2 1 1
586 execute dump_hosts;
587 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
588 truncate table performance_schema.memory_summary_by_thread_by_event_name;
589 "================== MEMORY_BY_THREAD truncated =================="
590 "================== Step 5b =================="
591 call dump_thread();
592 username user1
593 EVENT_NAME memory/sql/User_level_lock
594 COUNT_ALLOC 1
595 COUNT_FREE 0
596 SUM_NUMBER_OF_BYTES_ALLOC 256
597 SUM_NUMBER_OF_BYTES_FREE 0
598 LOW_COUNT_USED 1
599 CURRENT_COUNT_USED 1
600 HIGH_COUNT_USED 1
601 LOW_NUMBER_OF_BYTES_USED 256
602 CURRENT_NUMBER_OF_BYTES_USED 256
603 HIGH_NUMBER_OF_BYTES_USED 256
604 username user1
605 EVENT_NAME memory/sql/user_var_entry::value
606 COUNT_ALLOC 3
607 COUNT_FREE 0
608 SUM_NUMBER_OF_BYTES_ALLOC 7024
609 SUM_NUMBER_OF_BYTES_FREE 0
610 LOW_COUNT_USED 3
611 CURRENT_COUNT_USED 3
612 HIGH_COUNT_USED 3
613 LOW_NUMBER_OF_BYTES_USED 7024
614 CURRENT_NUMBER_OF_BYTES_USED 7024
615 HIGH_NUMBER_OF_BYTES_USED 7024
616 username user2
617 EVENT_NAME memory/sql/User_level_lock
618 COUNT_ALLOC 1
619 COUNT_FREE 0
620 SUM_NUMBER_OF_BYTES_ALLOC 256
621 SUM_NUMBER_OF_BYTES_FREE 0
622 LOW_COUNT_USED 1
623 CURRENT_COUNT_USED 1
624 HIGH_COUNT_USED 1
625 LOW_NUMBER_OF_BYTES_USED 256
626 CURRENT_NUMBER_OF_BYTES_USED 256
627 HIGH_NUMBER_OF_BYTES_USED 256
628 username user2
629 EVENT_NAME memory/sql/user_var_entry::value
630 COUNT_ALLOC 3
631 COUNT_FREE 0
632 SUM_NUMBER_OF_BYTES_ALLOC 7024
633 SUM_NUMBER_OF_BYTES_FREE 0
634 LOW_COUNT_USED 3
635 CURRENT_COUNT_USED 3
636 HIGH_COUNT_USED 3
637 LOW_NUMBER_OF_BYTES_USED 7024
638 CURRENT_NUMBER_OF_BYTES_USED 7024
639 HIGH_NUMBER_OF_BYTES_USED 7024
640 username user3
641 status not found
642 username user4
643 status not found
644 execute dump_memory_account;
645 execute dump_memory_user;
646 USER user1
647 EVENT_NAME memory/sql/User_level_lock
648 COUNT_ALLOC 2
649 COUNT_FREE 1
650 SUM_NUMBER_OF_BYTES_ALLOC 272
651 SUM_NUMBER_OF_BYTES_FREE 16
652 LOW_COUNT_USED 0
653 CURRENT_COUNT_USED 1
654 HIGH_COUNT_USED 2
655 LOW_NUMBER_OF_BYTES_USED 0
656 CURRENT_NUMBER_OF_BYTES_USED 256
657 HIGH_NUMBER_OF_BYTES_USED 272
658 USER user1
659 EVENT_NAME memory/sql/user_var_entry::value
660 COUNT_ALLOC 3
661 COUNT_FREE 0
662 SUM_NUMBER_OF_BYTES_ALLOC 7024
663 SUM_NUMBER_OF_BYTES_FREE 0
664 LOW_COUNT_USED 0
665 CURRENT_COUNT_USED 3
666 HIGH_COUNT_USED 3
667 LOW_NUMBER_OF_BYTES_USED 0
668 CURRENT_NUMBER_OF_BYTES_USED 7024
669 HIGH_NUMBER_OF_BYTES_USED 7024
670 USER user2
671 EVENT_NAME memory/sql/User_level_lock
672 COUNT_ALLOC 2
673 COUNT_FREE 1
674 SUM_NUMBER_OF_BYTES_ALLOC 272
675 SUM_NUMBER_OF_BYTES_FREE 16
676 LOW_COUNT_USED 0
677 CURRENT_COUNT_USED 1
678 HIGH_COUNT_USED 2
679 LOW_NUMBER_OF_BYTES_USED 0
680 CURRENT_NUMBER_OF_BYTES_USED 256
681 HIGH_NUMBER_OF_BYTES_USED 272
682 USER user2
683 EVENT_NAME memory/sql/user_var_entry::value
684 COUNT_ALLOC 3
685 COUNT_FREE 0
686 SUM_NUMBER_OF_BYTES_ALLOC 7024
687 SUM_NUMBER_OF_BYTES_FREE 0
688 LOW_COUNT_USED 0
689 CURRENT_COUNT_USED 3
690 HIGH_COUNT_USED 3
691 LOW_NUMBER_OF_BYTES_USED 0
692 CURRENT_NUMBER_OF_BYTES_USED 7024
693 HIGH_NUMBER_OF_BYTES_USED 7024
694 execute dump_memory_host;
695 execute dump_memory_global;
696 EVENT_NAME memory/sql/Query_cache
697 COUNT_ALLOC 4
698 COUNT_FREE 2
699 SUM_NUMBER_OF_BYTES_ALLOC 65536
700 SUM_NUMBER_OF_BYTES_FREE 32768
701 LOW_COUNT_USED 0
702 CURRENT_COUNT_USED 2
703 HIGH_COUNT_USED 2
704 LOW_NUMBER_OF_BYTES_USED 0
705 CURRENT_NUMBER_OF_BYTES_USED 32768
706 HIGH_NUMBER_OF_BYTES_USED 32768
707 EVENT_NAME memory/sql/User_level_lock
708 COUNT_ALLOC 4
709 COUNT_FREE 2
710 SUM_NUMBER_OF_BYTES_ALLOC 544
711 SUM_NUMBER_OF_BYTES_FREE 32
712 LOW_COUNT_USED 0
713 CURRENT_COUNT_USED 2
714 HIGH_COUNT_USED 4
715 LOW_NUMBER_OF_BYTES_USED 0
716 CURRENT_NUMBER_OF_BYTES_USED 512
717 HIGH_NUMBER_OF_BYTES_USED 544
718 EVENT_NAME memory/sql/user_var_entry::value
719 COUNT_ALLOC 7
720 COUNT_FREE 0
721 SUM_NUMBER_OF_BYTES_ALLOC 14144
722 SUM_NUMBER_OF_BYTES_FREE 0
723 LOW_COUNT_USED 1
724 CURRENT_COUNT_USED 7
725 HIGH_COUNT_USED 7
726 LOW_NUMBER_OF_BYTES_USED 96
727 CURRENT_NUMBER_OF_BYTES_USED 14144
728 HIGH_NUMBER_OF_BYTES_USED 14144
729 execute dump_accounts;
730 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
731 execute dump_users;
732 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
733 root 1 1
734 user1 1 1
735 user2 1 1
736 execute dump_hosts;
737 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
738 connect con3, localhost, user3, , ;
739 "================== con3 connected =================="
740 connection default;
741 "================== Step 6 =================="
742 call dump_thread();
743 username user1
744 EVENT_NAME memory/sql/User_level_lock
745 COUNT_ALLOC 1
746 COUNT_FREE 0
747 SUM_NUMBER_OF_BYTES_ALLOC 256
748 SUM_NUMBER_OF_BYTES_FREE 0
749 LOW_COUNT_USED 1
750 CURRENT_COUNT_USED 1
751 HIGH_COUNT_USED 1
752 LOW_NUMBER_OF_BYTES_USED 256
753 CURRENT_NUMBER_OF_BYTES_USED 256
754 HIGH_NUMBER_OF_BYTES_USED 256
755 username user1
756 EVENT_NAME memory/sql/user_var_entry::value
757 COUNT_ALLOC 3
758 COUNT_FREE 0
759 SUM_NUMBER_OF_BYTES_ALLOC 7024
760 SUM_NUMBER_OF_BYTES_FREE 0
761 LOW_COUNT_USED 3
762 CURRENT_COUNT_USED 3
763 HIGH_COUNT_USED 3
764 LOW_NUMBER_OF_BYTES_USED 7024
765 CURRENT_NUMBER_OF_BYTES_USED 7024
766 HIGH_NUMBER_OF_BYTES_USED 7024
767 username user2
768 EVENT_NAME memory/sql/User_level_lock
769 COUNT_ALLOC 1
770 COUNT_FREE 0
771 SUM_NUMBER_OF_BYTES_ALLOC 256
772 SUM_NUMBER_OF_BYTES_FREE 0
773 LOW_COUNT_USED 1
774 CURRENT_COUNT_USED 1
775 HIGH_COUNT_USED 1
776 LOW_NUMBER_OF_BYTES_USED 256
777 CURRENT_NUMBER_OF_BYTES_USED 256
778 HIGH_NUMBER_OF_BYTES_USED 256
779 username user2
780 EVENT_NAME memory/sql/user_var_entry::value
781 COUNT_ALLOC 3
782 COUNT_FREE 0
783 SUM_NUMBER_OF_BYTES_ALLOC 7024
784 SUM_NUMBER_OF_BYTES_FREE 0
785 LOW_COUNT_USED 3
786 CURRENT_COUNT_USED 3
787 HIGH_COUNT_USED 3
788 LOW_NUMBER_OF_BYTES_USED 7024
789 CURRENT_NUMBER_OF_BYTES_USED 7024
790 HIGH_NUMBER_OF_BYTES_USED 7024
791 username user3
792 EVENT_NAME memory/sql/User_level_lock
793 COUNT_ALLOC 0
794 COUNT_FREE 0
795 SUM_NUMBER_OF_BYTES_ALLOC 0
796 SUM_NUMBER_OF_BYTES_FREE 0
797 LOW_COUNT_USED 0
798 CURRENT_COUNT_USED 0
799 HIGH_COUNT_USED 0
800 LOW_NUMBER_OF_BYTES_USED 0
801 CURRENT_NUMBER_OF_BYTES_USED 0
802 HIGH_NUMBER_OF_BYTES_USED 0
803 username user3
804 EVENT_NAME memory/sql/user_var_entry::value
805 COUNT_ALLOC 0
806 COUNT_FREE 0
807 SUM_NUMBER_OF_BYTES_ALLOC 0
808 SUM_NUMBER_OF_BYTES_FREE 0
809 LOW_COUNT_USED 0
810 CURRENT_COUNT_USED 0
811 HIGH_COUNT_USED 0
812 LOW_NUMBER_OF_BYTES_USED 0
813 CURRENT_NUMBER_OF_BYTES_USED 0
814 HIGH_NUMBER_OF_BYTES_USED 0
815 username user4
816 status not found
817 execute dump_memory_account;
818 execute dump_memory_user;
819 USER user1
820 EVENT_NAME memory/sql/User_level_lock
821 COUNT_ALLOC 2
822 COUNT_FREE 1
823 SUM_NUMBER_OF_BYTES_ALLOC 272
824 SUM_NUMBER_OF_BYTES_FREE 16
825 LOW_COUNT_USED 0
826 CURRENT_COUNT_USED 1
827 HIGH_COUNT_USED 2
828 LOW_NUMBER_OF_BYTES_USED 0
829 CURRENT_NUMBER_OF_BYTES_USED 256
830 HIGH_NUMBER_OF_BYTES_USED 272
831 USER user1
832 EVENT_NAME memory/sql/user_var_entry::value
833 COUNT_ALLOC 3
834 COUNT_FREE 0
835 SUM_NUMBER_OF_BYTES_ALLOC 7024
836 SUM_NUMBER_OF_BYTES_FREE 0
837 LOW_COUNT_USED 0
838 CURRENT_COUNT_USED 3
839 HIGH_COUNT_USED 3
840 LOW_NUMBER_OF_BYTES_USED 0
841 CURRENT_NUMBER_OF_BYTES_USED 7024
842 HIGH_NUMBER_OF_BYTES_USED 7024
843 USER user2
844 EVENT_NAME memory/sql/User_level_lock
845 COUNT_ALLOC 2
846 COUNT_FREE 1
847 SUM_NUMBER_OF_BYTES_ALLOC 272
848 SUM_NUMBER_OF_BYTES_FREE 16
849 LOW_COUNT_USED 0
850 CURRENT_COUNT_USED 1
851 HIGH_COUNT_USED 2
852 LOW_NUMBER_OF_BYTES_USED 0
853 CURRENT_NUMBER_OF_BYTES_USED 256
854 HIGH_NUMBER_OF_BYTES_USED 272
855 USER user2
856 EVENT_NAME memory/sql/user_var_entry::value
857 COUNT_ALLOC 3
858 COUNT_FREE 0
859 SUM_NUMBER_OF_BYTES_ALLOC 7024
860 SUM_NUMBER_OF_BYTES_FREE 0
861 LOW_COUNT_USED 0
862 CURRENT_COUNT_USED 3
863 HIGH_COUNT_USED 3
864 LOW_NUMBER_OF_BYTES_USED 0
865 CURRENT_NUMBER_OF_BYTES_USED 7024
866 HIGH_NUMBER_OF_BYTES_USED 7024
867 USER user3
868 EVENT_NAME memory/sql/User_level_lock
869 COUNT_ALLOC 0
870 COUNT_FREE 0
871 SUM_NUMBER_OF_BYTES_ALLOC 0
872 SUM_NUMBER_OF_BYTES_FREE 0
873 LOW_COUNT_USED 0
874 CURRENT_COUNT_USED 0
875 HIGH_COUNT_USED 0
876 LOW_NUMBER_OF_BYTES_USED 0
877 CURRENT_NUMBER_OF_BYTES_USED 0
878 HIGH_NUMBER_OF_BYTES_USED 0
879 USER user3
880 EVENT_NAME memory/sql/user_var_entry::value
881 COUNT_ALLOC 0
882 COUNT_FREE 0
883 SUM_NUMBER_OF_BYTES_ALLOC 0
884 SUM_NUMBER_OF_BYTES_FREE 0
885 LOW_COUNT_USED 0
886 CURRENT_COUNT_USED 0
887 HIGH_COUNT_USED 0
888 LOW_NUMBER_OF_BYTES_USED 0
889 CURRENT_NUMBER_OF_BYTES_USED 0
890 HIGH_NUMBER_OF_BYTES_USED 0
891 execute dump_memory_host;
892 execute dump_memory_global;
893 EVENT_NAME memory/sql/Query_cache
894 COUNT_ALLOC 4
895 COUNT_FREE 2
896 SUM_NUMBER_OF_BYTES_ALLOC 65536
897 SUM_NUMBER_OF_BYTES_FREE 32768
898 LOW_COUNT_USED 0
899 CURRENT_COUNT_USED 2
900 HIGH_COUNT_USED 2
901 LOW_NUMBER_OF_BYTES_USED 0
902 CURRENT_NUMBER_OF_BYTES_USED 32768
903 HIGH_NUMBER_OF_BYTES_USED 32768
904 EVENT_NAME memory/sql/User_level_lock
905 COUNT_ALLOC 4
906 COUNT_FREE 2
907 SUM_NUMBER_OF_BYTES_ALLOC 544
908 SUM_NUMBER_OF_BYTES_FREE 32
909 LOW_COUNT_USED 0
910 CURRENT_COUNT_USED 2
911 HIGH_COUNT_USED 4
912 LOW_NUMBER_OF_BYTES_USED 0
913 CURRENT_NUMBER_OF_BYTES_USED 512
914 HIGH_NUMBER_OF_BYTES_USED 544
915 EVENT_NAME memory/sql/user_var_entry::value
916 COUNT_ALLOC 7
917 COUNT_FREE 0
918 SUM_NUMBER_OF_BYTES_ALLOC 14144
919 SUM_NUMBER_OF_BYTES_FREE 0
920 LOW_COUNT_USED 1
921 CURRENT_COUNT_USED 7
922 HIGH_COUNT_USED 7
923 LOW_NUMBER_OF_BYTES_USED 96
924 CURRENT_NUMBER_OF_BYTES_USED 14144
925 HIGH_NUMBER_OF_BYTES_USED 14144
926 execute dump_accounts;
927 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
928 execute dump_users;
929 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
930 root 1 1
931 user1 1 1
932 user2 1 1
933 user3 1 1
934 execute dump_hosts;
935 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
936 connection con3;
937 set GLOBAL query_cache_size=500*1024;
938 select get_lock("marker_3", 10);
939 get_lock("marker_3", 10)
940 1
941 select release_lock("marker_3");
942 release_lock("marker_3")
943 1
944 set @v1 = repeat("a", 1000);
945 set @v2 = repeat("b", 2000);
946 set @v3 = repeat("c", 4000);
947 "================== con3 marker =================="
948 connection default;
949 "================== Step 7 =================="
950 call dump_thread();
951 username user1
952 EVENT_NAME memory/sql/User_level_lock
953 COUNT_ALLOC 1
954 COUNT_FREE 0
955 SUM_NUMBER_OF_BYTES_ALLOC 256
956 SUM_NUMBER_OF_BYTES_FREE 0
957 LOW_COUNT_USED 1
958 CURRENT_COUNT_USED 1
959 HIGH_COUNT_USED 1
960 LOW_NUMBER_OF_BYTES_USED 256
961 CURRENT_NUMBER_OF_BYTES_USED 256
962 HIGH_NUMBER_OF_BYTES_USED 256
963 username user1
964 EVENT_NAME memory/sql/user_var_entry::value
965 COUNT_ALLOC 3
966 COUNT_FREE 0
967 SUM_NUMBER_OF_BYTES_ALLOC 7024
968 SUM_NUMBER_OF_BYTES_FREE 0
969 LOW_COUNT_USED 3
970 CURRENT_COUNT_USED 3
971 HIGH_COUNT_USED 3
972 LOW_NUMBER_OF_BYTES_USED 7024
973 CURRENT_NUMBER_OF_BYTES_USED 7024
974 HIGH_NUMBER_OF_BYTES_USED 7024
975 username user2
976 EVENT_NAME memory/sql/User_level_lock
977 COUNT_ALLOC 1
978 COUNT_FREE 0
979 SUM_NUMBER_OF_BYTES_ALLOC 256
980 SUM_NUMBER_OF_BYTES_FREE 0
981 LOW_COUNT_USED 1
982 CURRENT_COUNT_USED 1
983 HIGH_COUNT_USED 1
984 LOW_NUMBER_OF_BYTES_USED 256
985 CURRENT_NUMBER_OF_BYTES_USED 256
986 HIGH_NUMBER_OF_BYTES_USED 256
987 username user2
988 EVENT_NAME memory/sql/user_var_entry::value
989 COUNT_ALLOC 3
990 COUNT_FREE 0
991 SUM_NUMBER_OF_BYTES_ALLOC 7024
992 SUM_NUMBER_OF_BYTES_FREE 0
993 LOW_COUNT_USED 3
994 CURRENT_COUNT_USED 3
995 HIGH_COUNT_USED 3
996 LOW_NUMBER_OF_BYTES_USED 7024
997 CURRENT_NUMBER_OF_BYTES_USED 7024
998 HIGH_NUMBER_OF_BYTES_USED 7024
999 username user3
1000 EVENT_NAME memory/sql/User_level_lock
1001 COUNT_ALLOC 2
1002 COUNT_FREE 1
1003 SUM_NUMBER_OF_BYTES_ALLOC 272
1004 SUM_NUMBER_OF_BYTES_FREE 16
1005 LOW_COUNT_USED 0
1006 CURRENT_COUNT_USED 1
1007 HIGH_COUNT_USED 2
1008 LOW_NUMBER_OF_BYTES_USED 0
1009 CURRENT_NUMBER_OF_BYTES_USED 256
1010 HIGH_NUMBER_OF_BYTES_USED 272
1011 username user3
1012 EVENT_NAME memory/sql/user_var_entry::value
1013 COUNT_ALLOC 3
1014 COUNT_FREE 0
1015 SUM_NUMBER_OF_BYTES_ALLOC 7024
1016 SUM_NUMBER_OF_BYTES_FREE 0
1017 LOW_COUNT_USED 0
1018 CURRENT_COUNT_USED 3
1019 HIGH_COUNT_USED 3
1020 LOW_NUMBER_OF_BYTES_USED 0
1021 CURRENT_NUMBER_OF_BYTES_USED 7024
1022 HIGH_NUMBER_OF_BYTES_USED 7024
1023 username user4
1024 status not found
1025 execute dump_memory_account;
1026 execute dump_memory_user;
1027 USER user1
1028 EVENT_NAME memory/sql/User_level_lock
1029 COUNT_ALLOC 2
1030 COUNT_FREE 1
1031 SUM_NUMBER_OF_BYTES_ALLOC 272
1032 SUM_NUMBER_OF_BYTES_FREE 16
1033 LOW_COUNT_USED 0
1034 CURRENT_COUNT_USED 1
1035 HIGH_COUNT_USED 2
1036 LOW_NUMBER_OF_BYTES_USED 0
1037 CURRENT_NUMBER_OF_BYTES_USED 256
1038 HIGH_NUMBER_OF_BYTES_USED 272
1039 USER user1
1040 EVENT_NAME memory/sql/user_var_entry::value
1041 COUNT_ALLOC 3
1042 COUNT_FREE 0
1043 SUM_NUMBER_OF_BYTES_ALLOC 7024
1044 SUM_NUMBER_OF_BYTES_FREE 0
1045 LOW_COUNT_USED 0
1046 CURRENT_COUNT_USED 3
1047 HIGH_COUNT_USED 3
1048 LOW_NUMBER_OF_BYTES_USED 0
1049 CURRENT_NUMBER_OF_BYTES_USED 7024
1050 HIGH_NUMBER_OF_BYTES_USED 7024
1051 USER user2
1052 EVENT_NAME memory/sql/User_level_lock
1053 COUNT_ALLOC 2
1054 COUNT_FREE 1
1055 SUM_NUMBER_OF_BYTES_ALLOC 272
1056 SUM_NUMBER_OF_BYTES_FREE 16
1057 LOW_COUNT_USED 0
1058 CURRENT_COUNT_USED 1
1059 HIGH_COUNT_USED 2
1060 LOW_NUMBER_OF_BYTES_USED 0
1061 CURRENT_NUMBER_OF_BYTES_USED 256
1062 HIGH_NUMBER_OF_BYTES_USED 272
1063 USER user2
1064 EVENT_NAME memory/sql/user_var_entry::value
1065 COUNT_ALLOC 3
1066 COUNT_FREE 0
1067 SUM_NUMBER_OF_BYTES_ALLOC 7024
1068 SUM_NUMBER_OF_BYTES_FREE 0
1069 LOW_COUNT_USED 0
1070 CURRENT_COUNT_USED 3
1071 HIGH_COUNT_USED 3
1072 LOW_NUMBER_OF_BYTES_USED 0
1073 CURRENT_NUMBER_OF_BYTES_USED 7024
1074 HIGH_NUMBER_OF_BYTES_USED 7024
1075 USER user3
1076 EVENT_NAME memory/sql/User_level_lock
1077 COUNT_ALLOC 2
1078 COUNT_FREE 1
1079 SUM_NUMBER_OF_BYTES_ALLOC 272
1080 SUM_NUMBER_OF_BYTES_FREE 16
1081 LOW_COUNT_USED 0
1082 CURRENT_COUNT_USED 1
1083 HIGH_COUNT_USED 2
1084 LOW_NUMBER_OF_BYTES_USED 0
1085 CURRENT_NUMBER_OF_BYTES_USED 256
1086 HIGH_NUMBER_OF_BYTES_USED 272
1087 USER user3
1088 EVENT_NAME memory/sql/user_var_entry::value
1089 COUNT_ALLOC 3
1090 COUNT_FREE 0
1091 SUM_NUMBER_OF_BYTES_ALLOC 7024
1092 SUM_NUMBER_OF_BYTES_FREE 0
1093 LOW_COUNT_USED 0
1094 CURRENT_COUNT_USED 3
1095 HIGH_COUNT_USED 3
1096 LOW_NUMBER_OF_BYTES_USED 0
1097 CURRENT_NUMBER_OF_BYTES_USED 7024
1098 HIGH_NUMBER_OF_BYTES_USED 7024
1099 execute dump_memory_host;
1100 execute dump_memory_global;
1101 EVENT_NAME memory/sql/Query_cache
1102 COUNT_ALLOC 6
1103 COUNT_FREE 4
1104 SUM_NUMBER_OF_BYTES_ALLOC 98304
1105 SUM_NUMBER_OF_BYTES_FREE 65536
1106 LOW_COUNT_USED 0
1107 CURRENT_COUNT_USED 2
1108 HIGH_COUNT_USED 2
1109 LOW_NUMBER_OF_BYTES_USED 0
1110 CURRENT_NUMBER_OF_BYTES_USED 32768
1111 HIGH_NUMBER_OF_BYTES_USED 32768
1112 EVENT_NAME memory/sql/User_level_lock
1113 COUNT_ALLOC 6
1114 COUNT_FREE 3
1115 SUM_NUMBER_OF_BYTES_ALLOC 816
1116 SUM_NUMBER_OF_BYTES_FREE 48
1117 LOW_COUNT_USED 0
1118 CURRENT_COUNT_USED 3
1119 HIGH_COUNT_USED 4
1120 LOW_NUMBER_OF_BYTES_USED 0
1121 CURRENT_NUMBER_OF_BYTES_USED 768
1122 HIGH_NUMBER_OF_BYTES_USED 784
1123 EVENT_NAME memory/sql/user_var_entry::value
1124 COUNT_ALLOC 10
1125 COUNT_FREE 0
1126 SUM_NUMBER_OF_BYTES_ALLOC 21168
1127 SUM_NUMBER_OF_BYTES_FREE 0
1128 LOW_COUNT_USED 1
1129 CURRENT_COUNT_USED 10
1130 HIGH_COUNT_USED 10
1131 LOW_NUMBER_OF_BYTES_USED 96
1132 CURRENT_NUMBER_OF_BYTES_USED 21168
1133 HIGH_NUMBER_OF_BYTES_USED 21168
1134 execute dump_accounts;
1135 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1136 execute dump_users;
1137 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1138 root 1 1
1139 user1 1 1
1140 user2 1 1
1141 user3 1 1
1142 execute dump_hosts;
1143 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1144 connect con4, localhost, user4, , ;
1145 connect con5, localhost, user4, , ;
1146 "================== con4/con5 (both user4) connected =================="
1147 connection default;
1148 "================== Step 8 =================="
1149 call dump_thread();
1150 username user1
1151 EVENT_NAME memory/sql/User_level_lock
1152 COUNT_ALLOC 1
1153 COUNT_FREE 0
1154 SUM_NUMBER_OF_BYTES_ALLOC 256
1155 SUM_NUMBER_OF_BYTES_FREE 0
1156 LOW_COUNT_USED 1
1157 CURRENT_COUNT_USED 1
1158 HIGH_COUNT_USED 1
1159 LOW_NUMBER_OF_BYTES_USED 256
1160 CURRENT_NUMBER_OF_BYTES_USED 256
1161 HIGH_NUMBER_OF_BYTES_USED 256
1162 username user1
1163 EVENT_NAME memory/sql/user_var_entry::value
1164 COUNT_ALLOC 3
1165 COUNT_FREE 0
1166 SUM_NUMBER_OF_BYTES_ALLOC 7024
1167 SUM_NUMBER_OF_BYTES_FREE 0
1168 LOW_COUNT_USED 3
1169 CURRENT_COUNT_USED 3
1170 HIGH_COUNT_USED 3
1171 LOW_NUMBER_OF_BYTES_USED 7024
1172 CURRENT_NUMBER_OF_BYTES_USED 7024
1173 HIGH_NUMBER_OF_BYTES_USED 7024
1174 username user2
1175 EVENT_NAME memory/sql/User_level_lock
1176 COUNT_ALLOC 1
1177 COUNT_FREE 0
1178 SUM_NUMBER_OF_BYTES_ALLOC 256
1179 SUM_NUMBER_OF_BYTES_FREE 0
1180 LOW_COUNT_USED 1
1181 CURRENT_COUNT_USED 1
1182 HIGH_COUNT_USED 1
1183 LOW_NUMBER_OF_BYTES_USED 256
1184 CURRENT_NUMBER_OF_BYTES_USED 256
1185 HIGH_NUMBER_OF_BYTES_USED 256
1186 username user2
1187 EVENT_NAME memory/sql/user_var_entry::value
1188 COUNT_ALLOC 3
1189 COUNT_FREE 0
1190 SUM_NUMBER_OF_BYTES_ALLOC 7024
1191 SUM_NUMBER_OF_BYTES_FREE 0
1192 LOW_COUNT_USED 3
1193 CURRENT_COUNT_USED 3
1194 HIGH_COUNT_USED 3
1195 LOW_NUMBER_OF_BYTES_USED 7024
1196 CURRENT_NUMBER_OF_BYTES_USED 7024
1197 HIGH_NUMBER_OF_BYTES_USED 7024
1198 username user3
1199 EVENT_NAME memory/sql/User_level_lock
1200 COUNT_ALLOC 2
1201 COUNT_FREE 1
1202 SUM_NUMBER_OF_BYTES_ALLOC 272
1203 SUM_NUMBER_OF_BYTES_FREE 16
1204 LOW_COUNT_USED 0
1205 CURRENT_COUNT_USED 1
1206 HIGH_COUNT_USED 2
1207 LOW_NUMBER_OF_BYTES_USED 0
1208 CURRENT_NUMBER_OF_BYTES_USED 256
1209 HIGH_NUMBER_OF_BYTES_USED 272
1210 username user3
1211 EVENT_NAME memory/sql/user_var_entry::value
1212 COUNT_ALLOC 3
1213 COUNT_FREE 0
1214 SUM_NUMBER_OF_BYTES_ALLOC 7024
1215 SUM_NUMBER_OF_BYTES_FREE 0
1216 LOW_COUNT_USED 0
1217 CURRENT_COUNT_USED 3
1218 HIGH_COUNT_USED 3
1219 LOW_NUMBER_OF_BYTES_USED 0
1220 CURRENT_NUMBER_OF_BYTES_USED 7024
1221 HIGH_NUMBER_OF_BYTES_USED 7024
1222 username user4
1223 EVENT_NAME memory/sql/User_level_lock
1224 COUNT_ALLOC 0
1225 COUNT_FREE 0
1226 SUM_NUMBER_OF_BYTES_ALLOC 0
1227 SUM_NUMBER_OF_BYTES_FREE 0
1228 LOW_COUNT_USED 0
1229 CURRENT_COUNT_USED 0
1230 HIGH_COUNT_USED 0
1231 LOW_NUMBER_OF_BYTES_USED 0
1232 CURRENT_NUMBER_OF_BYTES_USED 0
1233 HIGH_NUMBER_OF_BYTES_USED 0
1234 username user4
1235 EVENT_NAME memory/sql/user_var_entry::value
1236 COUNT_ALLOC 0
1237 COUNT_FREE 0
1238 SUM_NUMBER_OF_BYTES_ALLOC 0
1239 SUM_NUMBER_OF_BYTES_FREE 0
1240 LOW_COUNT_USED 0
1241 CURRENT_COUNT_USED 0
1242 HIGH_COUNT_USED 0
1243 LOW_NUMBER_OF_BYTES_USED 0
1244 CURRENT_NUMBER_OF_BYTES_USED 0
1245 HIGH_NUMBER_OF_BYTES_USED 0
1246 execute dump_memory_account;
1247 execute dump_memory_user;
1248 USER user1
1249 EVENT_NAME memory/sql/User_level_lock
1250 COUNT_ALLOC 2
1251 COUNT_FREE 1
1252 SUM_NUMBER_OF_BYTES_ALLOC 272
1253 SUM_NUMBER_OF_BYTES_FREE 16
1254 LOW_COUNT_USED 0
1255 CURRENT_COUNT_USED 1
1256 HIGH_COUNT_USED 2
1257 LOW_NUMBER_OF_BYTES_USED 0
1258 CURRENT_NUMBER_OF_BYTES_USED 256
1259 HIGH_NUMBER_OF_BYTES_USED 272
1260 USER user1
1261 EVENT_NAME memory/sql/user_var_entry::value
1262 COUNT_ALLOC 3
1263 COUNT_FREE 0
1264 SUM_NUMBER_OF_BYTES_ALLOC 7024
1265 SUM_NUMBER_OF_BYTES_FREE 0
1266 LOW_COUNT_USED 0
1267 CURRENT_COUNT_USED 3
1268 HIGH_COUNT_USED 3
1269 LOW_NUMBER_OF_BYTES_USED 0
1270 CURRENT_NUMBER_OF_BYTES_USED 7024
1271 HIGH_NUMBER_OF_BYTES_USED 7024
1272 USER user2
1273 EVENT_NAME memory/sql/User_level_lock
1274 COUNT_ALLOC 2
1275 COUNT_FREE 1
1276 SUM_NUMBER_OF_BYTES_ALLOC 272
1277 SUM_NUMBER_OF_BYTES_FREE 16
1278 LOW_COUNT_USED 0
1279 CURRENT_COUNT_USED 1
1280 HIGH_COUNT_USED 2
1281 LOW_NUMBER_OF_BYTES_USED 0
1282 CURRENT_NUMBER_OF_BYTES_USED 256
1283 HIGH_NUMBER_OF_BYTES_USED 272
1284 USER user2
1285 EVENT_NAME memory/sql/user_var_entry::value
1286 COUNT_ALLOC 3
1287 COUNT_FREE 0
1288 SUM_NUMBER_OF_BYTES_ALLOC 7024
1289 SUM_NUMBER_OF_BYTES_FREE 0
1290 LOW_COUNT_USED 0
1291 CURRENT_COUNT_USED 3
1292 HIGH_COUNT_USED 3
1293 LOW_NUMBER_OF_BYTES_USED 0
1294 CURRENT_NUMBER_OF_BYTES_USED 7024
1295 HIGH_NUMBER_OF_BYTES_USED 7024
1296 USER user3
1297 EVENT_NAME memory/sql/User_level_lock
1298 COUNT_ALLOC 2
1299 COUNT_FREE 1
1300 SUM_NUMBER_OF_BYTES_ALLOC 272
1301 SUM_NUMBER_OF_BYTES_FREE 16
1302 LOW_COUNT_USED 0
1303 CURRENT_COUNT_USED 1
1304 HIGH_COUNT_USED 2
1305 LOW_NUMBER_OF_BYTES_USED 0
1306 CURRENT_NUMBER_OF_BYTES_USED 256
1307 HIGH_NUMBER_OF_BYTES_USED 272
1308 USER user3
1309 EVENT_NAME memory/sql/user_var_entry::value
1310 COUNT_ALLOC 3
1311 COUNT_FREE 0
1312 SUM_NUMBER_OF_BYTES_ALLOC 7024
1313 SUM_NUMBER_OF_BYTES_FREE 0
1314 LOW_COUNT_USED 0
1315 CURRENT_COUNT_USED 3
1316 HIGH_COUNT_USED 3
1317 LOW_NUMBER_OF_BYTES_USED 0
1318 CURRENT_NUMBER_OF_BYTES_USED 7024
1319 HIGH_NUMBER_OF_BYTES_USED 7024
1320 USER user4
1321 EVENT_NAME memory/sql/User_level_lock
1322 COUNT_ALLOC 0
1323 COUNT_FREE 0
1324 SUM_NUMBER_OF_BYTES_ALLOC 0
1325 SUM_NUMBER_OF_BYTES_FREE 0
1326 LOW_COUNT_USED 0
1327 CURRENT_COUNT_USED 0
1328 HIGH_COUNT_USED 0
1329 LOW_NUMBER_OF_BYTES_USED 0
1330 CURRENT_NUMBER_OF_BYTES_USED 0
1331 HIGH_NUMBER_OF_BYTES_USED 0
1332 USER user4
1333 EVENT_NAME memory/sql/user_var_entry::value
1334 COUNT_ALLOC 0
1335 COUNT_FREE 0
1336 SUM_NUMBER_OF_BYTES_ALLOC 0
1337 SUM_NUMBER_OF_BYTES_FREE 0
1338 LOW_COUNT_USED 0
1339 CURRENT_COUNT_USED 0
1340 HIGH_COUNT_USED 0
1341 LOW_NUMBER_OF_BYTES_USED 0
1342 CURRENT_NUMBER_OF_BYTES_USED 0
1343 HIGH_NUMBER_OF_BYTES_USED 0
1344 execute dump_memory_host;
1345 execute dump_memory_global;
1346 EVENT_NAME memory/sql/Query_cache
1347 COUNT_ALLOC 6
1348 COUNT_FREE 4
1349 SUM_NUMBER_OF_BYTES_ALLOC 98304
1350 SUM_NUMBER_OF_BYTES_FREE 65536
1351 LOW_COUNT_USED 0
1352 CURRENT_COUNT_USED 2
1353 HIGH_COUNT_USED 2
1354 LOW_NUMBER_OF_BYTES_USED 0
1355 CURRENT_NUMBER_OF_BYTES_USED 32768
1356 HIGH_NUMBER_OF_BYTES_USED 32768
1357 EVENT_NAME memory/sql/User_level_lock
1358 COUNT_ALLOC 6
1359 COUNT_FREE 3
1360 SUM_NUMBER_OF_BYTES_ALLOC 816
1361 SUM_NUMBER_OF_BYTES_FREE 48
1362 LOW_COUNT_USED 0
1363 CURRENT_COUNT_USED 3
1364 HIGH_COUNT_USED 4
1365 LOW_NUMBER_OF_BYTES_USED 0
1366 CURRENT_NUMBER_OF_BYTES_USED 768
1367 HIGH_NUMBER_OF_BYTES_USED 784
1368 EVENT_NAME memory/sql/user_var_entry::value
1369 COUNT_ALLOC 10
1370 COUNT_FREE 0
1371 SUM_NUMBER_OF_BYTES_ALLOC 21168
1372 SUM_NUMBER_OF_BYTES_FREE 0
1373 LOW_COUNT_USED 1
1374 CURRENT_COUNT_USED 10
1375 HIGH_COUNT_USED 10
1376 LOW_NUMBER_OF_BYTES_USED 96
1377 CURRENT_NUMBER_OF_BYTES_USED 21168
1378 HIGH_NUMBER_OF_BYTES_USED 21168
1379 execute dump_accounts;
1380 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1381 execute dump_users;
1382 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1383 root 1 1
1384 user1 1 1
1385 user2 1 1
1386 user3 1 1
1387 user4 2 2
1388 execute dump_hosts;
1389 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1390 connection con4;
1391 set GLOBAL query_cache_size=4000*1024;
1392 select get_lock("marker_4", 10);
1393 get_lock("marker_4", 10)
1394 1
1395 select release_lock("marker_4");
1396 release_lock("marker_4")
1397 1
1398 set @v1 = repeat("a", 1000);
1399 set @v2 = repeat("b", 2000);
1400 set @v3 = repeat("c", 4000);
1401 connection con5;
1402 select get_lock("marker_5", 10);
1403 get_lock("marker_5", 10)
1404 1
1405 select release_lock("marker_5");
1406 release_lock("marker_5")
1407 1
1408 set @v1 = repeat("a", 1000);
1409 set @v2 = repeat("b", 2000);
1410 set @v3 = repeat("c", 4000);
1411 "================== con4/con5 marker =================="
1412 connection default;
1413 "================== Step 9 =================="
1414 call dump_thread();
1415 username user1
1416 EVENT_NAME memory/sql/User_level_lock
1417 COUNT_ALLOC 1
1418 COUNT_FREE 0
1419 SUM_NUMBER_OF_BYTES_ALLOC 256
1420 SUM_NUMBER_OF_BYTES_FREE 0
1421 LOW_COUNT_USED 1
1422 CURRENT_COUNT_USED 1
1423 HIGH_COUNT_USED 1
1424 LOW_NUMBER_OF_BYTES_USED 256
1425 CURRENT_NUMBER_OF_BYTES_USED 256
1426 HIGH_NUMBER_OF_BYTES_USED 256
1427 username user1
1428 EVENT_NAME memory/sql/user_var_entry::value
1429 COUNT_ALLOC 3
1430 COUNT_FREE 0
1431 SUM_NUMBER_OF_BYTES_ALLOC 7024
1432 SUM_NUMBER_OF_BYTES_FREE 0
1433 LOW_COUNT_USED 3
1434 CURRENT_COUNT_USED 3
1435 HIGH_COUNT_USED 3
1436 LOW_NUMBER_OF_BYTES_USED 7024
1437 CURRENT_NUMBER_OF_BYTES_USED 7024
1438 HIGH_NUMBER_OF_BYTES_USED 7024
1439 username user2
1440 EVENT_NAME memory/sql/User_level_lock
1441 COUNT_ALLOC 1
1442 COUNT_FREE 0
1443 SUM_NUMBER_OF_BYTES_ALLOC 256
1444 SUM_NUMBER_OF_BYTES_FREE 0
1445 LOW_COUNT_USED 1
1446 CURRENT_COUNT_USED 1
1447 HIGH_COUNT_USED 1
1448 LOW_NUMBER_OF_BYTES_USED 256
1449 CURRENT_NUMBER_OF_BYTES_USED 256
1450 HIGH_NUMBER_OF_BYTES_USED 256
1451 username user2
1452 EVENT_NAME memory/sql/user_var_entry::value
1453 COUNT_ALLOC 3
1454 COUNT_FREE 0
1455 SUM_NUMBER_OF_BYTES_ALLOC 7024
1456 SUM_NUMBER_OF_BYTES_FREE 0
1457 LOW_COUNT_USED 3
1458 CURRENT_COUNT_USED 3
1459 HIGH_COUNT_USED 3
1460 LOW_NUMBER_OF_BYTES_USED 7024
1461 CURRENT_NUMBER_OF_BYTES_USED 7024
1462 HIGH_NUMBER_OF_BYTES_USED 7024
1463 username user3
1464 EVENT_NAME memory/sql/User_level_lock
1465 COUNT_ALLOC 2
1466 COUNT_FREE 1
1467 SUM_NUMBER_OF_BYTES_ALLOC 272
1468 SUM_NUMBER_OF_BYTES_FREE 16
1469 LOW_COUNT_USED 0
1470 CURRENT_COUNT_USED 1
1471 HIGH_COUNT_USED 2
1472 LOW_NUMBER_OF_BYTES_USED 0
1473 CURRENT_NUMBER_OF_BYTES_USED 256
1474 HIGH_NUMBER_OF_BYTES_USED 272
1475 username user3
1476 EVENT_NAME memory/sql/user_var_entry::value
1477 COUNT_ALLOC 3
1478 COUNT_FREE 0
1479 SUM_NUMBER_OF_BYTES_ALLOC 7024
1480 SUM_NUMBER_OF_BYTES_FREE 0
1481 LOW_COUNT_USED 0
1482 CURRENT_COUNT_USED 3
1483 HIGH_COUNT_USED 3
1484 LOW_NUMBER_OF_BYTES_USED 0
1485 CURRENT_NUMBER_OF_BYTES_USED 7024
1486 HIGH_NUMBER_OF_BYTES_USED 7024
1487 username user4
1488 EVENT_NAME memory/sql/User_level_lock
1489 COUNT_ALLOC 2
1490 COUNT_FREE 1
1491 SUM_NUMBER_OF_BYTES_ALLOC 272
1492 SUM_NUMBER_OF_BYTES_FREE 16
1493 LOW_COUNT_USED 0
1494 CURRENT_COUNT_USED 1
1495 HIGH_COUNT_USED 2
1496 LOW_NUMBER_OF_BYTES_USED 0
1497 CURRENT_NUMBER_OF_BYTES_USED 256
1498 HIGH_NUMBER_OF_BYTES_USED 272
1499 username user4
1500 EVENT_NAME memory/sql/user_var_entry::value
1501 COUNT_ALLOC 3
1502 COUNT_FREE 0
1503 SUM_NUMBER_OF_BYTES_ALLOC 7024
1504 SUM_NUMBER_OF_BYTES_FREE 0
1505 LOW_COUNT_USED 0
1506 CURRENT_COUNT_USED 3
1507 HIGH_COUNT_USED 3
1508 LOW_NUMBER_OF_BYTES_USED 0
1509 CURRENT_NUMBER_OF_BYTES_USED 7024
1510 HIGH_NUMBER_OF_BYTES_USED 7024
1511 execute dump_memory_account;
1512 execute dump_memory_user;
1513 USER user1
1514 EVENT_NAME memory/sql/User_level_lock
1515 COUNT_ALLOC 2
1516 COUNT_FREE 1
1517 SUM_NUMBER_OF_BYTES_ALLOC 272
1518 SUM_NUMBER_OF_BYTES_FREE 16
1519 LOW_COUNT_USED 0
1520 CURRENT_COUNT_USED 1
1521 HIGH_COUNT_USED 2
1522 LOW_NUMBER_OF_BYTES_USED 0
1523 CURRENT_NUMBER_OF_BYTES_USED 256
1524 HIGH_NUMBER_OF_BYTES_USED 272
1525 USER user1
1526 EVENT_NAME memory/sql/user_var_entry::value
1527 COUNT_ALLOC 3
1528 COUNT_FREE 0
1529 SUM_NUMBER_OF_BYTES_ALLOC 7024
1530 SUM_NUMBER_OF_BYTES_FREE 0
1531 LOW_COUNT_USED 0
1532 CURRENT_COUNT_USED 3
1533 HIGH_COUNT_USED 3
1534 LOW_NUMBER_OF_BYTES_USED 0
1535 CURRENT_NUMBER_OF_BYTES_USED 7024
1536 HIGH_NUMBER_OF_BYTES_USED 7024
1537 USER user2
1538 EVENT_NAME memory/sql/User_level_lock
1539 COUNT_ALLOC 2
1540 COUNT_FREE 1
1541 SUM_NUMBER_OF_BYTES_ALLOC 272
1542 SUM_NUMBER_OF_BYTES_FREE 16
1543 LOW_COUNT_USED 0
1544 CURRENT_COUNT_USED 1
1545 HIGH_COUNT_USED 2
1546 LOW_NUMBER_OF_BYTES_USED 0
1547 CURRENT_NUMBER_OF_BYTES_USED 256
1548 HIGH_NUMBER_OF_BYTES_USED 272
1549 USER user2
1550 EVENT_NAME memory/sql/user_var_entry::value
1551 COUNT_ALLOC 3
1552 COUNT_FREE 0
1553 SUM_NUMBER_OF_BYTES_ALLOC 7024
1554 SUM_NUMBER_OF_BYTES_FREE 0
1555 LOW_COUNT_USED 0
1556 CURRENT_COUNT_USED 3
1557 HIGH_COUNT_USED 3
1558 LOW_NUMBER_OF_BYTES_USED 0
1559 CURRENT_NUMBER_OF_BYTES_USED 7024
1560 HIGH_NUMBER_OF_BYTES_USED 7024
1561 USER user3
1562 EVENT_NAME memory/sql/User_level_lock
1563 COUNT_ALLOC 2
1564 COUNT_FREE 1
1565 SUM_NUMBER_OF_BYTES_ALLOC 272
1566 SUM_NUMBER_OF_BYTES_FREE 16
1567 LOW_COUNT_USED 0
1568 CURRENT_COUNT_USED 1
1569 HIGH_COUNT_USED 2
1570 LOW_NUMBER_OF_BYTES_USED 0
1571 CURRENT_NUMBER_OF_BYTES_USED 256
1572 HIGH_NUMBER_OF_BYTES_USED 272
1573 USER user3
1574 EVENT_NAME memory/sql/user_var_entry::value
1575 COUNT_ALLOC 3
1576 COUNT_FREE 0
1577 SUM_NUMBER_OF_BYTES_ALLOC 7024
1578 SUM_NUMBER_OF_BYTES_FREE 0
1579 LOW_COUNT_USED 0
1580 CURRENT_COUNT_USED 3
1581 HIGH_COUNT_USED 3
1582 LOW_NUMBER_OF_BYTES_USED 0
1583 CURRENT_NUMBER_OF_BYTES_USED 7024
1584 HIGH_NUMBER_OF_BYTES_USED 7024
1585 USER user4
1586 EVENT_NAME memory/sql/User_level_lock
1587 COUNT_ALLOC 4
1588 COUNT_FREE 2
1589 SUM_NUMBER_OF_BYTES_ALLOC 544
1590 SUM_NUMBER_OF_BYTES_FREE 32
1591 LOW_COUNT_USED 0
1592 CURRENT_COUNT_USED 2
1593 HIGH_COUNT_USED 4
1594 LOW_NUMBER_OF_BYTES_USED 0
1595 CURRENT_NUMBER_OF_BYTES_USED 512
1596 HIGH_NUMBER_OF_BYTES_USED 544
1597 USER user4
1598 EVENT_NAME memory/sql/user_var_entry::value
1599 COUNT_ALLOC 6
1600 COUNT_FREE 0
1601 SUM_NUMBER_OF_BYTES_ALLOC 14048
1602 SUM_NUMBER_OF_BYTES_FREE 0
1603 LOW_COUNT_USED 0
1604 CURRENT_COUNT_USED 6
1605 HIGH_COUNT_USED 6
1606 LOW_NUMBER_OF_BYTES_USED 0
1607 CURRENT_NUMBER_OF_BYTES_USED 14048
1608 HIGH_NUMBER_OF_BYTES_USED 14048
1609 execute dump_memory_host;
1610 execute dump_memory_global;
1611 EVENT_NAME memory/sql/Query_cache
1612 COUNT_ALLOC 8
1613 COUNT_FREE 6
1614 SUM_NUMBER_OF_BYTES_ALLOC 131072
1615 SUM_NUMBER_OF_BYTES_FREE 98304
1616 LOW_COUNT_USED 0
1617 CURRENT_COUNT_USED 2
1618 HIGH_COUNT_USED 2
1619 LOW_NUMBER_OF_BYTES_USED 0
1620 CURRENT_NUMBER_OF_BYTES_USED 32768
1621 HIGH_NUMBER_OF_BYTES_USED 32768
1622 EVENT_NAME memory/sql/User_level_lock
1623 COUNT_ALLOC 10
1624 COUNT_FREE 5
1625 SUM_NUMBER_OF_BYTES_ALLOC 1360
1626 SUM_NUMBER_OF_BYTES_FREE 80
1627 LOW_COUNT_USED 0
1628 CURRENT_COUNT_USED 5
1629 HIGH_COUNT_USED 8
1630 LOW_NUMBER_OF_BYTES_USED 0
1631 CURRENT_NUMBER_OF_BYTES_USED 1280
1632 HIGH_NUMBER_OF_BYTES_USED 1328
1633 EVENT_NAME memory/sql/user_var_entry::value
1634 COUNT_ALLOC 16
1635 COUNT_FREE 0
1636 SUM_NUMBER_OF_BYTES_ALLOC 35216
1637 SUM_NUMBER_OF_BYTES_FREE 0
1638 LOW_COUNT_USED 1
1639 CURRENT_COUNT_USED 16
1640 HIGH_COUNT_USED 16
1641 LOW_NUMBER_OF_BYTES_USED 96
1642 CURRENT_NUMBER_OF_BYTES_USED 35216
1643 HIGH_NUMBER_OF_BYTES_USED 35216
1644 execute dump_accounts;
1645 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1646 execute dump_users;
1647 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1648 root 1 1
1649 user1 1 1
1650 user2 1 1
1651 user3 1 1
1652 user4 2 2
1653 execute dump_hosts;
1654 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1655 disconnect con1;
1656 connection default;
1657 disconnect con5;
1658 "================== con1/con5 disconnected =================="
1659 "================== Step 10 =================="
1660 call dump_thread();
1661 username user1
1662 status not found
1663 username user2
1664 EVENT_NAME memory/sql/User_level_lock
1665 COUNT_ALLOC 1
1666 COUNT_FREE 0
1667 SUM_NUMBER_OF_BYTES_ALLOC 256
1668 SUM_NUMBER_OF_BYTES_FREE 0
1669 LOW_COUNT_USED 1
1670 CURRENT_COUNT_USED 1
1671 HIGH_COUNT_USED 1
1672 LOW_NUMBER_OF_BYTES_USED 256
1673 CURRENT_NUMBER_OF_BYTES_USED 256
1674 HIGH_NUMBER_OF_BYTES_USED 256
1675 username user2
1676 EVENT_NAME memory/sql/user_var_entry::value
1677 COUNT_ALLOC 3
1678 COUNT_FREE 0
1679 SUM_NUMBER_OF_BYTES_ALLOC 7024
1680 SUM_NUMBER_OF_BYTES_FREE 0
1681 LOW_COUNT_USED 3
1682 CURRENT_COUNT_USED 3
1683 HIGH_COUNT_USED 3
1684 LOW_NUMBER_OF_BYTES_USED 7024
1685 CURRENT_NUMBER_OF_BYTES_USED 7024
1686 HIGH_NUMBER_OF_BYTES_USED 7024
1687 username user3
1688 EVENT_NAME memory/sql/User_level_lock
1689 COUNT_ALLOC 2
1690 COUNT_FREE 1
1691 SUM_NUMBER_OF_BYTES_ALLOC 272
1692 SUM_NUMBER_OF_BYTES_FREE 16
1693 LOW_COUNT_USED 0
1694 CURRENT_COUNT_USED 1
1695 HIGH_COUNT_USED 2
1696 LOW_NUMBER_OF_BYTES_USED 0
1697 CURRENT_NUMBER_OF_BYTES_USED 256
1698 HIGH_NUMBER_OF_BYTES_USED 272
1699 username user3
1700 EVENT_NAME memory/sql/user_var_entry::value
1701 COUNT_ALLOC 3
1702 COUNT_FREE 0
1703 SUM_NUMBER_OF_BYTES_ALLOC 7024
1704 SUM_NUMBER_OF_BYTES_FREE 0
1705 LOW_COUNT_USED 0
1706 CURRENT_COUNT_USED 3
1707 HIGH_COUNT_USED 3
1708 LOW_NUMBER_OF_BYTES_USED 0
1709 CURRENT_NUMBER_OF_BYTES_USED 7024
1710 HIGH_NUMBER_OF_BYTES_USED 7024
1711 username user4
1712 EVENT_NAME memory/sql/User_level_lock
1713 COUNT_ALLOC 2
1714 COUNT_FREE 1
1715 SUM_NUMBER_OF_BYTES_ALLOC 272
1716 SUM_NUMBER_OF_BYTES_FREE 16
1717 LOW_COUNT_USED 0
1718 CURRENT_COUNT_USED 1
1719 HIGH_COUNT_USED 2
1720 LOW_NUMBER_OF_BYTES_USED 0
1721 CURRENT_NUMBER_OF_BYTES_USED 256
1722 HIGH_NUMBER_OF_BYTES_USED 272
1723 username user4
1724 EVENT_NAME memory/sql/user_var_entry::value
1725 COUNT_ALLOC 3
1726 COUNT_FREE 0
1727 SUM_NUMBER_OF_BYTES_ALLOC 7024
1728 SUM_NUMBER_OF_BYTES_FREE 0
1729 LOW_COUNT_USED 0
1730 CURRENT_COUNT_USED 3
1731 HIGH_COUNT_USED 3
1732 LOW_NUMBER_OF_BYTES_USED 0
1733 CURRENT_NUMBER_OF_BYTES_USED 7024
1734 HIGH_NUMBER_OF_BYTES_USED 7024
1735 execute dump_memory_account;
1736 execute dump_memory_user;
1737 USER user1
1738 EVENT_NAME memory/sql/User_level_lock
1739 COUNT_ALLOC 2
1740 COUNT_FREE 2
1741 SUM_NUMBER_OF_BYTES_ALLOC 272
1742 SUM_NUMBER_OF_BYTES_FREE 272
1743 LOW_COUNT_USED 0
1744 CURRENT_COUNT_USED 0
1745 HIGH_COUNT_USED 2
1746 LOW_NUMBER_OF_BYTES_USED 0
1747 CURRENT_NUMBER_OF_BYTES_USED 0
1748 HIGH_NUMBER_OF_BYTES_USED 272
1749 USER user1
1750 EVENT_NAME memory/sql/user_var_entry::value
1751 COUNT_ALLOC 3
1752 COUNT_FREE 3
1753 SUM_NUMBER_OF_BYTES_ALLOC 7024
1754 SUM_NUMBER_OF_BYTES_FREE 7024
1755 LOW_COUNT_USED 0
1756 CURRENT_COUNT_USED 0
1757 HIGH_COUNT_USED 3
1758 LOW_NUMBER_OF_BYTES_USED 0
1759 CURRENT_NUMBER_OF_BYTES_USED 0
1760 HIGH_NUMBER_OF_BYTES_USED 7024
1761 USER user2
1762 EVENT_NAME memory/sql/User_level_lock
1763 COUNT_ALLOC 2
1764 COUNT_FREE 1
1765 SUM_NUMBER_OF_BYTES_ALLOC 272
1766 SUM_NUMBER_OF_BYTES_FREE 16
1767 LOW_COUNT_USED 0
1768 CURRENT_COUNT_USED 1
1769 HIGH_COUNT_USED 2
1770 LOW_NUMBER_OF_BYTES_USED 0
1771 CURRENT_NUMBER_OF_BYTES_USED 256
1772 HIGH_NUMBER_OF_BYTES_USED 272
1773 USER user2
1774 EVENT_NAME memory/sql/user_var_entry::value
1775 COUNT_ALLOC 3
1776 COUNT_FREE 0
1777 SUM_NUMBER_OF_BYTES_ALLOC 7024
1778 SUM_NUMBER_OF_BYTES_FREE 0
1779 LOW_COUNT_USED 0
1780 CURRENT_COUNT_USED 3
1781 HIGH_COUNT_USED 3
1782 LOW_NUMBER_OF_BYTES_USED 0
1783 CURRENT_NUMBER_OF_BYTES_USED 7024
1784 HIGH_NUMBER_OF_BYTES_USED 7024
1785 USER user3
1786 EVENT_NAME memory/sql/User_level_lock
1787 COUNT_ALLOC 2
1788 COUNT_FREE 1
1789 SUM_NUMBER_OF_BYTES_ALLOC 272
1790 SUM_NUMBER_OF_BYTES_FREE 16
1791 LOW_COUNT_USED 0
1792 CURRENT_COUNT_USED 1
1793 HIGH_COUNT_USED 2
1794 LOW_NUMBER_OF_BYTES_USED 0
1795 CURRENT_NUMBER_OF_BYTES_USED 256
1796 HIGH_NUMBER_OF_BYTES_USED 272
1797 USER user3
1798 EVENT_NAME memory/sql/user_var_entry::value
1799 COUNT_ALLOC 3
1800 COUNT_FREE 0
1801 SUM_NUMBER_OF_BYTES_ALLOC 7024
1802 SUM_NUMBER_OF_BYTES_FREE 0
1803 LOW_COUNT_USED 0
1804 CURRENT_COUNT_USED 3
1805 HIGH_COUNT_USED 3
1806 LOW_NUMBER_OF_BYTES_USED 0
1807 CURRENT_NUMBER_OF_BYTES_USED 7024
1808 HIGH_NUMBER_OF_BYTES_USED 7024
1809 USER user4
1810 EVENT_NAME memory/sql/User_level_lock
1811 COUNT_ALLOC 4
1812 COUNT_FREE 3
1813 SUM_NUMBER_OF_BYTES_ALLOC 544
1814 SUM_NUMBER_OF_BYTES_FREE 288
1815 LOW_COUNT_USED 0
1816 CURRENT_COUNT_USED 1
1817 HIGH_COUNT_USED 4
1818 LOW_NUMBER_OF_BYTES_USED 0
1819 CURRENT_NUMBER_OF_BYTES_USED 256
1820 HIGH_NUMBER_OF_BYTES_USED 544
1821 USER user4
1822 EVENT_NAME memory/sql/user_var_entry::value
1823 COUNT_ALLOC 6
1824 COUNT_FREE 3
1825 SUM_NUMBER_OF_BYTES_ALLOC 14048
1826 SUM_NUMBER_OF_BYTES_FREE 7024
1827 LOW_COUNT_USED 0
1828 CURRENT_COUNT_USED 3
1829 HIGH_COUNT_USED 6
1830 LOW_NUMBER_OF_BYTES_USED 0
1831 CURRENT_NUMBER_OF_BYTES_USED 7024
1832 HIGH_NUMBER_OF_BYTES_USED 14048
1833 execute dump_memory_host;
1834 execute dump_memory_global;
1835 EVENT_NAME memory/sql/Query_cache
1836 COUNT_ALLOC 8
1837 COUNT_FREE 6
1838 SUM_NUMBER_OF_BYTES_ALLOC 131072
1839 SUM_NUMBER_OF_BYTES_FREE 98304
1840 LOW_COUNT_USED 0
1841 CURRENT_COUNT_USED 2
1842 HIGH_COUNT_USED 2
1843 LOW_NUMBER_OF_BYTES_USED 0
1844 CURRENT_NUMBER_OF_BYTES_USED 32768
1845 HIGH_NUMBER_OF_BYTES_USED 32768
1846 EVENT_NAME memory/sql/User_level_lock
1847 COUNT_ALLOC 10
1848 COUNT_FREE 7
1849 SUM_NUMBER_OF_BYTES_ALLOC 1360
1850 SUM_NUMBER_OF_BYTES_FREE 592
1851 LOW_COUNT_USED 0
1852 CURRENT_COUNT_USED 3
1853 HIGH_COUNT_USED 8
1854 LOW_NUMBER_OF_BYTES_USED 0
1855 CURRENT_NUMBER_OF_BYTES_USED 768
1856 HIGH_NUMBER_OF_BYTES_USED 1328
1857 EVENT_NAME memory/sql/user_var_entry::value
1858 COUNT_ALLOC 16
1859 COUNT_FREE 6
1860 SUM_NUMBER_OF_BYTES_ALLOC 35216
1861 SUM_NUMBER_OF_BYTES_FREE 14048
1862 LOW_COUNT_USED 1
1863 CURRENT_COUNT_USED 10
1864 HIGH_COUNT_USED 16
1865 LOW_NUMBER_OF_BYTES_USED 96
1866 CURRENT_NUMBER_OF_BYTES_USED 21168
1867 HIGH_NUMBER_OF_BYTES_USED 35216
1868 execute dump_accounts;
1869 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1870 execute dump_users;
1871 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1872 root 1 1
1873 user1 0 1
1874 user2 1 1
1875 user3 1 1
1876 user4 1 2
1877 execute dump_hosts;
1878 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1879 disconnect con2;
1880 connection default;
1881 "================== con2 disconnected =================="
1882 "================== Step 11 =================="
1883 call dump_thread();
1884 username user1
1885 status not found
1886 username user2
1887 status not found
1888 username user3
1889 EVENT_NAME memory/sql/User_level_lock
1890 COUNT_ALLOC 2
1891 COUNT_FREE 1
1892 SUM_NUMBER_OF_BYTES_ALLOC 272
1893 SUM_NUMBER_OF_BYTES_FREE 16
1894 LOW_COUNT_USED 0
1895 CURRENT_COUNT_USED 1
1896 HIGH_COUNT_USED 2
1897 LOW_NUMBER_OF_BYTES_USED 0
1898 CURRENT_NUMBER_OF_BYTES_USED 256
1899 HIGH_NUMBER_OF_BYTES_USED 272
1900 username user3
1901 EVENT_NAME memory/sql/user_var_entry::value
1902 COUNT_ALLOC 3
1903 COUNT_FREE 0
1904 SUM_NUMBER_OF_BYTES_ALLOC 7024
1905 SUM_NUMBER_OF_BYTES_FREE 0
1906 LOW_COUNT_USED 0
1907 CURRENT_COUNT_USED 3
1908 HIGH_COUNT_USED 3
1909 LOW_NUMBER_OF_BYTES_USED 0
1910 CURRENT_NUMBER_OF_BYTES_USED 7024
1911 HIGH_NUMBER_OF_BYTES_USED 7024
1912 username user4
1913 EVENT_NAME memory/sql/User_level_lock
1914 COUNT_ALLOC 2
1915 COUNT_FREE 1
1916 SUM_NUMBER_OF_BYTES_ALLOC 272
1917 SUM_NUMBER_OF_BYTES_FREE 16
1918 LOW_COUNT_USED 0
1919 CURRENT_COUNT_USED 1
1920 HIGH_COUNT_USED 2
1921 LOW_NUMBER_OF_BYTES_USED 0
1922 CURRENT_NUMBER_OF_BYTES_USED 256
1923 HIGH_NUMBER_OF_BYTES_USED 272
1924 username user4
1925 EVENT_NAME memory/sql/user_var_entry::value
1926 COUNT_ALLOC 3
1927 COUNT_FREE 0
1928 SUM_NUMBER_OF_BYTES_ALLOC 7024
1929 SUM_NUMBER_OF_BYTES_FREE 0
1930 LOW_COUNT_USED 0
1931 CURRENT_COUNT_USED 3
1932 HIGH_COUNT_USED 3
1933 LOW_NUMBER_OF_BYTES_USED 0
1934 CURRENT_NUMBER_OF_BYTES_USED 7024
1935 HIGH_NUMBER_OF_BYTES_USED 7024
1936 execute dump_memory_account;
1937 execute dump_memory_user;
1938 USER user1
1939 EVENT_NAME memory/sql/User_level_lock
1940 COUNT_ALLOC 2
1941 COUNT_FREE 2
1942 SUM_NUMBER_OF_BYTES_ALLOC 272
1943 SUM_NUMBER_OF_BYTES_FREE 272
1944 LOW_COUNT_USED 0
1945 CURRENT_COUNT_USED 0
1946 HIGH_COUNT_USED 2
1947 LOW_NUMBER_OF_BYTES_USED 0
1948 CURRENT_NUMBER_OF_BYTES_USED 0
1949 HIGH_NUMBER_OF_BYTES_USED 272
1950 USER user1
1951 EVENT_NAME memory/sql/user_var_entry::value
1952 COUNT_ALLOC 3
1953 COUNT_FREE 3
1954 SUM_NUMBER_OF_BYTES_ALLOC 7024
1955 SUM_NUMBER_OF_BYTES_FREE 7024
1956 LOW_COUNT_USED 0
1957 CURRENT_COUNT_USED 0
1958 HIGH_COUNT_USED 3
1959 LOW_NUMBER_OF_BYTES_USED 0
1960 CURRENT_NUMBER_OF_BYTES_USED 0
1961 HIGH_NUMBER_OF_BYTES_USED 7024
1962 USER user2
1963 EVENT_NAME memory/sql/User_level_lock
1964 COUNT_ALLOC 2
1965 COUNT_FREE 2
1966 SUM_NUMBER_OF_BYTES_ALLOC 272
1967 SUM_NUMBER_OF_BYTES_FREE 272
1968 LOW_COUNT_USED 0
1969 CURRENT_COUNT_USED 0
1970 HIGH_COUNT_USED 2
1971 LOW_NUMBER_OF_BYTES_USED 0
1972 CURRENT_NUMBER_OF_BYTES_USED 0
1973 HIGH_NUMBER_OF_BYTES_USED 272
1974 USER user2
1975 EVENT_NAME memory/sql/user_var_entry::value
1976 COUNT_ALLOC 3
1977 COUNT_FREE 3
1978 SUM_NUMBER_OF_BYTES_ALLOC 7024
1979 SUM_NUMBER_OF_BYTES_FREE 7024
1980 LOW_COUNT_USED 0
1981 CURRENT_COUNT_USED 0
1982 HIGH_COUNT_USED 3
1983 LOW_NUMBER_OF_BYTES_USED 0
1984 CURRENT_NUMBER_OF_BYTES_USED 0
1985 HIGH_NUMBER_OF_BYTES_USED 7024
1986 USER user3
1987 EVENT_NAME memory/sql/User_level_lock
1988 COUNT_ALLOC 2
1989 COUNT_FREE 1
1990 SUM_NUMBER_OF_BYTES_ALLOC 272
1991 SUM_NUMBER_OF_BYTES_FREE 16
1992 LOW_COUNT_USED 0
1993 CURRENT_COUNT_USED 1
1994 HIGH_COUNT_USED 2
1995 LOW_NUMBER_OF_BYTES_USED 0
1996 CURRENT_NUMBER_OF_BYTES_USED 256
1997 HIGH_NUMBER_OF_BYTES_USED 272
1998 USER user3
1999 EVENT_NAME memory/sql/user_var_entry::value
2000 COUNT_ALLOC 3
2001 COUNT_FREE 0
2002 SUM_NUMBER_OF_BYTES_ALLOC 7024
2003 SUM_NUMBER_OF_BYTES_FREE 0
2004 LOW_COUNT_USED 0
2005 CURRENT_COUNT_USED 3
2006 HIGH_COUNT_USED 3
2007 LOW_NUMBER_OF_BYTES_USED 0
2008 CURRENT_NUMBER_OF_BYTES_USED 7024
2009 HIGH_NUMBER_OF_BYTES_USED 7024
2010 USER user4
2011 EVENT_NAME memory/sql/User_level_lock
2012 COUNT_ALLOC 4
2013 COUNT_FREE 3
2014 SUM_NUMBER_OF_BYTES_ALLOC 544
2015 SUM_NUMBER_OF_BYTES_FREE 288
2016 LOW_COUNT_USED 0
2017 CURRENT_COUNT_USED 1
2018 HIGH_COUNT_USED 4
2019 LOW_NUMBER_OF_BYTES_USED 0
2020 CURRENT_NUMBER_OF_BYTES_USED 256
2021 HIGH_NUMBER_OF_BYTES_USED 544
2022 USER user4
2023 EVENT_NAME memory/sql/user_var_entry::value
2024 COUNT_ALLOC 6
2025 COUNT_FREE 3
2026 SUM_NUMBER_OF_BYTES_ALLOC 14048
2027 SUM_NUMBER_OF_BYTES_FREE 7024
2028 LOW_COUNT_USED 0
2029 CURRENT_COUNT_USED 3
2030 HIGH_COUNT_USED 6
2031 LOW_NUMBER_OF_BYTES_USED 0
2032 CURRENT_NUMBER_OF_BYTES_USED 7024
2033 HIGH_NUMBER_OF_BYTES_USED 14048
2034 execute dump_memory_host;
2035 execute dump_memory_global;
2036 EVENT_NAME memory/sql/Query_cache
2037 COUNT_ALLOC 8
2038 COUNT_FREE 6
2039 SUM_NUMBER_OF_BYTES_ALLOC 131072
2040 SUM_NUMBER_OF_BYTES_FREE 98304
2041 LOW_COUNT_USED 0
2042 CURRENT_COUNT_USED 2
2043 HIGH_COUNT_USED 2
2044 LOW_NUMBER_OF_BYTES_USED 0
2045 CURRENT_NUMBER_OF_BYTES_USED 32768
2046 HIGH_NUMBER_OF_BYTES_USED 32768
2047 EVENT_NAME memory/sql/User_level_lock
2048 COUNT_ALLOC 10
2049 COUNT_FREE 8
2050 SUM_NUMBER_OF_BYTES_ALLOC 1360
2051 SUM_NUMBER_OF_BYTES_FREE 848
2052 LOW_COUNT_USED 0
2053 CURRENT_COUNT_USED 2
2054 HIGH_COUNT_USED 8
2055 LOW_NUMBER_OF_BYTES_USED 0
2056 CURRENT_NUMBER_OF_BYTES_USED 512
2057 HIGH_NUMBER_OF_BYTES_USED 1328
2058 EVENT_NAME memory/sql/user_var_entry::value
2059 COUNT_ALLOC 16
2060 COUNT_FREE 9
2061 SUM_NUMBER_OF_BYTES_ALLOC 35216
2062 SUM_NUMBER_OF_BYTES_FREE 21072
2063 LOW_COUNT_USED 1
2064 CURRENT_COUNT_USED 7
2065 HIGH_COUNT_USED 16
2066 LOW_NUMBER_OF_BYTES_USED 96
2067 CURRENT_NUMBER_OF_BYTES_USED 14144
2068 HIGH_NUMBER_OF_BYTES_USED 35216
2069 execute dump_accounts;
2070 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2071 execute dump_users;
2072 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2073 root 1 1
2074 user1 0 1
2075 user2 0 1
2076 user3 1 1
2077 user4 1 2
2078 execute dump_hosts;
2079 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2080 disconnect con3;
2081 connection default;
2082 "================== con3 disconnected =================="
2083 "================== Step 12 =================="
2084 call dump_thread();
2085 username user1
2086 status not found
2087 username user2
2088 status not found
2089 username user3
2090 status not found
2091 username user4
2092 EVENT_NAME memory/sql/User_level_lock
2093 COUNT_ALLOC 2
2094 COUNT_FREE 1
2095 SUM_NUMBER_OF_BYTES_ALLOC 272
2096 SUM_NUMBER_OF_BYTES_FREE 16
2097 LOW_COUNT_USED 0
2098 CURRENT_COUNT_USED 1
2099 HIGH_COUNT_USED 2
2100 LOW_NUMBER_OF_BYTES_USED 0
2101 CURRENT_NUMBER_OF_BYTES_USED 256
2102 HIGH_NUMBER_OF_BYTES_USED 272
2103 username user4
2104 EVENT_NAME memory/sql/user_var_entry::value
2105 COUNT_ALLOC 3
2106 COUNT_FREE 0
2107 SUM_NUMBER_OF_BYTES_ALLOC 7024
2108 SUM_NUMBER_OF_BYTES_FREE 0
2109 LOW_COUNT_USED 0
2110 CURRENT_COUNT_USED 3
2111 HIGH_COUNT_USED 3
2112 LOW_NUMBER_OF_BYTES_USED 0
2113 CURRENT_NUMBER_OF_BYTES_USED 7024
2114 HIGH_NUMBER_OF_BYTES_USED 7024
2115 execute dump_memory_account;
2116 execute dump_memory_user;
2117 USER user1
2118 EVENT_NAME memory/sql/User_level_lock
2119 COUNT_ALLOC 2
2120 COUNT_FREE 2
2121 SUM_NUMBER_OF_BYTES_ALLOC 272
2122 SUM_NUMBER_OF_BYTES_FREE 272
2123 LOW_COUNT_USED 0
2124 CURRENT_COUNT_USED 0
2125 HIGH_COUNT_USED 2
2126 LOW_NUMBER_OF_BYTES_USED 0
2127 CURRENT_NUMBER_OF_BYTES_USED 0
2128 HIGH_NUMBER_OF_BYTES_USED 272
2129 USER user1
2130 EVENT_NAME memory/sql/user_var_entry::value
2131 COUNT_ALLOC 3
2132 COUNT_FREE 3
2133 SUM_NUMBER_OF_BYTES_ALLOC 7024
2134 SUM_NUMBER_OF_BYTES_FREE 7024
2135 LOW_COUNT_USED 0
2136 CURRENT_COUNT_USED 0
2137 HIGH_COUNT_USED 3
2138 LOW_NUMBER_OF_BYTES_USED 0
2139 CURRENT_NUMBER_OF_BYTES_USED 0
2140 HIGH_NUMBER_OF_BYTES_USED 7024
2141 USER user2
2142 EVENT_NAME memory/sql/User_level_lock
2143 COUNT_ALLOC 2
2144 COUNT_FREE 2
2145 SUM_NUMBER_OF_BYTES_ALLOC 272
2146 SUM_NUMBER_OF_BYTES_FREE 272
2147 LOW_COUNT_USED 0
2148 CURRENT_COUNT_USED 0
2149 HIGH_COUNT_USED 2
2150 LOW_NUMBER_OF_BYTES_USED 0
2151 CURRENT_NUMBER_OF_BYTES_USED 0
2152 HIGH_NUMBER_OF_BYTES_USED 272
2153 USER user2
2154 EVENT_NAME memory/sql/user_var_entry::value
2155 COUNT_ALLOC 3
2156 COUNT_FREE 3
2157 SUM_NUMBER_OF_BYTES_ALLOC 7024
2158 SUM_NUMBER_OF_BYTES_FREE 7024
2159 LOW_COUNT_USED 0
2160 CURRENT_COUNT_USED 0
2161 HIGH_COUNT_USED 3
2162 LOW_NUMBER_OF_BYTES_USED 0
2163 CURRENT_NUMBER_OF_BYTES_USED 0
2164 HIGH_NUMBER_OF_BYTES_USED 7024
2165 USER user3
2166 EVENT_NAME memory/sql/User_level_lock
2167 COUNT_ALLOC 2
2168 COUNT_FREE 2
2169 SUM_NUMBER_OF_BYTES_ALLOC 272
2170 SUM_NUMBER_OF_BYTES_FREE 272
2171 LOW_COUNT_USED 0
2172 CURRENT_COUNT_USED 0
2173 HIGH_COUNT_USED 2
2174 LOW_NUMBER_OF_BYTES_USED 0
2175 CURRENT_NUMBER_OF_BYTES_USED 0
2176 HIGH_NUMBER_OF_BYTES_USED 272
2177 USER user3
2178 EVENT_NAME memory/sql/user_var_entry::value
2179 COUNT_ALLOC 3
2180 COUNT_FREE 3
2181 SUM_NUMBER_OF_BYTES_ALLOC 7024
2182 SUM_NUMBER_OF_BYTES_FREE 7024
2183 LOW_COUNT_USED 0
2184 CURRENT_COUNT_USED 0
2185 HIGH_COUNT_USED 3
2186 LOW_NUMBER_OF_BYTES_USED 0
2187 CURRENT_NUMBER_OF_BYTES_USED 0
2188 HIGH_NUMBER_OF_BYTES_USED 7024
2189 USER user4
2190 EVENT_NAME memory/sql/User_level_lock
2191 COUNT_ALLOC 4
2192 COUNT_FREE 3
2193 SUM_NUMBER_OF_BYTES_ALLOC 544
2194 SUM_NUMBER_OF_BYTES_FREE 288
2195 LOW_COUNT_USED 0
2196 CURRENT_COUNT_USED 1
2197 HIGH_COUNT_USED 4
2198 LOW_NUMBER_OF_BYTES_USED 0
2199 CURRENT_NUMBER_OF_BYTES_USED 256
2200 HIGH_NUMBER_OF_BYTES_USED 544
2201 USER user4
2202 EVENT_NAME memory/sql/user_var_entry::value
2203 COUNT_ALLOC 6
2204 COUNT_FREE 3
2205 SUM_NUMBER_OF_BYTES_ALLOC 14048
2206 SUM_NUMBER_OF_BYTES_FREE 7024
2207 LOW_COUNT_USED 0
2208 CURRENT_COUNT_USED 3
2209 HIGH_COUNT_USED 6
2210 LOW_NUMBER_OF_BYTES_USED 0
2211 CURRENT_NUMBER_OF_BYTES_USED 7024
2212 HIGH_NUMBER_OF_BYTES_USED 14048
2213 execute dump_memory_host;
2214 execute dump_memory_global;
2215 EVENT_NAME memory/sql/Query_cache
2216 COUNT_ALLOC 8
2217 COUNT_FREE 6
2218 SUM_NUMBER_OF_BYTES_ALLOC 131072
2219 SUM_NUMBER_OF_BYTES_FREE 98304
2220 LOW_COUNT_USED 0
2221 CURRENT_COUNT_USED 2
2222 HIGH_COUNT_USED 2
2223 LOW_NUMBER_OF_BYTES_USED 0
2224 CURRENT_NUMBER_OF_BYTES_USED 32768
2225 HIGH_NUMBER_OF_BYTES_USED 32768
2226 EVENT_NAME memory/sql/User_level_lock
2227 COUNT_ALLOC 10
2228 COUNT_FREE 9
2229 SUM_NUMBER_OF_BYTES_ALLOC 1360
2230 SUM_NUMBER_OF_BYTES_FREE 1104
2231 LOW_COUNT_USED 0
2232 CURRENT_COUNT_USED 1
2233 HIGH_COUNT_USED 8
2234 LOW_NUMBER_OF_BYTES_USED 0
2235 CURRENT_NUMBER_OF_BYTES_USED 256
2236 HIGH_NUMBER_OF_BYTES_USED 1328
2237 EVENT_NAME memory/sql/user_var_entry::value
2238 COUNT_ALLOC 16
2239 COUNT_FREE 12
2240 SUM_NUMBER_OF_BYTES_ALLOC 35216
2241 SUM_NUMBER_OF_BYTES_FREE 28096
2242 LOW_COUNT_USED 1
2243 CURRENT_COUNT_USED 4
2244 HIGH_COUNT_USED 16
2245 LOW_NUMBER_OF_BYTES_USED 96
2246 CURRENT_NUMBER_OF_BYTES_USED 7120
2247 HIGH_NUMBER_OF_BYTES_USED 35216
2248 execute dump_accounts;
2249 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2250 execute dump_users;
2251 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2252 root 1 1
2253 user1 0 1
2254 user2 0 1
2255 user3 0 1
2256 user4 1 2
2257 execute dump_hosts;
2258 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2259 disconnect con4;
2260 connection default;
2261 "================== con4 disconnected =================="
2262 "================== Step 13 =================="
2263 call dump_thread();
2264 username user1
2265 status not found
2266 username user2
2267 status not found
2268 username user3
2269 status not found
2270 username user4
2271 status not found
2272 execute dump_memory_account;
2273 execute dump_memory_user;
2274 USER user1
2275 EVENT_NAME memory/sql/User_level_lock
2276 COUNT_ALLOC 2
2277 COUNT_FREE 2
2278 SUM_NUMBER_OF_BYTES_ALLOC 272
2279 SUM_NUMBER_OF_BYTES_FREE 272
2280 LOW_COUNT_USED 0
2281 CURRENT_COUNT_USED 0
2282 HIGH_COUNT_USED 2
2283 LOW_NUMBER_OF_BYTES_USED 0
2284 CURRENT_NUMBER_OF_BYTES_USED 0
2285 HIGH_NUMBER_OF_BYTES_USED 272
2286 USER user1
2287 EVENT_NAME memory/sql/user_var_entry::value
2288 COUNT_ALLOC 3
2289 COUNT_FREE 3
2290 SUM_NUMBER_OF_BYTES_ALLOC 7024
2291 SUM_NUMBER_OF_BYTES_FREE 7024
2292 LOW_COUNT_USED 0
2293 CURRENT_COUNT_USED 0
2294 HIGH_COUNT_USED 3
2295 LOW_NUMBER_OF_BYTES_USED 0
2296 CURRENT_NUMBER_OF_BYTES_USED 0
2297 HIGH_NUMBER_OF_BYTES_USED 7024
2298 USER user2
2299 EVENT_NAME memory/sql/User_level_lock
2300 COUNT_ALLOC 2
2301 COUNT_FREE 2
2302 SUM_NUMBER_OF_BYTES_ALLOC 272
2303 SUM_NUMBER_OF_BYTES_FREE 272
2304 LOW_COUNT_USED 0
2305 CURRENT_COUNT_USED 0
2306 HIGH_COUNT_USED 2
2307 LOW_NUMBER_OF_BYTES_USED 0
2308 CURRENT_NUMBER_OF_BYTES_USED 0
2309 HIGH_NUMBER_OF_BYTES_USED 272
2310 USER user2
2311 EVENT_NAME memory/sql/user_var_entry::value
2312 COUNT_ALLOC 3
2313 COUNT_FREE 3
2314 SUM_NUMBER_OF_BYTES_ALLOC 7024
2315 SUM_NUMBER_OF_BYTES_FREE 7024
2316 LOW_COUNT_USED 0
2317 CURRENT_COUNT_USED 0
2318 HIGH_COUNT_USED 3
2319 LOW_NUMBER_OF_BYTES_USED 0
2320 CURRENT_NUMBER_OF_BYTES_USED 0
2321 HIGH_NUMBER_OF_BYTES_USED 7024
2322 USER user3
2323 EVENT_NAME memory/sql/User_level_lock
2324 COUNT_ALLOC 2
2325 COUNT_FREE 2
2326 SUM_NUMBER_OF_BYTES_ALLOC 272
2327 SUM_NUMBER_OF_BYTES_FREE 272
2328 LOW_COUNT_USED 0
2329 CURRENT_COUNT_USED 0
2330 HIGH_COUNT_USED 2
2331 LOW_NUMBER_OF_BYTES_USED 0
2332 CURRENT_NUMBER_OF_BYTES_USED 0
2333 HIGH_NUMBER_OF_BYTES_USED 272
2334 USER user3
2335 EVENT_NAME memory/sql/user_var_entry::value
2336 COUNT_ALLOC 3
2337 COUNT_FREE 3
2338 SUM_NUMBER_OF_BYTES_ALLOC 7024
2339 SUM_NUMBER_OF_BYTES_FREE 7024
2340 LOW_COUNT_USED 0
2341 CURRENT_COUNT_USED 0
2342 HIGH_COUNT_USED 3
2343 LOW_NUMBER_OF_BYTES_USED 0
2344 CURRENT_NUMBER_OF_BYTES_USED 0
2345 HIGH_NUMBER_OF_BYTES_USED 7024
2346 USER user4
2347 EVENT_NAME memory/sql/User_level_lock
2348 COUNT_ALLOC 4
2349 COUNT_FREE 4
2350 SUM_NUMBER_OF_BYTES_ALLOC 544
2351 SUM_NUMBER_OF_BYTES_FREE 544
2352 LOW_COUNT_USED 0
2353 CURRENT_COUNT_USED 0
2354 HIGH_COUNT_USED 4
2355 LOW_NUMBER_OF_BYTES_USED 0
2356 CURRENT_NUMBER_OF_BYTES_USED 0
2357 HIGH_NUMBER_OF_BYTES_USED 544
2358 USER user4
2359 EVENT_NAME memory/sql/user_var_entry::value
2360 COUNT_ALLOC 6
2361 COUNT_FREE 6
2362 SUM_NUMBER_OF_BYTES_ALLOC 14048
2363 SUM_NUMBER_OF_BYTES_FREE 14048
2364 LOW_COUNT_USED 0
2365 CURRENT_COUNT_USED 0
2366 HIGH_COUNT_USED 6
2367 LOW_NUMBER_OF_BYTES_USED 0
2368 CURRENT_NUMBER_OF_BYTES_USED 0
2369 HIGH_NUMBER_OF_BYTES_USED 14048
2370 execute dump_memory_host;
2371 execute dump_memory_global;
2372 EVENT_NAME memory/sql/Query_cache
2373 COUNT_ALLOC 8
2374 COUNT_FREE 6
2375 SUM_NUMBER_OF_BYTES_ALLOC 131072
2376 SUM_NUMBER_OF_BYTES_FREE 98304
2377 LOW_COUNT_USED 0
2378 CURRENT_COUNT_USED 2
2379 HIGH_COUNT_USED 2
2380 LOW_NUMBER_OF_BYTES_USED 0
2381 CURRENT_NUMBER_OF_BYTES_USED 32768
2382 HIGH_NUMBER_OF_BYTES_USED 32768
2383 EVENT_NAME memory/sql/User_level_lock
2384 COUNT_ALLOC 10
2385 COUNT_FREE 10
2386 SUM_NUMBER_OF_BYTES_ALLOC 1360
2387 SUM_NUMBER_OF_BYTES_FREE 1360
2388 LOW_COUNT_USED 0
2389 CURRENT_COUNT_USED 0
2390 HIGH_COUNT_USED 8
2391 LOW_NUMBER_OF_BYTES_USED 0
2392 CURRENT_NUMBER_OF_BYTES_USED 0
2393 HIGH_NUMBER_OF_BYTES_USED 1328
2394 EVENT_NAME memory/sql/user_var_entry::value
2395 COUNT_ALLOC 16
2396 COUNT_FREE 15
2397 SUM_NUMBER_OF_BYTES_ALLOC 35216
2398 SUM_NUMBER_OF_BYTES_FREE 35120
2399 LOW_COUNT_USED 1
2400 CURRENT_COUNT_USED 1
2401 HIGH_COUNT_USED 16
2402 LOW_NUMBER_OF_BYTES_USED 96
2403 CURRENT_NUMBER_OF_BYTES_USED 96
2404 HIGH_NUMBER_OF_BYTES_USED 35216
2405 execute dump_accounts;
2406 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2407 execute dump_users;
2408 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2409 root 1 1
2410 user1 0 1
2411 user2 0 1
2412 user3 0 1
2413 user4 0 2
2414 execute dump_hosts;
2415 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2416 connection default;
2417 truncate performance_schema.memory_summary_by_thread_by_event_name;
2418 "================== MEMORY_BY_THREAD truncated =================="
2419 "================== Step 14 =================="
2420 call dump_thread();
2421 username user1
2422 status not found
2423 username user2
2424 status not found
2425 username user3
2426 status not found
2427 username user4
2428 status not found
2429 execute dump_memory_account;
2430 execute dump_memory_user;
2431 USER user1
2432 EVENT_NAME memory/sql/User_level_lock
2433 COUNT_ALLOC 2
2434 COUNT_FREE 2
2435 SUM_NUMBER_OF_BYTES_ALLOC 272
2436 SUM_NUMBER_OF_BYTES_FREE 272
2437 LOW_COUNT_USED 0
2438 CURRENT_COUNT_USED 0
2439 HIGH_COUNT_USED 2
2440 LOW_NUMBER_OF_BYTES_USED 0
2441 CURRENT_NUMBER_OF_BYTES_USED 0
2442 HIGH_NUMBER_OF_BYTES_USED 272
2443 USER user1
2444 EVENT_NAME memory/sql/user_var_entry::value
2445 COUNT_ALLOC 3
2446 COUNT_FREE 3
2447 SUM_NUMBER_OF_BYTES_ALLOC 7024
2448 SUM_NUMBER_OF_BYTES_FREE 7024
2449 LOW_COUNT_USED 0
2450 CURRENT_COUNT_USED 0
2451 HIGH_COUNT_USED 3
2452 LOW_NUMBER_OF_BYTES_USED 0
2453 CURRENT_NUMBER_OF_BYTES_USED 0
2454 HIGH_NUMBER_OF_BYTES_USED 7024
2455 USER user2
2456 EVENT_NAME memory/sql/User_level_lock
2457 COUNT_ALLOC 2
2458 COUNT_FREE 2
2459 SUM_NUMBER_OF_BYTES_ALLOC 272
2460 SUM_NUMBER_OF_BYTES_FREE 272
2461 LOW_COUNT_USED 0
2462 CURRENT_COUNT_USED 0
2463 HIGH_COUNT_USED 2
2464 LOW_NUMBER_OF_BYTES_USED 0
2465 CURRENT_NUMBER_OF_BYTES_USED 0
2466 HIGH_NUMBER_OF_BYTES_USED 272
2467 USER user2
2468 EVENT_NAME memory/sql/user_var_entry::value
2469 COUNT_ALLOC 3
2470 COUNT_FREE 3
2471 SUM_NUMBER_OF_BYTES_ALLOC 7024
2472 SUM_NUMBER_OF_BYTES_FREE 7024
2473 LOW_COUNT_USED 0
2474 CURRENT_COUNT_USED 0
2475 HIGH_COUNT_USED 3
2476 LOW_NUMBER_OF_BYTES_USED 0
2477 CURRENT_NUMBER_OF_BYTES_USED 0
2478 HIGH_NUMBER_OF_BYTES_USED 7024
2479 USER user3
2480 EVENT_NAME memory/sql/User_level_lock
2481 COUNT_ALLOC 2
2482 COUNT_FREE 2
2483 SUM_NUMBER_OF_BYTES_ALLOC 272
2484 SUM_NUMBER_OF_BYTES_FREE 272
2485 LOW_COUNT_USED 0
2486 CURRENT_COUNT_USED 0
2487 HIGH_COUNT_USED 2
2488 LOW_NUMBER_OF_BYTES_USED 0
2489 CURRENT_NUMBER_OF_BYTES_USED 0
2490 HIGH_NUMBER_OF_BYTES_USED 272
2491 USER user3
2492 EVENT_NAME memory/sql/user_var_entry::value
2493 COUNT_ALLOC 3
2494 COUNT_FREE 3
2495 SUM_NUMBER_OF_BYTES_ALLOC 7024
2496 SUM_NUMBER_OF_BYTES_FREE 7024
2497 LOW_COUNT_USED 0
2498 CURRENT_COUNT_USED 0
2499 HIGH_COUNT_USED 3
2500 LOW_NUMBER_OF_BYTES_USED 0
2501 CURRENT_NUMBER_OF_BYTES_USED 0
2502 HIGH_NUMBER_OF_BYTES_USED 7024
2503 USER user4
2504 EVENT_NAME memory/sql/User_level_lock
2505 COUNT_ALLOC 4
2506 COUNT_FREE 4
2507 SUM_NUMBER_OF_BYTES_ALLOC 544
2508 SUM_NUMBER_OF_BYTES_FREE 544
2509 LOW_COUNT_USED 0
2510 CURRENT_COUNT_USED 0
2511 HIGH_COUNT_USED 4
2512 LOW_NUMBER_OF_BYTES_USED 0
2513 CURRENT_NUMBER_OF_BYTES_USED 0
2514 HIGH_NUMBER_OF_BYTES_USED 544
2515 USER user4
2516 EVENT_NAME memory/sql/user_var_entry::value
2517 COUNT_ALLOC 6
2518 COUNT_FREE 6
2519 SUM_NUMBER_OF_BYTES_ALLOC 14048
2520 SUM_NUMBER_OF_BYTES_FREE 14048
2521 LOW_COUNT_USED 0
2522 CURRENT_COUNT_USED 0
2523 HIGH_COUNT_USED 6
2524 LOW_NUMBER_OF_BYTES_USED 0
2525 CURRENT_NUMBER_OF_BYTES_USED 0
2526 HIGH_NUMBER_OF_BYTES_USED 14048
2527 execute dump_memory_host;
2528 execute dump_memory_global;
2529 EVENT_NAME memory/sql/Query_cache
2530 COUNT_ALLOC 8
2531 COUNT_FREE 6
2532 SUM_NUMBER_OF_BYTES_ALLOC 131072
2533 SUM_NUMBER_OF_BYTES_FREE 98304
2534 LOW_COUNT_USED 0
2535 CURRENT_COUNT_USED 2
2536 HIGH_COUNT_USED 2
2537 LOW_NUMBER_OF_BYTES_USED 0
2538 CURRENT_NUMBER_OF_BYTES_USED 32768
2539 HIGH_NUMBER_OF_BYTES_USED 32768
2540 EVENT_NAME memory/sql/User_level_lock
2541 COUNT_ALLOC 10
2542 COUNT_FREE 10
2543 SUM_NUMBER_OF_BYTES_ALLOC 1360
2544 SUM_NUMBER_OF_BYTES_FREE 1360
2545 LOW_COUNT_USED 0
2546 CURRENT_COUNT_USED 0
2547 HIGH_COUNT_USED 8
2548 LOW_NUMBER_OF_BYTES_USED 0
2549 CURRENT_NUMBER_OF_BYTES_USED 0
2550 HIGH_NUMBER_OF_BYTES_USED 1328
2551 EVENT_NAME memory/sql/user_var_entry::value
2552 COUNT_ALLOC 16
2553 COUNT_FREE 15
2554 SUM_NUMBER_OF_BYTES_ALLOC 35216
2555 SUM_NUMBER_OF_BYTES_FREE 35120
2556 LOW_COUNT_USED 1
2557 CURRENT_COUNT_USED 1
2558 HIGH_COUNT_USED 16
2559 LOW_NUMBER_OF_BYTES_USED 96
2560 CURRENT_NUMBER_OF_BYTES_USED 96
2561 HIGH_NUMBER_OF_BYTES_USED 35216
2562 execute dump_accounts;
2563 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2564 execute dump_users;
2565 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2566 root 1 1
2567 user1 0 1
2568 user2 0 1
2569 user3 0 1
2570 user4 0 2
2571 execute dump_hosts;
2572 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2573 truncate performance_schema.memory_summary_by_account_by_event_name;
2574 "================== MEMORY_BY_ACCOUNT truncated =================="
2575 "================== Step 15 =================="
2576 call dump_thread();
2577 username user1
2578 status not found
2579 username user2
2580 status not found
2581 username user3
2582 status not found
2583 username user4
2584 status not found
2585 execute dump_memory_account;
2586 execute dump_memory_user;
2587 USER user1
2588 EVENT_NAME memory/sql/User_level_lock
2589 COUNT_ALLOC 2
2590 COUNT_FREE 2
2591 SUM_NUMBER_OF_BYTES_ALLOC 272
2592 SUM_NUMBER_OF_BYTES_FREE 272
2593 LOW_COUNT_USED 0
2594 CURRENT_COUNT_USED 0
2595 HIGH_COUNT_USED 2
2596 LOW_NUMBER_OF_BYTES_USED 0
2597 CURRENT_NUMBER_OF_BYTES_USED 0
2598 HIGH_NUMBER_OF_BYTES_USED 272
2599 USER user1
2600 EVENT_NAME memory/sql/user_var_entry::value
2601 COUNT_ALLOC 3
2602 COUNT_FREE 3
2603 SUM_NUMBER_OF_BYTES_ALLOC 7024
2604 SUM_NUMBER_OF_BYTES_FREE 7024
2605 LOW_COUNT_USED 0
2606 CURRENT_COUNT_USED 0
2607 HIGH_COUNT_USED 3
2608 LOW_NUMBER_OF_BYTES_USED 0
2609 CURRENT_NUMBER_OF_BYTES_USED 0
2610 HIGH_NUMBER_OF_BYTES_USED 7024
2611 USER user2
2612 EVENT_NAME memory/sql/User_level_lock
2613 COUNT_ALLOC 2
2614 COUNT_FREE 2
2615 SUM_NUMBER_OF_BYTES_ALLOC 272
2616 SUM_NUMBER_OF_BYTES_FREE 272
2617 LOW_COUNT_USED 0
2618 CURRENT_COUNT_USED 0
2619 HIGH_COUNT_USED 2
2620 LOW_NUMBER_OF_BYTES_USED 0
2621 CURRENT_NUMBER_OF_BYTES_USED 0
2622 HIGH_NUMBER_OF_BYTES_USED 272
2623 USER user2
2624 EVENT_NAME memory/sql/user_var_entry::value
2625 COUNT_ALLOC 3
2626 COUNT_FREE 3
2627 SUM_NUMBER_OF_BYTES_ALLOC 7024
2628 SUM_NUMBER_OF_BYTES_FREE 7024
2629 LOW_COUNT_USED 0
2630 CURRENT_COUNT_USED 0
2631 HIGH_COUNT_USED 3
2632 LOW_NUMBER_OF_BYTES_USED 0
2633 CURRENT_NUMBER_OF_BYTES_USED 0
2634 HIGH_NUMBER_OF_BYTES_USED 7024
2635 USER user3
2636 EVENT_NAME memory/sql/User_level_lock
2637 COUNT_ALLOC 2
2638 COUNT_FREE 2
2639 SUM_NUMBER_OF_BYTES_ALLOC 272
2640 SUM_NUMBER_OF_BYTES_FREE 272
2641 LOW_COUNT_USED 0
2642 CURRENT_COUNT_USED 0
2643 HIGH_COUNT_USED 2
2644 LOW_NUMBER_OF_BYTES_USED 0
2645 CURRENT_NUMBER_OF_BYTES_USED 0
2646 HIGH_NUMBER_OF_BYTES_USED 272
2647 USER user3
2648 EVENT_NAME memory/sql/user_var_entry::value
2649 COUNT_ALLOC 3
2650 COUNT_FREE 3
2651 SUM_NUMBER_OF_BYTES_ALLOC 7024
2652 SUM_NUMBER_OF_BYTES_FREE 7024
2653 LOW_COUNT_USED 0
2654 CURRENT_COUNT_USED 0
2655 HIGH_COUNT_USED 3
2656 LOW_NUMBER_OF_BYTES_USED 0
2657 CURRENT_NUMBER_OF_BYTES_USED 0
2658 HIGH_NUMBER_OF_BYTES_USED 7024
2659 USER user4
2660 EVENT_NAME memory/sql/User_level_lock
2661 COUNT_ALLOC 4
2662 COUNT_FREE 4
2663 SUM_NUMBER_OF_BYTES_ALLOC 544
2664 SUM_NUMBER_OF_BYTES_FREE 544
2665 LOW_COUNT_USED 0
2666 CURRENT_COUNT_USED 0
2667 HIGH_COUNT_USED 4
2668 LOW_NUMBER_OF_BYTES_USED 0
2669 CURRENT_NUMBER_OF_BYTES_USED 0
2670 HIGH_NUMBER_OF_BYTES_USED 544
2671 USER user4
2672 EVENT_NAME memory/sql/user_var_entry::value
2673 COUNT_ALLOC 6
2674 COUNT_FREE 6
2675 SUM_NUMBER_OF_BYTES_ALLOC 14048
2676 SUM_NUMBER_OF_BYTES_FREE 14048
2677 LOW_COUNT_USED 0
2678 CURRENT_COUNT_USED 0
2679 HIGH_COUNT_USED 6
2680 LOW_NUMBER_OF_BYTES_USED 0
2681 CURRENT_NUMBER_OF_BYTES_USED 0
2682 HIGH_NUMBER_OF_BYTES_USED 14048
2683 execute dump_memory_host;
2684 execute dump_memory_global;
2685 EVENT_NAME memory/sql/Query_cache
2686 COUNT_ALLOC 8
2687 COUNT_FREE 6
2688 SUM_NUMBER_OF_BYTES_ALLOC 131072
2689 SUM_NUMBER_OF_BYTES_FREE 98304
2690 LOW_COUNT_USED 0
2691 CURRENT_COUNT_USED 2
2692 HIGH_COUNT_USED 2
2693 LOW_NUMBER_OF_BYTES_USED 0
2694 CURRENT_NUMBER_OF_BYTES_USED 32768
2695 HIGH_NUMBER_OF_BYTES_USED 32768
2696 EVENT_NAME memory/sql/User_level_lock
2697 COUNT_ALLOC 10
2698 COUNT_FREE 10
2699 SUM_NUMBER_OF_BYTES_ALLOC 1360
2700 SUM_NUMBER_OF_BYTES_FREE 1360
2701 LOW_COUNT_USED 0
2702 CURRENT_COUNT_USED 0
2703 HIGH_COUNT_USED 8
2704 LOW_NUMBER_OF_BYTES_USED 0
2705 CURRENT_NUMBER_OF_BYTES_USED 0
2706 HIGH_NUMBER_OF_BYTES_USED 1328
2707 EVENT_NAME memory/sql/user_var_entry::value
2708 COUNT_ALLOC 16
2709 COUNT_FREE 15
2710 SUM_NUMBER_OF_BYTES_ALLOC 35216
2711 SUM_NUMBER_OF_BYTES_FREE 35120
2712 LOW_COUNT_USED 1
2713 CURRENT_COUNT_USED 1
2714 HIGH_COUNT_USED 16
2715 LOW_NUMBER_OF_BYTES_USED 96
2716 CURRENT_NUMBER_OF_BYTES_USED 96
2717 HIGH_NUMBER_OF_BYTES_USED 35216
2718 execute dump_accounts;
2719 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2720 execute dump_users;
2721 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2722 root 1 1
2723 user1 0 1
2724 user2 0 1
2725 user3 0 1
2726 user4 0 2
2727 execute dump_hosts;
2728 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2729 truncate performance_schema.memory_summary_by_user_by_event_name;
2730 "================== MEMORY_BY_USER truncated =================="
2731 "================== Step 16 =================="
2732 call dump_thread();
2733 username user1
2734 status not found
2735 username user2
2736 status not found
2737 username user3
2738 status not found
2739 username user4
2740 status not found
2741 execute dump_memory_account;
2742 execute dump_memory_user;
2743 USER user1
2744 EVENT_NAME memory/sql/User_level_lock
2745 COUNT_ALLOC 0
2746 COUNT_FREE 0
2747 SUM_NUMBER_OF_BYTES_ALLOC 0
2748 SUM_NUMBER_OF_BYTES_FREE 0
2749 LOW_COUNT_USED 0
2750 CURRENT_COUNT_USED 0
2751 HIGH_COUNT_USED 0
2752 LOW_NUMBER_OF_BYTES_USED 0
2753 CURRENT_NUMBER_OF_BYTES_USED 0
2754 HIGH_NUMBER_OF_BYTES_USED 0
2755 USER user1
2756 EVENT_NAME memory/sql/user_var_entry::value
2757 COUNT_ALLOC 0
2758 COUNT_FREE 0
2759 SUM_NUMBER_OF_BYTES_ALLOC 0
2760 SUM_NUMBER_OF_BYTES_FREE 0
2761 LOW_COUNT_USED 0
2762 CURRENT_COUNT_USED 0
2763 HIGH_COUNT_USED 0
2764 LOW_NUMBER_OF_BYTES_USED 0
2765 CURRENT_NUMBER_OF_BYTES_USED 0
2766 HIGH_NUMBER_OF_BYTES_USED 0
2767 USER user2
2768 EVENT_NAME memory/sql/User_level_lock
2769 COUNT_ALLOC 0
2770 COUNT_FREE 0
2771 SUM_NUMBER_OF_BYTES_ALLOC 0
2772 SUM_NUMBER_OF_BYTES_FREE 0
2773 LOW_COUNT_USED 0
2774 CURRENT_COUNT_USED 0
2775 HIGH_COUNT_USED 0
2776 LOW_NUMBER_OF_BYTES_USED 0
2777 CURRENT_NUMBER_OF_BYTES_USED 0
2778 HIGH_NUMBER_OF_BYTES_USED 0
2779 USER user2
2780 EVENT_NAME memory/sql/user_var_entry::value
2781 COUNT_ALLOC 0
2782 COUNT_FREE 0
2783 SUM_NUMBER_OF_BYTES_ALLOC 0
2784 SUM_NUMBER_OF_BYTES_FREE 0
2785 LOW_COUNT_USED 0
2786 CURRENT_COUNT_USED 0
2787 HIGH_COUNT_USED 0
2788 LOW_NUMBER_OF_BYTES_USED 0
2789 CURRENT_NUMBER_OF_BYTES_USED 0
2790 HIGH_NUMBER_OF_BYTES_USED 0
2791 USER user3
2792 EVENT_NAME memory/sql/User_level_lock
2793 COUNT_ALLOC 0
2794 COUNT_FREE 0
2795 SUM_NUMBER_OF_BYTES_ALLOC 0
2796 SUM_NUMBER_OF_BYTES_FREE 0
2797 LOW_COUNT_USED 0
2798 CURRENT_COUNT_USED 0
2799 HIGH_COUNT_USED 0
2800 LOW_NUMBER_OF_BYTES_USED 0
2801 CURRENT_NUMBER_OF_BYTES_USED 0
2802 HIGH_NUMBER_OF_BYTES_USED 0
2803 USER user3
2804 EVENT_NAME memory/sql/user_var_entry::value
2805 COUNT_ALLOC 0
2806 COUNT_FREE 0
2807 SUM_NUMBER_OF_BYTES_ALLOC 0
2808 SUM_NUMBER_OF_BYTES_FREE 0
2809 LOW_COUNT_USED 0
2810 CURRENT_COUNT_USED 0
2811 HIGH_COUNT_USED 0
2812 LOW_NUMBER_OF_BYTES_USED 0
2813 CURRENT_NUMBER_OF_BYTES_USED 0
2814 HIGH_NUMBER_OF_BYTES_USED 0
2815 USER user4
2816 EVENT_NAME memory/sql/User_level_lock
2817 COUNT_ALLOC 0
2818 COUNT_FREE 0
2819 SUM_NUMBER_OF_BYTES_ALLOC 0
2820 SUM_NUMBER_OF_BYTES_FREE 0
2821 LOW_COUNT_USED 0
2822 CURRENT_COUNT_USED 0
2823 HIGH_COUNT_USED 0
2824 LOW_NUMBER_OF_BYTES_USED 0
2825 CURRENT_NUMBER_OF_BYTES_USED 0
2826 HIGH_NUMBER_OF_BYTES_USED 0
2827 USER user4
2828 EVENT_NAME memory/sql/user_var_entry::value
2829 COUNT_ALLOC 0
2830 COUNT_FREE 0
2831 SUM_NUMBER_OF_BYTES_ALLOC 0
2832 SUM_NUMBER_OF_BYTES_FREE 0
2833 LOW_COUNT_USED 0
2834 CURRENT_COUNT_USED 0
2835 HIGH_COUNT_USED 0
2836 LOW_NUMBER_OF_BYTES_USED 0
2837 CURRENT_NUMBER_OF_BYTES_USED 0
2838 HIGH_NUMBER_OF_BYTES_USED 0
2839 execute dump_memory_host;
2840 execute dump_memory_global;
2841 EVENT_NAME memory/sql/Query_cache
2842 COUNT_ALLOC 8
2843 COUNT_FREE 6
2844 SUM_NUMBER_OF_BYTES_ALLOC 131072
2845 SUM_NUMBER_OF_BYTES_FREE 98304
2846 LOW_COUNT_USED 0
2847 CURRENT_COUNT_USED 2
2848 HIGH_COUNT_USED 2
2849 LOW_NUMBER_OF_BYTES_USED 0
2850 CURRENT_NUMBER_OF_BYTES_USED 32768
2851 HIGH_NUMBER_OF_BYTES_USED 32768
2852 EVENT_NAME memory/sql/User_level_lock
2853 COUNT_ALLOC 10
2854 COUNT_FREE 10
2855 SUM_NUMBER_OF_BYTES_ALLOC 1360
2856 SUM_NUMBER_OF_BYTES_FREE 1360
2857 LOW_COUNT_USED 0
2858 CURRENT_COUNT_USED 0
2859 HIGH_COUNT_USED 8
2860 LOW_NUMBER_OF_BYTES_USED 0
2861 CURRENT_NUMBER_OF_BYTES_USED 0
2862 HIGH_NUMBER_OF_BYTES_USED 1328
2863 EVENT_NAME memory/sql/user_var_entry::value
2864 COUNT_ALLOC 16
2865 COUNT_FREE 15
2866 SUM_NUMBER_OF_BYTES_ALLOC 35216
2867 SUM_NUMBER_OF_BYTES_FREE 35120
2868 LOW_COUNT_USED 1
2869 CURRENT_COUNT_USED 1
2870 HIGH_COUNT_USED 16
2871 LOW_NUMBER_OF_BYTES_USED 96
2872 CURRENT_NUMBER_OF_BYTES_USED 96
2873 HIGH_NUMBER_OF_BYTES_USED 35216
2874 execute dump_accounts;
2875 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2876 execute dump_users;
2877 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2878 root 1 1
2879 user1 0 1
2880 user2 0 1
2881 user3 0 1
2882 user4 0 2
2883 execute dump_hosts;
2884 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2885 truncate performance_schema.memory_summary_by_host_by_event_name;
2886 "================== MEMORY_BY_HOST truncated =================="
2887 "================== Step 17 =================="
2888 call dump_thread();
2889 username user1
2890 status not found
2891 username user2
2892 status not found
2893 username user3
2894 status not found
2895 username user4
2896 status not found
2897 execute dump_memory_account;
2898 execute dump_memory_user;
2899 USER user1
2900 EVENT_NAME memory/sql/User_level_lock
2901 COUNT_ALLOC 0
2902 COUNT_FREE 0
2903 SUM_NUMBER_OF_BYTES_ALLOC 0
2904 SUM_NUMBER_OF_BYTES_FREE 0
2905 LOW_COUNT_USED 0
2906 CURRENT_COUNT_USED 0
2907 HIGH_COUNT_USED 0
2908 LOW_NUMBER_OF_BYTES_USED 0
2909 CURRENT_NUMBER_OF_BYTES_USED 0
2910 HIGH_NUMBER_OF_BYTES_USED 0
2911 USER user1
2912 EVENT_NAME memory/sql/user_var_entry::value
2913 COUNT_ALLOC 0
2914 COUNT_FREE 0
2915 SUM_NUMBER_OF_BYTES_ALLOC 0
2916 SUM_NUMBER_OF_BYTES_FREE 0
2917 LOW_COUNT_USED 0
2918 CURRENT_COUNT_USED 0
2919 HIGH_COUNT_USED 0
2920 LOW_NUMBER_OF_BYTES_USED 0
2921 CURRENT_NUMBER_OF_BYTES_USED 0
2922 HIGH_NUMBER_OF_BYTES_USED 0
2923 USER user2
2924 EVENT_NAME memory/sql/User_level_lock
2925 COUNT_ALLOC 0
2926 COUNT_FREE 0
2927 SUM_NUMBER_OF_BYTES_ALLOC 0
2928 SUM_NUMBER_OF_BYTES_FREE 0
2929 LOW_COUNT_USED 0
2930 CURRENT_COUNT_USED 0
2931 HIGH_COUNT_USED 0
2932 LOW_NUMBER_OF_BYTES_USED 0
2933 CURRENT_NUMBER_OF_BYTES_USED 0
2934 HIGH_NUMBER_OF_BYTES_USED 0
2935 USER user2
2936 EVENT_NAME memory/sql/user_var_entry::value
2937 COUNT_ALLOC 0
2938 COUNT_FREE 0
2939 SUM_NUMBER_OF_BYTES_ALLOC 0
2940 SUM_NUMBER_OF_BYTES_FREE 0
2941 LOW_COUNT_USED 0
2942 CURRENT_COUNT_USED 0
2943 HIGH_COUNT_USED 0
2944 LOW_NUMBER_OF_BYTES_USED 0
2945 CURRENT_NUMBER_OF_BYTES_USED 0
2946 HIGH_NUMBER_OF_BYTES_USED 0
2947 USER user3
2948 EVENT_NAME memory/sql/User_level_lock
2949 COUNT_ALLOC 0
2950 COUNT_FREE 0
2951 SUM_NUMBER_OF_BYTES_ALLOC 0
2952 SUM_NUMBER_OF_BYTES_FREE 0
2953 LOW_COUNT_USED 0
2954 CURRENT_COUNT_USED 0
2955 HIGH_COUNT_USED 0
2956 LOW_NUMBER_OF_BYTES_USED 0
2957 CURRENT_NUMBER_OF_BYTES_USED 0
2958 HIGH_NUMBER_OF_BYTES_USED 0
2959 USER user3
2960 EVENT_NAME memory/sql/user_var_entry::value
2961 COUNT_ALLOC 0
2962 COUNT_FREE 0
2963 SUM_NUMBER_OF_BYTES_ALLOC 0
2964 SUM_NUMBER_OF_BYTES_FREE 0
2965 LOW_COUNT_USED 0
2966 CURRENT_COUNT_USED 0
2967 HIGH_COUNT_USED 0
2968 LOW_NUMBER_OF_BYTES_USED 0
2969 CURRENT_NUMBER_OF_BYTES_USED 0
2970 HIGH_NUMBER_OF_BYTES_USED 0
2971 USER user4
2972 EVENT_NAME memory/sql/User_level_lock
2973 COUNT_ALLOC 0
2974 COUNT_FREE 0
2975 SUM_NUMBER_OF_BYTES_ALLOC 0
2976 SUM_NUMBER_OF_BYTES_FREE 0
2977 LOW_COUNT_USED 0
2978 CURRENT_COUNT_USED 0
2979 HIGH_COUNT_USED 0
2980 LOW_NUMBER_OF_BYTES_USED 0
2981 CURRENT_NUMBER_OF_BYTES_USED 0
2982 HIGH_NUMBER_OF_BYTES_USED 0
2983 USER user4
2984 EVENT_NAME memory/sql/user_var_entry::value
2985 COUNT_ALLOC 0
2986 COUNT_FREE 0
2987 SUM_NUMBER_OF_BYTES_ALLOC 0
2988 SUM_NUMBER_OF_BYTES_FREE 0
2989 LOW_COUNT_USED 0
2990 CURRENT_COUNT_USED 0
2991 HIGH_COUNT_USED 0
2992 LOW_NUMBER_OF_BYTES_USED 0
2993 CURRENT_NUMBER_OF_BYTES_USED 0
2994 HIGH_NUMBER_OF_BYTES_USED 0
2995 execute dump_memory_host;
2996 execute dump_memory_global;
2997 EVENT_NAME memory/sql/Query_cache
2998 COUNT_ALLOC 8
2999 COUNT_FREE 6
3000 SUM_NUMBER_OF_BYTES_ALLOC 131072
3001 SUM_NUMBER_OF_BYTES_FREE 98304
3002 LOW_COUNT_USED 0
3003 CURRENT_COUNT_USED 2
3004 HIGH_COUNT_USED 2
3005 LOW_NUMBER_OF_BYTES_USED 0
3006 CURRENT_NUMBER_OF_BYTES_USED 32768
3007 HIGH_NUMBER_OF_BYTES_USED 32768
3008 EVENT_NAME memory/sql/User_level_lock
3009 COUNT_ALLOC 10
3010 COUNT_FREE 10
3011 SUM_NUMBER_OF_BYTES_ALLOC 1360
3012 SUM_NUMBER_OF_BYTES_FREE 1360
3013 LOW_COUNT_USED 0
3014 CURRENT_COUNT_USED 0
3015 HIGH_COUNT_USED 8
3016 LOW_NUMBER_OF_BYTES_USED 0
3017 CURRENT_NUMBER_OF_BYTES_USED 0
3018 HIGH_NUMBER_OF_BYTES_USED 1328
3019 EVENT_NAME memory/sql/user_var_entry::value
3020 COUNT_ALLOC 16
3021 COUNT_FREE 15
3022 SUM_NUMBER_OF_BYTES_ALLOC 35216
3023 SUM_NUMBER_OF_BYTES_FREE 35120
3024 LOW_COUNT_USED 1
3025 CURRENT_COUNT_USED 1
3026 HIGH_COUNT_USED 16
3027 LOW_NUMBER_OF_BYTES_USED 96
3028 CURRENT_NUMBER_OF_BYTES_USED 96
3029 HIGH_NUMBER_OF_BYTES_USED 35216
3030 execute dump_accounts;
3031 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3032 execute dump_users;
3033 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3034 root 1 1
3035 user1 0 1
3036 user2 0 1
3037 user3 0 1
3038 user4 0 2
3039 execute dump_hosts;
3040 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3041 truncate performance_schema.memory_summary_global_by_event_name;
3042 "================== MEMORY_GLOBAL truncated =================="
3043 "================== Step 18 =================="
3044 call dump_thread();
3045 username user1
3046 status not found
3047 username user2
3048 status not found
3049 username user3
3050 status not found
3051 username user4
3052 status not found
3053 execute dump_memory_account;
3054 execute dump_memory_user;
3055 USER user1
3056 EVENT_NAME memory/sql/User_level_lock
3057 COUNT_ALLOC 0
3058 COUNT_FREE 0
3059 SUM_NUMBER_OF_BYTES_ALLOC 0
3060 SUM_NUMBER_OF_BYTES_FREE 0
3061 LOW_COUNT_USED 0
3062 CURRENT_COUNT_USED 0
3063 HIGH_COUNT_USED 0
3064 LOW_NUMBER_OF_BYTES_USED 0
3065 CURRENT_NUMBER_OF_BYTES_USED 0
3066 HIGH_NUMBER_OF_BYTES_USED 0
3067 USER user1
3068 EVENT_NAME memory/sql/user_var_entry::value
3069 COUNT_ALLOC 0
3070 COUNT_FREE 0
3071 SUM_NUMBER_OF_BYTES_ALLOC 0
3072 SUM_NUMBER_OF_BYTES_FREE 0
3073 LOW_COUNT_USED 0
3074 CURRENT_COUNT_USED 0
3075 HIGH_COUNT_USED 0
3076 LOW_NUMBER_OF_BYTES_USED 0
3077 CURRENT_NUMBER_OF_BYTES_USED 0
3078 HIGH_NUMBER_OF_BYTES_USED 0
3079 USER user2
3080 EVENT_NAME memory/sql/User_level_lock
3081 COUNT_ALLOC 0
3082 COUNT_FREE 0
3083 SUM_NUMBER_OF_BYTES_ALLOC 0
3084 SUM_NUMBER_OF_BYTES_FREE 0
3085 LOW_COUNT_USED 0
3086 CURRENT_COUNT_USED 0
3087 HIGH_COUNT_USED 0
3088 LOW_NUMBER_OF_BYTES_USED 0
3089 CURRENT_NUMBER_OF_BYTES_USED 0
3090 HIGH_NUMBER_OF_BYTES_USED 0
3091 USER user2
3092 EVENT_NAME memory/sql/user_var_entry::value
3093 COUNT_ALLOC 0
3094 COUNT_FREE 0
3095 SUM_NUMBER_OF_BYTES_ALLOC 0
3096 SUM_NUMBER_OF_BYTES_FREE 0
3097 LOW_COUNT_USED 0
3098 CURRENT_COUNT_USED 0
3099 HIGH_COUNT_USED 0
3100 LOW_NUMBER_OF_BYTES_USED 0
3101 CURRENT_NUMBER_OF_BYTES_USED 0
3102 HIGH_NUMBER_OF_BYTES_USED 0
3103 USER user3
3104 EVENT_NAME memory/sql/User_level_lock
3105 COUNT_ALLOC 0
3106 COUNT_FREE 0
3107 SUM_NUMBER_OF_BYTES_ALLOC 0
3108 SUM_NUMBER_OF_BYTES_FREE 0
3109 LOW_COUNT_USED 0
3110 CURRENT_COUNT_USED 0
3111 HIGH_COUNT_USED 0
3112 LOW_NUMBER_OF_BYTES_USED 0
3113 CURRENT_NUMBER_OF_BYTES_USED 0
3114 HIGH_NUMBER_OF_BYTES_USED 0
3115 USER user3
3116 EVENT_NAME memory/sql/user_var_entry::value
3117 COUNT_ALLOC 0
3118 COUNT_FREE 0
3119 SUM_NUMBER_OF_BYTES_ALLOC 0
3120 SUM_NUMBER_OF_BYTES_FREE 0
3121 LOW_COUNT_USED 0
3122 CURRENT_COUNT_USED 0
3123 HIGH_COUNT_USED 0
3124 LOW_NUMBER_OF_BYTES_USED 0
3125 CURRENT_NUMBER_OF_BYTES_USED 0
3126 HIGH_NUMBER_OF_BYTES_USED 0
3127 USER user4
3128 EVENT_NAME memory/sql/User_level_lock
3129 COUNT_ALLOC 0
3130 COUNT_FREE 0
3131 SUM_NUMBER_OF_BYTES_ALLOC 0
3132 SUM_NUMBER_OF_BYTES_FREE 0
3133 LOW_COUNT_USED 0
3134 CURRENT_COUNT_USED 0
3135 HIGH_COUNT_USED 0
3136 LOW_NUMBER_OF_BYTES_USED 0
3137 CURRENT_NUMBER_OF_BYTES_USED 0
3138 HIGH_NUMBER_OF_BYTES_USED 0
3139 USER user4
3140 EVENT_NAME memory/sql/user_var_entry::value
3141 COUNT_ALLOC 0
3142 COUNT_FREE 0
3143 SUM_NUMBER_OF_BYTES_ALLOC 0
3144 SUM_NUMBER_OF_BYTES_FREE 0
3145 LOW_COUNT_USED 0
3146 CURRENT_COUNT_USED 0
3147 HIGH_COUNT_USED 0
3148 LOW_NUMBER_OF_BYTES_USED 0
3149 CURRENT_NUMBER_OF_BYTES_USED 0
3150 HIGH_NUMBER_OF_BYTES_USED 0
3151 execute dump_memory_host;
3152 execute dump_memory_global;
3153 EVENT_NAME memory/sql/Query_cache
3154 COUNT_ALLOC 2
3155 COUNT_FREE 0
3156 SUM_NUMBER_OF_BYTES_ALLOC 32768
3157 SUM_NUMBER_OF_BYTES_FREE 0
3158 LOW_COUNT_USED 2
3159 CURRENT_COUNT_USED 2
3160 HIGH_COUNT_USED 2
3161 LOW_NUMBER_OF_BYTES_USED 32768
3162 CURRENT_NUMBER_OF_BYTES_USED 32768
3163 HIGH_NUMBER_OF_BYTES_USED 32768
3164 EVENT_NAME memory/sql/User_level_lock
3165 COUNT_ALLOC 0
3166 COUNT_FREE 0
3167 SUM_NUMBER_OF_BYTES_ALLOC 0
3168 SUM_NUMBER_OF_BYTES_FREE 0
3169 LOW_COUNT_USED 0
3170 CURRENT_COUNT_USED 0
3171 HIGH_COUNT_USED 0
3172 LOW_NUMBER_OF_BYTES_USED 0
3173 CURRENT_NUMBER_OF_BYTES_USED 0
3174 HIGH_NUMBER_OF_BYTES_USED 0
3175 EVENT_NAME memory/sql/user_var_entry::value
3176 COUNT_ALLOC 1
3177 COUNT_FREE 0
3178 SUM_NUMBER_OF_BYTES_ALLOC 96
3179 SUM_NUMBER_OF_BYTES_FREE 0
3180 LOW_COUNT_USED 1
3181 CURRENT_COUNT_USED 1
3182 HIGH_COUNT_USED 1
3183 LOW_NUMBER_OF_BYTES_USED 96
3184 CURRENT_NUMBER_OF_BYTES_USED 96
3185 HIGH_NUMBER_OF_BYTES_USED 96
3186 execute dump_accounts;
3187 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3188 execute dump_users;
3189 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3190 root 1 1
3191 user1 0 1
3192 user2 0 1
3193 user3 0 1
3194 user4 0 2
3195 execute dump_hosts;
3196 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3197 truncate performance_schema.accounts;
3198 "================== ACCOUNTS truncated =================="
3199 "================== Step 19 =================="
3200 call dump_thread();
3201 username user1
3202 status not found
3203 username user2
3204 status not found
3205 username user3
3206 status not found
3207 username user4
3208 status not found
3209 execute dump_memory_account;
3210 execute dump_memory_user;
3211 USER user1
3212 EVENT_NAME memory/sql/User_level_lock
3213 COUNT_ALLOC 0
3214 COUNT_FREE 0
3215 SUM_NUMBER_OF_BYTES_ALLOC 0
3216 SUM_NUMBER_OF_BYTES_FREE 0
3217 LOW_COUNT_USED 0
3218 CURRENT_COUNT_USED 0
3219 HIGH_COUNT_USED 0
3220 LOW_NUMBER_OF_BYTES_USED 0
3221 CURRENT_NUMBER_OF_BYTES_USED 0
3222 HIGH_NUMBER_OF_BYTES_USED 0
3223 USER user1
3224 EVENT_NAME memory/sql/user_var_entry::value
3225 COUNT_ALLOC 0
3226 COUNT_FREE 0
3227 SUM_NUMBER_OF_BYTES_ALLOC 0
3228 SUM_NUMBER_OF_BYTES_FREE 0
3229 LOW_COUNT_USED 0
3230 CURRENT_COUNT_USED 0
3231 HIGH_COUNT_USED 0
3232 LOW_NUMBER_OF_BYTES_USED 0
3233 CURRENT_NUMBER_OF_BYTES_USED 0
3234 HIGH_NUMBER_OF_BYTES_USED 0
3235 USER user2
3236 EVENT_NAME memory/sql/User_level_lock
3237 COUNT_ALLOC 0
3238 COUNT_FREE 0
3239 SUM_NUMBER_OF_BYTES_ALLOC 0
3240 SUM_NUMBER_OF_BYTES_FREE 0
3241 LOW_COUNT_USED 0
3242 CURRENT_COUNT_USED 0
3243 HIGH_COUNT_USED 0
3244 LOW_NUMBER_OF_BYTES_USED 0
3245 CURRENT_NUMBER_OF_BYTES_USED 0
3246 HIGH_NUMBER_OF_BYTES_USED 0
3247 USER user2
3248 EVENT_NAME memory/sql/user_var_entry::value
3249 COUNT_ALLOC 0
3250 COUNT_FREE 0
3251 SUM_NUMBER_OF_BYTES_ALLOC 0
3252 SUM_NUMBER_OF_BYTES_FREE 0
3253 LOW_COUNT_USED 0
3254 CURRENT_COUNT_USED 0
3255 HIGH_COUNT_USED 0
3256 LOW_NUMBER_OF_BYTES_USED 0
3257 CURRENT_NUMBER_OF_BYTES_USED 0
3258 HIGH_NUMBER_OF_BYTES_USED 0
3259 USER user3
3260 EVENT_NAME memory/sql/User_level_lock
3261 COUNT_ALLOC 0
3262 COUNT_FREE 0
3263 SUM_NUMBER_OF_BYTES_ALLOC 0
3264 SUM_NUMBER_OF_BYTES_FREE 0
3265 LOW_COUNT_USED 0
3266 CURRENT_COUNT_USED 0
3267 HIGH_COUNT_USED 0
3268 LOW_NUMBER_OF_BYTES_USED 0
3269 CURRENT_NUMBER_OF_BYTES_USED 0
3270 HIGH_NUMBER_OF_BYTES_USED 0
3271 USER user3
3272 EVENT_NAME memory/sql/user_var_entry::value
3273 COUNT_ALLOC 0
3274 COUNT_FREE 0
3275 SUM_NUMBER_OF_BYTES_ALLOC 0
3276 SUM_NUMBER_OF_BYTES_FREE 0
3277 LOW_COUNT_USED 0
3278 CURRENT_COUNT_USED 0
3279 HIGH_COUNT_USED 0
3280 LOW_NUMBER_OF_BYTES_USED 0
3281 CURRENT_NUMBER_OF_BYTES_USED 0
3282 HIGH_NUMBER_OF_BYTES_USED 0
3283 USER user4
3284 EVENT_NAME memory/sql/User_level_lock
3285 COUNT_ALLOC 0
3286 COUNT_FREE 0
3287 SUM_NUMBER_OF_BYTES_ALLOC 0
3288 SUM_NUMBER_OF_BYTES_FREE 0
3289 LOW_COUNT_USED 0
3290 CURRENT_COUNT_USED 0
3291 HIGH_COUNT_USED 0
3292 LOW_NUMBER_OF_BYTES_USED 0
3293 CURRENT_NUMBER_OF_BYTES_USED 0
3294 HIGH_NUMBER_OF_BYTES_USED 0
3295 USER user4
3296 EVENT_NAME memory/sql/user_var_entry::value
3297 COUNT_ALLOC 0
3298 COUNT_FREE 0
3299 SUM_NUMBER_OF_BYTES_ALLOC 0
3300 SUM_NUMBER_OF_BYTES_FREE 0
3301 LOW_COUNT_USED 0
3302 CURRENT_COUNT_USED 0
3303 HIGH_COUNT_USED 0
3304 LOW_NUMBER_OF_BYTES_USED 0
3305 CURRENT_NUMBER_OF_BYTES_USED 0
3306 HIGH_NUMBER_OF_BYTES_USED 0
3307 execute dump_memory_host;
3308 execute dump_memory_global;
3309 EVENT_NAME memory/sql/Query_cache
3310 COUNT_ALLOC 2
3311 COUNT_FREE 0
3312 SUM_NUMBER_OF_BYTES_ALLOC 32768
3313 SUM_NUMBER_OF_BYTES_FREE 0
3314 LOW_COUNT_USED 2
3315 CURRENT_COUNT_USED 2
3316 HIGH_COUNT_USED 2
3317 LOW_NUMBER_OF_BYTES_USED 32768
3318 CURRENT_NUMBER_OF_BYTES_USED 32768
3319 HIGH_NUMBER_OF_BYTES_USED 32768
3320 EVENT_NAME memory/sql/User_level_lock
3321 COUNT_ALLOC 0
3322 COUNT_FREE 0
3323 SUM_NUMBER_OF_BYTES_ALLOC 0
3324 SUM_NUMBER_OF_BYTES_FREE 0
3325 LOW_COUNT_USED 0
3326 CURRENT_COUNT_USED 0
3327 HIGH_COUNT_USED 0
3328 LOW_NUMBER_OF_BYTES_USED 0
3329 CURRENT_NUMBER_OF_BYTES_USED 0
3330 HIGH_NUMBER_OF_BYTES_USED 0
3331 EVENT_NAME memory/sql/user_var_entry::value
3332 COUNT_ALLOC 1
3333 COUNT_FREE 0
3334 SUM_NUMBER_OF_BYTES_ALLOC 96
3335 SUM_NUMBER_OF_BYTES_FREE 0
3336 LOW_COUNT_USED 1
3337 CURRENT_COUNT_USED 1
3338 HIGH_COUNT_USED 1
3339 LOW_NUMBER_OF_BYTES_USED 96
3340 CURRENT_NUMBER_OF_BYTES_USED 96
3341 HIGH_NUMBER_OF_BYTES_USED 96
3342 execute dump_accounts;
3343 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3344 execute dump_users;
3345 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3346 root 1 1
3347 user1 0 1
3348 user2 0 1
3349 user3 0 1
3350 user4 0 2
3351 execute dump_hosts;
3352 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3353 truncate performance_schema.users;
3354 "================== USERS truncated =================="
3355 "================== Step 20 =================="
3356 call dump_thread();
3357 username user1
3358 status not found
3359 username user2
3360 status not found
3361 username user3
3362 status not found
3363 username user4
3364 status not found
3365 execute dump_memory_account;
3366 execute dump_memory_user;
3367 execute dump_memory_host;
3368 execute dump_memory_global;
3369 EVENT_NAME memory/sql/Query_cache
3370 COUNT_ALLOC 2
3371 COUNT_FREE 0
3372 SUM_NUMBER_OF_BYTES_ALLOC 32768
3373 SUM_NUMBER_OF_BYTES_FREE 0
3374 LOW_COUNT_USED 2
3375 CURRENT_COUNT_USED 2
3376 HIGH_COUNT_USED 2
3377 LOW_NUMBER_OF_BYTES_USED 32768
3378 CURRENT_NUMBER_OF_BYTES_USED 32768
3379 HIGH_NUMBER_OF_BYTES_USED 32768
3380 EVENT_NAME memory/sql/User_level_lock
3381 COUNT_ALLOC 0
3382 COUNT_FREE 0
3383 SUM_NUMBER_OF_BYTES_ALLOC 0
3384 SUM_NUMBER_OF_BYTES_FREE 0
3385 LOW_COUNT_USED 0
3386 CURRENT_COUNT_USED 0
3387 HIGH_COUNT_USED 0
3388 LOW_NUMBER_OF_BYTES_USED 0
3389 CURRENT_NUMBER_OF_BYTES_USED 0
3390 HIGH_NUMBER_OF_BYTES_USED 0
3391 EVENT_NAME memory/sql/user_var_entry::value
3392 COUNT_ALLOC 1
3393 COUNT_FREE 0
3394 SUM_NUMBER_OF_BYTES_ALLOC 96
3395 SUM_NUMBER_OF_BYTES_FREE 0
3396 LOW_COUNT_USED 1
3397 CURRENT_COUNT_USED 1
3398 HIGH_COUNT_USED 1
3399 LOW_NUMBER_OF_BYTES_USED 96
3400 CURRENT_NUMBER_OF_BYTES_USED 96
3401 HIGH_NUMBER_OF_BYTES_USED 96
3402 execute dump_accounts;
3403 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3404 execute dump_users;
3405 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3406 root 1 1
3407 execute dump_hosts;
3408 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3409 truncate performance_schema.hosts;
3410 "================== HOSTS truncated =================="
3411 "================== Step 21 =================="
3412 call dump_thread();
3413 username user1
3414 status not found
3415 username user2
3416 status not found
3417 username user3
3418 status not found
3419 username user4
3420 status not found
3421 execute dump_memory_account;
3422 execute dump_memory_user;
3423 execute dump_memory_host;
3424 execute dump_memory_global;
3425 EVENT_NAME memory/sql/Query_cache
3426 COUNT_ALLOC 2
3427 COUNT_FREE 0
3428 SUM_NUMBER_OF_BYTES_ALLOC 32768
3429 SUM_NUMBER_OF_BYTES_FREE 0
3430 LOW_COUNT_USED 2
3431 CURRENT_COUNT_USED 2
3432 HIGH_COUNT_USED 2
3433 LOW_NUMBER_OF_BYTES_USED 32768
3434 CURRENT_NUMBER_OF_BYTES_USED 32768
3435 HIGH_NUMBER_OF_BYTES_USED 32768
3436 EVENT_NAME memory/sql/User_level_lock
3437 COUNT_ALLOC 0
3438 COUNT_FREE 0
3439 SUM_NUMBER_OF_BYTES_ALLOC 0
3440 SUM_NUMBER_OF_BYTES_FREE 0
3441 LOW_COUNT_USED 0
3442 CURRENT_COUNT_USED 0
3443 HIGH_COUNT_USED 0
3444 LOW_NUMBER_OF_BYTES_USED 0
3445 CURRENT_NUMBER_OF_BYTES_USED 0
3446 HIGH_NUMBER_OF_BYTES_USED 0
3447 EVENT_NAME memory/sql/user_var_entry::value
3448 COUNT_ALLOC 1
3449 COUNT_FREE 0
3450 SUM_NUMBER_OF_BYTES_ALLOC 96
3451 SUM_NUMBER_OF_BYTES_FREE 0
3452 LOW_COUNT_USED 1
3453 CURRENT_COUNT_USED 1
3454 HIGH_COUNT_USED 1
3455 LOW_NUMBER_OF_BYTES_USED 96
3456 CURRENT_NUMBER_OF_BYTES_USED 96
3457 HIGH_NUMBER_OF_BYTES_USED 96
3458 execute dump_accounts;
3459 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3460 execute dump_users;
3461 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3462 root 1 1
3463 execute dump_hosts;
3464 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS