Debian Codegraph @

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

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