Debian Codegraph @

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

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