Debian Codegraph @

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