Debian Codegraph @

mysql-test/suite/perfschema/r/memory_aggregate_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 root localhost 1 1
54 execute dump_users;
55 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
56 root 1 1
57 execute dump_hosts;
58 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
59 connect con1, localhost, user1, , ;
60 "================== con1 connected =================="
61 connection default;
62 "================== Step 2 =================="
63 call dump_thread();
64 username user1
65 EVENT_NAME memory/sql/User_level_lock
66 COUNT_ALLOC 0
67 COUNT_FREE 0
68 SUM_NUMBER_OF_BYTES_ALLOC 0
69 SUM_NUMBER_OF_BYTES_FREE 0
70 LOW_COUNT_USED 0
71 CURRENT_COUNT_USED 0
72 HIGH_COUNT_USED 0
73 LOW_NUMBER_OF_BYTES_USED 0
74 CURRENT_NUMBER_OF_BYTES_USED 0
75 HIGH_NUMBER_OF_BYTES_USED 0
76 username user1
77 EVENT_NAME memory/sql/user_var_entry::value
78 COUNT_ALLOC 0
79 COUNT_FREE 0
80 SUM_NUMBER_OF_BYTES_ALLOC 0
81 SUM_NUMBER_OF_BYTES_FREE 0
82 LOW_COUNT_USED 0
83 CURRENT_COUNT_USED 0
84 HIGH_COUNT_USED 0
85 LOW_NUMBER_OF_BYTES_USED 0
86 CURRENT_NUMBER_OF_BYTES_USED 0
87 HIGH_NUMBER_OF_BYTES_USED 0
88 username user2
89 status not found
90 username user3
91 status not found
92 username user4
93 status not found
94 execute dump_memory_account;
95 USER user1
96 HOST localhost
97 EVENT_NAME memory/sql/User_level_lock
98 COUNT_ALLOC 0
99 COUNT_FREE 0
100 SUM_NUMBER_OF_BYTES_ALLOC 0
101 SUM_NUMBER_OF_BYTES_FREE 0
102 LOW_COUNT_USED 0
103 CURRENT_COUNT_USED 0
104 HIGH_COUNT_USED 0
105 LOW_NUMBER_OF_BYTES_USED 0
106 CURRENT_NUMBER_OF_BYTES_USED 0
107 HIGH_NUMBER_OF_BYTES_USED 0
108 USER user1
109 HOST localhost
110 EVENT_NAME memory/sql/user_var_entry::value
111 COUNT_ALLOC 0
112 COUNT_FREE 0
113 SUM_NUMBER_OF_BYTES_ALLOC 0
114 SUM_NUMBER_OF_BYTES_FREE 0
115 LOW_COUNT_USED 0
116 CURRENT_COUNT_USED 0
117 HIGH_COUNT_USED 0
118 LOW_NUMBER_OF_BYTES_USED 0
119 CURRENT_NUMBER_OF_BYTES_USED 0
120 HIGH_NUMBER_OF_BYTES_USED 0
121 execute dump_memory_user;
122 USER user1
123 EVENT_NAME memory/sql/User_level_lock
124 COUNT_ALLOC 0
125 COUNT_FREE 0
126 SUM_NUMBER_OF_BYTES_ALLOC 0
127 SUM_NUMBER_OF_BYTES_FREE 0
128 LOW_COUNT_USED 0
129 CURRENT_COUNT_USED 0
130 HIGH_COUNT_USED 0
131 LOW_NUMBER_OF_BYTES_USED 0
132 CURRENT_NUMBER_OF_BYTES_USED 0
133 HIGH_NUMBER_OF_BYTES_USED 0
134 USER user1
135 EVENT_NAME memory/sql/user_var_entry::value
136 COUNT_ALLOC 0
137 COUNT_FREE 0
138 SUM_NUMBER_OF_BYTES_ALLOC 0
139 SUM_NUMBER_OF_BYTES_FREE 0
140 LOW_COUNT_USED 0
141 CURRENT_COUNT_USED 0
142 HIGH_COUNT_USED 0
143 LOW_NUMBER_OF_BYTES_USED 0
144 CURRENT_NUMBER_OF_BYTES_USED 0
145 HIGH_NUMBER_OF_BYTES_USED 0
146 execute dump_memory_host;
147 execute dump_memory_global;
148 EVENT_NAME memory/sql/Query_cache
149 COUNT_ALLOC 0
150 COUNT_FREE 0
151 SUM_NUMBER_OF_BYTES_ALLOC 0
152 SUM_NUMBER_OF_BYTES_FREE 0
153 LOW_COUNT_USED 0
154 CURRENT_COUNT_USED 0
155 HIGH_COUNT_USED 0
156 LOW_NUMBER_OF_BYTES_USED 0
157 CURRENT_NUMBER_OF_BYTES_USED 0
158 HIGH_NUMBER_OF_BYTES_USED 0
159 EVENT_NAME memory/sql/User_level_lock
160 COUNT_ALLOC 0
161 COUNT_FREE 0
162 SUM_NUMBER_OF_BYTES_ALLOC 0
163 SUM_NUMBER_OF_BYTES_FREE 0
164 LOW_COUNT_USED 0
165 CURRENT_COUNT_USED 0
166 HIGH_COUNT_USED 0
167 LOW_NUMBER_OF_BYTES_USED 0
168 CURRENT_NUMBER_OF_BYTES_USED 0
169 HIGH_NUMBER_OF_BYTES_USED 0
170 EVENT_NAME memory/sql/user_var_entry::value
171 COUNT_ALLOC 1
172 COUNT_FREE 0
173 SUM_NUMBER_OF_BYTES_ALLOC 96
174 SUM_NUMBER_OF_BYTES_FREE 0
175 LOW_COUNT_USED 1
176 CURRENT_COUNT_USED 1
177 HIGH_COUNT_USED 1
178 LOW_NUMBER_OF_BYTES_USED 96
179 CURRENT_NUMBER_OF_BYTES_USED 96
180 HIGH_NUMBER_OF_BYTES_USED 96
181 execute dump_accounts;
182 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
183 root localhost 1 1
184 user1 localhost 1 1
185 execute dump_users;
186 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
187 root 1 1
188 user1 1 1
189 execute dump_hosts;
190 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
191 connection con1;
192 set GLOBAL query_cache_size=1000*1024;
193 select get_lock("marker_1", 10);
194 get_lock("marker_1", 10)
195 1
196 select release_lock("marker_1");
197 release_lock("marker_1")
198 1
199 set @v1 = repeat("a", 1000);
200 set @v2 = repeat("b", 2000);
201 set @v3 = repeat("c", 4000);
202 "================== con1 marker =================="
203 connection default;
204 "================== Step 3 =================="
205 call dump_thread();
206 username user1
207 EVENT_NAME memory/sql/User_level_lock
208 COUNT_ALLOC 2
209 COUNT_FREE 1
210 SUM_NUMBER_OF_BYTES_ALLOC 272
211 SUM_NUMBER_OF_BYTES_FREE 16
212 LOW_COUNT_USED 0
213 CURRENT_COUNT_USED 1
214 HIGH_COUNT_USED 2
215 LOW_NUMBER_OF_BYTES_USED 0
216 CURRENT_NUMBER_OF_BYTES_USED 256
217 HIGH_NUMBER_OF_BYTES_USED 272
218 username user1
219 EVENT_NAME memory/sql/user_var_entry::value
220 COUNT_ALLOC 3
221 COUNT_FREE 0
222 SUM_NUMBER_OF_BYTES_ALLOC 7024
223 SUM_NUMBER_OF_BYTES_FREE 0
224 LOW_COUNT_USED 0
225 CURRENT_COUNT_USED 3
226 HIGH_COUNT_USED 3
227 LOW_NUMBER_OF_BYTES_USED 0
228 CURRENT_NUMBER_OF_BYTES_USED 7024
229 HIGH_NUMBER_OF_BYTES_USED 7024
230 username user2
231 status not found
232 username user3
233 status not found
234 username user4
235 status not found
236 execute dump_memory_account;
237 USER user1
238 HOST localhost
239 EVENT_NAME memory/sql/User_level_lock
240 COUNT_ALLOC 2
241 COUNT_FREE 1
242 SUM_NUMBER_OF_BYTES_ALLOC 272
243 SUM_NUMBER_OF_BYTES_FREE 16
244 LOW_COUNT_USED 0
245 CURRENT_COUNT_USED 1
246 HIGH_COUNT_USED 2
247 LOW_NUMBER_OF_BYTES_USED 0
248 CURRENT_NUMBER_OF_BYTES_USED 256
249 HIGH_NUMBER_OF_BYTES_USED 272
250 USER user1
251 HOST localhost
252 EVENT_NAME memory/sql/user_var_entry::value
253 COUNT_ALLOC 3
254 COUNT_FREE 0
255 SUM_NUMBER_OF_BYTES_ALLOC 7024
256 SUM_NUMBER_OF_BYTES_FREE 0
257 LOW_COUNT_USED 0
258 CURRENT_COUNT_USED 3
259 HIGH_COUNT_USED 3
260 LOW_NUMBER_OF_BYTES_USED 0
261 CURRENT_NUMBER_OF_BYTES_USED 7024
262 HIGH_NUMBER_OF_BYTES_USED 7024
263 execute dump_memory_user;
264 USER user1
265 EVENT_NAME memory/sql/User_level_lock
266 COUNT_ALLOC 2
267 COUNT_FREE 1
268 SUM_NUMBER_OF_BYTES_ALLOC 272
269 SUM_NUMBER_OF_BYTES_FREE 16
270 LOW_COUNT_USED 0
271 CURRENT_COUNT_USED 1
272 HIGH_COUNT_USED 2
273 LOW_NUMBER_OF_BYTES_USED 0
274 CURRENT_NUMBER_OF_BYTES_USED 256
275 HIGH_NUMBER_OF_BYTES_USED 272
276 USER user1
277 EVENT_NAME memory/sql/user_var_entry::value
278 COUNT_ALLOC 3
279 COUNT_FREE 0
280 SUM_NUMBER_OF_BYTES_ALLOC 7024
281 SUM_NUMBER_OF_BYTES_FREE 0
282 LOW_COUNT_USED 0
283 CURRENT_COUNT_USED 3
284 HIGH_COUNT_USED 3
285 LOW_NUMBER_OF_BYTES_USED 0
286 CURRENT_NUMBER_OF_BYTES_USED 7024
287 HIGH_NUMBER_OF_BYTES_USED 7024
288 execute dump_memory_host;
289 execute dump_memory_global;
290 EVENT_NAME memory/sql/Query_cache
291 COUNT_ALLOC 2
292 COUNT_FREE 0
293 SUM_NUMBER_OF_BYTES_ALLOC 32768
294 SUM_NUMBER_OF_BYTES_FREE 0
295 LOW_COUNT_USED 0
296 CURRENT_COUNT_USED 2
297 HIGH_COUNT_USED 2
298 LOW_NUMBER_OF_BYTES_USED 0
299 CURRENT_NUMBER_OF_BYTES_USED 32768
300 HIGH_NUMBER_OF_BYTES_USED 32768
301 EVENT_NAME memory/sql/User_level_lock
302 COUNT_ALLOC 2
303 COUNT_FREE 1
304 SUM_NUMBER_OF_BYTES_ALLOC 272
305 SUM_NUMBER_OF_BYTES_FREE 16
306 LOW_COUNT_USED 0
307 CURRENT_COUNT_USED 1
308 HIGH_COUNT_USED 2
309 LOW_NUMBER_OF_BYTES_USED 0
310 CURRENT_NUMBER_OF_BYTES_USED 256
311 HIGH_NUMBER_OF_BYTES_USED 272
312 EVENT_NAME memory/sql/user_var_entry::value
313 COUNT_ALLOC 4
314 COUNT_FREE 0
315 SUM_NUMBER_OF_BYTES_ALLOC 7120
316 SUM_NUMBER_OF_BYTES_FREE 0
317 LOW_COUNT_USED 1
318 CURRENT_COUNT_USED 4
319 HIGH_COUNT_USED 4
320 LOW_NUMBER_OF_BYTES_USED 96
321 CURRENT_NUMBER_OF_BYTES_USED 7120
322 HIGH_NUMBER_OF_BYTES_USED 7120
323 execute dump_accounts;
324 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
325 root localhost 1 1
326 user1 localhost 1 1
327 execute dump_users;
328 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
329 root 1 1
330 user1 1 1
331 execute dump_hosts;
332 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
333 connect con2, localhost, user2, , ;
334 "================== con2 connected =================="
335 connection default;
336 "================== Step 4 =================="
337 call dump_thread();
338 username user1
339 EVENT_NAME memory/sql/User_level_lock
340 COUNT_ALLOC 2
341 COUNT_FREE 1
342 SUM_NUMBER_OF_BYTES_ALLOC 272
343 SUM_NUMBER_OF_BYTES_FREE 16
344 LOW_COUNT_USED 0
345 CURRENT_COUNT_USED 1
346 HIGH_COUNT_USED 2
347 LOW_NUMBER_OF_BYTES_USED 0
348 CURRENT_NUMBER_OF_BYTES_USED 256
349 HIGH_NUMBER_OF_BYTES_USED 272
350 username user1
351 EVENT_NAME memory/sql/user_var_entry::value
352 COUNT_ALLOC 3
353 COUNT_FREE 0
354 SUM_NUMBER_OF_BYTES_ALLOC 7024
355 SUM_NUMBER_OF_BYTES_FREE 0
356 LOW_COUNT_USED 0
357 CURRENT_COUNT_USED 3
358 HIGH_COUNT_USED 3
359 LOW_NUMBER_OF_BYTES_USED 0
360 CURRENT_NUMBER_OF_BYTES_USED 7024
361 HIGH_NUMBER_OF_BYTES_USED 7024
362 username user2
363 EVENT_NAME memory/sql/User_level_lock
364 COUNT_ALLOC 0
365 COUNT_FREE 0
366 SUM_NUMBER_OF_BYTES_ALLOC 0
367 SUM_NUMBER_OF_BYTES_FREE 0
368 LOW_COUNT_USED 0
369 CURRENT_COUNT_USED 0
370 HIGH_COUNT_USED 0
371 LOW_NUMBER_OF_BYTES_USED 0
372 CURRENT_NUMBER_OF_BYTES_USED 0
373 HIGH_NUMBER_OF_BYTES_USED 0
374 username user2
375 EVENT_NAME memory/sql/user_var_entry::value
376 COUNT_ALLOC 0
377 COUNT_FREE 0
378 SUM_NUMBER_OF_BYTES_ALLOC 0
379 SUM_NUMBER_OF_BYTES_FREE 0
380 LOW_COUNT_USED 0
381 CURRENT_COUNT_USED 0
382 HIGH_COUNT_USED 0
383 LOW_NUMBER_OF_BYTES_USED 0
384 CURRENT_NUMBER_OF_BYTES_USED 0
385 HIGH_NUMBER_OF_BYTES_USED 0
386 username user3
387 status not found
388 username user4
389 status not found
390 execute dump_memory_account;
391 USER user1
392 HOST localhost
393 EVENT_NAME memory/sql/User_level_lock
394 COUNT_ALLOC 2
395 COUNT_FREE 1
396 SUM_NUMBER_OF_BYTES_ALLOC 272
397 SUM_NUMBER_OF_BYTES_FREE 16
398 LOW_COUNT_USED 0
399 CURRENT_COUNT_USED 1
400 HIGH_COUNT_USED 2
401 LOW_NUMBER_OF_BYTES_USED 0
402 CURRENT_NUMBER_OF_BYTES_USED 256
403 HIGH_NUMBER_OF_BYTES_USED 272
404 USER user1
405 HOST localhost
406 EVENT_NAME memory/sql/user_var_entry::value
407 COUNT_ALLOC 3
408 COUNT_FREE 0
409 SUM_NUMBER_OF_BYTES_ALLOC 7024
410 SUM_NUMBER_OF_BYTES_FREE 0
411 LOW_COUNT_USED 0
412 CURRENT_COUNT_USED 3
413 HIGH_COUNT_USED 3
414 LOW_NUMBER_OF_BYTES_USED 0
415 CURRENT_NUMBER_OF_BYTES_USED 7024
416 HIGH_NUMBER_OF_BYTES_USED 7024
417 USER user2
418 HOST localhost
419 EVENT_NAME memory/sql/User_level_lock
420 COUNT_ALLOC 0
421 COUNT_FREE 0
422 SUM_NUMBER_OF_BYTES_ALLOC 0
423 SUM_NUMBER_OF_BYTES_FREE 0
424 LOW_COUNT_USED 0
425 CURRENT_COUNT_USED 0
426 HIGH_COUNT_USED 0
427 LOW_NUMBER_OF_BYTES_USED 0
428 CURRENT_NUMBER_OF_BYTES_USED 0
429 HIGH_NUMBER_OF_BYTES_USED 0
430 USER user2
431 HOST localhost
432 EVENT_NAME memory/sql/user_var_entry::value
433 COUNT_ALLOC 0
434 COUNT_FREE 0
435 SUM_NUMBER_OF_BYTES_ALLOC 0
436 SUM_NUMBER_OF_BYTES_FREE 0
437 LOW_COUNT_USED 0
438 CURRENT_COUNT_USED 0
439 HIGH_COUNT_USED 0
440 LOW_NUMBER_OF_BYTES_USED 0
441 CURRENT_NUMBER_OF_BYTES_USED 0
442 HIGH_NUMBER_OF_BYTES_USED 0
443 execute dump_memory_user;
444 USER user1
445 EVENT_NAME memory/sql/User_level_lock
446 COUNT_ALLOC 2
447 COUNT_FREE 1
448 SUM_NUMBER_OF_BYTES_ALLOC 272
449 SUM_NUMBER_OF_BYTES_FREE 16
450 LOW_COUNT_USED 0
451 CURRENT_COUNT_USED 1
452 HIGH_COUNT_USED 2
453 LOW_NUMBER_OF_BYTES_USED 0
454 CURRENT_NUMBER_OF_BYTES_USED 256
455 HIGH_NUMBER_OF_BYTES_USED 272
456 USER user1
457 EVENT_NAME memory/sql/user_var_entry::value
458 COUNT_ALLOC 3
459 COUNT_FREE 0
460 SUM_NUMBER_OF_BYTES_ALLOC 7024
461 SUM_NUMBER_OF_BYTES_FREE 0
462 LOW_COUNT_USED 0
463 CURRENT_COUNT_USED 3
464 HIGH_COUNT_USED 3
465 LOW_NUMBER_OF_BYTES_USED 0
466 CURRENT_NUMBER_OF_BYTES_USED 7024
467 HIGH_NUMBER_OF_BYTES_USED 7024
468 USER user2
469 EVENT_NAME memory/sql/User_level_lock
470 COUNT_ALLOC 0
471 COUNT_FREE 0
472 SUM_NUMBER_OF_BYTES_ALLOC 0
473 SUM_NUMBER_OF_BYTES_FREE 0
474 LOW_COUNT_USED 0
475 CURRENT_COUNT_USED 0
476 HIGH_COUNT_USED 0
477 LOW_NUMBER_OF_BYTES_USED 0
478 CURRENT_NUMBER_OF_BYTES_USED 0
479 HIGH_NUMBER_OF_BYTES_USED 0
480 USER user2
481 EVENT_NAME memory/sql/user_var_entry::value
482 COUNT_ALLOC 0
483 COUNT_FREE 0
484 SUM_NUMBER_OF_BYTES_ALLOC 0
485 SUM_NUMBER_OF_BYTES_FREE 0
486 LOW_COUNT_USED 0
487 CURRENT_COUNT_USED 0
488 HIGH_COUNT_USED 0
489 LOW_NUMBER_OF_BYTES_USED 0
490 CURRENT_NUMBER_OF_BYTES_USED 0
491 HIGH_NUMBER_OF_BYTES_USED 0
492 execute dump_memory_host;
493 execute dump_memory_global;
494 EVENT_NAME memory/sql/Query_cache
495 COUNT_ALLOC 2
496 COUNT_FREE 0
497 SUM_NUMBER_OF_BYTES_ALLOC 32768
498 SUM_NUMBER_OF_BYTES_FREE 0
499 LOW_COUNT_USED 0
500 CURRENT_COUNT_USED 2
501 HIGH_COUNT_USED 2
502 LOW_NUMBER_OF_BYTES_USED 0
503 CURRENT_NUMBER_OF_BYTES_USED 32768
504 HIGH_NUMBER_OF_BYTES_USED 32768
505 EVENT_NAME memory/sql/User_level_lock
506 COUNT_ALLOC 2
507 COUNT_FREE 1
508 SUM_NUMBER_OF_BYTES_ALLOC 272
509 SUM_NUMBER_OF_BYTES_FREE 16
510 LOW_COUNT_USED 0
511 CURRENT_COUNT_USED 1
512 HIGH_COUNT_USED 2
513 LOW_NUMBER_OF_BYTES_USED 0
514 CURRENT_NUMBER_OF_BYTES_USED 256
515 HIGH_NUMBER_OF_BYTES_USED 272
516 EVENT_NAME memory/sql/user_var_entry::value
517 COUNT_ALLOC 4
518 COUNT_FREE 0
519 SUM_NUMBER_OF_BYTES_ALLOC 7120
520 SUM_NUMBER_OF_BYTES_FREE 0
521 LOW_COUNT_USED 1
522 CURRENT_COUNT_USED 4
523 HIGH_COUNT_USED 4
524 LOW_NUMBER_OF_BYTES_USED 96
525 CURRENT_NUMBER_OF_BYTES_USED 7120
526 HIGH_NUMBER_OF_BYTES_USED 7120
527 execute dump_accounts;
528 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
529 root localhost 1 1
530 user1 localhost 1 1
531 user2 localhost 1 1
532 execute dump_users;
533 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
534 root 1 1
535 user1 1 1
536 user2 1 1
537 execute dump_hosts;
538 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
539 connection con2;
540 set GLOBAL query_cache_size=2000*1024;
541 select get_lock("marker_2", 10);
542 get_lock("marker_2", 10)
543 1
544 select release_lock("marker_2");
545 release_lock("marker_2")
546 1
547 set @v1 = repeat("a", 1000);
548 set @v2 = repeat("b", 2000);
549 set @v3 = repeat("c", 4000);
550 "================== con2 marker =================="
551 connection default;
552 "================== Step 5 =================="
553 call dump_thread();
554 username user1
555 EVENT_NAME memory/sql/User_level_lock
556 COUNT_ALLOC 2
557 COUNT_FREE 1
558 SUM_NUMBER_OF_BYTES_ALLOC 272
559 SUM_NUMBER_OF_BYTES_FREE 16
560 LOW_COUNT_USED 0
561 CURRENT_COUNT_USED 1
562 HIGH_COUNT_USED 2
563 LOW_NUMBER_OF_BYTES_USED 0
564 CURRENT_NUMBER_OF_BYTES_USED 256
565 HIGH_NUMBER_OF_BYTES_USED 272
566 username user1
567 EVENT_NAME memory/sql/user_var_entry::value
568 COUNT_ALLOC 3
569 COUNT_FREE 0
570 SUM_NUMBER_OF_BYTES_ALLOC 7024
571 SUM_NUMBER_OF_BYTES_FREE 0
572 LOW_COUNT_USED 0
573 CURRENT_COUNT_USED 3
574 HIGH_COUNT_USED 3
575 LOW_NUMBER_OF_BYTES_USED 0
576 CURRENT_NUMBER_OF_BYTES_USED 7024
577 HIGH_NUMBER_OF_BYTES_USED 7024
578 username user2
579 EVENT_NAME memory/sql/User_level_lock
580 COUNT_ALLOC 2
581 COUNT_FREE 1
582 SUM_NUMBER_OF_BYTES_ALLOC 272
583 SUM_NUMBER_OF_BYTES_FREE 16
584 LOW_COUNT_USED 0
585 CURRENT_COUNT_USED 1
586 HIGH_COUNT_USED 2
587 LOW_NUMBER_OF_BYTES_USED 0
588 CURRENT_NUMBER_OF_BYTES_USED 256
589 HIGH_NUMBER_OF_BYTES_USED 272
590 username user2
591 EVENT_NAME memory/sql/user_var_entry::value
592 COUNT_ALLOC 3
593 COUNT_FREE 0
594 SUM_NUMBER_OF_BYTES_ALLOC 7024
595 SUM_NUMBER_OF_BYTES_FREE 0
596 LOW_COUNT_USED 0
597 CURRENT_COUNT_USED 3
598 HIGH_COUNT_USED 3
599 LOW_NUMBER_OF_BYTES_USED 0
600 CURRENT_NUMBER_OF_BYTES_USED 7024
601 HIGH_NUMBER_OF_BYTES_USED 7024
602 username user3
603 status not found
604 username user4
605 status not found
606 execute dump_memory_account;
607 USER user1
608 HOST localhost
609 EVENT_NAME memory/sql/User_level_lock
610 COUNT_ALLOC 2
611 COUNT_FREE 1
612 SUM_NUMBER_OF_BYTES_ALLOC 272
613 SUM_NUMBER_OF_BYTES_FREE 16
614 LOW_COUNT_USED 0
615 CURRENT_COUNT_USED 1
616 HIGH_COUNT_USED 2
617 LOW_NUMBER_OF_BYTES_USED 0
618 CURRENT_NUMBER_OF_BYTES_USED 256
619 HIGH_NUMBER_OF_BYTES_USED 272
620 USER user1
621 HOST localhost
622 EVENT_NAME memory/sql/user_var_entry::value
623 COUNT_ALLOC 3
624 COUNT_FREE 0
625 SUM_NUMBER_OF_BYTES_ALLOC 7024
626 SUM_NUMBER_OF_BYTES_FREE 0
627 LOW_COUNT_USED 0
628 CURRENT_COUNT_USED 3
629 HIGH_COUNT_USED 3
630 LOW_NUMBER_OF_BYTES_USED 0
631 CURRENT_NUMBER_OF_BYTES_USED 7024
632 HIGH_NUMBER_OF_BYTES_USED 7024
633 USER user2
634 HOST localhost
635 EVENT_NAME memory/sql/User_level_lock
636 COUNT_ALLOC 2
637 COUNT_FREE 1
638 SUM_NUMBER_OF_BYTES_ALLOC 272
639 SUM_NUMBER_OF_BYTES_FREE 16
640 LOW_COUNT_USED 0
641 CURRENT_COUNT_USED 1
642 HIGH_COUNT_USED 2
643 LOW_NUMBER_OF_BYTES_USED 0
644 CURRENT_NUMBER_OF_BYTES_USED 256
645 HIGH_NUMBER_OF_BYTES_USED 272
646 USER user2
647 HOST localhost
648 EVENT_NAME memory/sql/user_var_entry::value
649 COUNT_ALLOC 3
650 COUNT_FREE 0
651 SUM_NUMBER_OF_BYTES_ALLOC 7024
652 SUM_NUMBER_OF_BYTES_FREE 0
653 LOW_COUNT_USED 0
654 CURRENT_COUNT_USED 3
655 HIGH_COUNT_USED 3
656 LOW_NUMBER_OF_BYTES_USED 0
657 CURRENT_NUMBER_OF_BYTES_USED 7024
658 HIGH_NUMBER_OF_BYTES_USED 7024
659 execute dump_memory_user;
660 USER user1
661 EVENT_NAME memory/sql/User_level_lock
662 COUNT_ALLOC 2
663 COUNT_FREE 1
664 SUM_NUMBER_OF_BYTES_ALLOC 272
665 SUM_NUMBER_OF_BYTES_FREE 16
666 LOW_COUNT_USED 0
667 CURRENT_COUNT_USED 1
668 HIGH_COUNT_USED 2
669 LOW_NUMBER_OF_BYTES_USED 0
670 CURRENT_NUMBER_OF_BYTES_USED 256
671 HIGH_NUMBER_OF_BYTES_USED 272
672 USER user1
673 EVENT_NAME memory/sql/user_var_entry::value
674 COUNT_ALLOC 3
675 COUNT_FREE 0
676 SUM_NUMBER_OF_BYTES_ALLOC 7024
677 SUM_NUMBER_OF_BYTES_FREE 0
678 LOW_COUNT_USED 0
679 CURRENT_COUNT_USED 3
680 HIGH_COUNT_USED 3
681 LOW_NUMBER_OF_BYTES_USED 0
682 CURRENT_NUMBER_OF_BYTES_USED 7024
683 HIGH_NUMBER_OF_BYTES_USED 7024
684 USER user2
685 EVENT_NAME memory/sql/User_level_lock
686 COUNT_ALLOC 2
687 COUNT_FREE 1
688 SUM_NUMBER_OF_BYTES_ALLOC 272
689 SUM_NUMBER_OF_BYTES_FREE 16
690 LOW_COUNT_USED 0
691 CURRENT_COUNT_USED 1
692 HIGH_COUNT_USED 2
693 LOW_NUMBER_OF_BYTES_USED 0
694 CURRENT_NUMBER_OF_BYTES_USED 256
695 HIGH_NUMBER_OF_BYTES_USED 272
696 USER user2
697 EVENT_NAME memory/sql/user_var_entry::value
698 COUNT_ALLOC 3
699 COUNT_FREE 0
700 SUM_NUMBER_OF_BYTES_ALLOC 7024
701 SUM_NUMBER_OF_BYTES_FREE 0
702 LOW_COUNT_USED 0
703 CURRENT_COUNT_USED 3
704 HIGH_COUNT_USED 3
705 LOW_NUMBER_OF_BYTES_USED 0
706 CURRENT_NUMBER_OF_BYTES_USED 7024
707 HIGH_NUMBER_OF_BYTES_USED 7024
708 execute dump_memory_host;
709 execute dump_memory_global;
710 EVENT_NAME memory/sql/Query_cache
711 COUNT_ALLOC 4
712 COUNT_FREE 2
713 SUM_NUMBER_OF_BYTES_ALLOC 65536
714 SUM_NUMBER_OF_BYTES_FREE 32768
715 LOW_COUNT_USED 0
716 CURRENT_COUNT_USED 2
717 HIGH_COUNT_USED 2
718 LOW_NUMBER_OF_BYTES_USED 0
719 CURRENT_NUMBER_OF_BYTES_USED 32768
720 HIGH_NUMBER_OF_BYTES_USED 32768
721 EVENT_NAME memory/sql/User_level_lock
722 COUNT_ALLOC 4
723 COUNT_FREE 2
724 SUM_NUMBER_OF_BYTES_ALLOC 544
725 SUM_NUMBER_OF_BYTES_FREE 32
726 LOW_COUNT_USED 0
727 CURRENT_COUNT_USED 2
728 HIGH_COUNT_USED 4
729 LOW_NUMBER_OF_BYTES_USED 0
730 CURRENT_NUMBER_OF_BYTES_USED 512
731 HIGH_NUMBER_OF_BYTES_USED 544
732 EVENT_NAME memory/sql/user_var_entry::value
733 COUNT_ALLOC 7
734 COUNT_FREE 0
735 SUM_NUMBER_OF_BYTES_ALLOC 14144
736 SUM_NUMBER_OF_BYTES_FREE 0
737 LOW_COUNT_USED 1
738 CURRENT_COUNT_USED 7
739 HIGH_COUNT_USED 7
740 LOW_NUMBER_OF_BYTES_USED 96
741 CURRENT_NUMBER_OF_BYTES_USED 14144
742 HIGH_NUMBER_OF_BYTES_USED 14144
743 execute dump_accounts;
744 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
745 root localhost 1 1
746 user1 localhost 1 1
747 user2 localhost 1 1
748 execute dump_users;
749 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
750 root 1 1
751 user1 1 1
752 user2 1 1
753 execute dump_hosts;
754 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
755 truncate table performance_schema.memory_summary_by_thread_by_event_name;
756 "================== MEMORY_BY_THREAD truncated =================="
757 "================== Step 5b =================="
758 call dump_thread();
759 username user1
760 EVENT_NAME memory/sql/User_level_lock
761 COUNT_ALLOC 1
762 COUNT_FREE 0
763 SUM_NUMBER_OF_BYTES_ALLOC 256
764 SUM_NUMBER_OF_BYTES_FREE 0
765 LOW_COUNT_USED 1
766 CURRENT_COUNT_USED 1
767 HIGH_COUNT_USED 1
768 LOW_NUMBER_OF_BYTES_USED 256
769 CURRENT_NUMBER_OF_BYTES_USED 256
770 HIGH_NUMBER_OF_BYTES_USED 256
771 username user1
772 EVENT_NAME memory/sql/user_var_entry::value
773 COUNT_ALLOC 3
774 COUNT_FREE 0
775 SUM_NUMBER_OF_BYTES_ALLOC 7024
776 SUM_NUMBER_OF_BYTES_FREE 0
777 LOW_COUNT_USED 3
778 CURRENT_COUNT_USED 3
779 HIGH_COUNT_USED 3
780 LOW_NUMBER_OF_BYTES_USED 7024
781 CURRENT_NUMBER_OF_BYTES_USED 7024
782 HIGH_NUMBER_OF_BYTES_USED 7024
783 username user2
784 EVENT_NAME memory/sql/User_level_lock
785 COUNT_ALLOC 1
786 COUNT_FREE 0
787 SUM_NUMBER_OF_BYTES_ALLOC 256
788 SUM_NUMBER_OF_BYTES_FREE 0
789 LOW_COUNT_USED 1
790 CURRENT_COUNT_USED 1
791 HIGH_COUNT_USED 1
792 LOW_NUMBER_OF_BYTES_USED 256
793 CURRENT_NUMBER_OF_BYTES_USED 256
794 HIGH_NUMBER_OF_BYTES_USED 256
795 username user2
796 EVENT_NAME memory/sql/user_var_entry::value
797 COUNT_ALLOC 3
798 COUNT_FREE 0
799 SUM_NUMBER_OF_BYTES_ALLOC 7024
800 SUM_NUMBER_OF_BYTES_FREE 0
801 LOW_COUNT_USED 3
802 CURRENT_COUNT_USED 3
803 HIGH_COUNT_USED 3
804 LOW_NUMBER_OF_BYTES_USED 7024
805 CURRENT_NUMBER_OF_BYTES_USED 7024
806 HIGH_NUMBER_OF_BYTES_USED 7024
807 username user3
808 status not found
809 username user4
810 status not found
811 execute dump_memory_account;
812 USER user1
813 HOST localhost
814 EVENT_NAME memory/sql/User_level_lock
815 COUNT_ALLOC 2
816 COUNT_FREE 1
817 SUM_NUMBER_OF_BYTES_ALLOC 272
818 SUM_NUMBER_OF_BYTES_FREE 16
819 LOW_COUNT_USED 0
820 CURRENT_COUNT_USED 1
821 HIGH_COUNT_USED 2
822 LOW_NUMBER_OF_BYTES_USED 0
823 CURRENT_NUMBER_OF_BYTES_USED 256
824 HIGH_NUMBER_OF_BYTES_USED 272
825 USER user1
826 HOST localhost
827 EVENT_NAME memory/sql/user_var_entry::value
828 COUNT_ALLOC 3
829 COUNT_FREE 0
830 SUM_NUMBER_OF_BYTES_ALLOC 7024
831 SUM_NUMBER_OF_BYTES_FREE 0
832 LOW_COUNT_USED 0
833 CURRENT_COUNT_USED 3
834 HIGH_COUNT_USED 3
835 LOW_NUMBER_OF_BYTES_USED 0
836 CURRENT_NUMBER_OF_BYTES_USED 7024
837 HIGH_NUMBER_OF_BYTES_USED 7024
838 USER user2
839 HOST localhost
840 EVENT_NAME memory/sql/User_level_lock
841 COUNT_ALLOC 2
842 COUNT_FREE 1
843 SUM_NUMBER_OF_BYTES_ALLOC 272
844 SUM_NUMBER_OF_BYTES_FREE 16
845 LOW_COUNT_USED 0
846 CURRENT_COUNT_USED 1
847 HIGH_COUNT_USED 2
848 LOW_NUMBER_OF_BYTES_USED 0
849 CURRENT_NUMBER_OF_BYTES_USED 256
850 HIGH_NUMBER_OF_BYTES_USED 272
851 USER user2
852 HOST localhost
853 EVENT_NAME memory/sql/user_var_entry::value
854 COUNT_ALLOC 3
855 COUNT_FREE 0
856 SUM_NUMBER_OF_BYTES_ALLOC 7024
857 SUM_NUMBER_OF_BYTES_FREE 0
858 LOW_COUNT_USED 0
859 CURRENT_COUNT_USED 3
860 HIGH_COUNT_USED 3
861 LOW_NUMBER_OF_BYTES_USED 0
862 CURRENT_NUMBER_OF_BYTES_USED 7024
863 HIGH_NUMBER_OF_BYTES_USED 7024
864 execute dump_memory_user;
865 USER user1
866 EVENT_NAME memory/sql/User_level_lock
867 COUNT_ALLOC 2
868 COUNT_FREE 1
869 SUM_NUMBER_OF_BYTES_ALLOC 272
870 SUM_NUMBER_OF_BYTES_FREE 16
871 LOW_COUNT_USED 0
872 CURRENT_COUNT_USED 1
873 HIGH_COUNT_USED 2
874 LOW_NUMBER_OF_BYTES_USED 0
875 CURRENT_NUMBER_OF_BYTES_USED 256
876 HIGH_NUMBER_OF_BYTES_USED 272
877 USER user1
878 EVENT_NAME memory/sql/user_var_entry::value
879 COUNT_ALLOC 3
880 COUNT_FREE 0
881 SUM_NUMBER_OF_BYTES_ALLOC 7024
882 SUM_NUMBER_OF_BYTES_FREE 0
883 LOW_COUNT_USED 0
884 CURRENT_COUNT_USED 3
885 HIGH_COUNT_USED 3
886 LOW_NUMBER_OF_BYTES_USED 0
887 CURRENT_NUMBER_OF_BYTES_USED 7024
888 HIGH_NUMBER_OF_BYTES_USED 7024
889 USER user2
890 EVENT_NAME memory/sql/User_level_lock
891 COUNT_ALLOC 2
892 COUNT_FREE 1
893 SUM_NUMBER_OF_BYTES_ALLOC 272
894 SUM_NUMBER_OF_BYTES_FREE 16
895 LOW_COUNT_USED 0
896 CURRENT_COUNT_USED 1
897 HIGH_COUNT_USED 2
898 LOW_NUMBER_OF_BYTES_USED 0
899 CURRENT_NUMBER_OF_BYTES_USED 256
900 HIGH_NUMBER_OF_BYTES_USED 272
901 USER user2
902 EVENT_NAME memory/sql/user_var_entry::value
903 COUNT_ALLOC 3
904 COUNT_FREE 0
905 SUM_NUMBER_OF_BYTES_ALLOC 7024
906 SUM_NUMBER_OF_BYTES_FREE 0
907 LOW_COUNT_USED 0
908 CURRENT_COUNT_USED 3
909 HIGH_COUNT_USED 3
910 LOW_NUMBER_OF_BYTES_USED 0
911 CURRENT_NUMBER_OF_BYTES_USED 7024
912 HIGH_NUMBER_OF_BYTES_USED 7024
913 execute dump_memory_host;
914 execute dump_memory_global;
915 EVENT_NAME memory/sql/Query_cache
916 COUNT_ALLOC 4
917 COUNT_FREE 2
918 SUM_NUMBER_OF_BYTES_ALLOC 65536
919 SUM_NUMBER_OF_BYTES_FREE 32768
920 LOW_COUNT_USED 0
921 CURRENT_COUNT_USED 2
922 HIGH_COUNT_USED 2
923 LOW_NUMBER_OF_BYTES_USED 0
924 CURRENT_NUMBER_OF_BYTES_USED 32768
925 HIGH_NUMBER_OF_BYTES_USED 32768
926 EVENT_NAME memory/sql/User_level_lock
927 COUNT_ALLOC 4
928 COUNT_FREE 2
929 SUM_NUMBER_OF_BYTES_ALLOC 544
930 SUM_NUMBER_OF_BYTES_FREE 32
931 LOW_COUNT_USED 0
932 CURRENT_COUNT_USED 2
933 HIGH_COUNT_USED 4
934 LOW_NUMBER_OF_BYTES_USED 0
935 CURRENT_NUMBER_OF_BYTES_USED 512
936 HIGH_NUMBER_OF_BYTES_USED 544
937 EVENT_NAME memory/sql/user_var_entry::value
938 COUNT_ALLOC 7
939 COUNT_FREE 0
940 SUM_NUMBER_OF_BYTES_ALLOC 14144
941 SUM_NUMBER_OF_BYTES_FREE 0
942 LOW_COUNT_USED 1
943 CURRENT_COUNT_USED 7
944 HIGH_COUNT_USED 7
945 LOW_NUMBER_OF_BYTES_USED 96
946 CURRENT_NUMBER_OF_BYTES_USED 14144
947 HIGH_NUMBER_OF_BYTES_USED 14144
948 execute dump_accounts;
949 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
950 root localhost 1 1
951 user1 localhost 1 1
952 user2 localhost 1 1
953 execute dump_users;
954 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
955 root 1 1
956 user1 1 1
957 user2 1 1
958 execute dump_hosts;
959 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
960 connect con3, localhost, user3, , ;
961 "================== con3 connected =================="
962 connection default;
963 "================== Step 6 =================="
964 call dump_thread();
965 username user1
966 EVENT_NAME memory/sql/User_level_lock
967 COUNT_ALLOC 1
968 COUNT_FREE 0
969 SUM_NUMBER_OF_BYTES_ALLOC 256
970 SUM_NUMBER_OF_BYTES_FREE 0
971 LOW_COUNT_USED 1
972 CURRENT_COUNT_USED 1
973 HIGH_COUNT_USED 1
974 LOW_NUMBER_OF_BYTES_USED 256
975 CURRENT_NUMBER_OF_BYTES_USED 256
976 HIGH_NUMBER_OF_BYTES_USED 256
977 username user1
978 EVENT_NAME memory/sql/user_var_entry::value
979 COUNT_ALLOC 3
980 COUNT_FREE 0
981 SUM_NUMBER_OF_BYTES_ALLOC 7024
982 SUM_NUMBER_OF_BYTES_FREE 0
983 LOW_COUNT_USED 3
984 CURRENT_COUNT_USED 3
985 HIGH_COUNT_USED 3
986 LOW_NUMBER_OF_BYTES_USED 7024
987 CURRENT_NUMBER_OF_BYTES_USED 7024
988 HIGH_NUMBER_OF_BYTES_USED 7024
989 username user2
990 EVENT_NAME memory/sql/User_level_lock
991 COUNT_ALLOC 1
992 COUNT_FREE 0
993 SUM_NUMBER_OF_BYTES_ALLOC 256
994 SUM_NUMBER_OF_BYTES_FREE 0
995 LOW_COUNT_USED 1
996 CURRENT_COUNT_USED 1
997 HIGH_COUNT_USED 1
998 LOW_NUMBER_OF_BYTES_USED 256
999 CURRENT_NUMBER_OF_BYTES_USED 256
1000 HIGH_NUMBER_OF_BYTES_USED 256
1001 username user2
1002 EVENT_NAME memory/sql/user_var_entry::value
1003 COUNT_ALLOC 3
1004 COUNT_FREE 0
1005 SUM_NUMBER_OF_BYTES_ALLOC 7024
1006 SUM_NUMBER_OF_BYTES_FREE 0
1007 LOW_COUNT_USED 3
1008 CURRENT_COUNT_USED 3
1009 HIGH_COUNT_USED 3
1010 LOW_NUMBER_OF_BYTES_USED 7024
1011 CURRENT_NUMBER_OF_BYTES_USED 7024
1012 HIGH_NUMBER_OF_BYTES_USED 7024
1013 username user3
1014 EVENT_NAME memory/sql/User_level_lock
1015 COUNT_ALLOC 0
1016 COUNT_FREE 0
1017 SUM_NUMBER_OF_BYTES_ALLOC 0
1018 SUM_NUMBER_OF_BYTES_FREE 0
1019 LOW_COUNT_USED 0
1020 CURRENT_COUNT_USED 0
1021 HIGH_COUNT_USED 0
1022 LOW_NUMBER_OF_BYTES_USED 0
1023 CURRENT_NUMBER_OF_BYTES_USED 0
1024 HIGH_NUMBER_OF_BYTES_USED 0
1025 username user3
1026 EVENT_NAME memory/sql/user_var_entry::value
1027 COUNT_ALLOC 0
1028 COUNT_FREE 0
1029 SUM_NUMBER_OF_BYTES_ALLOC 0
1030 SUM_NUMBER_OF_BYTES_FREE 0
1031 LOW_COUNT_USED 0
1032 CURRENT_COUNT_USED 0
1033 HIGH_COUNT_USED 0
1034 LOW_NUMBER_OF_BYTES_USED 0
1035 CURRENT_NUMBER_OF_BYTES_USED 0
1036 HIGH_NUMBER_OF_BYTES_USED 0
1037 username user4
1038 status not found
1039 execute dump_memory_account;
1040 USER user1
1041 HOST localhost
1042 EVENT_NAME memory/sql/User_level_lock
1043 COUNT_ALLOC 2
1044 COUNT_FREE 1
1045 SUM_NUMBER_OF_BYTES_ALLOC 272
1046 SUM_NUMBER_OF_BYTES_FREE 16
1047 LOW_COUNT_USED 0
1048 CURRENT_COUNT_USED 1
1049 HIGH_COUNT_USED 2
1050 LOW_NUMBER_OF_BYTES_USED 0
1051 CURRENT_NUMBER_OF_BYTES_USED 256
1052 HIGH_NUMBER_OF_BYTES_USED 272
1053 USER user1
1054 HOST localhost
1055 EVENT_NAME memory/sql/user_var_entry::value
1056 COUNT_ALLOC 3
1057 COUNT_FREE 0
1058 SUM_NUMBER_OF_BYTES_ALLOC 7024
1059 SUM_NUMBER_OF_BYTES_FREE 0
1060 LOW_COUNT_USED 0
1061 CURRENT_COUNT_USED 3
1062 HIGH_COUNT_USED 3
1063 LOW_NUMBER_OF_BYTES_USED 0
1064 CURRENT_NUMBER_OF_BYTES_USED 7024
1065 HIGH_NUMBER_OF_BYTES_USED 7024
1066 USER user2
1067 HOST localhost
1068 EVENT_NAME memory/sql/User_level_lock
1069 COUNT_ALLOC 2
1070 COUNT_FREE 1
1071 SUM_NUMBER_OF_BYTES_ALLOC 272
1072 SUM_NUMBER_OF_BYTES_FREE 16
1073 LOW_COUNT_USED 0
1074 CURRENT_COUNT_USED 1
1075 HIGH_COUNT_USED 2
1076 LOW_NUMBER_OF_BYTES_USED 0
1077 CURRENT_NUMBER_OF_BYTES_USED 256
1078 HIGH_NUMBER_OF_BYTES_USED 272
1079 USER user2
1080 HOST localhost
1081 EVENT_NAME memory/sql/user_var_entry::value
1082 COUNT_ALLOC 3
1083 COUNT_FREE 0
1084 SUM_NUMBER_OF_BYTES_ALLOC 7024
1085 SUM_NUMBER_OF_BYTES_FREE 0
1086 LOW_COUNT_USED 0
1087 CURRENT_COUNT_USED 3
1088 HIGH_COUNT_USED 3
1089 LOW_NUMBER_OF_BYTES_USED 0
1090 CURRENT_NUMBER_OF_BYTES_USED 7024
1091 HIGH_NUMBER_OF_BYTES_USED 7024
1092 USER user3
1093 HOST localhost
1094 EVENT_NAME memory/sql/User_level_lock
1095 COUNT_ALLOC 0
1096 COUNT_FREE 0
1097 SUM_NUMBER_OF_BYTES_ALLOC 0
1098 SUM_NUMBER_OF_BYTES_FREE 0
1099 LOW_COUNT_USED 0
1100 CURRENT_COUNT_USED 0
1101 HIGH_COUNT_USED 0
1102 LOW_NUMBER_OF_BYTES_USED 0
1103 CURRENT_NUMBER_OF_BYTES_USED 0
1104 HIGH_NUMBER_OF_BYTES_USED 0
1105 USER user3
1106 HOST localhost
1107 EVENT_NAME memory/sql/user_var_entry::value
1108 COUNT_ALLOC 0
1109 COUNT_FREE 0
1110 SUM_NUMBER_OF_BYTES_ALLOC 0
1111 SUM_NUMBER_OF_BYTES_FREE 0
1112 LOW_COUNT_USED 0
1113 CURRENT_COUNT_USED 0
1114 HIGH_COUNT_USED 0
1115 LOW_NUMBER_OF_BYTES_USED 0
1116 CURRENT_NUMBER_OF_BYTES_USED 0
1117 HIGH_NUMBER_OF_BYTES_USED 0
1118 execute dump_memory_user;
1119 USER user1
1120 EVENT_NAME memory/sql/User_level_lock
1121 COUNT_ALLOC 2
1122 COUNT_FREE 1
1123 SUM_NUMBER_OF_BYTES_ALLOC 272
1124 SUM_NUMBER_OF_BYTES_FREE 16
1125 LOW_COUNT_USED 0
1126 CURRENT_COUNT_USED 1
1127 HIGH_COUNT_USED 2
1128 LOW_NUMBER_OF_BYTES_USED 0
1129 CURRENT_NUMBER_OF_BYTES_USED 256
1130 HIGH_NUMBER_OF_BYTES_USED 272
1131 USER user1
1132 EVENT_NAME memory/sql/user_var_entry::value
1133 COUNT_ALLOC 3
1134 COUNT_FREE 0
1135 SUM_NUMBER_OF_BYTES_ALLOC 7024
1136 SUM_NUMBER_OF_BYTES_FREE 0
1137 LOW_COUNT_USED 0
1138 CURRENT_COUNT_USED 3
1139 HIGH_COUNT_USED 3
1140 LOW_NUMBER_OF_BYTES_USED 0
1141 CURRENT_NUMBER_OF_BYTES_USED 7024
1142 HIGH_NUMBER_OF_BYTES_USED 7024
1143 USER user2
1144 EVENT_NAME memory/sql/User_level_lock
1145 COUNT_ALLOC 2
1146 COUNT_FREE 1
1147 SUM_NUMBER_OF_BYTES_ALLOC 272
1148 SUM_NUMBER_OF_BYTES_FREE 16
1149 LOW_COUNT_USED 0
1150 CURRENT_COUNT_USED 1
1151 HIGH_COUNT_USED 2
1152 LOW_NUMBER_OF_BYTES_USED 0
1153 CURRENT_NUMBER_OF_BYTES_USED 256
1154 HIGH_NUMBER_OF_BYTES_USED 272
1155 USER user2
1156 EVENT_NAME memory/sql/user_var_entry::value
1157 COUNT_ALLOC 3
1158 COUNT_FREE 0
1159 SUM_NUMBER_OF_BYTES_ALLOC 7024
1160 SUM_NUMBER_OF_BYTES_FREE 0
1161 LOW_COUNT_USED 0
1162 CURRENT_COUNT_USED 3
1163 HIGH_COUNT_USED 3
1164 LOW_NUMBER_OF_BYTES_USED 0
1165 CURRENT_NUMBER_OF_BYTES_USED 7024
1166 HIGH_NUMBER_OF_BYTES_USED 7024
1167 USER user3
1168 EVENT_NAME memory/sql/User_level_lock
1169 COUNT_ALLOC 0
1170 COUNT_FREE 0
1171 SUM_NUMBER_OF_BYTES_ALLOC 0
1172 SUM_NUMBER_OF_BYTES_FREE 0
1173 LOW_COUNT_USED 0
1174 CURRENT_COUNT_USED 0
1175 HIGH_COUNT_USED 0
1176 LOW_NUMBER_OF_BYTES_USED 0
1177 CURRENT_NUMBER_OF_BYTES_USED 0
1178 HIGH_NUMBER_OF_BYTES_USED 0
1179 USER user3
1180 EVENT_NAME memory/sql/user_var_entry::value
1181 COUNT_ALLOC 0
1182 COUNT_FREE 0
1183 SUM_NUMBER_OF_BYTES_ALLOC 0
1184 SUM_NUMBER_OF_BYTES_FREE 0
1185 LOW_COUNT_USED 0
1186 CURRENT_COUNT_USED 0
1187 HIGH_COUNT_USED 0
1188 LOW_NUMBER_OF_BYTES_USED 0
1189 CURRENT_NUMBER_OF_BYTES_USED 0
1190 HIGH_NUMBER_OF_BYTES_USED 0
1191 execute dump_memory_host;
1192 execute dump_memory_global;
1193 EVENT_NAME memory/sql/Query_cache
1194 COUNT_ALLOC 4
1195 COUNT_FREE 2
1196 SUM_NUMBER_OF_BYTES_ALLOC 65536
1197 SUM_NUMBER_OF_BYTES_FREE 32768
1198 LOW_COUNT_USED 0
1199 CURRENT_COUNT_USED 2
1200 HIGH_COUNT_USED 2
1201 LOW_NUMBER_OF_BYTES_USED 0
1202 CURRENT_NUMBER_OF_BYTES_USED 32768
1203 HIGH_NUMBER_OF_BYTES_USED 32768
1204 EVENT_NAME memory/sql/User_level_lock
1205 COUNT_ALLOC 4
1206 COUNT_FREE 2
1207 SUM_NUMBER_OF_BYTES_ALLOC 544
1208 SUM_NUMBER_OF_BYTES_FREE 32
1209 LOW_COUNT_USED 0
1210 CURRENT_COUNT_USED 2
1211 HIGH_COUNT_USED 4
1212 LOW_NUMBER_OF_BYTES_USED 0
1213 CURRENT_NUMBER_OF_BYTES_USED 512
1214 HIGH_NUMBER_OF_BYTES_USED 544
1215 EVENT_NAME memory/sql/user_var_entry::value
1216 COUNT_ALLOC 7
1217 COUNT_FREE 0
1218 SUM_NUMBER_OF_BYTES_ALLOC 14144
1219 SUM_NUMBER_OF_BYTES_FREE 0
1220 LOW_COUNT_USED 1
1221 CURRENT_COUNT_USED 7
1222 HIGH_COUNT_USED 7
1223 LOW_NUMBER_OF_BYTES_USED 96
1224 CURRENT_NUMBER_OF_BYTES_USED 14144
1225 HIGH_NUMBER_OF_BYTES_USED 14144
1226 execute dump_accounts;
1227 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1228 root localhost 1 1
1229 user1 localhost 1 1
1230 user2 localhost 1 1
1231 user3 localhost 1 1
1232 execute dump_users;
1233 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1234 root 1 1
1235 user1 1 1
1236 user2 1 1
1237 user3 1 1
1238 execute dump_hosts;
1239 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1240 connection con3;
1241 set GLOBAL query_cache_size=500*1024;
1242 select get_lock("marker_3", 10);
1243 get_lock("marker_3", 10)
1244 1
1245 select release_lock("marker_3");
1246 release_lock("marker_3")
1247 1
1248 set @v1 = repeat("a", 1000);
1249 set @v2 = repeat("b", 2000);
1250 set @v3 = repeat("c", 4000);
1251 "================== con3 marker =================="
1252 connection default;
1253 "================== Step 7 =================="
1254 call dump_thread();
1255 username user1
1256 EVENT_NAME memory/sql/User_level_lock
1257 COUNT_ALLOC 1
1258 COUNT_FREE 0
1259 SUM_NUMBER_OF_BYTES_ALLOC 256
1260 SUM_NUMBER_OF_BYTES_FREE 0
1261 LOW_COUNT_USED 1
1262 CURRENT_COUNT_USED 1
1263 HIGH_COUNT_USED 1
1264 LOW_NUMBER_OF_BYTES_USED 256
1265 CURRENT_NUMBER_OF_BYTES_USED 256
1266 HIGH_NUMBER_OF_BYTES_USED 256
1267 username user1
1268 EVENT_NAME memory/sql/user_var_entry::value
1269 COUNT_ALLOC 3
1270 COUNT_FREE 0
1271 SUM_NUMBER_OF_BYTES_ALLOC 7024
1272 SUM_NUMBER_OF_BYTES_FREE 0
1273 LOW_COUNT_USED 3
1274 CURRENT_COUNT_USED 3
1275 HIGH_COUNT_USED 3
1276 LOW_NUMBER_OF_BYTES_USED 7024
1277 CURRENT_NUMBER_OF_BYTES_USED 7024
1278 HIGH_NUMBER_OF_BYTES_USED 7024
1279 username user2
1280 EVENT_NAME memory/sql/User_level_lock
1281 COUNT_ALLOC 1
1282 COUNT_FREE 0
1283 SUM_NUMBER_OF_BYTES_ALLOC 256
1284 SUM_NUMBER_OF_BYTES_FREE 0
1285 LOW_COUNT_USED 1
1286 CURRENT_COUNT_USED 1
1287 HIGH_COUNT_USED 1
1288 LOW_NUMBER_OF_BYTES_USED 256
1289 CURRENT_NUMBER_OF_BYTES_USED 256
1290 HIGH_NUMBER_OF_BYTES_USED 256
1291 username user2
1292 EVENT_NAME memory/sql/user_var_entry::value
1293 COUNT_ALLOC 3
1294 COUNT_FREE 0
1295 SUM_NUMBER_OF_BYTES_ALLOC 7024
1296 SUM_NUMBER_OF_BYTES_FREE 0
1297 LOW_COUNT_USED 3
1298 CURRENT_COUNT_USED 3
1299 HIGH_COUNT_USED 3
1300 LOW_NUMBER_OF_BYTES_USED 7024
1301 CURRENT_NUMBER_OF_BYTES_USED 7024
1302 HIGH_NUMBER_OF_BYTES_USED 7024
1303 username user3
1304 EVENT_NAME memory/sql/User_level_lock
1305 COUNT_ALLOC 2
1306 COUNT_FREE 1
1307 SUM_NUMBER_OF_BYTES_ALLOC 272
1308 SUM_NUMBER_OF_BYTES_FREE 16
1309 LOW_COUNT_USED 0
1310 CURRENT_COUNT_USED 1
1311 HIGH_COUNT_USED 2
1312 LOW_NUMBER_OF_BYTES_USED 0
1313 CURRENT_NUMBER_OF_BYTES_USED 256
1314 HIGH_NUMBER_OF_BYTES_USED 272
1315 username user3
1316 EVENT_NAME memory/sql/user_var_entry::value
1317 COUNT_ALLOC 3
1318 COUNT_FREE 0
1319 SUM_NUMBER_OF_BYTES_ALLOC 7024
1320 SUM_NUMBER_OF_BYTES_FREE 0
1321 LOW_COUNT_USED 0
1322 CURRENT_COUNT_USED 3
1323 HIGH_COUNT_USED 3
1324 LOW_NUMBER_OF_BYTES_USED 0
1325 CURRENT_NUMBER_OF_BYTES_USED 7024
1326 HIGH_NUMBER_OF_BYTES_USED 7024
1327 username user4
1328 status not found
1329 execute dump_memory_account;
1330 USER user1
1331 HOST localhost
1332 EVENT_NAME memory/sql/User_level_lock
1333 COUNT_ALLOC 2
1334 COUNT_FREE 1
1335 SUM_NUMBER_OF_BYTES_ALLOC 272
1336 SUM_NUMBER_OF_BYTES_FREE 16
1337 LOW_COUNT_USED 0
1338 CURRENT_COUNT_USED 1
1339 HIGH_COUNT_USED 2
1340 LOW_NUMBER_OF_BYTES_USED 0
1341 CURRENT_NUMBER_OF_BYTES_USED 256
1342 HIGH_NUMBER_OF_BYTES_USED 272
1343 USER user1
1344 HOST localhost
1345 EVENT_NAME memory/sql/user_var_entry::value
1346 COUNT_ALLOC 3
1347 COUNT_FREE 0
1348 SUM_NUMBER_OF_BYTES_ALLOC 7024
1349 SUM_NUMBER_OF_BYTES_FREE 0
1350 LOW_COUNT_USED 0
1351 CURRENT_COUNT_USED 3
1352 HIGH_COUNT_USED 3
1353 LOW_NUMBER_OF_BYTES_USED 0
1354 CURRENT_NUMBER_OF_BYTES_USED 7024
1355 HIGH_NUMBER_OF_BYTES_USED 7024
1356 USER user2
1357 HOST localhost
1358 EVENT_NAME memory/sql/User_level_lock
1359 COUNT_ALLOC 2
1360 COUNT_FREE 1
1361 SUM_NUMBER_OF_BYTES_ALLOC 272
1362 SUM_NUMBER_OF_BYTES_FREE 16
1363 LOW_COUNT_USED 0
1364 CURRENT_COUNT_USED 1
1365 HIGH_COUNT_USED 2
1366 LOW_NUMBER_OF_BYTES_USED 0
1367 CURRENT_NUMBER_OF_BYTES_USED 256
1368 HIGH_NUMBER_OF_BYTES_USED 272
1369 USER user2
1370 HOST localhost
1371 EVENT_NAME memory/sql/user_var_entry::value
1372 COUNT_ALLOC 3
1373 COUNT_FREE 0
1374 SUM_NUMBER_OF_BYTES_ALLOC 7024
1375 SUM_NUMBER_OF_BYTES_FREE 0
1376 LOW_COUNT_USED 0
1377 CURRENT_COUNT_USED 3
1378 HIGH_COUNT_USED 3
1379 LOW_NUMBER_OF_BYTES_USED 0
1380 CURRENT_NUMBER_OF_BYTES_USED 7024
1381 HIGH_NUMBER_OF_BYTES_USED 7024
1382 USER user3
1383 HOST localhost
1384 EVENT_NAME memory/sql/User_level_lock
1385 COUNT_ALLOC 2
1386 COUNT_FREE 1
1387 SUM_NUMBER_OF_BYTES_ALLOC 272
1388 SUM_NUMBER_OF_BYTES_FREE 16
1389 LOW_COUNT_USED 0
1390 CURRENT_COUNT_USED 1
1391 HIGH_COUNT_USED 2
1392 LOW_NUMBER_OF_BYTES_USED 0
1393 CURRENT_NUMBER_OF_BYTES_USED 256
1394 HIGH_NUMBER_OF_BYTES_USED 272
1395 USER user3
1396 HOST localhost
1397 EVENT_NAME memory/sql/user_var_entry::value
1398 COUNT_ALLOC 3
1399 COUNT_FREE 0
1400 SUM_NUMBER_OF_BYTES_ALLOC 7024
1401 SUM_NUMBER_OF_BYTES_FREE 0
1402 LOW_COUNT_USED 0
1403 CURRENT_COUNT_USED 3
1404 HIGH_COUNT_USED 3
1405 LOW_NUMBER_OF_BYTES_USED 0
1406 CURRENT_NUMBER_OF_BYTES_USED 7024
1407 HIGH_NUMBER_OF_BYTES_USED 7024
1408 execute dump_memory_user;
1409 USER user1
1410 EVENT_NAME memory/sql/User_level_lock
1411 COUNT_ALLOC 2
1412 COUNT_FREE 1
1413 SUM_NUMBER_OF_BYTES_ALLOC 272
1414 SUM_NUMBER_OF_BYTES_FREE 16
1415 LOW_COUNT_USED 0
1416 CURRENT_COUNT_USED 1
1417 HIGH_COUNT_USED 2
1418 LOW_NUMBER_OF_BYTES_USED 0
1419 CURRENT_NUMBER_OF_BYTES_USED 256
1420 HIGH_NUMBER_OF_BYTES_USED 272
1421 USER user1
1422 EVENT_NAME memory/sql/user_var_entry::value
1423 COUNT_ALLOC 3
1424 COUNT_FREE 0
1425 SUM_NUMBER_OF_BYTES_ALLOC 7024
1426 SUM_NUMBER_OF_BYTES_FREE 0
1427 LOW_COUNT_USED 0
1428 CURRENT_COUNT_USED 3
1429 HIGH_COUNT_USED 3
1430 LOW_NUMBER_OF_BYTES_USED 0
1431 CURRENT_NUMBER_OF_BYTES_USED 7024
1432 HIGH_NUMBER_OF_BYTES_USED 7024
1433 USER user2
1434 EVENT_NAME memory/sql/User_level_lock
1435 COUNT_ALLOC 2
1436 COUNT_FREE 1
1437 SUM_NUMBER_OF_BYTES_ALLOC 272
1438 SUM_NUMBER_OF_BYTES_FREE 16
1439 LOW_COUNT_USED 0
1440 CURRENT_COUNT_USED 1
1441 HIGH_COUNT_USED 2
1442 LOW_NUMBER_OF_BYTES_USED 0
1443 CURRENT_NUMBER_OF_BYTES_USED 256
1444 HIGH_NUMBER_OF_BYTES_USED 272
1445 USER user2
1446 EVENT_NAME memory/sql/user_var_entry::value
1447 COUNT_ALLOC 3
1448 COUNT_FREE 0
1449 SUM_NUMBER_OF_BYTES_ALLOC 7024
1450 SUM_NUMBER_OF_BYTES_FREE 0
1451 LOW_COUNT_USED 0
1452 CURRENT_COUNT_USED 3
1453 HIGH_COUNT_USED 3
1454 LOW_NUMBER_OF_BYTES_USED 0
1455 CURRENT_NUMBER_OF_BYTES_USED 7024
1456 HIGH_NUMBER_OF_BYTES_USED 7024
1457 USER user3
1458 EVENT_NAME memory/sql/User_level_lock
1459 COUNT_ALLOC 2
1460 COUNT_FREE 1
1461 SUM_NUMBER_OF_BYTES_ALLOC 272
1462 SUM_NUMBER_OF_BYTES_FREE 16
1463 LOW_COUNT_USED 0
1464 CURRENT_COUNT_USED 1
1465 HIGH_COUNT_USED 2
1466 LOW_NUMBER_OF_BYTES_USED 0
1467 CURRENT_NUMBER_OF_BYTES_USED 256
1468 HIGH_NUMBER_OF_BYTES_USED 272
1469 USER user3
1470 EVENT_NAME memory/sql/user_var_entry::value
1471 COUNT_ALLOC 3
1472 COUNT_FREE 0
1473 SUM_NUMBER_OF_BYTES_ALLOC 7024
1474 SUM_NUMBER_OF_BYTES_FREE 0
1475 LOW_COUNT_USED 0
1476 CURRENT_COUNT_USED 3
1477 HIGH_COUNT_USED 3
1478 LOW_NUMBER_OF_BYTES_USED 0
1479 CURRENT_NUMBER_OF_BYTES_USED 7024
1480 HIGH_NUMBER_OF_BYTES_USED 7024
1481 execute dump_memory_host;
1482 execute dump_memory_global;
1483 EVENT_NAME memory/sql/Query_cache
1484 COUNT_ALLOC 6
1485 COUNT_FREE 4
1486 SUM_NUMBER_OF_BYTES_ALLOC 98304
1487 SUM_NUMBER_OF_BYTES_FREE 65536
1488 LOW_COUNT_USED 0
1489 CURRENT_COUNT_USED 2
1490 HIGH_COUNT_USED 2
1491 LOW_NUMBER_OF_BYTES_USED 0
1492 CURRENT_NUMBER_OF_BYTES_USED 32768
1493 HIGH_NUMBER_OF_BYTES_USED 32768
1494 EVENT_NAME memory/sql/User_level_lock
1495 COUNT_ALLOC 6
1496 COUNT_FREE 3
1497 SUM_NUMBER_OF_BYTES_ALLOC 816
1498 SUM_NUMBER_OF_BYTES_FREE 48
1499 LOW_COUNT_USED 0
1500 CURRENT_COUNT_USED 3
1501 HIGH_COUNT_USED 6
1502 LOW_NUMBER_OF_BYTES_USED 0
1503 CURRENT_NUMBER_OF_BYTES_USED 768
1504 HIGH_NUMBER_OF_BYTES_USED 816
1505 EVENT_NAME memory/sql/user_var_entry::value
1506 COUNT_ALLOC 10
1507 COUNT_FREE 0
1508 SUM_NUMBER_OF_BYTES_ALLOC 21168
1509 SUM_NUMBER_OF_BYTES_FREE 0
1510 LOW_COUNT_USED 1
1511 CURRENT_COUNT_USED 10
1512 HIGH_COUNT_USED 10
1513 LOW_NUMBER_OF_BYTES_USED 96
1514 CURRENT_NUMBER_OF_BYTES_USED 21168
1515 HIGH_NUMBER_OF_BYTES_USED 21168
1516 execute dump_accounts;
1517 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1518 root localhost 1 1
1519 user1 localhost 1 1
1520 user2 localhost 1 1
1521 user3 localhost 1 1
1522 execute dump_users;
1523 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1524 root 1 1
1525 user1 1 1
1526 user2 1 1
1527 user3 1 1
1528 execute dump_hosts;
1529 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1530 connect con4, localhost, user4, , ;
1531 connect con5, localhost, user4, , ;
1532 "================== con4/con5 (both user4) connected =================="
1533 connection default;
1534 "================== Step 8 =================="
1535 call dump_thread();
1536 username user1
1537 EVENT_NAME memory/sql/User_level_lock
1538 COUNT_ALLOC 1
1539 COUNT_FREE 0
1540 SUM_NUMBER_OF_BYTES_ALLOC 256
1541 SUM_NUMBER_OF_BYTES_FREE 0
1542 LOW_COUNT_USED 1
1543 CURRENT_COUNT_USED 1
1544 HIGH_COUNT_USED 1
1545 LOW_NUMBER_OF_BYTES_USED 256
1546 CURRENT_NUMBER_OF_BYTES_USED 256
1547 HIGH_NUMBER_OF_BYTES_USED 256
1548 username user1
1549 EVENT_NAME memory/sql/user_var_entry::value
1550 COUNT_ALLOC 3
1551 COUNT_FREE 0
1552 SUM_NUMBER_OF_BYTES_ALLOC 7024
1553 SUM_NUMBER_OF_BYTES_FREE 0
1554 LOW_COUNT_USED 3
1555 CURRENT_COUNT_USED 3
1556 HIGH_COUNT_USED 3
1557 LOW_NUMBER_OF_BYTES_USED 7024
1558 CURRENT_NUMBER_OF_BYTES_USED 7024
1559 HIGH_NUMBER_OF_BYTES_USED 7024
1560 username user2
1561 EVENT_NAME memory/sql/User_level_lock
1562 COUNT_ALLOC 1
1563 COUNT_FREE 0
1564 SUM_NUMBER_OF_BYTES_ALLOC 256
1565 SUM_NUMBER_OF_BYTES_FREE 0
1566 LOW_COUNT_USED 1
1567 CURRENT_COUNT_USED 1
1568 HIGH_COUNT_USED 1
1569 LOW_NUMBER_OF_BYTES_USED 256
1570 CURRENT_NUMBER_OF_BYTES_USED 256
1571 HIGH_NUMBER_OF_BYTES_USED 256
1572 username user2
1573 EVENT_NAME memory/sql/user_var_entry::value
1574 COUNT_ALLOC 3
1575 COUNT_FREE 0
1576 SUM_NUMBER_OF_BYTES_ALLOC 7024
1577 SUM_NUMBER_OF_BYTES_FREE 0
1578 LOW_COUNT_USED 3
1579 CURRENT_COUNT_USED 3
1580 HIGH_COUNT_USED 3
1581 LOW_NUMBER_OF_BYTES_USED 7024
1582 CURRENT_NUMBER_OF_BYTES_USED 7024
1583 HIGH_NUMBER_OF_BYTES_USED 7024
1584 username user3
1585 EVENT_NAME memory/sql/User_level_lock
1586 COUNT_ALLOC 2
1587 COUNT_FREE 1
1588 SUM_NUMBER_OF_BYTES_ALLOC 272
1589 SUM_NUMBER_OF_BYTES_FREE 16
1590 LOW_COUNT_USED 0
1591 CURRENT_COUNT_USED 1
1592 HIGH_COUNT_USED 2
1593 LOW_NUMBER_OF_BYTES_USED 0
1594 CURRENT_NUMBER_OF_BYTES_USED 256
1595 HIGH_NUMBER_OF_BYTES_USED 272
1596 username user3
1597 EVENT_NAME memory/sql/user_var_entry::value
1598 COUNT_ALLOC 3
1599 COUNT_FREE 0
1600 SUM_NUMBER_OF_BYTES_ALLOC 7024
1601 SUM_NUMBER_OF_BYTES_FREE 0
1602 LOW_COUNT_USED 0
1603 CURRENT_COUNT_USED 3
1604 HIGH_COUNT_USED 3
1605 LOW_NUMBER_OF_BYTES_USED 0
1606 CURRENT_NUMBER_OF_BYTES_USED 7024
1607 HIGH_NUMBER_OF_BYTES_USED 7024
1608 username user4
1609 EVENT_NAME memory/sql/User_level_lock
1610 COUNT_ALLOC 0
1611 COUNT_FREE 0
1612 SUM_NUMBER_OF_BYTES_ALLOC 0
1613 SUM_NUMBER_OF_BYTES_FREE 0
1614 LOW_COUNT_USED 0
1615 CURRENT_COUNT_USED 0
1616 HIGH_COUNT_USED 0
1617 LOW_NUMBER_OF_BYTES_USED 0
1618 CURRENT_NUMBER_OF_BYTES_USED 0
1619 HIGH_NUMBER_OF_BYTES_USED 0
1620 username user4
1621 EVENT_NAME memory/sql/user_var_entry::value
1622 COUNT_ALLOC 0
1623 COUNT_FREE 0
1624 SUM_NUMBER_OF_BYTES_ALLOC 0
1625 SUM_NUMBER_OF_BYTES_FREE 0
1626 LOW_COUNT_USED 0
1627 CURRENT_COUNT_USED 0
1628 HIGH_COUNT_USED 0
1629 LOW_NUMBER_OF_BYTES_USED 0
1630 CURRENT_NUMBER_OF_BYTES_USED 0
1631 HIGH_NUMBER_OF_BYTES_USED 0
1632 execute dump_memory_account;
1633 USER user1
1634 HOST localhost
1635 EVENT_NAME memory/sql/User_level_lock
1636 COUNT_ALLOC 2
1637 COUNT_FREE 1
1638 SUM_NUMBER_OF_BYTES_ALLOC 272
1639 SUM_NUMBER_OF_BYTES_FREE 16
1640 LOW_COUNT_USED 0
1641 CURRENT_COUNT_USED 1
1642 HIGH_COUNT_USED 2
1643 LOW_NUMBER_OF_BYTES_USED 0
1644 CURRENT_NUMBER_OF_BYTES_USED 256
1645 HIGH_NUMBER_OF_BYTES_USED 272
1646 USER user1
1647 HOST localhost
1648 EVENT_NAME memory/sql/user_var_entry::value
1649 COUNT_ALLOC 3
1650 COUNT_FREE 0
1651 SUM_NUMBER_OF_BYTES_ALLOC 7024
1652 SUM_NUMBER_OF_BYTES_FREE 0
1653 LOW_COUNT_USED 0
1654 CURRENT_COUNT_USED 3
1655 HIGH_COUNT_USED 3
1656 LOW_NUMBER_OF_BYTES_USED 0
1657 CURRENT_NUMBER_OF_BYTES_USED 7024
1658 HIGH_NUMBER_OF_BYTES_USED 7024
1659 USER user2
1660 HOST localhost
1661 EVENT_NAME memory/sql/User_level_lock
1662 COUNT_ALLOC 2
1663 COUNT_FREE 1
1664 SUM_NUMBER_OF_BYTES_ALLOC 272
1665 SUM_NUMBER_OF_BYTES_FREE 16
1666 LOW_COUNT_USED 0
1667 CURRENT_COUNT_USED 1
1668 HIGH_COUNT_USED 2
1669 LOW_NUMBER_OF_BYTES_USED 0
1670 CURRENT_NUMBER_OF_BYTES_USED 256
1671 HIGH_NUMBER_OF_BYTES_USED 272
1672 USER user2
1673 HOST localhost
1674 EVENT_NAME memory/sql/user_var_entry::value
1675 COUNT_ALLOC 3
1676 COUNT_FREE 0
1677 SUM_NUMBER_OF_BYTES_ALLOC 7024
1678 SUM_NUMBER_OF_BYTES_FREE 0
1679 LOW_COUNT_USED 0
1680 CURRENT_COUNT_USED 3
1681 HIGH_COUNT_USED 3
1682 LOW_NUMBER_OF_BYTES_USED 0
1683 CURRENT_NUMBER_OF_BYTES_USED 7024
1684 HIGH_NUMBER_OF_BYTES_USED 7024
1685 USER user3
1686 HOST localhost
1687 EVENT_NAME memory/sql/User_level_lock
1688 COUNT_ALLOC 2
1689 COUNT_FREE 1
1690 SUM_NUMBER_OF_BYTES_ALLOC 272
1691 SUM_NUMBER_OF_BYTES_FREE 16
1692 LOW_COUNT_USED 0
1693 CURRENT_COUNT_USED 1
1694 HIGH_COUNT_USED 2
1695 LOW_NUMBER_OF_BYTES_USED 0
1696 CURRENT_NUMBER_OF_BYTES_USED 256
1697 HIGH_NUMBER_OF_BYTES_USED 272
1698 USER user3
1699 HOST localhost
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 USER user4
1712 HOST localhost
1713 EVENT_NAME memory/sql/User_level_lock
1714 COUNT_ALLOC 0
1715 COUNT_FREE 0
1716 SUM_NUMBER_OF_BYTES_ALLOC 0
1717 SUM_NUMBER_OF_BYTES_FREE 0
1718 LOW_COUNT_USED 0
1719 CURRENT_COUNT_USED 0
1720 HIGH_COUNT_USED 0
1721 LOW_NUMBER_OF_BYTES_USED 0
1722 CURRENT_NUMBER_OF_BYTES_USED 0
1723 HIGH_NUMBER_OF_BYTES_USED 0
1724 USER user4
1725 HOST localhost
1726 EVENT_NAME memory/sql/user_var_entry::value
1727 COUNT_ALLOC 0
1728 COUNT_FREE 0
1729 SUM_NUMBER_OF_BYTES_ALLOC 0
1730 SUM_NUMBER_OF_BYTES_FREE 0
1731 LOW_COUNT_USED 0
1732 CURRENT_COUNT_USED 0
1733 HIGH_COUNT_USED 0
1734 LOW_NUMBER_OF_BYTES_USED 0
1735 CURRENT_NUMBER_OF_BYTES_USED 0
1736 HIGH_NUMBER_OF_BYTES_USED 0
1737 execute dump_memory_user;
1738 USER user1
1739 EVENT_NAME memory/sql/User_level_lock
1740 COUNT_ALLOC 2
1741 COUNT_FREE 1
1742 SUM_NUMBER_OF_BYTES_ALLOC 272
1743 SUM_NUMBER_OF_BYTES_FREE 16
1744 LOW_COUNT_USED 0
1745 CURRENT_COUNT_USED 1
1746 HIGH_COUNT_USED 2
1747 LOW_NUMBER_OF_BYTES_USED 0
1748 CURRENT_NUMBER_OF_BYTES_USED 256
1749 HIGH_NUMBER_OF_BYTES_USED 272
1750 USER user1
1751 EVENT_NAME memory/sql/user_var_entry::value
1752 COUNT_ALLOC 3
1753 COUNT_FREE 0
1754 SUM_NUMBER_OF_BYTES_ALLOC 7024
1755 SUM_NUMBER_OF_BYTES_FREE 0
1756 LOW_COUNT_USED 0
1757 CURRENT_COUNT_USED 3
1758 HIGH_COUNT_USED 3
1759 LOW_NUMBER_OF_BYTES_USED 0
1760 CURRENT_NUMBER_OF_BYTES_USED 7024
1761 HIGH_NUMBER_OF_BYTES_USED 7024
1762 USER user2
1763 EVENT_NAME memory/sql/User_level_lock
1764 COUNT_ALLOC 2
1765 COUNT_FREE 1
1766 SUM_NUMBER_OF_BYTES_ALLOC 272
1767 SUM_NUMBER_OF_BYTES_FREE 16
1768 LOW_COUNT_USED 0
1769 CURRENT_COUNT_USED 1
1770 HIGH_COUNT_USED 2
1771 LOW_NUMBER_OF_BYTES_USED 0
1772 CURRENT_NUMBER_OF_BYTES_USED 256
1773 HIGH_NUMBER_OF_BYTES_USED 272
1774 USER user2
1775 EVENT_NAME memory/sql/user_var_entry::value
1776 COUNT_ALLOC 3
1777 COUNT_FREE 0
1778 SUM_NUMBER_OF_BYTES_ALLOC 7024
1779 SUM_NUMBER_OF_BYTES_FREE 0
1780 LOW_COUNT_USED 0
1781 CURRENT_COUNT_USED 3
1782 HIGH_COUNT_USED 3
1783 LOW_NUMBER_OF_BYTES_USED 0
1784 CURRENT_NUMBER_OF_BYTES_USED 7024
1785 HIGH_NUMBER_OF_BYTES_USED 7024
1786 USER user3
1787 EVENT_NAME memory/sql/User_level_lock
1788 COUNT_ALLOC 2
1789 COUNT_FREE 1
1790 SUM_NUMBER_OF_BYTES_ALLOC 272
1791 SUM_NUMBER_OF_BYTES_FREE 16
1792 LOW_COUNT_USED 0
1793 CURRENT_COUNT_USED 1
1794 HIGH_COUNT_USED 2
1795 LOW_NUMBER_OF_BYTES_USED 0
1796 CURRENT_NUMBER_OF_BYTES_USED 256
1797 HIGH_NUMBER_OF_BYTES_USED 272
1798 USER user3
1799 EVENT_NAME memory/sql/user_var_entry::value
1800 COUNT_ALLOC 3
1801 COUNT_FREE 0
1802 SUM_NUMBER_OF_BYTES_ALLOC 7024
1803 SUM_NUMBER_OF_BYTES_FREE 0
1804 LOW_COUNT_USED 0
1805 CURRENT_COUNT_USED 3
1806 HIGH_COUNT_USED 3
1807 LOW_NUMBER_OF_BYTES_USED 0
1808 CURRENT_NUMBER_OF_BYTES_USED 7024
1809 HIGH_NUMBER_OF_BYTES_USED 7024
1810 USER user4
1811 EVENT_NAME memory/sql/User_level_lock
1812 COUNT_ALLOC 0
1813 COUNT_FREE 0
1814 SUM_NUMBER_OF_BYTES_ALLOC 0
1815 SUM_NUMBER_OF_BYTES_FREE 0
1816 LOW_COUNT_USED 0
1817 CURRENT_COUNT_USED 0
1818 HIGH_COUNT_USED 0
1819 LOW_NUMBER_OF_BYTES_USED 0
1820 CURRENT_NUMBER_OF_BYTES_USED 0
1821 HIGH_NUMBER_OF_BYTES_USED 0
1822 USER user4
1823 EVENT_NAME memory/sql/user_var_entry::value
1824 COUNT_ALLOC 0
1825 COUNT_FREE 0
1826 SUM_NUMBER_OF_BYTES_ALLOC 0
1827 SUM_NUMBER_OF_BYTES_FREE 0
1828 LOW_COUNT_USED 0
1829 CURRENT_COUNT_USED 0
1830 HIGH_COUNT_USED 0
1831 LOW_NUMBER_OF_BYTES_USED 0
1832 CURRENT_NUMBER_OF_BYTES_USED 0
1833 HIGH_NUMBER_OF_BYTES_USED 0
1834 execute dump_memory_host;
1835 execute dump_memory_global;
1836 EVENT_NAME memory/sql/Query_cache
1837 COUNT_ALLOC 6
1838 COUNT_FREE 4
1839 SUM_NUMBER_OF_BYTES_ALLOC 98304
1840 SUM_NUMBER_OF_BYTES_FREE 65536
1841 LOW_COUNT_USED 0
1842 CURRENT_COUNT_USED 2
1843 HIGH_COUNT_USED 2
1844 LOW_NUMBER_OF_BYTES_USED 0
1845 CURRENT_NUMBER_OF_BYTES_USED 32768
1846 HIGH_NUMBER_OF_BYTES_USED 32768
1847 EVENT_NAME memory/sql/User_level_lock
1848 COUNT_ALLOC 6
1849 COUNT_FREE 3
1850 SUM_NUMBER_OF_BYTES_ALLOC 816
1851 SUM_NUMBER_OF_BYTES_FREE 48
1852 LOW_COUNT_USED 0
1853 CURRENT_COUNT_USED 3
1854 HIGH_COUNT_USED 6
1855 LOW_NUMBER_OF_BYTES_USED 0
1856 CURRENT_NUMBER_OF_BYTES_USED 768
1857 HIGH_NUMBER_OF_BYTES_USED 816
1858 EVENT_NAME memory/sql/user_var_entry::value
1859 COUNT_ALLOC 10
1860 COUNT_FREE 0
1861 SUM_NUMBER_OF_BYTES_ALLOC 21168
1862 SUM_NUMBER_OF_BYTES_FREE 0
1863 LOW_COUNT_USED 1
1864 CURRENT_COUNT_USED 10
1865 HIGH_COUNT_USED 10
1866 LOW_NUMBER_OF_BYTES_USED 96
1867 CURRENT_NUMBER_OF_BYTES_USED 21168
1868 HIGH_NUMBER_OF_BYTES_USED 21168
1869 execute dump_accounts;
1870 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1871 root localhost 1 1
1872 user1 localhost 1 1
1873 user2 localhost 1 1
1874 user3 localhost 1 1
1875 user4 localhost 2 2
1876 execute dump_users;
1877 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1878 root 1 1
1879 user1 1 1
1880 user2 1 1
1881 user3 1 1
1882 user4 2 2
1883 execute dump_hosts;
1884 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1885 connection con4;
1886 set GLOBAL query_cache_size=4000*1024;
1887 select get_lock("marker_4", 10);
1888 get_lock("marker_4", 10)
1889 1
1890 select release_lock("marker_4");
1891 release_lock("marker_4")
1892 1
1893 set @v1 = repeat("a", 1000);
1894 set @v2 = repeat("b", 2000);
1895 set @v3 = repeat("c", 4000);
1896 connection con5;
1897 select get_lock("marker_5", 10);
1898 get_lock("marker_5", 10)
1899 1
1900 select release_lock("marker_5");
1901 release_lock("marker_5")
1902 1
1903 set @v1 = repeat("a", 1000);
1904 set @v2 = repeat("b", 2000);
1905 set @v3 = repeat("c", 4000);
1906 "================== con4/con5 marker =================="
1907 connection default;
1908 "================== Step 9 =================="
1909 call dump_thread();
1910 username user1
1911 EVENT_NAME memory/sql/User_level_lock
1912 COUNT_ALLOC 1
1913 COUNT_FREE 0
1914 SUM_NUMBER_OF_BYTES_ALLOC 256
1915 SUM_NUMBER_OF_BYTES_FREE 0
1916 LOW_COUNT_USED 1
1917 CURRENT_COUNT_USED 1
1918 HIGH_COUNT_USED 1
1919 LOW_NUMBER_OF_BYTES_USED 256
1920 CURRENT_NUMBER_OF_BYTES_USED 256
1921 HIGH_NUMBER_OF_BYTES_USED 256
1922 username user1
1923 EVENT_NAME memory/sql/user_var_entry::value
1924 COUNT_ALLOC 3
1925 COUNT_FREE 0
1926 SUM_NUMBER_OF_BYTES_ALLOC 7024
1927 SUM_NUMBER_OF_BYTES_FREE 0
1928 LOW_COUNT_USED 3
1929 CURRENT_COUNT_USED 3
1930 HIGH_COUNT_USED 3
1931 LOW_NUMBER_OF_BYTES_USED 7024
1932 CURRENT_NUMBER_OF_BYTES_USED 7024
1933 HIGH_NUMBER_OF_BYTES_USED 7024
1934 username user2
1935 EVENT_NAME memory/sql/User_level_lock
1936 COUNT_ALLOC 1
1937 COUNT_FREE 0
1938 SUM_NUMBER_OF_BYTES_ALLOC 256
1939 SUM_NUMBER_OF_BYTES_FREE 0
1940 LOW_COUNT_USED 1
1941 CURRENT_COUNT_USED 1
1942 HIGH_COUNT_USED 1
1943 LOW_NUMBER_OF_BYTES_USED 256
1944 CURRENT_NUMBER_OF_BYTES_USED 256
1945 HIGH_NUMBER_OF_BYTES_USED 256
1946 username user2
1947 EVENT_NAME memory/sql/user_var_entry::value
1948 COUNT_ALLOC 3
1949 COUNT_FREE 0
1950 SUM_NUMBER_OF_BYTES_ALLOC 7024
1951 SUM_NUMBER_OF_BYTES_FREE 0
1952 LOW_COUNT_USED 3
1953 CURRENT_COUNT_USED 3
1954 HIGH_COUNT_USED 3
1955 LOW_NUMBER_OF_BYTES_USED 7024
1956 CURRENT_NUMBER_OF_BYTES_USED 7024
1957 HIGH_NUMBER_OF_BYTES_USED 7024
1958 username user3
1959 EVENT_NAME memory/sql/User_level_lock
1960 COUNT_ALLOC 2
1961 COUNT_FREE 1
1962 SUM_NUMBER_OF_BYTES_ALLOC 272
1963 SUM_NUMBER_OF_BYTES_FREE 16
1964 LOW_COUNT_USED 0
1965 CURRENT_COUNT_USED 1
1966 HIGH_COUNT_USED 2
1967 LOW_NUMBER_OF_BYTES_USED 0
1968 CURRENT_NUMBER_OF_BYTES_USED 256
1969 HIGH_NUMBER_OF_BYTES_USED 272
1970 username user3
1971 EVENT_NAME memory/sql/user_var_entry::value
1972 COUNT_ALLOC 3
1973 COUNT_FREE 0
1974 SUM_NUMBER_OF_BYTES_ALLOC 7024
1975 SUM_NUMBER_OF_BYTES_FREE 0
1976 LOW_COUNT_USED 0
1977 CURRENT_COUNT_USED 3
1978 HIGH_COUNT_USED 3
1979 LOW_NUMBER_OF_BYTES_USED 0
1980 CURRENT_NUMBER_OF_BYTES_USED 7024
1981 HIGH_NUMBER_OF_BYTES_USED 7024
1982 username user4
1983 EVENT_NAME memory/sql/User_level_lock
1984 COUNT_ALLOC 2
1985 COUNT_FREE 1
1986 SUM_NUMBER_OF_BYTES_ALLOC 272
1987 SUM_NUMBER_OF_BYTES_FREE 16
1988 LOW_COUNT_USED 0
1989 CURRENT_COUNT_USED 1
1990 HIGH_COUNT_USED 2
1991 LOW_NUMBER_OF_BYTES_USED 0
1992 CURRENT_NUMBER_OF_BYTES_USED 256
1993 HIGH_NUMBER_OF_BYTES_USED 272
1994 username user4
1995 EVENT_NAME memory/sql/user_var_entry::value
1996 COUNT_ALLOC 3
1997 COUNT_FREE 0
1998 SUM_NUMBER_OF_BYTES_ALLOC 7024
1999 SUM_NUMBER_OF_BYTES_FREE 0
2000 LOW_COUNT_USED 0
2001 CURRENT_COUNT_USED 3
2002 HIGH_COUNT_USED 3
2003 LOW_NUMBER_OF_BYTES_USED 0
2004 CURRENT_NUMBER_OF_BYTES_USED 7024
2005 HIGH_NUMBER_OF_BYTES_USED 7024
2006 execute dump_memory_account;
2007 USER user1
2008 HOST localhost
2009 EVENT_NAME memory/sql/User_level_lock
2010 COUNT_ALLOC 2
2011 COUNT_FREE 1
2012 SUM_NUMBER_OF_BYTES_ALLOC 272
2013 SUM_NUMBER_OF_BYTES_FREE 16
2014 LOW_COUNT_USED 0
2015 CURRENT_COUNT_USED 1
2016 HIGH_COUNT_USED 2
2017 LOW_NUMBER_OF_BYTES_USED 0
2018 CURRENT_NUMBER_OF_BYTES_USED 256
2019 HIGH_NUMBER_OF_BYTES_USED 272
2020 USER user1
2021 HOST localhost
2022 EVENT_NAME memory/sql/user_var_entry::value
2023 COUNT_ALLOC 3
2024 COUNT_FREE 0
2025 SUM_NUMBER_OF_BYTES_ALLOC 7024
2026 SUM_NUMBER_OF_BYTES_FREE 0
2027 LOW_COUNT_USED 0
2028 CURRENT_COUNT_USED 3
2029 HIGH_COUNT_USED 3
2030 LOW_NUMBER_OF_BYTES_USED 0
2031 CURRENT_NUMBER_OF_BYTES_USED 7024
2032 HIGH_NUMBER_OF_BYTES_USED 7024
2033 USER user2
2034 HOST localhost
2035 EVENT_NAME memory/sql/User_level_lock
2036 COUNT_ALLOC 2
2037 COUNT_FREE 1
2038 SUM_NUMBER_OF_BYTES_ALLOC 272
2039 SUM_NUMBER_OF_BYTES_FREE 16
2040 LOW_COUNT_USED 0
2041 CURRENT_COUNT_USED 1
2042 HIGH_COUNT_USED 2
2043 LOW_NUMBER_OF_BYTES_USED 0
2044 CURRENT_NUMBER_OF_BYTES_USED 256
2045 HIGH_NUMBER_OF_BYTES_USED 272
2046 USER user2
2047 HOST localhost
2048 EVENT_NAME memory/sql/user_var_entry::value
2049 COUNT_ALLOC 3
2050 COUNT_FREE 0
2051 SUM_NUMBER_OF_BYTES_ALLOC 7024
2052 SUM_NUMBER_OF_BYTES_FREE 0
2053 LOW_COUNT_USED 0
2054 CURRENT_COUNT_USED 3
2055 HIGH_COUNT_USED 3
2056 LOW_NUMBER_OF_BYTES_USED 0
2057 CURRENT_NUMBER_OF_BYTES_USED 7024
2058 HIGH_NUMBER_OF_BYTES_USED 7024
2059 USER user3
2060 HOST localhost
2061 EVENT_NAME memory/sql/User_level_lock
2062 COUNT_ALLOC 2
2063 COUNT_FREE 1
2064 SUM_NUMBER_OF_BYTES_ALLOC 272
2065 SUM_NUMBER_OF_BYTES_FREE 16
2066 LOW_COUNT_USED 0
2067 CURRENT_COUNT_USED 1
2068 HIGH_COUNT_USED 2
2069 LOW_NUMBER_OF_BYTES_USED 0
2070 CURRENT_NUMBER_OF_BYTES_USED 256
2071 HIGH_NUMBER_OF_BYTES_USED 272
2072 USER user3
2073 HOST localhost
2074 EVENT_NAME memory/sql/user_var_entry::value
2075 COUNT_ALLOC 3
2076 COUNT_FREE 0
2077 SUM_NUMBER_OF_BYTES_ALLOC 7024
2078 SUM_NUMBER_OF_BYTES_FREE 0
2079 LOW_COUNT_USED 0
2080 CURRENT_COUNT_USED 3
2081 HIGH_COUNT_USED 3
2082 LOW_NUMBER_OF_BYTES_USED 0
2083 CURRENT_NUMBER_OF_BYTES_USED 7024
2084 HIGH_NUMBER_OF_BYTES_USED 7024
2085 USER user4
2086 HOST localhost
2087 EVENT_NAME memory/sql/User_level_lock
2088 COUNT_ALLOC 4
2089 COUNT_FREE 2
2090 SUM_NUMBER_OF_BYTES_ALLOC 544
2091 SUM_NUMBER_OF_BYTES_FREE 32
2092 LOW_COUNT_USED 0
2093 CURRENT_COUNT_USED 2
2094 HIGH_COUNT_USED 4
2095 LOW_NUMBER_OF_BYTES_USED 0
2096 CURRENT_NUMBER_OF_BYTES_USED 512
2097 HIGH_NUMBER_OF_BYTES_USED 544
2098 USER user4
2099 HOST localhost
2100 EVENT_NAME memory/sql/user_var_entry::value
2101 COUNT_ALLOC 6
2102 COUNT_FREE 0
2103 SUM_NUMBER_OF_BYTES_ALLOC 14048
2104 SUM_NUMBER_OF_BYTES_FREE 0
2105 LOW_COUNT_USED 0
2106 CURRENT_COUNT_USED 6
2107 HIGH_COUNT_USED 6
2108 LOW_NUMBER_OF_BYTES_USED 0
2109 CURRENT_NUMBER_OF_BYTES_USED 14048
2110 HIGH_NUMBER_OF_BYTES_USED 14048
2111 execute dump_memory_user;
2112 USER user1
2113 EVENT_NAME memory/sql/User_level_lock
2114 COUNT_ALLOC 2
2115 COUNT_FREE 1
2116 SUM_NUMBER_OF_BYTES_ALLOC 272
2117 SUM_NUMBER_OF_BYTES_FREE 16
2118 LOW_COUNT_USED 0
2119 CURRENT_COUNT_USED 1
2120 HIGH_COUNT_USED 2
2121 LOW_NUMBER_OF_BYTES_USED 0
2122 CURRENT_NUMBER_OF_BYTES_USED 256
2123 HIGH_NUMBER_OF_BYTES_USED 272
2124 USER user1
2125 EVENT_NAME memory/sql/user_var_entry::value
2126 COUNT_ALLOC 3
2127 COUNT_FREE 0
2128 SUM_NUMBER_OF_BYTES_ALLOC 7024
2129 SUM_NUMBER_OF_BYTES_FREE 0
2130 LOW_COUNT_USED 0
2131 CURRENT_COUNT_USED 3
2132 HIGH_COUNT_USED 3
2133 LOW_NUMBER_OF_BYTES_USED 0
2134 CURRENT_NUMBER_OF_BYTES_USED 7024
2135 HIGH_NUMBER_OF_BYTES_USED 7024
2136 USER user2
2137 EVENT_NAME memory/sql/User_level_lock
2138 COUNT_ALLOC 2
2139 COUNT_FREE 1
2140 SUM_NUMBER_OF_BYTES_ALLOC 272
2141 SUM_NUMBER_OF_BYTES_FREE 16
2142 LOW_COUNT_USED 0
2143 CURRENT_COUNT_USED 1
2144 HIGH_COUNT_USED 2
2145 LOW_NUMBER_OF_BYTES_USED 0
2146 CURRENT_NUMBER_OF_BYTES_USED 256
2147 HIGH_NUMBER_OF_BYTES_USED 272
2148 USER user2
2149 EVENT_NAME memory/sql/user_var_entry::value
2150 COUNT_ALLOC 3
2151 COUNT_FREE 0
2152 SUM_NUMBER_OF_BYTES_ALLOC 7024
2153 SUM_NUMBER_OF_BYTES_FREE 0
2154 LOW_COUNT_USED 0
2155 CURRENT_COUNT_USED 3
2156 HIGH_COUNT_USED 3
2157 LOW_NUMBER_OF_BYTES_USED 0
2158 CURRENT_NUMBER_OF_BYTES_USED 7024
2159 HIGH_NUMBER_OF_BYTES_USED 7024
2160 USER user3
2161 EVENT_NAME memory/sql/User_level_lock
2162 COUNT_ALLOC 2
2163 COUNT_FREE 1
2164 SUM_NUMBER_OF_BYTES_ALLOC 272
2165 SUM_NUMBER_OF_BYTES_FREE 16
2166 LOW_COUNT_USED 0
2167 CURRENT_COUNT_USED 1
2168 HIGH_COUNT_USED 2
2169 LOW_NUMBER_OF_BYTES_USED 0
2170 CURRENT_NUMBER_OF_BYTES_USED 256
2171 HIGH_NUMBER_OF_BYTES_USED 272
2172 USER user3
2173 EVENT_NAME memory/sql/user_var_entry::value
2174 COUNT_ALLOC 3
2175 COUNT_FREE 0
2176 SUM_NUMBER_OF_BYTES_ALLOC 7024
2177 SUM_NUMBER_OF_BYTES_FREE 0
2178 LOW_COUNT_USED 0
2179 CURRENT_COUNT_USED 3
2180 HIGH_COUNT_USED 3
2181 LOW_NUMBER_OF_BYTES_USED 0
2182 CURRENT_NUMBER_OF_BYTES_USED 7024
2183 HIGH_NUMBER_OF_BYTES_USED 7024
2184 USER user4
2185 EVENT_NAME memory/sql/User_level_lock
2186 COUNT_ALLOC 4
2187 COUNT_FREE 2
2188 SUM_NUMBER_OF_BYTES_ALLOC 544
2189 SUM_NUMBER_OF_BYTES_FREE 32
2190 LOW_COUNT_USED 0
2191 CURRENT_COUNT_USED 2
2192 HIGH_COUNT_USED 4
2193 LOW_NUMBER_OF_BYTES_USED 0
2194 CURRENT_NUMBER_OF_BYTES_USED 512
2195 HIGH_NUMBER_OF_BYTES_USED 544
2196 USER user4
2197 EVENT_NAME memory/sql/user_var_entry::value
2198 COUNT_ALLOC 6
2199 COUNT_FREE 0
2200 SUM_NUMBER_OF_BYTES_ALLOC 14048
2201 SUM_NUMBER_OF_BYTES_FREE 0
2202 LOW_COUNT_USED 0
2203 CURRENT_COUNT_USED 6
2204 HIGH_COUNT_USED 6
2205 LOW_NUMBER_OF_BYTES_USED 0
2206 CURRENT_NUMBER_OF_BYTES_USED 14048
2207 HIGH_NUMBER_OF_BYTES_USED 14048
2208 execute dump_memory_host;
2209 execute dump_memory_global;
2210 EVENT_NAME memory/sql/Query_cache
2211 COUNT_ALLOC 8
2212 COUNT_FREE 6
2213 SUM_NUMBER_OF_BYTES_ALLOC 131072
2214 SUM_NUMBER_OF_BYTES_FREE 98304
2215 LOW_COUNT_USED 0
2216 CURRENT_COUNT_USED 2
2217 HIGH_COUNT_USED 2
2218 LOW_NUMBER_OF_BYTES_USED 0
2219 CURRENT_NUMBER_OF_BYTES_USED 32768
2220 HIGH_NUMBER_OF_BYTES_USED 32768
2221 EVENT_NAME memory/sql/User_level_lock
2222 COUNT_ALLOC 10
2223 COUNT_FREE 5
2224 SUM_NUMBER_OF_BYTES_ALLOC 1360
2225 SUM_NUMBER_OF_BYTES_FREE 80
2226 LOW_COUNT_USED 0
2227 CURRENT_COUNT_USED 5
2228 HIGH_COUNT_USED 10
2229 LOW_NUMBER_OF_BYTES_USED 0
2230 CURRENT_NUMBER_OF_BYTES_USED 1280
2231 HIGH_NUMBER_OF_BYTES_USED 1360
2232 EVENT_NAME memory/sql/user_var_entry::value
2233 COUNT_ALLOC 16
2234 COUNT_FREE 0
2235 SUM_NUMBER_OF_BYTES_ALLOC 35216
2236 SUM_NUMBER_OF_BYTES_FREE 0
2237 LOW_COUNT_USED 1
2238 CURRENT_COUNT_USED 16
2239 HIGH_COUNT_USED 16
2240 LOW_NUMBER_OF_BYTES_USED 96
2241 CURRENT_NUMBER_OF_BYTES_USED 35216
2242 HIGH_NUMBER_OF_BYTES_USED 35216
2243 execute dump_accounts;
2244 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2245 root localhost 1 1
2246 user1 localhost 1 1
2247 user2 localhost 1 1
2248 user3 localhost 1 1
2249 user4 localhost 2 2
2250 execute dump_users;
2251 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2252 root 1 1
2253 user1 1 1
2254 user2 1 1
2255 user3 1 1
2256 user4 2 2
2257 execute dump_hosts;
2258 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2259 disconnect con1;
2260 connection default;
2261 disconnect con5;
2262 "================== con1/con5 disconnected =================="
2263 "================== Step 10 =================="
2264 call dump_thread();
2265 username user1
2266 status not found
2267 username user2
2268 EVENT_NAME memory/sql/User_level_lock
2269 COUNT_ALLOC 1
2270 COUNT_FREE 0
2271 SUM_NUMBER_OF_BYTES_ALLOC 256
2272 SUM_NUMBER_OF_BYTES_FREE 0
2273 LOW_COUNT_USED 1
2274 CURRENT_COUNT_USED 1
2275 HIGH_COUNT_USED 1
2276 LOW_NUMBER_OF_BYTES_USED 256
2277 CURRENT_NUMBER_OF_BYTES_USED 256
2278 HIGH_NUMBER_OF_BYTES_USED 256
2279 username user2
2280 EVENT_NAME memory/sql/user_var_entry::value
2281 COUNT_ALLOC 3
2282 COUNT_FREE 0
2283 SUM_NUMBER_OF_BYTES_ALLOC 7024
2284 SUM_NUMBER_OF_BYTES_FREE 0
2285 LOW_COUNT_USED 3
2286 CURRENT_COUNT_USED 3
2287 HIGH_COUNT_USED 3
2288 LOW_NUMBER_OF_BYTES_USED 7024
2289 CURRENT_NUMBER_OF_BYTES_USED 7024
2290 HIGH_NUMBER_OF_BYTES_USED 7024
2291 username user3
2292 EVENT_NAME memory/sql/User_level_lock
2293 COUNT_ALLOC 2
2294 COUNT_FREE 1
2295 SUM_NUMBER_OF_BYTES_ALLOC 272
2296 SUM_NUMBER_OF_BYTES_FREE 16
2297 LOW_COUNT_USED 0
2298 CURRENT_COUNT_USED 1
2299 HIGH_COUNT_USED 2
2300 LOW_NUMBER_OF_BYTES_USED 0
2301 CURRENT_NUMBER_OF_BYTES_USED 256
2302 HIGH_NUMBER_OF_BYTES_USED 272
2303 username user3
2304 EVENT_NAME memory/sql/user_var_entry::value
2305 COUNT_ALLOC 3
2306 COUNT_FREE 0
2307 SUM_NUMBER_OF_BYTES_ALLOC 7024
2308 SUM_NUMBER_OF_BYTES_FREE 0
2309 LOW_COUNT_USED 0
2310 CURRENT_COUNT_USED 3
2311 HIGH_COUNT_USED 3
2312 LOW_NUMBER_OF_BYTES_USED 0
2313 CURRENT_NUMBER_OF_BYTES_USED 7024
2314 HIGH_NUMBER_OF_BYTES_USED 7024
2315 username user4
2316 EVENT_NAME memory/sql/User_level_lock
2317 COUNT_ALLOC 2
2318 COUNT_FREE 1
2319 SUM_NUMBER_OF_BYTES_ALLOC 272
2320 SUM_NUMBER_OF_BYTES_FREE 16
2321 LOW_COUNT_USED 0
2322 CURRENT_COUNT_USED 1
2323 HIGH_COUNT_USED 2
2324 LOW_NUMBER_OF_BYTES_USED 0
2325 CURRENT_NUMBER_OF_BYTES_USED 256
2326 HIGH_NUMBER_OF_BYTES_USED 272
2327 username user4
2328 EVENT_NAME memory/sql/user_var_entry::value
2329 COUNT_ALLOC 3
2330 COUNT_FREE 0
2331 SUM_NUMBER_OF_BYTES_ALLOC 7024
2332 SUM_NUMBER_OF_BYTES_FREE 0
2333 LOW_COUNT_USED 0
2334 CURRENT_COUNT_USED 3
2335 HIGH_COUNT_USED 3
2336 LOW_NUMBER_OF_BYTES_USED 0
2337 CURRENT_NUMBER_OF_BYTES_USED 7024
2338 HIGH_NUMBER_OF_BYTES_USED 7024
2339 execute dump_memory_account;
2340 USER user1
2341 HOST localhost
2342 EVENT_NAME memory/sql/User_level_lock
2343 COUNT_ALLOC 2
2344 COUNT_FREE 2
2345 SUM_NUMBER_OF_BYTES_ALLOC 272
2346 SUM_NUMBER_OF_BYTES_FREE 272
2347 LOW_COUNT_USED 0
2348 CURRENT_COUNT_USED 0
2349 HIGH_COUNT_USED 2
2350 LOW_NUMBER_OF_BYTES_USED 0
2351 CURRENT_NUMBER_OF_BYTES_USED 0
2352 HIGH_NUMBER_OF_BYTES_USED 272
2353 USER user1
2354 HOST localhost
2355 EVENT_NAME memory/sql/user_var_entry::value
2356 COUNT_ALLOC 3
2357 COUNT_FREE 3
2358 SUM_NUMBER_OF_BYTES_ALLOC 7024
2359 SUM_NUMBER_OF_BYTES_FREE 7024
2360 LOW_COUNT_USED 0
2361 CURRENT_COUNT_USED 0
2362 HIGH_COUNT_USED 3
2363 LOW_NUMBER_OF_BYTES_USED 0
2364 CURRENT_NUMBER_OF_BYTES_USED 0
2365 HIGH_NUMBER_OF_BYTES_USED 7024
2366 USER user2
2367 HOST localhost
2368 EVENT_NAME memory/sql/User_level_lock
2369 COUNT_ALLOC 2
2370 COUNT_FREE 1
2371 SUM_NUMBER_OF_BYTES_ALLOC 272
2372 SUM_NUMBER_OF_BYTES_FREE 16
2373 LOW_COUNT_USED 0
2374 CURRENT_COUNT_USED 1
2375 HIGH_COUNT_USED 2
2376 LOW_NUMBER_OF_BYTES_USED 0
2377 CURRENT_NUMBER_OF_BYTES_USED 256
2378 HIGH_NUMBER_OF_BYTES_USED 272
2379 USER user2
2380 HOST localhost
2381 EVENT_NAME memory/sql/user_var_entry::value
2382 COUNT_ALLOC 3
2383 COUNT_FREE 0
2384 SUM_NUMBER_OF_BYTES_ALLOC 7024
2385 SUM_NUMBER_OF_BYTES_FREE 0
2386 LOW_COUNT_USED 0
2387 CURRENT_COUNT_USED 3
2388 HIGH_COUNT_USED 3
2389 LOW_NUMBER_OF_BYTES_USED 0
2390 CURRENT_NUMBER_OF_BYTES_USED 7024
2391 HIGH_NUMBER_OF_BYTES_USED 7024
2392 USER user3
2393 HOST localhost
2394 EVENT_NAME memory/sql/User_level_lock
2395 COUNT_ALLOC 2
2396 COUNT_FREE 1
2397 SUM_NUMBER_OF_BYTES_ALLOC 272
2398 SUM_NUMBER_OF_BYTES_FREE 16
2399 LOW_COUNT_USED 0
2400 CURRENT_COUNT_USED 1
2401 HIGH_COUNT_USED 2
2402 LOW_NUMBER_OF_BYTES_USED 0
2403 CURRENT_NUMBER_OF_BYTES_USED 256
2404 HIGH_NUMBER_OF_BYTES_USED 272
2405 USER user3
2406 HOST localhost
2407 EVENT_NAME memory/sql/user_var_entry::value
2408 COUNT_ALLOC 3
2409 COUNT_FREE 0
2410 SUM_NUMBER_OF_BYTES_ALLOC 7024
2411 SUM_NUMBER_OF_BYTES_FREE 0
2412 LOW_COUNT_USED 0
2413 CURRENT_COUNT_USED 3
2414 HIGH_COUNT_USED 3
2415 LOW_NUMBER_OF_BYTES_USED 0
2416 CURRENT_NUMBER_OF_BYTES_USED 7024
2417 HIGH_NUMBER_OF_BYTES_USED 7024
2418 USER user4
2419 HOST localhost
2420 EVENT_NAME memory/sql/User_level_lock
2421 COUNT_ALLOC 4
2422 COUNT_FREE 3
2423 SUM_NUMBER_OF_BYTES_ALLOC 544
2424 SUM_NUMBER_OF_BYTES_FREE 288
2425 LOW_COUNT_USED 0
2426 CURRENT_COUNT_USED 1
2427 HIGH_COUNT_USED 4
2428 LOW_NUMBER_OF_BYTES_USED 0
2429 CURRENT_NUMBER_OF_BYTES_USED 256
2430 HIGH_NUMBER_OF_BYTES_USED 544
2431 USER user4
2432 HOST localhost
2433 EVENT_NAME memory/sql/user_var_entry::value
2434 COUNT_ALLOC 6
2435 COUNT_FREE 3
2436 SUM_NUMBER_OF_BYTES_ALLOC 14048
2437 SUM_NUMBER_OF_BYTES_FREE 7024
2438 LOW_COUNT_USED 0
2439 CURRENT_COUNT_USED 3
2440 HIGH_COUNT_USED 6
2441 LOW_NUMBER_OF_BYTES_USED 0
2442 CURRENT_NUMBER_OF_BYTES_USED 7024
2443 HIGH_NUMBER_OF_BYTES_USED 14048
2444 execute dump_memory_user;
2445 USER user1
2446 EVENT_NAME memory/sql/User_level_lock
2447 COUNT_ALLOC 2
2448 COUNT_FREE 2
2449 SUM_NUMBER_OF_BYTES_ALLOC 272
2450 SUM_NUMBER_OF_BYTES_FREE 272
2451 LOW_COUNT_USED 0
2452 CURRENT_COUNT_USED 0
2453 HIGH_COUNT_USED 2
2454 LOW_NUMBER_OF_BYTES_USED 0
2455 CURRENT_NUMBER_OF_BYTES_USED 0
2456 HIGH_NUMBER_OF_BYTES_USED 272
2457 USER user1
2458 EVENT_NAME memory/sql/user_var_entry::value
2459 COUNT_ALLOC 3
2460 COUNT_FREE 3
2461 SUM_NUMBER_OF_BYTES_ALLOC 7024
2462 SUM_NUMBER_OF_BYTES_FREE 7024
2463 LOW_COUNT_USED 0
2464 CURRENT_COUNT_USED 0
2465 HIGH_COUNT_USED 3
2466 LOW_NUMBER_OF_BYTES_USED 0
2467 CURRENT_NUMBER_OF_BYTES_USED 0
2468 HIGH_NUMBER_OF_BYTES_USED 7024
2469 USER user2
2470 EVENT_NAME memory/sql/User_level_lock
2471 COUNT_ALLOC 2
2472 COUNT_FREE 1
2473 SUM_NUMBER_OF_BYTES_ALLOC 272
2474 SUM_NUMBER_OF_BYTES_FREE 16
2475 LOW_COUNT_USED 0
2476 CURRENT_COUNT_USED 1
2477 HIGH_COUNT_USED 2
2478 LOW_NUMBER_OF_BYTES_USED 0
2479 CURRENT_NUMBER_OF_BYTES_USED 256
2480 HIGH_NUMBER_OF_BYTES_USED 272
2481 USER user2
2482 EVENT_NAME memory/sql/user_var_entry::value
2483 COUNT_ALLOC 3
2484 COUNT_FREE 0
2485 SUM_NUMBER_OF_BYTES_ALLOC 7024
2486 SUM_NUMBER_OF_BYTES_FREE 0
2487 LOW_COUNT_USED 0
2488 CURRENT_COUNT_USED 3
2489 HIGH_COUNT_USED 3
2490 LOW_NUMBER_OF_BYTES_USED 0
2491 CURRENT_NUMBER_OF_BYTES_USED 7024
2492 HIGH_NUMBER_OF_BYTES_USED 7024
2493 USER user3
2494 EVENT_NAME memory/sql/User_level_lock
2495 COUNT_ALLOC 2
2496 COUNT_FREE 1
2497 SUM_NUMBER_OF_BYTES_ALLOC 272
2498 SUM_NUMBER_OF_BYTES_FREE 16
2499 LOW_COUNT_USED 0
2500 CURRENT_COUNT_USED 1
2501 HIGH_COUNT_USED 2
2502 LOW_NUMBER_OF_BYTES_USED 0
2503 CURRENT_NUMBER_OF_BYTES_USED 256
2504 HIGH_NUMBER_OF_BYTES_USED 272
2505 USER user3
2506 EVENT_NAME memory/sql/user_var_entry::value
2507 COUNT_ALLOC 3
2508 COUNT_FREE 0
2509 SUM_NUMBER_OF_BYTES_ALLOC 7024
2510 SUM_NUMBER_OF_BYTES_FREE 0
2511 LOW_COUNT_USED 0
2512 CURRENT_COUNT_USED 3
2513 HIGH_COUNT_USED 3
2514 LOW_NUMBER_OF_BYTES_USED 0
2515 CURRENT_NUMBER_OF_BYTES_USED 7024
2516 HIGH_NUMBER_OF_BYTES_USED 7024
2517 USER user4
2518 EVENT_NAME memory/sql/User_level_lock
2519 COUNT_ALLOC 4
2520 COUNT_FREE 3
2521 SUM_NUMBER_OF_BYTES_ALLOC 544
2522 SUM_NUMBER_OF_BYTES_FREE 288
2523 LOW_COUNT_USED 0
2524 CURRENT_COUNT_USED 1
2525 HIGH_COUNT_USED 4
2526 LOW_NUMBER_OF_BYTES_USED 0
2527 CURRENT_NUMBER_OF_BYTES_USED 256
2528 HIGH_NUMBER_OF_BYTES_USED 544
2529 USER user4
2530 EVENT_NAME memory/sql/user_var_entry::value
2531 COUNT_ALLOC 6
2532 COUNT_FREE 3
2533 SUM_NUMBER_OF_BYTES_ALLOC 14048
2534 SUM_NUMBER_OF_BYTES_FREE 7024
2535 LOW_COUNT_USED 0
2536 CURRENT_COUNT_USED 3
2537 HIGH_COUNT_USED 6
2538 LOW_NUMBER_OF_BYTES_USED 0
2539 CURRENT_NUMBER_OF_BYTES_USED 7024
2540 HIGH_NUMBER_OF_BYTES_USED 14048
2541 execute dump_memory_host;
2542 execute dump_memory_global;
2543 EVENT_NAME memory/sql/Query_cache
2544 COUNT_ALLOC 8
2545 COUNT_FREE 6
2546 SUM_NUMBER_OF_BYTES_ALLOC 131072
2547 SUM_NUMBER_OF_BYTES_FREE 98304
2548 LOW_COUNT_USED 0
2549 CURRENT_COUNT_USED 2
2550 HIGH_COUNT_USED 2
2551 LOW_NUMBER_OF_BYTES_USED 0
2552 CURRENT_NUMBER_OF_BYTES_USED 32768
2553 HIGH_NUMBER_OF_BYTES_USED 32768
2554 EVENT_NAME memory/sql/User_level_lock
2555 COUNT_ALLOC 10
2556 COUNT_FREE 7
2557 SUM_NUMBER_OF_BYTES_ALLOC 1360
2558 SUM_NUMBER_OF_BYTES_FREE 592
2559 LOW_COUNT_USED 0
2560 CURRENT_COUNT_USED 3
2561 HIGH_COUNT_USED 10
2562 LOW_NUMBER_OF_BYTES_USED 0
2563 CURRENT_NUMBER_OF_BYTES_USED 768
2564 HIGH_NUMBER_OF_BYTES_USED 1360
2565 EVENT_NAME memory/sql/user_var_entry::value
2566 COUNT_ALLOC 16
2567 COUNT_FREE 6
2568 SUM_NUMBER_OF_BYTES_ALLOC 35216
2569 SUM_NUMBER_OF_BYTES_FREE 14048
2570 LOW_COUNT_USED 1
2571 CURRENT_COUNT_USED 10
2572 HIGH_COUNT_USED 16
2573 LOW_NUMBER_OF_BYTES_USED 96
2574 CURRENT_NUMBER_OF_BYTES_USED 21168
2575 HIGH_NUMBER_OF_BYTES_USED 35216
2576 execute dump_accounts;
2577 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2578 root localhost 1 1
2579 user1 localhost 0 1
2580 user2 localhost 1 1
2581 user3 localhost 1 1
2582 user4 localhost 1 2
2583 execute dump_users;
2584 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2585 root 1 1
2586 user1 0 1
2587 user2 1 1
2588 user3 1 1
2589 user4 1 2
2590 execute dump_hosts;
2591 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2592 disconnect con2;
2593 connection default;
2594 "================== con2 disconnected =================="
2595 "================== Step 11 =================="
2596 call dump_thread();
2597 username user1
2598 status not found
2599 username user2
2600 status not found
2601 username user3
2602 EVENT_NAME memory/sql/User_level_lock
2603 COUNT_ALLOC 2
2604 COUNT_FREE 1
2605 SUM_NUMBER_OF_BYTES_ALLOC 272
2606 SUM_NUMBER_OF_BYTES_FREE 16
2607 LOW_COUNT_USED 0
2608 CURRENT_COUNT_USED 1
2609 HIGH_COUNT_USED 2
2610 LOW_NUMBER_OF_BYTES_USED 0
2611 CURRENT_NUMBER_OF_BYTES_USED 256
2612 HIGH_NUMBER_OF_BYTES_USED 272
2613 username user3
2614 EVENT_NAME memory/sql/user_var_entry::value
2615 COUNT_ALLOC 3
2616 COUNT_FREE 0
2617 SUM_NUMBER_OF_BYTES_ALLOC 7024
2618 SUM_NUMBER_OF_BYTES_FREE 0
2619 LOW_COUNT_USED 0
2620 CURRENT_COUNT_USED 3
2621 HIGH_COUNT_USED 3
2622 LOW_NUMBER_OF_BYTES_USED 0
2623 CURRENT_NUMBER_OF_BYTES_USED 7024
2624 HIGH_NUMBER_OF_BYTES_USED 7024
2625 username user4
2626 EVENT_NAME memory/sql/User_level_lock
2627 COUNT_ALLOC 2
2628 COUNT_FREE 1
2629 SUM_NUMBER_OF_BYTES_ALLOC 272
2630 SUM_NUMBER_OF_BYTES_FREE 16
2631 LOW_COUNT_USED 0
2632 CURRENT_COUNT_USED 1
2633 HIGH_COUNT_USED 2
2634 LOW_NUMBER_OF_BYTES_USED 0
2635 CURRENT_NUMBER_OF_BYTES_USED 256
2636 HIGH_NUMBER_OF_BYTES_USED 272
2637 username user4
2638 EVENT_NAME memory/sql/user_var_entry::value
2639 COUNT_ALLOC 3
2640 COUNT_FREE 0
2641 SUM_NUMBER_OF_BYTES_ALLOC 7024
2642 SUM_NUMBER_OF_BYTES_FREE 0
2643 LOW_COUNT_USED 0
2644 CURRENT_COUNT_USED 3
2645 HIGH_COUNT_USED 3
2646 LOW_NUMBER_OF_BYTES_USED 0
2647 CURRENT_NUMBER_OF_BYTES_USED 7024
2648 HIGH_NUMBER_OF_BYTES_USED 7024
2649 execute dump_memory_account;
2650 USER user1
2651 HOST localhost
2652 EVENT_NAME memory/sql/User_level_lock
2653 COUNT_ALLOC 2
2654 COUNT_FREE 2
2655 SUM_NUMBER_OF_BYTES_ALLOC 272
2656 SUM_NUMBER_OF_BYTES_FREE 272
2657 LOW_COUNT_USED 0
2658 CURRENT_COUNT_USED 0
2659 HIGH_COUNT_USED 2
2660 LOW_NUMBER_OF_BYTES_USED 0
2661 CURRENT_NUMBER_OF_BYTES_USED 0
2662 HIGH_NUMBER_OF_BYTES_USED 272
2663 USER user1
2664 HOST localhost
2665 EVENT_NAME memory/sql/user_var_entry::value
2666 COUNT_ALLOC 3
2667 COUNT_FREE 3
2668 SUM_NUMBER_OF_BYTES_ALLOC 7024
2669 SUM_NUMBER_OF_BYTES_FREE 7024
2670 LOW_COUNT_USED 0
2671 CURRENT_COUNT_USED 0
2672 HIGH_COUNT_USED 3
2673 LOW_NUMBER_OF_BYTES_USED 0
2674 CURRENT_NUMBER_OF_BYTES_USED 0
2675 HIGH_NUMBER_OF_BYTES_USED 7024
2676 USER user2
2677 HOST localhost
2678 EVENT_NAME memory/sql/User_level_lock
2679 COUNT_ALLOC 2
2680 COUNT_FREE 2
2681 SUM_NUMBER_OF_BYTES_ALLOC 272
2682 SUM_NUMBER_OF_BYTES_FREE 272
2683 LOW_COUNT_USED 0
2684 CURRENT_COUNT_USED 0
2685 HIGH_COUNT_USED 2
2686 LOW_NUMBER_OF_BYTES_USED 0
2687 CURRENT_NUMBER_OF_BYTES_USED 0
2688 HIGH_NUMBER_OF_BYTES_USED 272
2689 USER user2
2690 HOST localhost
2691 EVENT_NAME memory/sql/user_var_entry::value
2692 COUNT_ALLOC 3
2693 COUNT_FREE 3
2694 SUM_NUMBER_OF_BYTES_ALLOC 7024
2695 SUM_NUMBER_OF_BYTES_FREE 7024
2696 LOW_COUNT_USED 0
2697 CURRENT_COUNT_USED 0
2698 HIGH_COUNT_USED 3
2699 LOW_NUMBER_OF_BYTES_USED 0
2700 CURRENT_NUMBER_OF_BYTES_USED 0
2701 HIGH_NUMBER_OF_BYTES_USED 7024
2702 USER user3
2703 HOST localhost
2704 EVENT_NAME memory/sql/User_level_lock
2705 COUNT_ALLOC 2
2706 COUNT_FREE 1
2707 SUM_NUMBER_OF_BYTES_ALLOC 272
2708 SUM_NUMBER_OF_BYTES_FREE 16
2709 LOW_COUNT_USED 0
2710 CURRENT_COUNT_USED 1
2711 HIGH_COUNT_USED 2
2712 LOW_NUMBER_OF_BYTES_USED 0
2713 CURRENT_NUMBER_OF_BYTES_USED 256
2714 HIGH_NUMBER_OF_BYTES_USED 272
2715 USER user3
2716 HOST localhost
2717 EVENT_NAME memory/sql/user_var_entry::value
2718 COUNT_ALLOC 3
2719 COUNT_FREE 0
2720 SUM_NUMBER_OF_BYTES_ALLOC 7024
2721 SUM_NUMBER_OF_BYTES_FREE 0
2722 LOW_COUNT_USED 0
2723 CURRENT_COUNT_USED 3
2724 HIGH_COUNT_USED 3
2725 LOW_NUMBER_OF_BYTES_USED 0
2726 CURRENT_NUMBER_OF_BYTES_USED 7024
2727 HIGH_NUMBER_OF_BYTES_USED 7024
2728 USER user4
2729 HOST localhost
2730 EVENT_NAME memory/sql/User_level_lock
2731 COUNT_ALLOC 4
2732 COUNT_FREE 3
2733 SUM_NUMBER_OF_BYTES_ALLOC 544
2734 SUM_NUMBER_OF_BYTES_FREE 288
2735 LOW_COUNT_USED 0
2736 CURRENT_COUNT_USED 1
2737 HIGH_COUNT_USED 4
2738 LOW_NUMBER_OF_BYTES_USED 0
2739 CURRENT_NUMBER_OF_BYTES_USED 256
2740 HIGH_NUMBER_OF_BYTES_USED 544
2741 USER user4
2742 HOST localhost
2743 EVENT_NAME memory/sql/user_var_entry::value
2744 COUNT_ALLOC 6
2745 COUNT_FREE 3
2746 SUM_NUMBER_OF_BYTES_ALLOC 14048
2747 SUM_NUMBER_OF_BYTES_FREE 7024
2748 LOW_COUNT_USED 0
2749 CURRENT_COUNT_USED 3
2750 HIGH_COUNT_USED 6
2751 LOW_NUMBER_OF_BYTES_USED 0
2752 CURRENT_NUMBER_OF_BYTES_USED 7024
2753 HIGH_NUMBER_OF_BYTES_USED 14048
2754 execute dump_memory_user;
2755 USER user1
2756 EVENT_NAME memory/sql/User_level_lock
2757 COUNT_ALLOC 2
2758 COUNT_FREE 2
2759 SUM_NUMBER_OF_BYTES_ALLOC 272
2760 SUM_NUMBER_OF_BYTES_FREE 272
2761 LOW_COUNT_USED 0
2762 CURRENT_COUNT_USED 0
2763 HIGH_COUNT_USED 2
2764 LOW_NUMBER_OF_BYTES_USED 0
2765 CURRENT_NUMBER_OF_BYTES_USED 0
2766 HIGH_NUMBER_OF_BYTES_USED 272
2767 USER user1
2768 EVENT_NAME memory/sql/user_var_entry::value
2769 COUNT_ALLOC 3
2770 COUNT_FREE 3
2771 SUM_NUMBER_OF_BYTES_ALLOC 7024
2772 SUM_NUMBER_OF_BYTES_FREE 7024
2773 LOW_COUNT_USED 0
2774 CURRENT_COUNT_USED 0
2775 HIGH_COUNT_USED 3
2776 LOW_NUMBER_OF_BYTES_USED 0
2777 CURRENT_NUMBER_OF_BYTES_USED 0
2778 HIGH_NUMBER_OF_BYTES_USED 7024
2779 USER user2
2780 EVENT_NAME memory/sql/User_level_lock
2781 COUNT_ALLOC 2
2782 COUNT_FREE 2
2783 SUM_NUMBER_OF_BYTES_ALLOC 272
2784 SUM_NUMBER_OF_BYTES_FREE 272
2785 LOW_COUNT_USED 0
2786 CURRENT_COUNT_USED 0
2787 HIGH_COUNT_USED 2
2788 LOW_NUMBER_OF_BYTES_USED 0
2789 CURRENT_NUMBER_OF_BYTES_USED 0
2790 HIGH_NUMBER_OF_BYTES_USED 272
2791 USER user2
2792 EVENT_NAME memory/sql/user_var_entry::value
2793 COUNT_ALLOC 3
2794 COUNT_FREE 3
2795 SUM_NUMBER_OF_BYTES_ALLOC 7024
2796 SUM_NUMBER_OF_BYTES_FREE 7024
2797 LOW_COUNT_USED 0
2798 CURRENT_COUNT_USED 0
2799 HIGH_COUNT_USED 3
2800 LOW_NUMBER_OF_BYTES_USED 0
2801 CURRENT_NUMBER_OF_BYTES_USED 0
2802 HIGH_NUMBER_OF_BYTES_USED 7024
2803 USER user3
2804 EVENT_NAME memory/sql/User_level_lock
2805 COUNT_ALLOC 2
2806 COUNT_FREE 1
2807 SUM_NUMBER_OF_BYTES_ALLOC 272
2808 SUM_NUMBER_OF_BYTES_FREE 16
2809 LOW_COUNT_USED 0
2810 CURRENT_COUNT_USED 1
2811 HIGH_COUNT_USED 2
2812 LOW_NUMBER_OF_BYTES_USED 0
2813 CURRENT_NUMBER_OF_BYTES_USED 256
2814 HIGH_NUMBER_OF_BYTES_USED 272
2815 USER user3
2816 EVENT_NAME memory/sql/user_var_entry::value
2817 COUNT_ALLOC 3
2818 COUNT_FREE 0
2819 SUM_NUMBER_OF_BYTES_ALLOC 7024
2820 SUM_NUMBER_OF_BYTES_FREE 0
2821 LOW_COUNT_USED 0
2822 CURRENT_COUNT_USED 3
2823 HIGH_COUNT_USED 3
2824 LOW_NUMBER_OF_BYTES_USED 0
2825 CURRENT_NUMBER_OF_BYTES_USED 7024
2826 HIGH_NUMBER_OF_BYTES_USED 7024
2827 USER user4
2828 EVENT_NAME memory/sql/User_level_lock
2829 COUNT_ALLOC 4
2830 COUNT_FREE 3
2831 SUM_NUMBER_OF_BYTES_ALLOC 544
2832 SUM_NUMBER_OF_BYTES_FREE 288
2833 LOW_COUNT_USED 0
2834 CURRENT_COUNT_USED 1
2835 HIGH_COUNT_USED 4
2836 LOW_NUMBER_OF_BYTES_USED 0
2837 CURRENT_NUMBER_OF_BYTES_USED 256
2838 HIGH_NUMBER_OF_BYTES_USED 544
2839 USER user4
2840 EVENT_NAME memory/sql/user_var_entry::value
2841 COUNT_ALLOC 6
2842 COUNT_FREE 3
2843 SUM_NUMBER_OF_BYTES_ALLOC 14048
2844 SUM_NUMBER_OF_BYTES_FREE 7024
2845 LOW_COUNT_USED 0
2846 CURRENT_COUNT_USED 3
2847 HIGH_COUNT_USED 6
2848 LOW_NUMBER_OF_BYTES_USED 0
2849 CURRENT_NUMBER_OF_BYTES_USED 7024
2850 HIGH_NUMBER_OF_BYTES_USED 14048
2851 execute dump_memory_host;
2852 execute dump_memory_global;
2853 EVENT_NAME memory/sql/Query_cache
2854 COUNT_ALLOC 8
2855 COUNT_FREE 6
2856 SUM_NUMBER_OF_BYTES_ALLOC 131072
2857 SUM_NUMBER_OF_BYTES_FREE 98304
2858 LOW_COUNT_USED 0
2859 CURRENT_COUNT_USED 2
2860 HIGH_COUNT_USED 2
2861 LOW_NUMBER_OF_BYTES_USED 0
2862 CURRENT_NUMBER_OF_BYTES_USED 32768
2863 HIGH_NUMBER_OF_BYTES_USED 32768
2864 EVENT_NAME memory/sql/User_level_lock
2865 COUNT_ALLOC 10
2866 COUNT_FREE 8
2867 SUM_NUMBER_OF_BYTES_ALLOC 1360
2868 SUM_NUMBER_OF_BYTES_FREE 848
2869 LOW_COUNT_USED 0
2870 CURRENT_COUNT_USED 2
2871 HIGH_COUNT_USED 10
2872 LOW_NUMBER_OF_BYTES_USED 0
2873 CURRENT_NUMBER_OF_BYTES_USED 512
2874 HIGH_NUMBER_OF_BYTES_USED 1360
2875 EVENT_NAME memory/sql/user_var_entry::value
2876 COUNT_ALLOC 16
2877 COUNT_FREE 9
2878 SUM_NUMBER_OF_BYTES_ALLOC 35216
2879 SUM_NUMBER_OF_BYTES_FREE 21072
2880 LOW_COUNT_USED 1
2881 CURRENT_COUNT_USED 7
2882 HIGH_COUNT_USED 16
2883 LOW_NUMBER_OF_BYTES_USED 96
2884 CURRENT_NUMBER_OF_BYTES_USED 14144
2885 HIGH_NUMBER_OF_BYTES_USED 35216
2886 execute dump_accounts;
2887 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2888 root localhost 1 1
2889 user1 localhost 0 1
2890 user2 localhost 0 1
2891 user3 localhost 1 1
2892 user4 localhost 1 2
2893 execute dump_users;
2894 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2895 root 1 1
2896 user1 0 1
2897 user2 0 1
2898 user3 1 1
2899 user4 1 2
2900 execute dump_hosts;
2901 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2902 disconnect con3;
2903 connection default;
2904 "================== con3 disconnected =================="
2905 "================== Step 12 =================="
2906 call dump_thread();
2907 username user1
2908 status not found
2909 username user2
2910 status not found
2911 username user3
2912 status not found
2913 username user4
2914 EVENT_NAME memory/sql/User_level_lock
2915 COUNT_ALLOC 2
2916 COUNT_FREE 1
2917 SUM_NUMBER_OF_BYTES_ALLOC 272
2918 SUM_NUMBER_OF_BYTES_FREE 16
2919 LOW_COUNT_USED 0
2920 CURRENT_COUNT_USED 1
2921 HIGH_COUNT_USED 2
2922 LOW_NUMBER_OF_BYTES_USED 0
2923 CURRENT_NUMBER_OF_BYTES_USED 256
2924 HIGH_NUMBER_OF_BYTES_USED 272
2925 username user4
2926 EVENT_NAME memory/sql/user_var_entry::value
2927 COUNT_ALLOC 3
2928 COUNT_FREE 0
2929 SUM_NUMBER_OF_BYTES_ALLOC 7024
2930 SUM_NUMBER_OF_BYTES_FREE 0
2931 LOW_COUNT_USED 0
2932 CURRENT_COUNT_USED 3
2933 HIGH_COUNT_USED 3
2934 LOW_NUMBER_OF_BYTES_USED 0
2935 CURRENT_NUMBER_OF_BYTES_USED 7024
2936 HIGH_NUMBER_OF_BYTES_USED 7024
2937 execute dump_memory_account;
2938 USER user1
2939 HOST localhost
2940 EVENT_NAME memory/sql/User_level_lock
2941 COUNT_ALLOC 2
2942 COUNT_FREE 2
2943 SUM_NUMBER_OF_BYTES_ALLOC 272
2944 SUM_NUMBER_OF_BYTES_FREE 272
2945 LOW_COUNT_USED 0
2946 CURRENT_COUNT_USED 0
2947 HIGH_COUNT_USED 2
2948 LOW_NUMBER_OF_BYTES_USED 0
2949 CURRENT_NUMBER_OF_BYTES_USED 0
2950 HIGH_NUMBER_OF_BYTES_USED 272
2951 USER user1
2952 HOST localhost
2953 EVENT_NAME memory/sql/user_var_entry::value
2954 COUNT_ALLOC 3
2955 COUNT_FREE 3
2956 SUM_NUMBER_OF_BYTES_ALLOC 7024
2957 SUM_NUMBER_OF_BYTES_FREE 7024
2958 LOW_COUNT_USED 0
2959 CURRENT_COUNT_USED 0
2960 HIGH_COUNT_USED 3
2961 LOW_NUMBER_OF_BYTES_USED 0
2962 CURRENT_NUMBER_OF_BYTES_USED 0
2963 HIGH_NUMBER_OF_BYTES_USED 7024
2964 USER user2
2965 HOST localhost
2966 EVENT_NAME memory/sql/User_level_lock
2967 COUNT_ALLOC 2
2968 COUNT_FREE 2
2969 SUM_NUMBER_OF_BYTES_ALLOC 272
2970 SUM_NUMBER_OF_BYTES_FREE 272
2971 LOW_COUNT_USED 0
2972 CURRENT_COUNT_USED 0
2973 HIGH_COUNT_USED 2
2974 LOW_NUMBER_OF_BYTES_USED 0
2975 CURRENT_NUMBER_OF_BYTES_USED 0
2976 HIGH_NUMBER_OF_BYTES_USED 272
2977 USER user2
2978 HOST localhost
2979 EVENT_NAME memory/sql/user_var_entry::value
2980 COUNT_ALLOC 3
2981 COUNT_FREE 3
2982 SUM_NUMBER_OF_BYTES_ALLOC 7024
2983 SUM_NUMBER_OF_BYTES_FREE 7024
2984 LOW_COUNT_USED 0
2985 CURRENT_COUNT_USED 0
2986 HIGH_COUNT_USED 3
2987 LOW_NUMBER_OF_BYTES_USED 0
2988 CURRENT_NUMBER_OF_BYTES_USED 0
2989 HIGH_NUMBER_OF_BYTES_USED 7024
2990 USER user3
2991 HOST localhost
2992 EVENT_NAME memory/sql/User_level_lock
2993 COUNT_ALLOC 2
2994 COUNT_FREE 2
2995 SUM_NUMBER_OF_BYTES_ALLOC 272
2996 SUM_NUMBER_OF_BYTES_FREE 272
2997 LOW_COUNT_USED 0
2998 CURRENT_COUNT_USED 0
2999 HIGH_COUNT_USED 2
3000 LOW_NUMBER_OF_BYTES_USED 0
3001 CURRENT_NUMBER_OF_BYTES_USED 0
3002 HIGH_NUMBER_OF_BYTES_USED 272
3003 USER user3
3004 HOST localhost
3005 EVENT_NAME memory/sql/user_var_entry::value
3006 COUNT_ALLOC 3
3007 COUNT_FREE 3
3008 SUM_NUMBER_OF_BYTES_ALLOC 7024
3009 SUM_NUMBER_OF_BYTES_FREE 7024
3010 LOW_COUNT_USED 0
3011 CURRENT_COUNT_USED 0
3012 HIGH_COUNT_USED 3
3013 LOW_NUMBER_OF_BYTES_USED 0
3014 CURRENT_NUMBER_OF_BYTES_USED 0
3015 HIGH_NUMBER_OF_BYTES_USED 7024
3016 USER user4
3017 HOST localhost
3018 EVENT_NAME memory/sql/User_level_lock
3019 COUNT_ALLOC 4
3020 COUNT_FREE 3
3021 SUM_NUMBER_OF_BYTES_ALLOC 544
3022 SUM_NUMBER_OF_BYTES_FREE 288
3023 LOW_COUNT_USED 0
3024 CURRENT_COUNT_USED 1
3025 HIGH_COUNT_USED 4
3026 LOW_NUMBER_OF_BYTES_USED 0
3027 CURRENT_NUMBER_OF_BYTES_USED 256
3028 HIGH_NUMBER_OF_BYTES_USED 544
3029 USER user4
3030 HOST localhost
3031 EVENT_NAME memory/sql/user_var_entry::value
3032 COUNT_ALLOC 6
3033 COUNT_FREE 3
3034 SUM_NUMBER_OF_BYTES_ALLOC 14048
3035 SUM_NUMBER_OF_BYTES_FREE 7024
3036 LOW_COUNT_USED 0
3037 CURRENT_COUNT_USED 3
3038 HIGH_COUNT_USED 6
3039 LOW_NUMBER_OF_BYTES_USED 0
3040 CURRENT_NUMBER_OF_BYTES_USED 7024
3041 HIGH_NUMBER_OF_BYTES_USED 14048
3042 execute dump_memory_user;
3043 USER user1
3044 EVENT_NAME memory/sql/User_level_lock
3045 COUNT_ALLOC 2
3046 COUNT_FREE 2
3047 SUM_NUMBER_OF_BYTES_ALLOC 272
3048 SUM_NUMBER_OF_BYTES_FREE 272
3049 LOW_COUNT_USED 0
3050 CURRENT_COUNT_USED 0
3051 HIGH_COUNT_USED 2
3052 LOW_NUMBER_OF_BYTES_USED 0
3053 CURRENT_NUMBER_OF_BYTES_USED 0
3054 HIGH_NUMBER_OF_BYTES_USED 272
3055 USER user1
3056 EVENT_NAME memory/sql/user_var_entry::value
3057 COUNT_ALLOC 3
3058 COUNT_FREE 3
3059 SUM_NUMBER_OF_BYTES_ALLOC 7024
3060 SUM_NUMBER_OF_BYTES_FREE 7024
3061 LOW_COUNT_USED 0
3062 CURRENT_COUNT_USED 0
3063 HIGH_COUNT_USED 3
3064 LOW_NUMBER_OF_BYTES_USED 0
3065 CURRENT_NUMBER_OF_BYTES_USED 0
3066 HIGH_NUMBER_OF_BYTES_USED 7024
3067 USER user2
3068 EVENT_NAME memory/sql/User_level_lock
3069 COUNT_ALLOC 2
3070 COUNT_FREE 2
3071 SUM_NUMBER_OF_BYTES_ALLOC 272
3072 SUM_NUMBER_OF_BYTES_FREE 272
3073 LOW_COUNT_USED 0
3074 CURRENT_COUNT_USED 0
3075 HIGH_COUNT_USED 2
3076 LOW_NUMBER_OF_BYTES_USED 0
3077 CURRENT_NUMBER_OF_BYTES_USED 0
3078 HIGH_NUMBER_OF_BYTES_USED 272
3079 USER user2
3080 EVENT_NAME memory/sql/user_var_entry::value
3081 COUNT_ALLOC 3
3082 COUNT_FREE 3
3083 SUM_NUMBER_OF_BYTES_ALLOC 7024
3084 SUM_NUMBER_OF_BYTES_FREE 7024
3085 LOW_COUNT_USED 0
3086 CURRENT_COUNT_USED 0
3087 HIGH_COUNT_USED 3
3088 LOW_NUMBER_OF_BYTES_USED 0
3089 CURRENT_NUMBER_OF_BYTES_USED 0
3090 HIGH_NUMBER_OF_BYTES_USED 7024
3091 USER user3
3092 EVENT_NAME memory/sql/User_level_lock
3093 COUNT_ALLOC 2
3094 COUNT_FREE 2
3095 SUM_NUMBER_OF_BYTES_ALLOC 272
3096 SUM_NUMBER_OF_BYTES_FREE 272
3097 LOW_COUNT_USED 0
3098 CURRENT_COUNT_USED 0
3099 HIGH_COUNT_USED 2
3100 LOW_NUMBER_OF_BYTES_USED 0
3101 CURRENT_NUMBER_OF_BYTES_USED 0
3102 HIGH_NUMBER_OF_BYTES_USED 272
3103 USER user3
3104 EVENT_NAME memory/sql/user_var_entry::value
3105 COUNT_ALLOC 3
3106 COUNT_FREE 3
3107 SUM_NUMBER_OF_BYTES_ALLOC 7024
3108 SUM_NUMBER_OF_BYTES_FREE 7024
3109 LOW_COUNT_USED 0
3110 CURRENT_COUNT_USED 0
3111 HIGH_COUNT_USED 3
3112 LOW_NUMBER_OF_BYTES_USED 0
3113 CURRENT_NUMBER_OF_BYTES_USED 0
3114 HIGH_NUMBER_OF_BYTES_USED 7024
3115 USER user4
3116 EVENT_NAME memory/sql/User_level_lock
3117 COUNT_ALLOC 4
3118 COUNT_FREE 3
3119 SUM_NUMBER_OF_BYTES_ALLOC 544
3120 SUM_NUMBER_OF_BYTES_FREE 288
3121 LOW_COUNT_USED 0
3122 CURRENT_COUNT_USED 1
3123 HIGH_COUNT_USED 4
3124 LOW_NUMBER_OF_BYTES_USED 0
3125 CURRENT_NUMBER_OF_BYTES_USED 256
3126 HIGH_NUMBER_OF_BYTES_USED 544
3127 USER user4
3128 EVENT_NAME memory/sql/user_var_entry::value
3129 COUNT_ALLOC 6
3130 COUNT_FREE 3
3131 SUM_NUMBER_OF_BYTES_ALLOC 14048
3132 SUM_NUMBER_OF_BYTES_FREE 7024
3133 LOW_COUNT_USED 0
3134 CURRENT_COUNT_USED 3
3135 HIGH_COUNT_USED 6
3136 LOW_NUMBER_OF_BYTES_USED 0
3137 CURRENT_NUMBER_OF_BYTES_USED 7024
3138 HIGH_NUMBER_OF_BYTES_USED 14048
3139 execute dump_memory_host;
3140 execute dump_memory_global;
3141 EVENT_NAME memory/sql/Query_cache
3142 COUNT_ALLOC 8
3143 COUNT_FREE 6
3144 SUM_NUMBER_OF_BYTES_ALLOC 131072
3145 SUM_NUMBER_OF_BYTES_FREE 98304
3146 LOW_COUNT_USED 0
3147 CURRENT_COUNT_USED 2
3148 HIGH_COUNT_USED 2
3149 LOW_NUMBER_OF_BYTES_USED 0
3150 CURRENT_NUMBER_OF_BYTES_USED 32768
3151 HIGH_NUMBER_OF_BYTES_USED 32768
3152 EVENT_NAME memory/sql/User_level_lock
3153 COUNT_ALLOC 10
3154 COUNT_FREE 9
3155 SUM_NUMBER_OF_BYTES_ALLOC 1360
3156 SUM_NUMBER_OF_BYTES_FREE 1104
3157 LOW_COUNT_USED 0
3158 CURRENT_COUNT_USED 1
3159 HIGH_COUNT_USED 10
3160 LOW_NUMBER_OF_BYTES_USED 0
3161 CURRENT_NUMBER_OF_BYTES_USED 256
3162 HIGH_NUMBER_OF_BYTES_USED 1360
3163 EVENT_NAME memory/sql/user_var_entry::value
3164 COUNT_ALLOC 16
3165 COUNT_FREE 12
3166 SUM_NUMBER_OF_BYTES_ALLOC 35216
3167 SUM_NUMBER_OF_BYTES_FREE 28096
3168 LOW_COUNT_USED 1
3169 CURRENT_COUNT_USED 4
3170 HIGH_COUNT_USED 16
3171 LOW_NUMBER_OF_BYTES_USED 96
3172 CURRENT_NUMBER_OF_BYTES_USED 7120
3173 HIGH_NUMBER_OF_BYTES_USED 35216
3174 execute dump_accounts;
3175 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3176 root localhost 1 1
3177 user1 localhost 0 1
3178 user2 localhost 0 1
3179 user3 localhost 0 1
3180 user4 localhost 1 2
3181 execute dump_users;
3182 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3183 root 1 1
3184 user1 0 1
3185 user2 0 1
3186 user3 0 1
3187 user4 1 2
3188 execute dump_hosts;
3189 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3190 disconnect con4;
3191 connection default;
3192 "================== con4 disconnected =================="
3193 "================== Step 13 =================="
3194 call dump_thread();
3195 username user1
3196 status not found
3197 username user2
3198 status not found
3199 username user3
3200 status not found
3201 username user4
3202 status not found
3203 execute dump_memory_account;
3204 USER user1
3205 HOST localhost
3206 EVENT_NAME memory/sql/User_level_lock
3207 COUNT_ALLOC 2
3208 COUNT_FREE 2
3209 SUM_NUMBER_OF_BYTES_ALLOC 272
3210 SUM_NUMBER_OF_BYTES_FREE 272
3211 LOW_COUNT_USED 0
3212 CURRENT_COUNT_USED 0
3213 HIGH_COUNT_USED 2
3214 LOW_NUMBER_OF_BYTES_USED 0
3215 CURRENT_NUMBER_OF_BYTES_USED 0
3216 HIGH_NUMBER_OF_BYTES_USED 272
3217 USER user1
3218 HOST localhost
3219 EVENT_NAME memory/sql/user_var_entry::value
3220 COUNT_ALLOC 3
3221 COUNT_FREE 3
3222 SUM_NUMBER_OF_BYTES_ALLOC 7024
3223 SUM_NUMBER_OF_BYTES_FREE 7024
3224 LOW_COUNT_USED 0
3225 CURRENT_COUNT_USED 0
3226 HIGH_COUNT_USED 3
3227 LOW_NUMBER_OF_BYTES_USED 0
3228 CURRENT_NUMBER_OF_BYTES_USED 0
3229 HIGH_NUMBER_OF_BYTES_USED 7024
3230 USER user2
3231 HOST localhost
3232 EVENT_NAME memory/sql/User_level_lock
3233 COUNT_ALLOC 2
3234 COUNT_FREE 2
3235 SUM_NUMBER_OF_BYTES_ALLOC 272
3236 SUM_NUMBER_OF_BYTES_FREE 272
3237 LOW_COUNT_USED 0
3238 CURRENT_COUNT_USED 0
3239 HIGH_COUNT_USED 2
3240 LOW_NUMBER_OF_BYTES_USED 0
3241 CURRENT_NUMBER_OF_BYTES_USED 0
3242 HIGH_NUMBER_OF_BYTES_USED 272
3243 USER user2
3244 HOST localhost
3245 EVENT_NAME memory/sql/user_var_entry::value
3246 COUNT_ALLOC 3
3247 COUNT_FREE 3
3248 SUM_NUMBER_OF_BYTES_ALLOC 7024
3249 SUM_NUMBER_OF_BYTES_FREE 7024
3250 LOW_COUNT_USED 0
3251 CURRENT_COUNT_USED 0
3252 HIGH_COUNT_USED 3
3253 LOW_NUMBER_OF_BYTES_USED 0
3254 CURRENT_NUMBER_OF_BYTES_USED 0
3255 HIGH_NUMBER_OF_BYTES_USED 7024
3256 USER user3
3257 HOST localhost
3258 EVENT_NAME memory/sql/User_level_lock
3259 COUNT_ALLOC 2
3260 COUNT_FREE 2
3261 SUM_NUMBER_OF_BYTES_ALLOC 272
3262 SUM_NUMBER_OF_BYTES_FREE 272
3263 LOW_COUNT_USED 0
3264 CURRENT_COUNT_USED 0
3265 HIGH_COUNT_USED 2
3266 LOW_NUMBER_OF_BYTES_USED 0
3267 CURRENT_NUMBER_OF_BYTES_USED 0
3268 HIGH_NUMBER_OF_BYTES_USED 272
3269 USER user3
3270 HOST localhost
3271 EVENT_NAME memory/sql/user_var_entry::value
3272 COUNT_ALLOC 3
3273 COUNT_FREE 3
3274 SUM_NUMBER_OF_BYTES_ALLOC 7024
3275 SUM_NUMBER_OF_BYTES_FREE 7024
3276 LOW_COUNT_USED 0
3277 CURRENT_COUNT_USED 0
3278 HIGH_COUNT_USED 3
3279 LOW_NUMBER_OF_BYTES_USED 0
3280 CURRENT_NUMBER_OF_BYTES_USED 0
3281 HIGH_NUMBER_OF_BYTES_USED 7024
3282 USER user4
3283 HOST localhost
3284 EVENT_NAME memory/sql/User_level_lock
3285 COUNT_ALLOC 4
3286 COUNT_FREE 4
3287 SUM_NUMBER_OF_BYTES_ALLOC 544
3288 SUM_NUMBER_OF_BYTES_FREE 544
3289 LOW_COUNT_USED 0
3290 CURRENT_COUNT_USED 0
3291 HIGH_COUNT_USED 4
3292 LOW_NUMBER_OF_BYTES_USED 0
3293 CURRENT_NUMBER_OF_BYTES_USED 0
3294 HIGH_NUMBER_OF_BYTES_USED 544
3295 USER user4
3296 HOST localhost
3297 EVENT_NAME memory/sql/user_var_entry::value
3298 COUNT_ALLOC 6
3299 COUNT_FREE 6
3300 SUM_NUMBER_OF_BYTES_ALLOC 14048
3301 SUM_NUMBER_OF_BYTES_FREE 14048
3302 LOW_COUNT_USED 0
3303 CURRENT_COUNT_USED 0
3304 HIGH_COUNT_USED 6
3305 LOW_NUMBER_OF_BYTES_USED 0
3306 CURRENT_NUMBER_OF_BYTES_USED 0
3307 HIGH_NUMBER_OF_BYTES_USED 14048
3308 execute dump_memory_user;
3309 USER user1
3310 EVENT_NAME memory/sql/User_level_lock
3311 COUNT_ALLOC 2
3312 COUNT_FREE 2
3313 SUM_NUMBER_OF_BYTES_ALLOC 272
3314 SUM_NUMBER_OF_BYTES_FREE 272
3315 LOW_COUNT_USED 0
3316 CURRENT_COUNT_USED 0
3317 HIGH_COUNT_USED 2
3318 LOW_NUMBER_OF_BYTES_USED 0
3319 CURRENT_NUMBER_OF_BYTES_USED 0
3320 HIGH_NUMBER_OF_BYTES_USED 272
3321 USER user1
3322 EVENT_NAME memory/sql/user_var_entry::value
3323 COUNT_ALLOC 3
3324 COUNT_FREE 3
3325 SUM_NUMBER_OF_BYTES_ALLOC 7024
3326 SUM_NUMBER_OF_BYTES_FREE 7024
3327 LOW_COUNT_USED 0
3328 CURRENT_COUNT_USED 0
3329 HIGH_COUNT_USED 3
3330 LOW_NUMBER_OF_BYTES_USED 0
3331 CURRENT_NUMBER_OF_BYTES_USED 0
3332 HIGH_NUMBER_OF_BYTES_USED 7024
3333 USER user2
3334 EVENT_NAME memory/sql/User_level_lock
3335 COUNT_ALLOC 2
3336 COUNT_FREE 2
3337 SUM_NUMBER_OF_BYTES_ALLOC 272
3338 SUM_NUMBER_OF_BYTES_FREE 272
3339 LOW_COUNT_USED 0
3340 CURRENT_COUNT_USED 0
3341 HIGH_COUNT_USED 2
3342 LOW_NUMBER_OF_BYTES_USED 0
3343 CURRENT_NUMBER_OF_BYTES_USED 0
3344 HIGH_NUMBER_OF_BYTES_USED 272
3345 USER user2
3346 EVENT_NAME memory/sql/user_var_entry::value
3347 COUNT_ALLOC 3
3348 COUNT_FREE 3
3349 SUM_NUMBER_OF_BYTES_ALLOC 7024
3350 SUM_NUMBER_OF_BYTES_FREE 7024
3351 LOW_COUNT_USED 0
3352 CURRENT_COUNT_USED 0
3353 HIGH_COUNT_USED 3
3354 LOW_NUMBER_OF_BYTES_USED 0
3355 CURRENT_NUMBER_OF_BYTES_USED 0
3356 HIGH_NUMBER_OF_BYTES_USED 7024
3357 USER user3
3358 EVENT_NAME memory/sql/User_level_lock
3359 COUNT_ALLOC 2
3360 COUNT_FREE 2
3361 SUM_NUMBER_OF_BYTES_ALLOC 272
3362 SUM_NUMBER_OF_BYTES_FREE 272
3363 LOW_COUNT_USED 0
3364 CURRENT_COUNT_USED 0
3365 HIGH_COUNT_USED 2
3366 LOW_NUMBER_OF_BYTES_USED 0
3367 CURRENT_NUMBER_OF_BYTES_USED 0
3368 HIGH_NUMBER_OF_BYTES_USED 272
3369 USER user3
3370 EVENT_NAME memory/sql/user_var_entry::value
3371 COUNT_ALLOC 3
3372 COUNT_FREE 3
3373 SUM_NUMBER_OF_BYTES_ALLOC 7024
3374 SUM_NUMBER_OF_BYTES_FREE 7024
3375 LOW_COUNT_USED 0
3376 CURRENT_COUNT_USED 0
3377 HIGH_COUNT_USED 3
3378 LOW_NUMBER_OF_BYTES_USED 0
3379 CURRENT_NUMBER_OF_BYTES_USED 0
3380 HIGH_NUMBER_OF_BYTES_USED 7024
3381 USER user4
3382 EVENT_NAME memory/sql/User_level_lock
3383 COUNT_ALLOC 4
3384 COUNT_FREE 4
3385 SUM_NUMBER_OF_BYTES_ALLOC 544
3386 SUM_NUMBER_OF_BYTES_FREE 544
3387 LOW_COUNT_USED 0
3388 CURRENT_COUNT_USED 0
3389 HIGH_COUNT_USED 4
3390 LOW_NUMBER_OF_BYTES_USED 0
3391 CURRENT_NUMBER_OF_BYTES_USED 0
3392 HIGH_NUMBER_OF_BYTES_USED 544
3393 USER user4
3394 EVENT_NAME memory/sql/user_var_entry::value
3395 COUNT_ALLOC 6
3396 COUNT_FREE 6
3397 SUM_NUMBER_OF_BYTES_ALLOC 14048
3398 SUM_NUMBER_OF_BYTES_FREE 14048
3399 LOW_COUNT_USED 0
3400 CURRENT_COUNT_USED 0
3401 HIGH_COUNT_USED 6
3402 LOW_NUMBER_OF_BYTES_USED 0
3403 CURRENT_NUMBER_OF_BYTES_USED 0
3404 HIGH_NUMBER_OF_BYTES_USED 14048
3405 execute dump_memory_host;
3406 execute dump_memory_global;
3407 EVENT_NAME memory/sql/Query_cache
3408 COUNT_ALLOC 8
3409 COUNT_FREE 6
3410 SUM_NUMBER_OF_BYTES_ALLOC 131072
3411 SUM_NUMBER_OF_BYTES_FREE 98304
3412 LOW_COUNT_USED 0
3413 CURRENT_COUNT_USED 2
3414 HIGH_COUNT_USED 2
3415 LOW_NUMBER_OF_BYTES_USED 0
3416 CURRENT_NUMBER_OF_BYTES_USED 32768
3417 HIGH_NUMBER_OF_BYTES_USED 32768
3418 EVENT_NAME memory/sql/User_level_lock
3419 COUNT_ALLOC 10
3420 COUNT_FREE 10
3421 SUM_NUMBER_OF_BYTES_ALLOC 1360
3422 SUM_NUMBER_OF_BYTES_FREE 1360
3423 LOW_COUNT_USED 0
3424 CURRENT_COUNT_USED 0
3425 HIGH_COUNT_USED 10
3426 LOW_NUMBER_OF_BYTES_USED 0
3427 CURRENT_NUMBER_OF_BYTES_USED 0
3428 HIGH_NUMBER_OF_BYTES_USED 1360
3429 EVENT_NAME memory/sql/user_var_entry::value
3430 COUNT_ALLOC 16
3431 COUNT_FREE 15
3432 SUM_NUMBER_OF_BYTES_ALLOC 35216
3433 SUM_NUMBER_OF_BYTES_FREE 35120
3434 LOW_COUNT_USED 1
3435 CURRENT_COUNT_USED 1
3436 HIGH_COUNT_USED 16
3437 LOW_NUMBER_OF_BYTES_USED 96
3438 CURRENT_NUMBER_OF_BYTES_USED 96
3439 HIGH_NUMBER_OF_BYTES_USED 35216
3440 execute dump_accounts;
3441 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3442 root localhost 1 1
3443 user1 localhost 0 1
3444 user2 localhost 0 1
3445 user3 localhost 0 1
3446 user4 localhost 0 2
3447 execute dump_users;
3448 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3449 root 1 1
3450 user1 0 1
3451 user2 0 1
3452 user3 0 1
3453 user4 0 2
3454 execute dump_hosts;
3455 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3456 connection default;
3457 truncate performance_schema.memory_summary_by_thread_by_event_name;
3458 "================== MEMORY_BY_THREAD truncated =================="
3459 "================== Step 14 =================="
3460 call dump_thread();
3461 username user1
3462 status not found
3463 username user2
3464 status not found
3465 username user3
3466 status not found
3467 username user4
3468 status not found
3469 execute dump_memory_account;
3470 USER user1
3471 HOST localhost
3472 EVENT_NAME memory/sql/User_level_lock
3473 COUNT_ALLOC 2
3474 COUNT_FREE 2
3475 SUM_NUMBER_OF_BYTES_ALLOC 272
3476 SUM_NUMBER_OF_BYTES_FREE 272
3477 LOW_COUNT_USED 0
3478 CURRENT_COUNT_USED 0
3479 HIGH_COUNT_USED 2
3480 LOW_NUMBER_OF_BYTES_USED 0
3481 CURRENT_NUMBER_OF_BYTES_USED 0
3482 HIGH_NUMBER_OF_BYTES_USED 272
3483 USER user1
3484 HOST localhost
3485 EVENT_NAME memory/sql/user_var_entry::value
3486 COUNT_ALLOC 3
3487 COUNT_FREE 3
3488 SUM_NUMBER_OF_BYTES_ALLOC 7024
3489 SUM_NUMBER_OF_BYTES_FREE 7024
3490 LOW_COUNT_USED 0
3491 CURRENT_COUNT_USED 0
3492 HIGH_COUNT_USED 3
3493 LOW_NUMBER_OF_BYTES_USED 0
3494 CURRENT_NUMBER_OF_BYTES_USED 0
3495 HIGH_NUMBER_OF_BYTES_USED 7024
3496 USER user2
3497 HOST localhost
3498 EVENT_NAME memory/sql/User_level_lock
3499 COUNT_ALLOC 2
3500 COUNT_FREE 2
3501 SUM_NUMBER_OF_BYTES_ALLOC 272
3502 SUM_NUMBER_OF_BYTES_FREE 272
3503 LOW_COUNT_USED 0
3504 CURRENT_COUNT_USED 0
3505 HIGH_COUNT_USED 2
3506 LOW_NUMBER_OF_BYTES_USED 0
3507 CURRENT_NUMBER_OF_BYTES_USED 0
3508 HIGH_NUMBER_OF_BYTES_USED 272
3509 USER user2
3510 HOST localhost
3511 EVENT_NAME memory/sql/user_var_entry::value
3512 COUNT_ALLOC 3
3513 COUNT_FREE 3
3514 SUM_NUMBER_OF_BYTES_ALLOC 7024
3515 SUM_NUMBER_OF_BYTES_FREE 7024
3516 LOW_COUNT_USED 0
3517 CURRENT_COUNT_USED 0
3518 HIGH_COUNT_USED 3
3519 LOW_NUMBER_OF_BYTES_USED 0
3520 CURRENT_NUMBER_OF_BYTES_USED 0
3521 HIGH_NUMBER_OF_BYTES_USED 7024
3522 USER user3
3523 HOST localhost
3524 EVENT_NAME memory/sql/User_level_lock
3525 COUNT_ALLOC 2
3526 COUNT_FREE 2
3527 SUM_NUMBER_OF_BYTES_ALLOC 272
3528 SUM_NUMBER_OF_BYTES_FREE 272
3529 LOW_COUNT_USED 0
3530 CURRENT_COUNT_USED 0
3531 HIGH_COUNT_USED 2
3532 LOW_NUMBER_OF_BYTES_USED 0
3533 CURRENT_NUMBER_OF_BYTES_USED 0
3534 HIGH_NUMBER_OF_BYTES_USED 272
3535 USER user3
3536 HOST localhost
3537 EVENT_NAME memory/sql/user_var_entry::value
3538 COUNT_ALLOC 3
3539 COUNT_FREE 3
3540 SUM_NUMBER_OF_BYTES_ALLOC 7024
3541 SUM_NUMBER_OF_BYTES_FREE 7024
3542 LOW_COUNT_USED 0
3543 CURRENT_COUNT_USED 0
3544 HIGH_COUNT_USED 3
3545 LOW_NUMBER_OF_BYTES_USED 0
3546 CURRENT_NUMBER_OF_BYTES_USED 0
3547 HIGH_NUMBER_OF_BYTES_USED 7024
3548 USER user4
3549 HOST localhost
3550 EVENT_NAME memory/sql/User_level_lock
3551 COUNT_ALLOC 4
3552 COUNT_FREE 4
3553 SUM_NUMBER_OF_BYTES_ALLOC 544
3554 SUM_NUMBER_OF_BYTES_FREE 544
3555 LOW_COUNT_USED 0
3556 CURRENT_COUNT_USED 0
3557 HIGH_COUNT_USED 4
3558 LOW_NUMBER_OF_BYTES_USED 0
3559 CURRENT_NUMBER_OF_BYTES_USED 0
3560 HIGH_NUMBER_OF_BYTES_USED 544
3561 USER user4
3562 HOST localhost
3563 EVENT_NAME memory/sql/user_var_entry::value
3564 COUNT_ALLOC 6
3565 COUNT_FREE 6
3566 SUM_NUMBER_OF_BYTES_ALLOC 14048
3567 SUM_NUMBER_OF_BYTES_FREE 14048
3568 LOW_COUNT_USED 0
3569 CURRENT_COUNT_USED 0
3570 HIGH_COUNT_USED 6
3571 LOW_NUMBER_OF_BYTES_USED 0
3572 CURRENT_NUMBER_OF_BYTES_USED 0
3573 HIGH_NUMBER_OF_BYTES_USED 14048
3574 execute dump_memory_user;
3575 USER user1
3576 EVENT_NAME memory/sql/User_level_lock
3577 COUNT_ALLOC 2
3578 COUNT_FREE 2
3579 SUM_NUMBER_OF_BYTES_ALLOC 272
3580 SUM_NUMBER_OF_BYTES_FREE 272
3581 LOW_COUNT_USED 0
3582 CURRENT_COUNT_USED 0
3583 HIGH_COUNT_USED 2
3584 LOW_NUMBER_OF_BYTES_USED 0
3585 CURRENT_NUMBER_OF_BYTES_USED 0
3586 HIGH_NUMBER_OF_BYTES_USED 272
3587 USER user1
3588 EVENT_NAME memory/sql/user_var_entry::value
3589 COUNT_ALLOC 3
3590 COUNT_FREE 3
3591 SUM_NUMBER_OF_BYTES_ALLOC 7024
3592 SUM_NUMBER_OF_BYTES_FREE 7024
3593 LOW_COUNT_USED 0
3594 CURRENT_COUNT_USED 0
3595 HIGH_COUNT_USED 3
3596 LOW_NUMBER_OF_BYTES_USED 0
3597 CURRENT_NUMBER_OF_BYTES_USED 0
3598 HIGH_NUMBER_OF_BYTES_USED 7024
3599 USER user2
3600 EVENT_NAME memory/sql/User_level_lock
3601 COUNT_ALLOC 2
3602 COUNT_FREE 2
3603 SUM_NUMBER_OF_BYTES_ALLOC 272
3604 SUM_NUMBER_OF_BYTES_FREE 272
3605 LOW_COUNT_USED 0
3606 CURRENT_COUNT_USED 0
3607 HIGH_COUNT_USED 2
3608 LOW_NUMBER_OF_BYTES_USED 0
3609 CURRENT_NUMBER_OF_BYTES_USED 0
3610 HIGH_NUMBER_OF_BYTES_USED 272
3611 USER user2
3612 EVENT_NAME memory/sql/user_var_entry::value
3613 COUNT_ALLOC 3
3614 COUNT_FREE 3
3615 SUM_NUMBER_OF_BYTES_ALLOC 7024
3616 SUM_NUMBER_OF_BYTES_FREE 7024
3617 LOW_COUNT_USED 0
3618 CURRENT_COUNT_USED 0
3619 HIGH_COUNT_USED 3
3620 LOW_NUMBER_OF_BYTES_USED 0
3621 CURRENT_NUMBER_OF_BYTES_USED 0
3622 HIGH_NUMBER_OF_BYTES_USED 7024
3623 USER user3
3624 EVENT_NAME memory/sql/User_level_lock
3625 COUNT_ALLOC 2
3626 COUNT_FREE 2
3627 SUM_NUMBER_OF_BYTES_ALLOC 272
3628 SUM_NUMBER_OF_BYTES_FREE 272
3629 LOW_COUNT_USED 0
3630 CURRENT_COUNT_USED 0
3631 HIGH_COUNT_USED 2
3632 LOW_NUMBER_OF_BYTES_USED 0
3633 CURRENT_NUMBER_OF_BYTES_USED 0
3634 HIGH_NUMBER_OF_BYTES_USED 272
3635 USER user3
3636 EVENT_NAME memory/sql/user_var_entry::value
3637 COUNT_ALLOC 3
3638 COUNT_FREE 3
3639 SUM_NUMBER_OF_BYTES_ALLOC 7024
3640 SUM_NUMBER_OF_BYTES_FREE 7024
3641 LOW_COUNT_USED 0
3642 CURRENT_COUNT_USED 0
3643 HIGH_COUNT_USED 3
3644 LOW_NUMBER_OF_BYTES_USED 0
3645 CURRENT_NUMBER_OF_BYTES_USED 0
3646 HIGH_NUMBER_OF_BYTES_USED 7024
3647 USER user4
3648 EVENT_NAME memory/sql/User_level_lock
3649 COUNT_ALLOC 4
3650 COUNT_FREE 4
3651 SUM_NUMBER_OF_BYTES_ALLOC 544
3652 SUM_NUMBER_OF_BYTES_FREE 544
3653 LOW_COUNT_USED 0
3654 CURRENT_COUNT_USED 0
3655 HIGH_COUNT_USED 4
3656 LOW_NUMBER_OF_BYTES_USED 0
3657 CURRENT_NUMBER_OF_BYTES_USED 0
3658 HIGH_NUMBER_OF_BYTES_USED 544
3659 USER user4
3660 EVENT_NAME memory/sql/user_var_entry::value
3661 COUNT_ALLOC 6
3662 COUNT_FREE 6
3663 SUM_NUMBER_OF_BYTES_ALLOC 14048
3664 SUM_NUMBER_OF_BYTES_FREE 14048
3665 LOW_COUNT_USED 0
3666 CURRENT_COUNT_USED 0
3667 HIGH_COUNT_USED 6
3668 LOW_NUMBER_OF_BYTES_USED 0
3669 CURRENT_NUMBER_OF_BYTES_USED 0
3670 HIGH_NUMBER_OF_BYTES_USED 14048
3671 execute dump_memory_host;
3672 execute dump_memory_global;
3673 EVENT_NAME memory/sql/Query_cache
3674 COUNT_ALLOC 8
3675 COUNT_FREE 6
3676 SUM_NUMBER_OF_BYTES_ALLOC 131072
3677 SUM_NUMBER_OF_BYTES_FREE 98304
3678 LOW_COUNT_USED 0
3679 CURRENT_COUNT_USED 2
3680 HIGH_COUNT_USED 2
3681 LOW_NUMBER_OF_BYTES_USED 0
3682 CURRENT_NUMBER_OF_BYTES_USED 32768
3683 HIGH_NUMBER_OF_BYTES_USED 32768
3684 EVENT_NAME memory/sql/User_level_lock
3685 COUNT_ALLOC 10
3686 COUNT_FREE 10
3687 SUM_NUMBER_OF_BYTES_ALLOC 1360
3688 SUM_NUMBER_OF_BYTES_FREE 1360
3689 LOW_COUNT_USED 0
3690 CURRENT_COUNT_USED 0
3691 HIGH_COUNT_USED 10
3692 LOW_NUMBER_OF_BYTES_USED 0
3693 CURRENT_NUMBER_OF_BYTES_USED 0
3694 HIGH_NUMBER_OF_BYTES_USED 1360
3695 EVENT_NAME memory/sql/user_var_entry::value
3696 COUNT_ALLOC 16
3697 COUNT_FREE 15
3698 SUM_NUMBER_OF_BYTES_ALLOC 35216
3699 SUM_NUMBER_OF_BYTES_FREE 35120
3700 LOW_COUNT_USED 1
3701 CURRENT_COUNT_USED 1
3702 HIGH_COUNT_USED 16
3703 LOW_NUMBER_OF_BYTES_USED 96
3704 CURRENT_NUMBER_OF_BYTES_USED 96
3705 HIGH_NUMBER_OF_BYTES_USED 35216
3706 execute dump_accounts;
3707 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3708 root localhost 1 1
3709 user1 localhost 0 1
3710 user2 localhost 0 1
3711 user3 localhost 0 1
3712 user4 localhost 0 2
3713 execute dump_users;
3714 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3715 root 1 1
3716 user1 0 1
3717 user2 0 1
3718 user3 0 1
3719 user4 0 2
3720 execute dump_hosts;
3721 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3722 truncate performance_schema.memory_summary_by_account_by_event_name;
3723 "================== MEMORY_BY_ACCOUNT truncated =================="
3724 "================== Step 15 =================="
3725 call dump_thread();
3726 username user1
3727 status not found
3728 username user2
3729 status not found
3730 username user3
3731 status not found
3732 username user4
3733 status not found
3734 execute dump_memory_account;
3735 USER user1
3736 HOST localhost
3737 EVENT_NAME memory/sql/User_level_lock
3738 COUNT_ALLOC 0
3739 COUNT_FREE 0
3740 SUM_NUMBER_OF_BYTES_ALLOC 0
3741 SUM_NUMBER_OF_BYTES_FREE 0
3742 LOW_COUNT_USED 0
3743 CURRENT_COUNT_USED 0
3744 HIGH_COUNT_USED 0
3745 LOW_NUMBER_OF_BYTES_USED 0
3746 CURRENT_NUMBER_OF_BYTES_USED 0
3747 HIGH_NUMBER_OF_BYTES_USED 0
3748 USER user1
3749 HOST localhost
3750 EVENT_NAME memory/sql/user_var_entry::value
3751 COUNT_ALLOC 0
3752 COUNT_FREE 0
3753 SUM_NUMBER_OF_BYTES_ALLOC 0
3754 SUM_NUMBER_OF_BYTES_FREE 0
3755 LOW_COUNT_USED 0
3756 CURRENT_COUNT_USED 0
3757 HIGH_COUNT_USED 0
3758 LOW_NUMBER_OF_BYTES_USED 0
3759 CURRENT_NUMBER_OF_BYTES_USED 0
3760 HIGH_NUMBER_OF_BYTES_USED 0
3761 USER user2
3762 HOST localhost
3763 EVENT_NAME memory/sql/User_level_lock
3764 COUNT_ALLOC 0
3765 COUNT_FREE 0
3766 SUM_NUMBER_OF_BYTES_ALLOC 0
3767 SUM_NUMBER_OF_BYTES_FREE 0
3768 LOW_COUNT_USED 0
3769 CURRENT_COUNT_USED 0
3770 HIGH_COUNT_USED 0
3771 LOW_NUMBER_OF_BYTES_USED 0
3772 CURRENT_NUMBER_OF_BYTES_USED 0
3773 HIGH_NUMBER_OF_BYTES_USED 0
3774 USER user2
3775 HOST localhost
3776 EVENT_NAME memory/sql/user_var_entry::value
3777 COUNT_ALLOC 0
3778 COUNT_FREE 0
3779 SUM_NUMBER_OF_BYTES_ALLOC 0
3780 SUM_NUMBER_OF_BYTES_FREE 0
3781 LOW_COUNT_USED 0
3782 CURRENT_COUNT_USED 0
3783 HIGH_COUNT_USED 0
3784 LOW_NUMBER_OF_BYTES_USED 0
3785 CURRENT_NUMBER_OF_BYTES_USED 0
3786 HIGH_NUMBER_OF_BYTES_USED 0
3787 USER user3
3788 HOST localhost
3789 EVENT_NAME memory/sql/User_level_lock
3790 COUNT_ALLOC 0
3791 COUNT_FREE 0
3792 SUM_NUMBER_OF_BYTES_ALLOC 0
3793 SUM_NUMBER_OF_BYTES_FREE 0
3794 LOW_COUNT_USED 0
3795 CURRENT_COUNT_USED 0
3796 HIGH_COUNT_USED 0
3797 LOW_NUMBER_OF_BYTES_USED 0
3798 CURRENT_NUMBER_OF_BYTES_USED 0
3799 HIGH_NUMBER_OF_BYTES_USED 0
3800 USER user3
3801 HOST localhost
3802 EVENT_NAME memory/sql/user_var_entry::value
3803 COUNT_ALLOC 0
3804 COUNT_FREE 0
3805 SUM_NUMBER_OF_BYTES_ALLOC 0
3806 SUM_NUMBER_OF_BYTES_FREE 0
3807 LOW_COUNT_USED 0
3808 CURRENT_COUNT_USED 0
3809 HIGH_COUNT_USED 0
3810 LOW_NUMBER_OF_BYTES_USED 0
3811 CURRENT_NUMBER_OF_BYTES_USED 0
3812 HIGH_NUMBER_OF_BYTES_USED 0
3813 USER user4
3814 HOST localhost
3815 EVENT_NAME memory/sql/User_level_lock
3816 COUNT_ALLOC 0
3817 COUNT_FREE 0
3818 SUM_NUMBER_OF_BYTES_ALLOC 0
3819 SUM_NUMBER_OF_BYTES_FREE 0
3820 LOW_COUNT_USED 0
3821 CURRENT_COUNT_USED 0
3822 HIGH_COUNT_USED 0
3823 LOW_NUMBER_OF_BYTES_USED 0
3824 CURRENT_NUMBER_OF_BYTES_USED 0
3825 HIGH_NUMBER_OF_BYTES_USED 0
3826 USER user4
3827 HOST localhost
3828 EVENT_NAME memory/sql/user_var_entry::value
3829 COUNT_ALLOC 0
3830 COUNT_FREE 0
3831 SUM_NUMBER_OF_BYTES_ALLOC 0
3832 SUM_NUMBER_OF_BYTES_FREE 0
3833 LOW_COUNT_USED 0
3834 CURRENT_COUNT_USED 0
3835 HIGH_COUNT_USED 0
3836 LOW_NUMBER_OF_BYTES_USED 0
3837 CURRENT_NUMBER_OF_BYTES_USED 0
3838 HIGH_NUMBER_OF_BYTES_USED 0
3839 execute dump_memory_user;
3840 USER user1
3841 EVENT_NAME memory/sql/User_level_lock
3842 COUNT_ALLOC 2
3843 COUNT_FREE 2
3844 SUM_NUMBER_OF_BYTES_ALLOC 272
3845 SUM_NUMBER_OF_BYTES_FREE 272
3846 LOW_COUNT_USED 0
3847 CURRENT_COUNT_USED 0
3848 HIGH_COUNT_USED 2
3849 LOW_NUMBER_OF_BYTES_USED 0
3850 CURRENT_NUMBER_OF_BYTES_USED 0
3851 HIGH_NUMBER_OF_BYTES_USED 272
3852 USER user1
3853 EVENT_NAME memory/sql/user_var_entry::value
3854 COUNT_ALLOC 3
3855 COUNT_FREE 3
3856 SUM_NUMBER_OF_BYTES_ALLOC 7024
3857 SUM_NUMBER_OF_BYTES_FREE 7024
3858 LOW_COUNT_USED 0
3859 CURRENT_COUNT_USED 0
3860 HIGH_COUNT_USED 3
3861 LOW_NUMBER_OF_BYTES_USED 0
3862 CURRENT_NUMBER_OF_BYTES_USED 0
3863 HIGH_NUMBER_OF_BYTES_USED 7024
3864 USER user2
3865 EVENT_NAME memory/sql/User_level_lock
3866 COUNT_ALLOC 2
3867 COUNT_FREE 2
3868 SUM_NUMBER_OF_BYTES_ALLOC 272
3869 SUM_NUMBER_OF_BYTES_FREE 272
3870 LOW_COUNT_USED 0
3871 CURRENT_COUNT_USED 0
3872 HIGH_COUNT_USED 2
3873 LOW_NUMBER_OF_BYTES_USED 0
3874 CURRENT_NUMBER_OF_BYTES_USED 0
3875 HIGH_NUMBER_OF_BYTES_USED 272
3876 USER user2
3877 EVENT_NAME memory/sql/user_var_entry::value
3878 COUNT_ALLOC 3
3879 COUNT_FREE 3
3880 SUM_NUMBER_OF_BYTES_ALLOC 7024
3881 SUM_NUMBER_OF_BYTES_FREE 7024
3882 LOW_COUNT_USED 0
3883 CURRENT_COUNT_USED 0
3884 HIGH_COUNT_USED 3
3885 LOW_NUMBER_OF_BYTES_USED 0
3886 CURRENT_NUMBER_OF_BYTES_USED 0
3887 HIGH_NUMBER_OF_BYTES_USED 7024
3888 USER user3
3889 EVENT_NAME memory/sql/User_level_lock
3890 COUNT_ALLOC 2
3891 COUNT_FREE 2
3892 SUM_NUMBER_OF_BYTES_ALLOC 272
3893 SUM_NUMBER_OF_BYTES_FREE 272
3894 LOW_COUNT_USED 0
3895 CURRENT_COUNT_USED 0
3896 HIGH_COUNT_USED 2
3897 LOW_NUMBER_OF_BYTES_USED 0
3898 CURRENT_NUMBER_OF_BYTES_USED 0
3899 HIGH_NUMBER_OF_BYTES_USED 272
3900 USER user3
3901 EVENT_NAME memory/sql/user_var_entry::value
3902 COUNT_ALLOC 3
3903 COUNT_FREE 3
3904 SUM_NUMBER_OF_BYTES_ALLOC 7024
3905 SUM_NUMBER_OF_BYTES_FREE 7024
3906 LOW_COUNT_USED 0
3907 CURRENT_COUNT_USED 0
3908 HIGH_COUNT_USED 3
3909 LOW_NUMBER_OF_BYTES_USED 0
3910 CURRENT_NUMBER_OF_BYTES_USED 0
3911 HIGH_NUMBER_OF_BYTES_USED 7024
3912 USER user4
3913 EVENT_NAME memory/sql/User_level_lock
3914 COUNT_ALLOC 4
3915 COUNT_FREE 4
3916 SUM_NUMBER_OF_BYTES_ALLOC 544
3917 SUM_NUMBER_OF_BYTES_FREE 544
3918 LOW_COUNT_USED 0
3919 CURRENT_COUNT_USED 0
3920 HIGH_COUNT_USED 4
3921 LOW_NUMBER_OF_BYTES_USED 0
3922 CURRENT_NUMBER_OF_BYTES_USED 0
3923 HIGH_NUMBER_OF_BYTES_USED 544
3924 USER user4
3925 EVENT_NAME memory/sql/user_var_entry::value
3926 COUNT_ALLOC 6
3927 COUNT_FREE 6
3928 SUM_NUMBER_OF_BYTES_ALLOC 14048
3929 SUM_NUMBER_OF_BYTES_FREE 14048
3930 LOW_COUNT_USED 0
3931 CURRENT_COUNT_USED 0
3932 HIGH_COUNT_USED 6
3933 LOW_NUMBER_OF_BYTES_USED 0
3934 CURRENT_NUMBER_OF_BYTES_USED 0
3935 HIGH_NUMBER_OF_BYTES_USED 14048
3936 execute dump_memory_host;
3937 execute dump_memory_global;
3938 EVENT_NAME memory/sql/Query_cache
3939 COUNT_ALLOC 8
3940 COUNT_FREE 6
3941 SUM_NUMBER_OF_BYTES_ALLOC 131072
3942 SUM_NUMBER_OF_BYTES_FREE 98304
3943 LOW_COUNT_USED 0
3944 CURRENT_COUNT_USED 2
3945 HIGH_COUNT_USED 2
3946 LOW_NUMBER_OF_BYTES_USED 0
3947 CURRENT_NUMBER_OF_BYTES_USED 32768
3948 HIGH_NUMBER_OF_BYTES_USED 32768
3949 EVENT_NAME memory/sql/User_level_lock
3950 COUNT_ALLOC 10
3951 COUNT_FREE 10
3952 SUM_NUMBER_OF_BYTES_ALLOC 1360
3953 SUM_NUMBER_OF_BYTES_FREE 1360
3954 LOW_COUNT_USED 0
3955 CURRENT_COUNT_USED 0
3956 HIGH_COUNT_USED 10
3957 LOW_NUMBER_OF_BYTES_USED 0
3958 CURRENT_NUMBER_OF_BYTES_USED 0
3959 HIGH_NUMBER_OF_BYTES_USED 1360
3960 EVENT_NAME memory/sql/user_var_entry::value
3961 COUNT_ALLOC 16
3962 COUNT_FREE 15
3963 SUM_NUMBER_OF_BYTES_ALLOC 35216
3964 SUM_NUMBER_OF_BYTES_FREE 35120
3965 LOW_COUNT_USED 1
3966 CURRENT_COUNT_USED 1
3967 HIGH_COUNT_USED 16
3968 LOW_NUMBER_OF_BYTES_USED 96
3969 CURRENT_NUMBER_OF_BYTES_USED 96
3970 HIGH_NUMBER_OF_BYTES_USED 35216
3971 execute dump_accounts;
3972 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3973 root localhost 1 1
3974 user1 localhost 0 1
3975 user2 localhost 0 1
3976 user3 localhost 0 1
3977 user4 localhost 0 2
3978 execute dump_users;
3979 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3980 root 1 1
3981 user1 0 1
3982 user2 0 1
3983 user3 0 1
3984 user4 0 2
3985 execute dump_hosts;
3986 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3987 truncate performance_schema.memory_summary_by_user_by_event_name;
3988 "================== MEMORY_BY_USER truncated =================="
3989 "================== Step 16 =================="
3990 call dump_thread();
3991 username user1
3992 status not found
3993 username user2
3994 status not found
3995 username user3
3996 status not found
3997 username user4
3998 status not found
3999 execute dump_memory_account;
4000 USER user1
4001 HOST localhost
4002 EVENT_NAME memory/sql/User_level_lock
4003 COUNT_ALLOC 0
4004 COUNT_FREE 0
4005 SUM_NUMBER_OF_BYTES_ALLOC 0
4006 SUM_NUMBER_OF_BYTES_FREE 0
4007 LOW_COUNT_USED 0
4008 CURRENT_COUNT_USED 0
4009 HIGH_COUNT_USED 0
4010 LOW_NUMBER_OF_BYTES_USED 0
4011 CURRENT_NUMBER_OF_BYTES_USED 0
4012 HIGH_NUMBER_OF_BYTES_USED 0
4013 USER user1
4014 HOST localhost
4015 EVENT_NAME memory/sql/user_var_entry::value
4016 COUNT_ALLOC 0
4017 COUNT_FREE 0
4018 SUM_NUMBER_OF_BYTES_ALLOC 0
4019 SUM_NUMBER_OF_BYTES_FREE 0
4020 LOW_COUNT_USED 0
4021 CURRENT_COUNT_USED 0
4022 HIGH_COUNT_USED 0
4023 LOW_NUMBER_OF_BYTES_USED 0
4024 CURRENT_NUMBER_OF_BYTES_USED 0
4025 HIGH_NUMBER_OF_BYTES_USED 0
4026 USER user2
4027 HOST localhost
4028 EVENT_NAME memory/sql/User_level_lock
4029 COUNT_ALLOC 0
4030 COUNT_FREE 0
4031 SUM_NUMBER_OF_BYTES_ALLOC 0
4032 SUM_NUMBER_OF_BYTES_FREE 0
4033 LOW_COUNT_USED 0
4034 CURRENT_COUNT_USED 0
4035 HIGH_COUNT_USED 0
4036 LOW_NUMBER_OF_BYTES_USED 0
4037 CURRENT_NUMBER_OF_BYTES_USED 0
4038 HIGH_NUMBER_OF_BYTES_USED 0
4039 USER user2
4040 HOST localhost
4041 EVENT_NAME memory/sql/user_var_entry::value
4042 COUNT_ALLOC 0
4043 COUNT_FREE 0
4044 SUM_NUMBER_OF_BYTES_ALLOC 0
4045 SUM_NUMBER_OF_BYTES_FREE 0
4046 LOW_COUNT_USED 0
4047 CURRENT_COUNT_USED 0
4048 HIGH_COUNT_USED 0
4049 LOW_NUMBER_OF_BYTES_USED 0
4050 CURRENT_NUMBER_OF_BYTES_USED 0
4051 HIGH_NUMBER_OF_BYTES_USED 0
4052 USER user3
4053 HOST localhost
4054 EVENT_NAME memory/sql/User_level_lock
4055 COUNT_ALLOC 0
4056 COUNT_FREE 0
4057 SUM_NUMBER_OF_BYTES_ALLOC 0
4058 SUM_NUMBER_OF_BYTES_FREE 0
4059 LOW_COUNT_USED 0
4060 CURRENT_COUNT_USED 0
4061 HIGH_COUNT_USED 0
4062 LOW_NUMBER_OF_BYTES_USED 0
4063 CURRENT_NUMBER_OF_BYTES_USED 0
4064 HIGH_NUMBER_OF_BYTES_USED 0
4065 USER user3
4066 HOST localhost
4067 EVENT_NAME memory/sql/user_var_entry::value
4068 COUNT_ALLOC 0
4069 COUNT_FREE 0
4070 SUM_NUMBER_OF_BYTES_ALLOC 0
4071 SUM_NUMBER_OF_BYTES_FREE 0
4072 LOW_COUNT_USED 0
4073 CURRENT_COUNT_USED 0
4074 HIGH_COUNT_USED 0
4075 LOW_NUMBER_OF_BYTES_USED 0
4076 CURRENT_NUMBER_OF_BYTES_USED 0
4077 HIGH_NUMBER_OF_BYTES_USED 0
4078 USER user4
4079 HOST localhost
4080 EVENT_NAME memory/sql/User_level_lock
4081 COUNT_ALLOC 0
4082 COUNT_FREE 0
4083 SUM_NUMBER_OF_BYTES_ALLOC 0
4084 SUM_NUMBER_OF_BYTES_FREE 0
4085 LOW_COUNT_USED 0
4086 CURRENT_COUNT_USED 0
4087 HIGH_COUNT_USED 0
4088 LOW_NUMBER_OF_BYTES_USED 0
4089 CURRENT_NUMBER_OF_BYTES_USED 0
4090 HIGH_NUMBER_OF_BYTES_USED 0
4091 USER user4
4092 HOST localhost
4093 EVENT_NAME memory/sql/user_var_entry::value
4094 COUNT_ALLOC 0
4095 COUNT_FREE 0
4096 SUM_NUMBER_OF_BYTES_ALLOC 0
4097 SUM_NUMBER_OF_BYTES_FREE 0
4098 LOW_COUNT_USED 0
4099 CURRENT_COUNT_USED 0
4100 HIGH_COUNT_USED 0
4101 LOW_NUMBER_OF_BYTES_USED 0
4102 CURRENT_NUMBER_OF_BYTES_USED 0
4103 HIGH_NUMBER_OF_BYTES_USED 0
4104 execute dump_memory_user;
4105 USER user1
4106 EVENT_NAME memory/sql/User_level_lock
4107 COUNT_ALLOC 0
4108 COUNT_FREE 0
4109 SUM_NUMBER_OF_BYTES_ALLOC 0
4110 SUM_NUMBER_OF_BYTES_FREE 0
4111 LOW_COUNT_USED 0
4112 CURRENT_COUNT_USED 0
4113 HIGH_COUNT_USED 0
4114 LOW_NUMBER_OF_BYTES_USED 0
4115 CURRENT_NUMBER_OF_BYTES_USED 0
4116 HIGH_NUMBER_OF_BYTES_USED 0
4117 USER user1
4118 EVENT_NAME memory/sql/user_var_entry::value
4119 COUNT_ALLOC 0
4120 COUNT_FREE 0
4121 SUM_NUMBER_OF_BYTES_ALLOC 0
4122 SUM_NUMBER_OF_BYTES_FREE 0
4123 LOW_COUNT_USED 0
4124 CURRENT_COUNT_USED 0
4125 HIGH_COUNT_USED 0
4126 LOW_NUMBER_OF_BYTES_USED 0
4127 CURRENT_NUMBER_OF_BYTES_USED 0
4128 HIGH_NUMBER_OF_BYTES_USED 0
4129 USER user2
4130 EVENT_NAME memory/sql/User_level_lock
4131 COUNT_ALLOC 0
4132 COUNT_FREE 0
4133 SUM_NUMBER_OF_BYTES_ALLOC 0
4134 SUM_NUMBER_OF_BYTES_FREE 0
4135 LOW_COUNT_USED 0
4136 CURRENT_COUNT_USED 0
4137 HIGH_COUNT_USED 0
4138 LOW_NUMBER_OF_BYTES_USED 0
4139 CURRENT_NUMBER_OF_BYTES_USED 0
4140 HIGH_NUMBER_OF_BYTES_USED 0
4141 USER user2
4142 EVENT_NAME memory/sql/user_var_entry::value
4143 COUNT_ALLOC 0
4144 COUNT_FREE 0
4145 SUM_NUMBER_OF_BYTES_ALLOC 0
4146 SUM_NUMBER_OF_BYTES_FREE 0
4147 LOW_COUNT_USED 0
4148 CURRENT_COUNT_USED 0
4149 HIGH_COUNT_USED 0
4150 LOW_NUMBER_OF_BYTES_USED 0
4151 CURRENT_NUMBER_OF_BYTES_USED 0
4152 HIGH_NUMBER_OF_BYTES_USED 0
4153 USER user3
4154 EVENT_NAME memory/sql/User_level_lock
4155 COUNT_ALLOC 0
4156 COUNT_FREE 0
4157 SUM_NUMBER_OF_BYTES_ALLOC 0
4158 SUM_NUMBER_OF_BYTES_FREE 0
4159 LOW_COUNT_USED 0
4160 CURRENT_COUNT_USED 0
4161 HIGH_COUNT_USED 0
4162 LOW_NUMBER_OF_BYTES_USED 0
4163 CURRENT_NUMBER_OF_BYTES_USED 0
4164 HIGH_NUMBER_OF_BYTES_USED 0
4165 USER user3
4166 EVENT_NAME memory/sql/user_var_entry::value
4167 COUNT_ALLOC 0
4168 COUNT_FREE 0
4169 SUM_NUMBER_OF_BYTES_ALLOC 0
4170 SUM_NUMBER_OF_BYTES_FREE 0
4171 LOW_COUNT_USED 0
4172 CURRENT_COUNT_USED 0
4173 HIGH_COUNT_USED 0
4174 LOW_NUMBER_OF_BYTES_USED 0
4175 CURRENT_NUMBER_OF_BYTES_USED 0
4176 HIGH_NUMBER_OF_BYTES_USED 0
4177 USER user4
4178 EVENT_NAME memory/sql/User_level_lock
4179 COUNT_ALLOC 0
4180 COUNT_FREE 0
4181 SUM_NUMBER_OF_BYTES_ALLOC 0
4182 SUM_NUMBER_OF_BYTES_FREE 0
4183 LOW_COUNT_USED 0
4184 CURRENT_COUNT_USED 0
4185 HIGH_COUNT_USED 0
4186 LOW_NUMBER_OF_BYTES_USED 0
4187 CURRENT_NUMBER_OF_BYTES_USED 0
4188 HIGH_NUMBER_OF_BYTES_USED 0
4189 USER user4
4190 EVENT_NAME memory/sql/user_var_entry::value
4191 COUNT_ALLOC 0
4192 COUNT_FREE 0
4193 SUM_NUMBER_OF_BYTES_ALLOC 0
4194 SUM_NUMBER_OF_BYTES_FREE 0
4195 LOW_COUNT_USED 0
4196 CURRENT_COUNT_USED 0
4197 HIGH_COUNT_USED 0
4198 LOW_NUMBER_OF_BYTES_USED 0
4199 CURRENT_NUMBER_OF_BYTES_USED 0
4200 HIGH_NUMBER_OF_BYTES_USED 0
4201 execute dump_memory_host;
4202 execute dump_memory_global;
4203 EVENT_NAME memory/sql/Query_cache
4204 COUNT_ALLOC 8
4205 COUNT_FREE 6
4206 SUM_NUMBER_OF_BYTES_ALLOC 131072
4207 SUM_NUMBER_OF_BYTES_FREE 98304
4208 LOW_COUNT_USED 0
4209 CURRENT_COUNT_USED 2
4210 HIGH_COUNT_USED 2
4211 LOW_NUMBER_OF_BYTES_USED 0
4212 CURRENT_NUMBER_OF_BYTES_USED 32768
4213 HIGH_NUMBER_OF_BYTES_USED 32768
4214 EVENT_NAME memory/sql/User_level_lock
4215 COUNT_ALLOC 10
4216 COUNT_FREE 10
4217 SUM_NUMBER_OF_BYTES_ALLOC 1360
4218 SUM_NUMBER_OF_BYTES_FREE 1360
4219 LOW_COUNT_USED 0
4220 CURRENT_COUNT_USED 0
4221 HIGH_COUNT_USED 10
4222 LOW_NUMBER_OF_BYTES_USED 0
4223 CURRENT_NUMBER_OF_BYTES_USED 0
4224 HIGH_NUMBER_OF_BYTES_USED 1360
4225 EVENT_NAME memory/sql/user_var_entry::value
4226 COUNT_ALLOC 16
4227 COUNT_FREE 15
4228 SUM_NUMBER_OF_BYTES_ALLOC 35216
4229 SUM_NUMBER_OF_BYTES_FREE 35120
4230 LOW_COUNT_USED 1
4231 CURRENT_COUNT_USED 1
4232 HIGH_COUNT_USED 16
4233 LOW_NUMBER_OF_BYTES_USED 96
4234 CURRENT_NUMBER_OF_BYTES_USED 96
4235 HIGH_NUMBER_OF_BYTES_USED 35216
4236 execute dump_accounts;
4237 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4238 root localhost 1 1
4239 user1 localhost 0 1
4240 user2 localhost 0 1
4241 user3 localhost 0 1
4242 user4 localhost 0 2
4243 execute dump_users;
4244 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4245 root 1 1
4246 user1 0 1
4247 user2 0 1
4248 user3 0 1
4249 user4 0 2
4250 execute dump_hosts;
4251 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4252 truncate performance_schema.memory_summary_by_host_by_event_name;
4253 "================== MEMORY_BY_HOST truncated =================="
4254 "================== Step 17 =================="
4255 call dump_thread();
4256 username user1
4257 status not found
4258 username user2
4259 status not found
4260 username user3
4261 status not found
4262 username user4
4263 status not found
4264 execute dump_memory_account;
4265 USER user1
4266 HOST localhost
4267 EVENT_NAME memory/sql/User_level_lock
4268 COUNT_ALLOC 0
4269 COUNT_FREE 0
4270 SUM_NUMBER_OF_BYTES_ALLOC 0
4271 SUM_NUMBER_OF_BYTES_FREE 0
4272 LOW_COUNT_USED 0
4273 CURRENT_COUNT_USED 0
4274 HIGH_COUNT_USED 0
4275 LOW_NUMBER_OF_BYTES_USED 0
4276 CURRENT_NUMBER_OF_BYTES_USED 0
4277 HIGH_NUMBER_OF_BYTES_USED 0
4278 USER user1
4279 HOST localhost
4280 EVENT_NAME memory/sql/user_var_entry::value
4281 COUNT_ALLOC 0
4282 COUNT_FREE 0
4283 SUM_NUMBER_OF_BYTES_ALLOC 0
4284 SUM_NUMBER_OF_BYTES_FREE 0
4285 LOW_COUNT_USED 0
4286 CURRENT_COUNT_USED 0
4287 HIGH_COUNT_USED 0
4288 LOW_NUMBER_OF_BYTES_USED 0
4289 CURRENT_NUMBER_OF_BYTES_USED 0
4290 HIGH_NUMBER_OF_BYTES_USED 0
4291 USER user2
4292 HOST localhost
4293 EVENT_NAME memory/sql/User_level_lock
4294 COUNT_ALLOC 0
4295 COUNT_FREE 0
4296 SUM_NUMBER_OF_BYTES_ALLOC 0
4297 SUM_NUMBER_OF_BYTES_FREE 0
4298 LOW_COUNT_USED 0
4299 CURRENT_COUNT_USED 0
4300 HIGH_COUNT_USED 0
4301 LOW_NUMBER_OF_BYTES_USED 0
4302 CURRENT_NUMBER_OF_BYTES_USED 0
4303 HIGH_NUMBER_OF_BYTES_USED 0
4304 USER user2
4305 HOST localhost
4306 EVENT_NAME memory/sql/user_var_entry::value
4307 COUNT_ALLOC 0
4308 COUNT_FREE 0
4309 SUM_NUMBER_OF_BYTES_ALLOC 0
4310 SUM_NUMBER_OF_BYTES_FREE 0
4311 LOW_COUNT_USED 0
4312 CURRENT_COUNT_USED 0
4313 HIGH_COUNT_USED 0
4314 LOW_NUMBER_OF_BYTES_USED 0
4315 CURRENT_NUMBER_OF_BYTES_USED 0
4316 HIGH_NUMBER_OF_BYTES_USED 0
4317 USER user3
4318 HOST localhost
4319 EVENT_NAME memory/sql/User_level_lock
4320 COUNT_ALLOC 0
4321 COUNT_FREE 0
4322 SUM_NUMBER_OF_BYTES_ALLOC 0
4323 SUM_NUMBER_OF_BYTES_FREE 0
4324 LOW_COUNT_USED 0
4325 CURRENT_COUNT_USED 0
4326 HIGH_COUNT_USED 0
4327 LOW_NUMBER_OF_BYTES_USED 0
4328 CURRENT_NUMBER_OF_BYTES_USED 0
4329 HIGH_NUMBER_OF_BYTES_USED 0
4330 USER user3
4331 HOST localhost
4332 EVENT_NAME memory/sql/user_var_entry::value
4333 COUNT_ALLOC 0
4334 COUNT_FREE 0
4335 SUM_NUMBER_OF_BYTES_ALLOC 0
4336 SUM_NUMBER_OF_BYTES_FREE 0
4337 LOW_COUNT_USED 0
4338 CURRENT_COUNT_USED 0
4339 HIGH_COUNT_USED 0
4340 LOW_NUMBER_OF_BYTES_USED 0
4341 CURRENT_NUMBER_OF_BYTES_USED 0
4342 HIGH_NUMBER_OF_BYTES_USED 0
4343 USER user4
4344 HOST localhost
4345 EVENT_NAME memory/sql/User_level_lock
4346 COUNT_ALLOC 0
4347 COUNT_FREE 0
4348 SUM_NUMBER_OF_BYTES_ALLOC 0
4349 SUM_NUMBER_OF_BYTES_FREE 0
4350 LOW_COUNT_USED 0
4351 CURRENT_COUNT_USED 0
4352 HIGH_COUNT_USED 0
4353 LOW_NUMBER_OF_BYTES_USED 0
4354 CURRENT_NUMBER_OF_BYTES_USED 0
4355 HIGH_NUMBER_OF_BYTES_USED 0
4356 USER user4
4357 HOST localhost
4358 EVENT_NAME memory/sql/user_var_entry::value
4359 COUNT_ALLOC 0
4360 COUNT_FREE 0
4361 SUM_NUMBER_OF_BYTES_ALLOC 0
4362 SUM_NUMBER_OF_BYTES_FREE 0
4363 LOW_COUNT_USED 0
4364 CURRENT_COUNT_USED 0
4365 HIGH_COUNT_USED 0
4366 LOW_NUMBER_OF_BYTES_USED 0
4367 CURRENT_NUMBER_OF_BYTES_USED 0
4368 HIGH_NUMBER_OF_BYTES_USED 0
4369 execute dump_memory_user;
4370 USER user1
4371 EVENT_NAME memory/sql/User_level_lock
4372 COUNT_ALLOC 0
4373 COUNT_FREE 0
4374 SUM_NUMBER_OF_BYTES_ALLOC 0
4375 SUM_NUMBER_OF_BYTES_FREE 0
4376 LOW_COUNT_USED 0
4377 CURRENT_COUNT_USED 0
4378 HIGH_COUNT_USED 0
4379 LOW_NUMBER_OF_BYTES_USED 0
4380 CURRENT_NUMBER_OF_BYTES_USED 0
4381 HIGH_NUMBER_OF_BYTES_USED 0
4382 USER user1
4383 EVENT_NAME memory/sql/user_var_entry::value
4384 COUNT_ALLOC 0
4385 COUNT_FREE 0
4386 SUM_NUMBER_OF_BYTES_ALLOC 0
4387 SUM_NUMBER_OF_BYTES_FREE 0
4388 LOW_COUNT_USED 0
4389 CURRENT_COUNT_USED 0
4390 HIGH_COUNT_USED 0
4391 LOW_NUMBER_OF_BYTES_USED 0
4392 CURRENT_NUMBER_OF_BYTES_USED 0
4393 HIGH_NUMBER_OF_BYTES_USED 0
4394 USER user2
4395 EVENT_NAME memory/sql/User_level_lock
4396 COUNT_ALLOC 0
4397 COUNT_FREE 0
4398 SUM_NUMBER_OF_BYTES_ALLOC 0
4399 SUM_NUMBER_OF_BYTES_FREE 0
4400 LOW_COUNT_USED 0
4401 CURRENT_COUNT_USED 0
4402 HIGH_COUNT_USED 0
4403 LOW_NUMBER_OF_BYTES_USED 0
4404 CURRENT_NUMBER_OF_BYTES_USED 0
4405 HIGH_NUMBER_OF_BYTES_USED 0
4406 USER user2
4407 EVENT_NAME memory/sql/user_var_entry::value
4408 COUNT_ALLOC 0
4409 COUNT_FREE 0
4410 SUM_NUMBER_OF_BYTES_ALLOC 0
4411 SUM_NUMBER_OF_BYTES_FREE 0
4412 LOW_COUNT_USED 0
4413 CURRENT_COUNT_USED 0
4414 HIGH_COUNT_USED 0
4415 LOW_NUMBER_OF_BYTES_USED 0
4416 CURRENT_NUMBER_OF_BYTES_USED 0
4417 HIGH_NUMBER_OF_BYTES_USED 0
4418 USER user3
4419 EVENT_NAME memory/sql/User_level_lock
4420 COUNT_ALLOC 0
4421 COUNT_FREE 0
4422 SUM_NUMBER_OF_BYTES_ALLOC 0
4423 SUM_NUMBER_OF_BYTES_FREE 0
4424 LOW_COUNT_USED 0
4425 CURRENT_COUNT_USED 0
4426 HIGH_COUNT_USED 0
4427 LOW_NUMBER_OF_BYTES_USED 0
4428 CURRENT_NUMBER_OF_BYTES_USED 0
4429 HIGH_NUMBER_OF_BYTES_USED 0
4430 USER user3
4431 EVENT_NAME memory/sql/user_var_entry::value
4432 COUNT_ALLOC 0
4433 COUNT_FREE 0
4434 SUM_NUMBER_OF_BYTES_ALLOC 0
4435 SUM_NUMBER_OF_BYTES_FREE 0
4436 LOW_COUNT_USED 0
4437 CURRENT_COUNT_USED 0
4438 HIGH_COUNT_USED 0
4439 LOW_NUMBER_OF_BYTES_USED 0
4440 CURRENT_NUMBER_OF_BYTES_USED 0
4441 HIGH_NUMBER_OF_BYTES_USED 0
4442 USER user4
4443 EVENT_NAME memory/sql/User_level_lock
4444 COUNT_ALLOC 0
4445 COUNT_FREE 0
4446 SUM_NUMBER_OF_BYTES_ALLOC 0
4447 SUM_NUMBER_OF_BYTES_FREE 0
4448 LOW_COUNT_USED 0
4449 CURRENT_COUNT_USED 0
4450 HIGH_COUNT_USED 0
4451 LOW_NUMBER_OF_BYTES_USED 0
4452 CURRENT_NUMBER_OF_BYTES_USED 0
4453 HIGH_NUMBER_OF_BYTES_USED 0
4454 USER user4
4455 EVENT_NAME memory/sql/user_var_entry::value
4456 COUNT_ALLOC 0
4457 COUNT_FREE 0
4458 SUM_NUMBER_OF_BYTES_ALLOC 0
4459 SUM_NUMBER_OF_BYTES_FREE 0
4460 LOW_COUNT_USED 0
4461 CURRENT_COUNT_USED 0
4462 HIGH_COUNT_USED 0
4463 LOW_NUMBER_OF_BYTES_USED 0
4464 CURRENT_NUMBER_OF_BYTES_USED 0
4465 HIGH_NUMBER_OF_BYTES_USED 0
4466 execute dump_memory_host;
4467 execute dump_memory_global;
4468 EVENT_NAME memory/sql/Query_cache
4469 COUNT_ALLOC 8
4470 COUNT_FREE 6
4471 SUM_NUMBER_OF_BYTES_ALLOC 131072
4472 SUM_NUMBER_OF_BYTES_FREE 98304
4473 LOW_COUNT_USED 0
4474 CURRENT_COUNT_USED 2
4475 HIGH_COUNT_USED 2
4476 LOW_NUMBER_OF_BYTES_USED 0
4477 CURRENT_NUMBER_OF_BYTES_USED 32768
4478 HIGH_NUMBER_OF_BYTES_USED 32768
4479 EVENT_NAME memory/sql/User_level_lock
4480 COUNT_ALLOC 10
4481 COUNT_FREE 10
4482 SUM_NUMBER_OF_BYTES_ALLOC 1360
4483 SUM_NUMBER_OF_BYTES_FREE 1360
4484 LOW_COUNT_USED 0
4485 CURRENT_COUNT_USED 0
4486 HIGH_COUNT_USED 10
4487 LOW_NUMBER_OF_BYTES_USED 0
4488 CURRENT_NUMBER_OF_BYTES_USED 0
4489 HIGH_NUMBER_OF_BYTES_USED 1360
4490 EVENT_NAME memory/sql/user_var_entry::value
4491 COUNT_ALLOC 16
4492 COUNT_FREE 15
4493 SUM_NUMBER_OF_BYTES_ALLOC 35216
4494 SUM_NUMBER_OF_BYTES_FREE 35120
4495 LOW_COUNT_USED 1
4496 CURRENT_COUNT_USED 1
4497 HIGH_COUNT_USED 16
4498 LOW_NUMBER_OF_BYTES_USED 96
4499 CURRENT_NUMBER_OF_BYTES_USED 96
4500 HIGH_NUMBER_OF_BYTES_USED 35216
4501 execute dump_accounts;
4502 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4503 root localhost 1 1
4504 user1 localhost 0 1
4505 user2 localhost 0 1
4506 user3 localhost 0 1
4507 user4 localhost 0 2
4508 execute dump_users;
4509 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4510 root 1 1
4511 user1 0 1
4512 user2 0 1
4513 user3 0 1
4514 user4 0 2
4515 execute dump_hosts;
4516 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4517 truncate performance_schema.memory_summary_global_by_event_name;
4518 "================== MEMORY_GLOBAL truncated =================="
4519 "================== Step 18 =================="
4520 call dump_thread();
4521 username user1
4522 status not found
4523 username user2
4524 status not found
4525 username user3
4526 status not found
4527 username user4
4528 status not found
4529 execute dump_memory_account;
4530 USER user1
4531 HOST localhost
4532 EVENT_NAME memory/sql/User_level_lock
4533 COUNT_ALLOC 0
4534 COUNT_FREE 0
4535 SUM_NUMBER_OF_BYTES_ALLOC 0
4536 SUM_NUMBER_OF_BYTES_FREE 0
4537 LOW_COUNT_USED 0
4538 CURRENT_COUNT_USED 0
4539 HIGH_COUNT_USED 0
4540 LOW_NUMBER_OF_BYTES_USED 0
4541 CURRENT_NUMBER_OF_BYTES_USED 0
4542 HIGH_NUMBER_OF_BYTES_USED 0
4543 USER user1
4544 HOST localhost
4545 EVENT_NAME memory/sql/user_var_entry::value
4546 COUNT_ALLOC 0
4547 COUNT_FREE 0
4548 SUM_NUMBER_OF_BYTES_ALLOC 0
4549 SUM_NUMBER_OF_BYTES_FREE 0
4550 LOW_COUNT_USED 0
4551 CURRENT_COUNT_USED 0
4552 HIGH_COUNT_USED 0
4553 LOW_NUMBER_OF_BYTES_USED 0
4554 CURRENT_NUMBER_OF_BYTES_USED 0
4555 HIGH_NUMBER_OF_BYTES_USED 0
4556 USER user2
4557 HOST localhost
4558 EVENT_NAME memory/sql/User_level_lock
4559 COUNT_ALLOC 0
4560 COUNT_FREE 0
4561 SUM_NUMBER_OF_BYTES_ALLOC 0
4562 SUM_NUMBER_OF_BYTES_FREE 0
4563 LOW_COUNT_USED 0
4564 CURRENT_COUNT_USED 0
4565 HIGH_COUNT_USED 0
4566 LOW_NUMBER_OF_BYTES_USED 0
4567 CURRENT_NUMBER_OF_BYTES_USED 0
4568 HIGH_NUMBER_OF_BYTES_USED 0
4569 USER user2
4570 HOST localhost
4571 EVENT_NAME memory/sql/user_var_entry::value
4572 COUNT_ALLOC 0
4573 COUNT_FREE 0
4574 SUM_NUMBER_OF_BYTES_ALLOC 0
4575 SUM_NUMBER_OF_BYTES_FREE 0
4576 LOW_COUNT_USED 0
4577 CURRENT_COUNT_USED 0
4578 HIGH_COUNT_USED 0
4579 LOW_NUMBER_OF_BYTES_USED 0
4580 CURRENT_NUMBER_OF_BYTES_USED 0
4581 HIGH_NUMBER_OF_BYTES_USED 0
4582 USER user3
4583 HOST localhost
4584 EVENT_NAME memory/sql/User_level_lock
4585 COUNT_ALLOC 0
4586 COUNT_FREE 0
4587 SUM_NUMBER_OF_BYTES_ALLOC 0
4588 SUM_NUMBER_OF_BYTES_FREE 0
4589 LOW_COUNT_USED 0
4590 CURRENT_COUNT_USED 0
4591 HIGH_COUNT_USED 0
4592 LOW_NUMBER_OF_BYTES_USED 0
4593 CURRENT_NUMBER_OF_BYTES_USED 0
4594 HIGH_NUMBER_OF_BYTES_USED 0
4595 USER user3
4596 HOST localhost
4597 EVENT_NAME memory/sql/user_var_entry::value
4598 COUNT_ALLOC 0
4599 COUNT_FREE 0
4600 SUM_NUMBER_OF_BYTES_ALLOC 0
4601 SUM_NUMBER_OF_BYTES_FREE 0
4602 LOW_COUNT_USED 0
4603 CURRENT_COUNT_USED 0
4604 HIGH_COUNT_USED 0
4605 LOW_NUMBER_OF_BYTES_USED 0
4606 CURRENT_NUMBER_OF_BYTES_USED 0
4607 HIGH_NUMBER_OF_BYTES_USED 0
4608 USER user4
4609 HOST localhost
4610 EVENT_NAME memory/sql/User_level_lock
4611 COUNT_ALLOC 0
4612 COUNT_FREE 0
4613 SUM_NUMBER_OF_BYTES_ALLOC 0
4614 SUM_NUMBER_OF_BYTES_FREE 0
4615 LOW_COUNT_USED 0
4616 CURRENT_COUNT_USED 0
4617 HIGH_COUNT_USED 0
4618 LOW_NUMBER_OF_BYTES_USED 0
4619 CURRENT_NUMBER_OF_BYTES_USED 0
4620 HIGH_NUMBER_OF_BYTES_USED 0
4621 USER user4
4622 HOST localhost
4623 EVENT_NAME memory/sql/user_var_entry::value
4624 COUNT_ALLOC 0
4625 COUNT_FREE 0
4626 SUM_NUMBER_OF_BYTES_ALLOC 0
4627 SUM_NUMBER_OF_BYTES_FREE 0
4628 LOW_COUNT_USED 0
4629 CURRENT_COUNT_USED 0
4630 HIGH_COUNT_USED 0
4631 LOW_NUMBER_OF_BYTES_USED 0
4632 CURRENT_NUMBER_OF_BYTES_USED 0
4633 HIGH_NUMBER_OF_BYTES_USED 0
4634 execute dump_memory_user;
4635 USER user1
4636 EVENT_NAME memory/sql/User_level_lock
4637 COUNT_ALLOC 0
4638 COUNT_FREE 0
4639 SUM_NUMBER_OF_BYTES_ALLOC 0
4640 SUM_NUMBER_OF_BYTES_FREE 0
4641 LOW_COUNT_USED 0
4642 CURRENT_COUNT_USED 0
4643 HIGH_COUNT_USED 0
4644 LOW_NUMBER_OF_BYTES_USED 0
4645 CURRENT_NUMBER_OF_BYTES_USED 0
4646 HIGH_NUMBER_OF_BYTES_USED 0
4647 USER user1
4648 EVENT_NAME memory/sql/user_var_entry::value
4649 COUNT_ALLOC 0
4650 COUNT_FREE 0
4651 SUM_NUMBER_OF_BYTES_ALLOC 0
4652 SUM_NUMBER_OF_BYTES_FREE 0
4653 LOW_COUNT_USED 0
4654 CURRENT_COUNT_USED 0
4655 HIGH_COUNT_USED 0
4656 LOW_NUMBER_OF_BYTES_USED 0
4657 CURRENT_NUMBER_OF_BYTES_USED 0
4658 HIGH_NUMBER_OF_BYTES_USED 0
4659 USER user2
4660 EVENT_NAME memory/sql/User_level_lock
4661 COUNT_ALLOC 0
4662 COUNT_FREE 0
4663 SUM_NUMBER_OF_BYTES_ALLOC 0
4664 SUM_NUMBER_OF_BYTES_FREE 0
4665 LOW_COUNT_USED 0
4666 CURRENT_COUNT_USED 0
4667 HIGH_COUNT_USED 0
4668 LOW_NUMBER_OF_BYTES_USED 0
4669 CURRENT_NUMBER_OF_BYTES_USED 0
4670 HIGH_NUMBER_OF_BYTES_USED 0
4671 USER user2
4672 EVENT_NAME memory/sql/user_var_entry::value
4673 COUNT_ALLOC 0
4674 COUNT_FREE 0
4675 SUM_NUMBER_OF_BYTES_ALLOC 0
4676 SUM_NUMBER_OF_BYTES_FREE 0
4677 LOW_COUNT_USED 0
4678 CURRENT_COUNT_USED 0
4679 HIGH_COUNT_USED 0
4680 LOW_NUMBER_OF_BYTES_USED 0
4681 CURRENT_NUMBER_OF_BYTES_USED 0
4682 HIGH_NUMBER_OF_BYTES_USED 0
4683 USER user3
4684 EVENT_NAME memory/sql/User_level_lock
4685 COUNT_ALLOC 0
4686 COUNT_FREE 0
4687 SUM_NUMBER_OF_BYTES_ALLOC 0
4688 SUM_NUMBER_OF_BYTES_FREE 0
4689 LOW_COUNT_USED 0
4690 CURRENT_COUNT_USED 0
4691 HIGH_COUNT_USED 0
4692 LOW_NUMBER_OF_BYTES_USED 0
4693 CURRENT_NUMBER_OF_BYTES_USED 0
4694 HIGH_NUMBER_OF_BYTES_USED 0
4695 USER user3
4696 EVENT_NAME memory/sql/user_var_entry::value
4697 COUNT_ALLOC 0
4698 COUNT_FREE 0
4699 SUM_NUMBER_OF_BYTES_ALLOC 0
4700 SUM_NUMBER_OF_BYTES_FREE 0
4701 LOW_COUNT_USED 0
4702 CURRENT_COUNT_USED 0
4703 HIGH_COUNT_USED 0
4704 LOW_NUMBER_OF_BYTES_USED 0
4705 CURRENT_NUMBER_OF_BYTES_USED 0
4706 HIGH_NUMBER_OF_BYTES_USED 0
4707 USER user4
4708 EVENT_NAME memory/sql/User_level_lock
4709 COUNT_ALLOC 0
4710 COUNT_FREE 0
4711 SUM_NUMBER_OF_BYTES_ALLOC 0
4712 SUM_NUMBER_OF_BYTES_FREE 0
4713 LOW_COUNT_USED 0
4714 CURRENT_COUNT_USED 0
4715 HIGH_COUNT_USED 0
4716 LOW_NUMBER_OF_BYTES_USED 0
4717 CURRENT_NUMBER_OF_BYTES_USED 0
4718 HIGH_NUMBER_OF_BYTES_USED 0
4719 USER user4
4720 EVENT_NAME memory/sql/user_var_entry::value
4721 COUNT_ALLOC 0
4722 COUNT_FREE 0
4723 SUM_NUMBER_OF_BYTES_ALLOC 0
4724 SUM_NUMBER_OF_BYTES_FREE 0
4725 LOW_COUNT_USED 0
4726 CURRENT_COUNT_USED 0
4727 HIGH_COUNT_USED 0
4728 LOW_NUMBER_OF_BYTES_USED 0
4729 CURRENT_NUMBER_OF_BYTES_USED 0
4730 HIGH_NUMBER_OF_BYTES_USED 0
4731 execute dump_memory_host;
4732 execute dump_memory_global;
4733 EVENT_NAME memory/sql/Query_cache
4734 COUNT_ALLOC 2
4735 COUNT_FREE 0
4736 SUM_NUMBER_OF_BYTES_ALLOC 32768
4737 SUM_NUMBER_OF_BYTES_FREE 0
4738 LOW_COUNT_USED 2
4739 CURRENT_COUNT_USED 2
4740 HIGH_COUNT_USED 2
4741 LOW_NUMBER_OF_BYTES_USED 32768
4742 CURRENT_NUMBER_OF_BYTES_USED 32768
4743 HIGH_NUMBER_OF_BYTES_USED 32768
4744 EVENT_NAME memory/sql/User_level_lock
4745 COUNT_ALLOC 0
4746 COUNT_FREE 0
4747 SUM_NUMBER_OF_BYTES_ALLOC 0
4748 SUM_NUMBER_OF_BYTES_FREE 0
4749 LOW_COUNT_USED 0
4750 CURRENT_COUNT_USED 0
4751 HIGH_COUNT_USED 0
4752 LOW_NUMBER_OF_BYTES_USED 0
4753 CURRENT_NUMBER_OF_BYTES_USED 0
4754 HIGH_NUMBER_OF_BYTES_USED 0
4755 EVENT_NAME memory/sql/user_var_entry::value
4756 COUNT_ALLOC 1
4757 COUNT_FREE 0
4758 SUM_NUMBER_OF_BYTES_ALLOC 96
4759 SUM_NUMBER_OF_BYTES_FREE 0
4760 LOW_COUNT_USED 1
4761 CURRENT_COUNT_USED 1
4762 HIGH_COUNT_USED 1
4763 LOW_NUMBER_OF_BYTES_USED 96
4764 CURRENT_NUMBER_OF_BYTES_USED 96
4765 HIGH_NUMBER_OF_BYTES_USED 96
4766 execute dump_accounts;
4767 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4768 root localhost 1 1
4769 user1 localhost 0 1
4770 user2 localhost 0 1
4771 user3 localhost 0 1
4772 user4 localhost 0 2
4773 execute dump_users;
4774 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4775 root 1 1
4776 user1 0 1
4777 user2 0 1
4778 user3 0 1
4779 user4 0 2
4780 execute dump_hosts;
4781 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4782 truncate performance_schema.accounts;
4783 "================== ACCOUNTS truncated =================="
4784 "================== Step 19 =================="
4785 call dump_thread();
4786 username user1
4787 status not found
4788 username user2
4789 status not found
4790 username user3
4791 status not found
4792 username user4
4793 status not found
4794 execute dump_memory_account;
4795 execute dump_memory_user;
4796 USER user1
4797 EVENT_NAME memory/sql/User_level_lock
4798 COUNT_ALLOC 0
4799 COUNT_FREE 0
4800 SUM_NUMBER_OF_BYTES_ALLOC 0
4801 SUM_NUMBER_OF_BYTES_FREE 0
4802 LOW_COUNT_USED 0
4803 CURRENT_COUNT_USED 0
4804 HIGH_COUNT_USED 0
4805 LOW_NUMBER_OF_BYTES_USED 0
4806 CURRENT_NUMBER_OF_BYTES_USED 0
4807 HIGH_NUMBER_OF_BYTES_USED 0
4808 USER user1
4809 EVENT_NAME memory/sql/user_var_entry::value
4810 COUNT_ALLOC 0
4811 COUNT_FREE 0
4812 SUM_NUMBER_OF_BYTES_ALLOC 0
4813 SUM_NUMBER_OF_BYTES_FREE 0
4814 LOW_COUNT_USED 0
4815 CURRENT_COUNT_USED 0
4816 HIGH_COUNT_USED 0
4817 LOW_NUMBER_OF_BYTES_USED 0
4818 CURRENT_NUMBER_OF_BYTES_USED 0
4819 HIGH_NUMBER_OF_BYTES_USED 0
4820 USER user2
4821 EVENT_NAME memory/sql/User_level_lock
4822 COUNT_ALLOC 0
4823 COUNT_FREE 0
4824 SUM_NUMBER_OF_BYTES_ALLOC 0
4825 SUM_NUMBER_OF_BYTES_FREE 0
4826 LOW_COUNT_USED 0
4827 CURRENT_COUNT_USED 0
4828 HIGH_COUNT_USED 0
4829 LOW_NUMBER_OF_BYTES_USED 0
4830 CURRENT_NUMBER_OF_BYTES_USED 0
4831 HIGH_NUMBER_OF_BYTES_USED 0
4832 USER user2
4833 EVENT_NAME memory/sql/user_var_entry::value
4834 COUNT_ALLOC 0
4835 COUNT_FREE 0
4836 SUM_NUMBER_OF_BYTES_ALLOC 0
4837 SUM_NUMBER_OF_BYTES_FREE 0
4838 LOW_COUNT_USED 0
4839 CURRENT_COUNT_USED 0
4840 HIGH_COUNT_USED 0
4841 LOW_NUMBER_OF_BYTES_USED 0
4842 CURRENT_NUMBER_OF_BYTES_USED 0
4843 HIGH_NUMBER_OF_BYTES_USED 0
4844 USER user3
4845 EVENT_NAME memory/sql/User_level_lock
4846 COUNT_ALLOC 0
4847 COUNT_FREE 0
4848 SUM_NUMBER_OF_BYTES_ALLOC 0
4849 SUM_NUMBER_OF_BYTES_FREE 0
4850 LOW_COUNT_USED 0
4851 CURRENT_COUNT_USED 0
4852 HIGH_COUNT_USED 0
4853 LOW_NUMBER_OF_BYTES_USED 0
4854 CURRENT_NUMBER_OF_BYTES_USED 0
4855 HIGH_NUMBER_OF_BYTES_USED 0
4856 USER user3
4857 EVENT_NAME memory/sql/user_var_entry::value
4858 COUNT_ALLOC 0
4859 COUNT_FREE 0
4860 SUM_NUMBER_OF_BYTES_ALLOC 0
4861 SUM_NUMBER_OF_BYTES_FREE 0
4862 LOW_COUNT_USED 0
4863 CURRENT_COUNT_USED 0
4864 HIGH_COUNT_USED 0
4865 LOW_NUMBER_OF_BYTES_USED 0
4866 CURRENT_NUMBER_OF_BYTES_USED 0
4867 HIGH_NUMBER_OF_BYTES_USED 0
4868 USER user4
4869 EVENT_NAME memory/sql/User_level_lock
4870 COUNT_ALLOC 0
4871 COUNT_FREE 0
4872 SUM_NUMBER_OF_BYTES_ALLOC 0
4873 SUM_NUMBER_OF_BYTES_FREE 0
4874 LOW_COUNT_USED 0
4875 CURRENT_COUNT_USED 0
4876 HIGH_COUNT_USED 0
4877 LOW_NUMBER_OF_BYTES_USED 0
4878 CURRENT_NUMBER_OF_BYTES_USED 0
4879 HIGH_NUMBER_OF_BYTES_USED 0
4880 USER user4
4881 EVENT_NAME memory/sql/user_var_entry::value
4882 COUNT_ALLOC 0
4883 COUNT_FREE 0
4884 SUM_NUMBER_OF_BYTES_ALLOC 0
4885 SUM_NUMBER_OF_BYTES_FREE 0
4886 LOW_COUNT_USED 0
4887 CURRENT_COUNT_USED 0
4888 HIGH_COUNT_USED 0
4889 LOW_NUMBER_OF_BYTES_USED 0
4890 CURRENT_NUMBER_OF_BYTES_USED 0
4891 HIGH_NUMBER_OF_BYTES_USED 0
4892 execute dump_memory_host;
4893 execute dump_memory_global;
4894 EVENT_NAME memory/sql/Query_cache
4895 COUNT_ALLOC 2
4896 COUNT_FREE 0
4897 SUM_NUMBER_OF_BYTES_ALLOC 32768
4898 SUM_NUMBER_OF_BYTES_FREE 0
4899 LOW_COUNT_USED 2
4900 CURRENT_COUNT_USED 2
4901 HIGH_COUNT_USED 2
4902 LOW_NUMBER_OF_BYTES_USED 32768
4903 CURRENT_NUMBER_OF_BYTES_USED 32768
4904 HIGH_NUMBER_OF_BYTES_USED 32768
4905 EVENT_NAME memory/sql/User_level_lock
4906 COUNT_ALLOC 0
4907 COUNT_FREE 0
4908 SUM_NUMBER_OF_BYTES_ALLOC 0
4909 SUM_NUMBER_OF_BYTES_FREE 0
4910 LOW_COUNT_USED 0
4911 CURRENT_COUNT_USED 0
4912 HIGH_COUNT_USED 0
4913 LOW_NUMBER_OF_BYTES_USED 0
4914 CURRENT_NUMBER_OF_BYTES_USED 0
4915 HIGH_NUMBER_OF_BYTES_USED 0
4916 EVENT_NAME memory/sql/user_var_entry::value
4917 COUNT_ALLOC 1
4918 COUNT_FREE 0
4919 SUM_NUMBER_OF_BYTES_ALLOC 96
4920 SUM_NUMBER_OF_BYTES_FREE 0
4921 LOW_COUNT_USED 1
4922 CURRENT_COUNT_USED 1
4923 HIGH_COUNT_USED 1
4924 LOW_NUMBER_OF_BYTES_USED 96
4925 CURRENT_NUMBER_OF_BYTES_USED 96
4926 HIGH_NUMBER_OF_BYTES_USED 96
4927 execute dump_accounts;
4928 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4929 root localhost 1 1
4930 execute dump_users;
4931 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4932 root 1 1
4933 user1 0 1
4934 user2 0 1
4935 user3 0 1
4936 user4 0 2
4937 execute dump_hosts;
4938 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4939 truncate performance_schema.users;
4940 "================== USERS truncated =================="
4941 "================== Step 20 =================="
4942 call dump_thread();
4943 username user1
4944 status not found
4945 username user2
4946 status not found
4947 username user3
4948 status not found
4949 username user4
4950 status not found
4951 execute dump_memory_account;
4952 execute dump_memory_user;
4953 execute dump_memory_host;
4954 execute dump_memory_global;
4955 EVENT_NAME memory/sql/Query_cache
4956 COUNT_ALLOC 2
4957 COUNT_FREE 0
4958 SUM_NUMBER_OF_BYTES_ALLOC 32768
4959 SUM_NUMBER_OF_BYTES_FREE 0
4960 LOW_COUNT_USED 2
4961 CURRENT_COUNT_USED 2
4962 HIGH_COUNT_USED 2
4963 LOW_NUMBER_OF_BYTES_USED 32768
4964 CURRENT_NUMBER_OF_BYTES_USED 32768
4965 HIGH_NUMBER_OF_BYTES_USED 32768
4966 EVENT_NAME memory/sql/User_level_lock
4967 COUNT_ALLOC 0
4968 COUNT_FREE 0
4969 SUM_NUMBER_OF_BYTES_ALLOC 0
4970 SUM_NUMBER_OF_BYTES_FREE 0
4971 LOW_COUNT_USED 0
4972 CURRENT_COUNT_USED 0
4973 HIGH_COUNT_USED 0
4974 LOW_NUMBER_OF_BYTES_USED 0
4975 CURRENT_NUMBER_OF_BYTES_USED 0
4976 HIGH_NUMBER_OF_BYTES_USED 0
4977 EVENT_NAME memory/sql/user_var_entry::value
4978 COUNT_ALLOC 1
4979 COUNT_FREE 0
4980 SUM_NUMBER_OF_BYTES_ALLOC 96
4981 SUM_NUMBER_OF_BYTES_FREE 0
4982 LOW_COUNT_USED 1
4983 CURRENT_COUNT_USED 1
4984 HIGH_COUNT_USED 1
4985 LOW_NUMBER_OF_BYTES_USED 96
4986 CURRENT_NUMBER_OF_BYTES_USED 96
4987 HIGH_NUMBER_OF_BYTES_USED 96
4988 execute dump_accounts;
4989 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4990 root localhost 1 1
4991 execute dump_users;
4992 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4993 root 1 1
4994 execute dump_hosts;
4995 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4996 truncate performance_schema.hosts;
4997 "================== HOSTS truncated =================="
4998 "================== Step 21 =================="
4999 call dump_thread();
5000 username user1
5001 status not found
5002 username user2
5003 status not found
5004 username user3
5005 status not found
5006 username user4
5007 status not found
5008 execute dump_memory_account;
5009 execute dump_memory_user;
5010 execute dump_memory_host;
5011 execute dump_memory_global;
5012 EVENT_NAME memory/sql/Query_cache
5013 COUNT_ALLOC 2
5014 COUNT_FREE 0
5015 SUM_NUMBER_OF_BYTES_ALLOC 32768
5016 SUM_NUMBER_OF_BYTES_FREE 0
5017 LOW_COUNT_USED 2
5018 CURRENT_COUNT_USED 2
5019 HIGH_COUNT_USED 2
5020 LOW_NUMBER_OF_BYTES_USED 32768
5021 CURRENT_NUMBER_OF_BYTES_USED 32768
5022 HIGH_NUMBER_OF_BYTES_USED 32768
5023 EVENT_NAME memory/sql/User_level_lock
5024 COUNT_ALLOC 0
5025 COUNT_FREE 0
5026 SUM_NUMBER_OF_BYTES_ALLOC 0
5027 SUM_NUMBER_OF_BYTES_FREE 0
5028 LOW_COUNT_USED 0
5029 CURRENT_COUNT_USED 0
5030 HIGH_COUNT_USED 0
5031 LOW_NUMBER_OF_BYTES_USED 0
5032 CURRENT_NUMBER_OF_BYTES_USED 0
5033 HIGH_NUMBER_OF_BYTES_USED 0
5034 EVENT_NAME memory/sql/user_var_entry::value
5035 COUNT_ALLOC 1
5036 COUNT_FREE 0
5037 SUM_NUMBER_OF_BYTES_ALLOC 96
5038 SUM_NUMBER_OF_BYTES_FREE 0
5039 LOW_COUNT_USED 1
5040 CURRENT_COUNT_USED 1
5041 HIGH_COUNT_USED 1
5042 LOW_NUMBER_OF_BYTES_USED 96
5043 CURRENT_NUMBER_OF_BYTES_USED 96
5044 HIGH_NUMBER_OF_BYTES_USED 96
5045 execute dump_accounts;
5046 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5047 root localhost 1 1
5048 execute dump_users;
5049 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5050 root 1 1
5051 execute dump_hosts;
5052 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS