Debian Codegraph @

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

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