Debian Codegraph @

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

raw
1 show global status like "performance_schema_memory_classes_lost";
2 Variable_name Value
3 Performance_schema_memory_classes_lost 0
4 "================== Step 1 =================="
5 call dump_thread();
6 username user1
7 status not found
8 username user2
9 status not found
10 username user3
11 status not found
12 username user4
13 status not found
14 execute dump_memory_account;
15 execute dump_memory_user;
16 execute dump_memory_host;
17 HOST localhost
18 EVENT_NAME memory/sql/User_level_lock
19 COUNT_ALLOC 0
20 COUNT_FREE 0
21 SUM_NUMBER_OF_BYTES_ALLOC 0
22 SUM_NUMBER_OF_BYTES_FREE 0
23 LOW_COUNT_USED 0
24 CURRENT_COUNT_USED 0
25 HIGH_COUNT_USED 0
26 LOW_NUMBER_OF_BYTES_USED 0
27 CURRENT_NUMBER_OF_BYTES_USED 0
28 HIGH_NUMBER_OF_BYTES_USED 0
29 HOST localhost
30 EVENT_NAME memory/sql/user_var_entry::value
31 COUNT_ALLOC 1
32 COUNT_FREE 0
33 SUM_NUMBER_OF_BYTES_ALLOC 96
34 SUM_NUMBER_OF_BYTES_FREE 0
35 LOW_COUNT_USED 1
36 CURRENT_COUNT_USED 1
37 HIGH_COUNT_USED 1
38 LOW_NUMBER_OF_BYTES_USED 96
39 CURRENT_NUMBER_OF_BYTES_USED 96
40 HIGH_NUMBER_OF_BYTES_USED 96
41 execute dump_memory_global;
42 EVENT_NAME memory/sql/Query_cache
43 COUNT_ALLOC 0
44 COUNT_FREE 0
45 SUM_NUMBER_OF_BYTES_ALLOC 0
46 SUM_NUMBER_OF_BYTES_FREE 0
47 LOW_COUNT_USED 0
48 CURRENT_COUNT_USED 0
49 HIGH_COUNT_USED 0
50 LOW_NUMBER_OF_BYTES_USED 0
51 CURRENT_NUMBER_OF_BYTES_USED 0
52 HIGH_NUMBER_OF_BYTES_USED 0
53 EVENT_NAME memory/sql/User_level_lock
54 COUNT_ALLOC 0
55 COUNT_FREE 0
56 SUM_NUMBER_OF_BYTES_ALLOC 0
57 SUM_NUMBER_OF_BYTES_FREE 0
58 LOW_COUNT_USED 0
59 CURRENT_COUNT_USED 0
60 HIGH_COUNT_USED 0
61 LOW_NUMBER_OF_BYTES_USED 0
62 CURRENT_NUMBER_OF_BYTES_USED 0
63 HIGH_NUMBER_OF_BYTES_USED 0
64 EVENT_NAME memory/sql/user_var_entry::value
65 COUNT_ALLOC 1
66 COUNT_FREE 0
67 SUM_NUMBER_OF_BYTES_ALLOC 96
68 SUM_NUMBER_OF_BYTES_FREE 0
69 LOW_COUNT_USED 1
70 CURRENT_COUNT_USED 1
71 HIGH_COUNT_USED 1
72 LOW_NUMBER_OF_BYTES_USED 96
73 CURRENT_NUMBER_OF_BYTES_USED 96
74 HIGH_NUMBER_OF_BYTES_USED 96
75 execute dump_accounts;
76 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
77 execute dump_users;
78 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
79 execute dump_hosts;
80 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
81 localhost 1 1
82 connect con1, localhost, user1, , ;
83 "================== con1 connected =================="
84 connection default;
85 "================== Step 2 =================="
86 call dump_thread();
87 username user1
88 EVENT_NAME memory/sql/User_level_lock
89 COUNT_ALLOC 0
90 COUNT_FREE 0
91 SUM_NUMBER_OF_BYTES_ALLOC 0
92 SUM_NUMBER_OF_BYTES_FREE 0
93 LOW_COUNT_USED 0
94 CURRENT_COUNT_USED 0
95 HIGH_COUNT_USED 0
96 LOW_NUMBER_OF_BYTES_USED 0
97 CURRENT_NUMBER_OF_BYTES_USED 0
98 HIGH_NUMBER_OF_BYTES_USED 0
99 username user1
100 EVENT_NAME memory/sql/user_var_entry::value
101 COUNT_ALLOC 0
102 COUNT_FREE 0
103 SUM_NUMBER_OF_BYTES_ALLOC 0
104 SUM_NUMBER_OF_BYTES_FREE 0
105 LOW_COUNT_USED 0
106 CURRENT_COUNT_USED 0
107 HIGH_COUNT_USED 0
108 LOW_NUMBER_OF_BYTES_USED 0
109 CURRENT_NUMBER_OF_BYTES_USED 0
110 HIGH_NUMBER_OF_BYTES_USED 0
111 username user2
112 status not found
113 username user3
114 status not found
115 username user4
116 status not found
117 execute dump_memory_account;
118 execute dump_memory_user;
119 execute dump_memory_host;
120 HOST localhost
121 EVENT_NAME memory/sql/User_level_lock
122 COUNT_ALLOC 0
123 COUNT_FREE 0
124 SUM_NUMBER_OF_BYTES_ALLOC 0
125 SUM_NUMBER_OF_BYTES_FREE 0
126 LOW_COUNT_USED 0
127 CURRENT_COUNT_USED 0
128 HIGH_COUNT_USED 0
129 LOW_NUMBER_OF_BYTES_USED 0
130 CURRENT_NUMBER_OF_BYTES_USED 0
131 HIGH_NUMBER_OF_BYTES_USED 0
132 HOST localhost
133 EVENT_NAME memory/sql/user_var_entry::value
134 COUNT_ALLOC 1
135 COUNT_FREE 0
136 SUM_NUMBER_OF_BYTES_ALLOC 96
137 SUM_NUMBER_OF_BYTES_FREE 0
138 LOW_COUNT_USED 1
139 CURRENT_COUNT_USED 1
140 HIGH_COUNT_USED 1
141 LOW_NUMBER_OF_BYTES_USED 96
142 CURRENT_NUMBER_OF_BYTES_USED 96
143 HIGH_NUMBER_OF_BYTES_USED 96
144 execute dump_memory_global;
145 EVENT_NAME memory/sql/Query_cache
146 COUNT_ALLOC 0
147 COUNT_FREE 0
148 SUM_NUMBER_OF_BYTES_ALLOC 0
149 SUM_NUMBER_OF_BYTES_FREE 0
150 LOW_COUNT_USED 0
151 CURRENT_COUNT_USED 0
152 HIGH_COUNT_USED 0
153 LOW_NUMBER_OF_BYTES_USED 0
154 CURRENT_NUMBER_OF_BYTES_USED 0
155 HIGH_NUMBER_OF_BYTES_USED 0
156 EVENT_NAME memory/sql/User_level_lock
157 COUNT_ALLOC 0
158 COUNT_FREE 0
159 SUM_NUMBER_OF_BYTES_ALLOC 0
160 SUM_NUMBER_OF_BYTES_FREE 0
161 LOW_COUNT_USED 0
162 CURRENT_COUNT_USED 0
163 HIGH_COUNT_USED 0
164 LOW_NUMBER_OF_BYTES_USED 0
165 CURRENT_NUMBER_OF_BYTES_USED 0
166 HIGH_NUMBER_OF_BYTES_USED 0
167 EVENT_NAME memory/sql/user_var_entry::value
168 COUNT_ALLOC 1
169 COUNT_FREE 0
170 SUM_NUMBER_OF_BYTES_ALLOC 96
171 SUM_NUMBER_OF_BYTES_FREE 0
172 LOW_COUNT_USED 1
173 CURRENT_COUNT_USED 1
174 HIGH_COUNT_USED 1
175 LOW_NUMBER_OF_BYTES_USED 96
176 CURRENT_NUMBER_OF_BYTES_USED 96
177 HIGH_NUMBER_OF_BYTES_USED 96
178 execute dump_accounts;
179 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
180 execute dump_users;
181 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
182 execute dump_hosts;
183 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
184 localhost 2 2
185 connection con1;
186 set GLOBAL query_cache_size=1000*1024;
187 select get_lock("marker_1", 10);
188 get_lock("marker_1", 10)
189 1
190 select release_lock("marker_1");
191 release_lock("marker_1")
192 1
193 set @v1 = repeat("a", 1000);
194 set @v2 = repeat("b", 2000);
195 set @v3 = repeat("c", 4000);
196 "================== con1 marker =================="
197 connection default;
198 "================== Step 3 =================="
199 call dump_thread();
200 username user1
201 EVENT_NAME memory/sql/User_level_lock
202 COUNT_ALLOC 2
203 COUNT_FREE 1
204 SUM_NUMBER_OF_BYTES_ALLOC 272
205 SUM_NUMBER_OF_BYTES_FREE 16
206 LOW_COUNT_USED 0
207 CURRENT_COUNT_USED 1
208 HIGH_COUNT_USED 2
209 LOW_NUMBER_OF_BYTES_USED 0
210 CURRENT_NUMBER_OF_BYTES_USED 256
211 HIGH_NUMBER_OF_BYTES_USED 272
212 username user1
213 EVENT_NAME memory/sql/user_var_entry::value
214 COUNT_ALLOC 3
215 COUNT_FREE 0
216 SUM_NUMBER_OF_BYTES_ALLOC 7024
217 SUM_NUMBER_OF_BYTES_FREE 0
218 LOW_COUNT_USED 0
219 CURRENT_COUNT_USED 3
220 HIGH_COUNT_USED 3
221 LOW_NUMBER_OF_BYTES_USED 0
222 CURRENT_NUMBER_OF_BYTES_USED 7024
223 HIGH_NUMBER_OF_BYTES_USED 7024
224 username user2
225 status not found
226 username user3
227 status not found
228 username user4
229 status not found
230 execute dump_memory_account;
231 execute dump_memory_user;
232 execute dump_memory_host;
233 HOST localhost
234 EVENT_NAME memory/sql/User_level_lock
235 COUNT_ALLOC 2
236 COUNT_FREE 1
237 SUM_NUMBER_OF_BYTES_ALLOC 272
238 SUM_NUMBER_OF_BYTES_FREE 16
239 LOW_COUNT_USED 0
240 CURRENT_COUNT_USED 1
241 HIGH_COUNT_USED 2
242 LOW_NUMBER_OF_BYTES_USED 0
243 CURRENT_NUMBER_OF_BYTES_USED 256
244 HIGH_NUMBER_OF_BYTES_USED 272
245 HOST localhost
246 EVENT_NAME memory/sql/user_var_entry::value
247 COUNT_ALLOC 4
248 COUNT_FREE 0
249 SUM_NUMBER_OF_BYTES_ALLOC 7120
250 SUM_NUMBER_OF_BYTES_FREE 0
251 LOW_COUNT_USED 1
252 CURRENT_COUNT_USED 4
253 HIGH_COUNT_USED 4
254 LOW_NUMBER_OF_BYTES_USED 96
255 CURRENT_NUMBER_OF_BYTES_USED 7120
256 HIGH_NUMBER_OF_BYTES_USED 7120
257 execute dump_memory_global;
258 EVENT_NAME memory/sql/Query_cache
259 COUNT_ALLOC 2
260 COUNT_FREE 0
261 SUM_NUMBER_OF_BYTES_ALLOC 32768
262 SUM_NUMBER_OF_BYTES_FREE 0
263 LOW_COUNT_USED 0
264 CURRENT_COUNT_USED 2
265 HIGH_COUNT_USED 2
266 LOW_NUMBER_OF_BYTES_USED 0
267 CURRENT_NUMBER_OF_BYTES_USED 32768
268 HIGH_NUMBER_OF_BYTES_USED 32768
269 EVENT_NAME memory/sql/User_level_lock
270 COUNT_ALLOC 2
271 COUNT_FREE 1
272 SUM_NUMBER_OF_BYTES_ALLOC 272
273 SUM_NUMBER_OF_BYTES_FREE 16
274 LOW_COUNT_USED 0
275 CURRENT_COUNT_USED 1
276 HIGH_COUNT_USED 2
277 LOW_NUMBER_OF_BYTES_USED 0
278 CURRENT_NUMBER_OF_BYTES_USED 256
279 HIGH_NUMBER_OF_BYTES_USED 272
280 EVENT_NAME memory/sql/user_var_entry::value
281 COUNT_ALLOC 4
282 COUNT_FREE 0
283 SUM_NUMBER_OF_BYTES_ALLOC 7120
284 SUM_NUMBER_OF_BYTES_FREE 0
285 LOW_COUNT_USED 1
286 CURRENT_COUNT_USED 4
287 HIGH_COUNT_USED 4
288 LOW_NUMBER_OF_BYTES_USED 96
289 CURRENT_NUMBER_OF_BYTES_USED 7120
290 HIGH_NUMBER_OF_BYTES_USED 7120
291 execute dump_accounts;
292 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
293 execute dump_users;
294 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
295 execute dump_hosts;
296 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
297 localhost 2 2
298 connect con2, localhost, user2, , ;
299 "================== con2 connected =================="
300 connection default;
301 "================== Step 4 =================="
302 call dump_thread();
303 username user1
304 EVENT_NAME memory/sql/User_level_lock
305 COUNT_ALLOC 2
306 COUNT_FREE 1
307 SUM_NUMBER_OF_BYTES_ALLOC 272
308 SUM_NUMBER_OF_BYTES_FREE 16
309 LOW_COUNT_USED 0
310 CURRENT_COUNT_USED 1
311 HIGH_COUNT_USED 2
312 LOW_NUMBER_OF_BYTES_USED 0
313 CURRENT_NUMBER_OF_BYTES_USED 256
314 HIGH_NUMBER_OF_BYTES_USED 272
315 username user1
316 EVENT_NAME memory/sql/user_var_entry::value
317 COUNT_ALLOC 3
318 COUNT_FREE 0
319 SUM_NUMBER_OF_BYTES_ALLOC 7024
320 SUM_NUMBER_OF_BYTES_FREE 0
321 LOW_COUNT_USED 0
322 CURRENT_COUNT_USED 3
323 HIGH_COUNT_USED 3
324 LOW_NUMBER_OF_BYTES_USED 0
325 CURRENT_NUMBER_OF_BYTES_USED 7024
326 HIGH_NUMBER_OF_BYTES_USED 7024
327 username user2
328 EVENT_NAME memory/sql/User_level_lock
329 COUNT_ALLOC 0
330 COUNT_FREE 0
331 SUM_NUMBER_OF_BYTES_ALLOC 0
332 SUM_NUMBER_OF_BYTES_FREE 0
333 LOW_COUNT_USED 0
334 CURRENT_COUNT_USED 0
335 HIGH_COUNT_USED 0
336 LOW_NUMBER_OF_BYTES_USED 0
337 CURRENT_NUMBER_OF_BYTES_USED 0
338 HIGH_NUMBER_OF_BYTES_USED 0
339 username user2
340 EVENT_NAME memory/sql/user_var_entry::value
341 COUNT_ALLOC 0
342 COUNT_FREE 0
343 SUM_NUMBER_OF_BYTES_ALLOC 0
344 SUM_NUMBER_OF_BYTES_FREE 0
345 LOW_COUNT_USED 0
346 CURRENT_COUNT_USED 0
347 HIGH_COUNT_USED 0
348 LOW_NUMBER_OF_BYTES_USED 0
349 CURRENT_NUMBER_OF_BYTES_USED 0
350 HIGH_NUMBER_OF_BYTES_USED 0
351 username user3
352 status not found
353 username user4
354 status not found
355 execute dump_memory_account;
356 execute dump_memory_user;
357 execute dump_memory_host;
358 HOST localhost
359 EVENT_NAME memory/sql/User_level_lock
360 COUNT_ALLOC 2
361 COUNT_FREE 1
362 SUM_NUMBER_OF_BYTES_ALLOC 272
363 SUM_NUMBER_OF_BYTES_FREE 16
364 LOW_COUNT_USED 0
365 CURRENT_COUNT_USED 1
366 HIGH_COUNT_USED 2
367 LOW_NUMBER_OF_BYTES_USED 0
368 CURRENT_NUMBER_OF_BYTES_USED 256
369 HIGH_NUMBER_OF_BYTES_USED 272
370 HOST localhost
371 EVENT_NAME memory/sql/user_var_entry::value
372 COUNT_ALLOC 4
373 COUNT_FREE 0
374 SUM_NUMBER_OF_BYTES_ALLOC 7120
375 SUM_NUMBER_OF_BYTES_FREE 0
376 LOW_COUNT_USED 1
377 CURRENT_COUNT_USED 4
378 HIGH_COUNT_USED 4
379 LOW_NUMBER_OF_BYTES_USED 96
380 CURRENT_NUMBER_OF_BYTES_USED 7120
381 HIGH_NUMBER_OF_BYTES_USED 7120
382 execute dump_memory_global;
383 EVENT_NAME memory/sql/Query_cache
384 COUNT_ALLOC 2
385 COUNT_FREE 0
386 SUM_NUMBER_OF_BYTES_ALLOC 32768
387 SUM_NUMBER_OF_BYTES_FREE 0
388 LOW_COUNT_USED 0
389 CURRENT_COUNT_USED 2
390 HIGH_COUNT_USED 2
391 LOW_NUMBER_OF_BYTES_USED 0
392 CURRENT_NUMBER_OF_BYTES_USED 32768
393 HIGH_NUMBER_OF_BYTES_USED 32768
394 EVENT_NAME memory/sql/User_level_lock
395 COUNT_ALLOC 2
396 COUNT_FREE 1
397 SUM_NUMBER_OF_BYTES_ALLOC 272
398 SUM_NUMBER_OF_BYTES_FREE 16
399 LOW_COUNT_USED 0
400 CURRENT_COUNT_USED 1
401 HIGH_COUNT_USED 2
402 LOW_NUMBER_OF_BYTES_USED 0
403 CURRENT_NUMBER_OF_BYTES_USED 256
404 HIGH_NUMBER_OF_BYTES_USED 272
405 EVENT_NAME memory/sql/user_var_entry::value
406 COUNT_ALLOC 4
407 COUNT_FREE 0
408 SUM_NUMBER_OF_BYTES_ALLOC 7120
409 SUM_NUMBER_OF_BYTES_FREE 0
410 LOW_COUNT_USED 1
411 CURRENT_COUNT_USED 4
412 HIGH_COUNT_USED 4
413 LOW_NUMBER_OF_BYTES_USED 96
414 CURRENT_NUMBER_OF_BYTES_USED 7120
415 HIGH_NUMBER_OF_BYTES_USED 7120
416 execute dump_accounts;
417 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
418 execute dump_users;
419 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
420 execute dump_hosts;
421 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
422 localhost 3 3
423 connection con2;
424 set GLOBAL query_cache_size=2000*1024;
425 select get_lock("marker_2", 10);
426 get_lock("marker_2", 10)
427 1
428 select release_lock("marker_2");
429 release_lock("marker_2")
430 1
431 set @v1 = repeat("a", 1000);
432 set @v2 = repeat("b", 2000);
433 set @v3 = repeat("c", 4000);
434 "================== con2 marker =================="
435 connection default;
436 "================== Step 5 =================="
437 call dump_thread();
438 username user1
439 EVENT_NAME memory/sql/User_level_lock
440 COUNT_ALLOC 2
441 COUNT_FREE 1
442 SUM_NUMBER_OF_BYTES_ALLOC 272
443 SUM_NUMBER_OF_BYTES_FREE 16
444 LOW_COUNT_USED 0
445 CURRENT_COUNT_USED 1
446 HIGH_COUNT_USED 2
447 LOW_NUMBER_OF_BYTES_USED 0
448 CURRENT_NUMBER_OF_BYTES_USED 256
449 HIGH_NUMBER_OF_BYTES_USED 272
450 username user1
451 EVENT_NAME memory/sql/user_var_entry::value
452 COUNT_ALLOC 3
453 COUNT_FREE 0
454 SUM_NUMBER_OF_BYTES_ALLOC 7024
455 SUM_NUMBER_OF_BYTES_FREE 0
456 LOW_COUNT_USED 0
457 CURRENT_COUNT_USED 3
458 HIGH_COUNT_USED 3
459 LOW_NUMBER_OF_BYTES_USED 0
460 CURRENT_NUMBER_OF_BYTES_USED 7024
461 HIGH_NUMBER_OF_BYTES_USED 7024
462 username user2
463 EVENT_NAME memory/sql/User_level_lock
464 COUNT_ALLOC 2
465 COUNT_FREE 1
466 SUM_NUMBER_OF_BYTES_ALLOC 272
467 SUM_NUMBER_OF_BYTES_FREE 16
468 LOW_COUNT_USED 0
469 CURRENT_COUNT_USED 1
470 HIGH_COUNT_USED 2
471 LOW_NUMBER_OF_BYTES_USED 0
472 CURRENT_NUMBER_OF_BYTES_USED 256
473 HIGH_NUMBER_OF_BYTES_USED 272
474 username user2
475 EVENT_NAME memory/sql/user_var_entry::value
476 COUNT_ALLOC 3
477 COUNT_FREE 0
478 SUM_NUMBER_OF_BYTES_ALLOC 7024
479 SUM_NUMBER_OF_BYTES_FREE 0
480 LOW_COUNT_USED 0
481 CURRENT_COUNT_USED 3
482 HIGH_COUNT_USED 3
483 LOW_NUMBER_OF_BYTES_USED 0
484 CURRENT_NUMBER_OF_BYTES_USED 7024
485 HIGH_NUMBER_OF_BYTES_USED 7024
486 username user3
487 status not found
488 username user4
489 status not found
490 execute dump_memory_account;
491 execute dump_memory_user;
492 execute dump_memory_host;
493 HOST localhost
494 EVENT_NAME memory/sql/User_level_lock
495 COUNT_ALLOC 4
496 COUNT_FREE 2
497 SUM_NUMBER_OF_BYTES_ALLOC 544
498 SUM_NUMBER_OF_BYTES_FREE 32
499 LOW_COUNT_USED 0
500 CURRENT_COUNT_USED 2
501 HIGH_COUNT_USED 4
502 LOW_NUMBER_OF_BYTES_USED 0
503 CURRENT_NUMBER_OF_BYTES_USED 512
504 HIGH_NUMBER_OF_BYTES_USED 544
505 HOST localhost
506 EVENT_NAME memory/sql/user_var_entry::value
507 COUNT_ALLOC 7
508 COUNT_FREE 0
509 SUM_NUMBER_OF_BYTES_ALLOC 14144
510 SUM_NUMBER_OF_BYTES_FREE 0
511 LOW_COUNT_USED 1
512 CURRENT_COUNT_USED 7
513 HIGH_COUNT_USED 7
514 LOW_NUMBER_OF_BYTES_USED 96
515 CURRENT_NUMBER_OF_BYTES_USED 14144
516 HIGH_NUMBER_OF_BYTES_USED 14144
517 execute dump_memory_global;
518 EVENT_NAME memory/sql/Query_cache
519 COUNT_ALLOC 4
520 COUNT_FREE 2
521 SUM_NUMBER_OF_BYTES_ALLOC 65536
522 SUM_NUMBER_OF_BYTES_FREE 32768
523 LOW_COUNT_USED 0
524 CURRENT_COUNT_USED 2
525 HIGH_COUNT_USED 2
526 LOW_NUMBER_OF_BYTES_USED 0
527 CURRENT_NUMBER_OF_BYTES_USED 32768
528 HIGH_NUMBER_OF_BYTES_USED 32768
529 EVENT_NAME memory/sql/User_level_lock
530 COUNT_ALLOC 4
531 COUNT_FREE 2
532 SUM_NUMBER_OF_BYTES_ALLOC 544
533 SUM_NUMBER_OF_BYTES_FREE 32
534 LOW_COUNT_USED 0
535 CURRENT_COUNT_USED 2
536 HIGH_COUNT_USED 4
537 LOW_NUMBER_OF_BYTES_USED 0
538 CURRENT_NUMBER_OF_BYTES_USED 512
539 HIGH_NUMBER_OF_BYTES_USED 544
540 EVENT_NAME memory/sql/user_var_entry::value
541 COUNT_ALLOC 7
542 COUNT_FREE 0
543 SUM_NUMBER_OF_BYTES_ALLOC 14144
544 SUM_NUMBER_OF_BYTES_FREE 0
545 LOW_COUNT_USED 1
546 CURRENT_COUNT_USED 7
547 HIGH_COUNT_USED 7
548 LOW_NUMBER_OF_BYTES_USED 96
549 CURRENT_NUMBER_OF_BYTES_USED 14144
550 HIGH_NUMBER_OF_BYTES_USED 14144
551 execute dump_accounts;
552 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
553 execute dump_users;
554 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
555 execute dump_hosts;
556 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
557 localhost 3 3
558 truncate table performance_schema.memory_summary_by_thread_by_event_name;
559 "================== MEMORY_BY_THREAD truncated =================="
560 "================== Step 5b =================="
561 call dump_thread();
562 username user1
563 EVENT_NAME memory/sql/User_level_lock
564 COUNT_ALLOC 1
565 COUNT_FREE 0
566 SUM_NUMBER_OF_BYTES_ALLOC 256
567 SUM_NUMBER_OF_BYTES_FREE 0
568 LOW_COUNT_USED 1
569 CURRENT_COUNT_USED 1
570 HIGH_COUNT_USED 1
571 LOW_NUMBER_OF_BYTES_USED 256
572 CURRENT_NUMBER_OF_BYTES_USED 256
573 HIGH_NUMBER_OF_BYTES_USED 256
574 username user1
575 EVENT_NAME memory/sql/user_var_entry::value
576 COUNT_ALLOC 3
577 COUNT_FREE 0
578 SUM_NUMBER_OF_BYTES_ALLOC 7024
579 SUM_NUMBER_OF_BYTES_FREE 0
580 LOW_COUNT_USED 3
581 CURRENT_COUNT_USED 3
582 HIGH_COUNT_USED 3
583 LOW_NUMBER_OF_BYTES_USED 7024
584 CURRENT_NUMBER_OF_BYTES_USED 7024
585 HIGH_NUMBER_OF_BYTES_USED 7024
586 username user2
587 EVENT_NAME memory/sql/User_level_lock
588 COUNT_ALLOC 1
589 COUNT_FREE 0
590 SUM_NUMBER_OF_BYTES_ALLOC 256
591 SUM_NUMBER_OF_BYTES_FREE 0
592 LOW_COUNT_USED 1
593 CURRENT_COUNT_USED 1
594 HIGH_COUNT_USED 1
595 LOW_NUMBER_OF_BYTES_USED 256
596 CURRENT_NUMBER_OF_BYTES_USED 256
597 HIGH_NUMBER_OF_BYTES_USED 256
598 username user2
599 EVENT_NAME memory/sql/user_var_entry::value
600 COUNT_ALLOC 3
601 COUNT_FREE 0
602 SUM_NUMBER_OF_BYTES_ALLOC 7024
603 SUM_NUMBER_OF_BYTES_FREE 0
604 LOW_COUNT_USED 3
605 CURRENT_COUNT_USED 3
606 HIGH_COUNT_USED 3
607 LOW_NUMBER_OF_BYTES_USED 7024
608 CURRENT_NUMBER_OF_BYTES_USED 7024
609 HIGH_NUMBER_OF_BYTES_USED 7024
610 username user3
611 status not found
612 username user4
613 status not found
614 execute dump_memory_account;
615 execute dump_memory_user;
616 execute dump_memory_host;
617 HOST localhost
618 EVENT_NAME memory/sql/User_level_lock
619 COUNT_ALLOC 4
620 COUNT_FREE 2
621 SUM_NUMBER_OF_BYTES_ALLOC 544
622 SUM_NUMBER_OF_BYTES_FREE 32
623 LOW_COUNT_USED 0
624 CURRENT_COUNT_USED 2
625 HIGH_COUNT_USED 4
626 LOW_NUMBER_OF_BYTES_USED 0
627 CURRENT_NUMBER_OF_BYTES_USED 512
628 HIGH_NUMBER_OF_BYTES_USED 544
629 HOST localhost
630 EVENT_NAME memory/sql/user_var_entry::value
631 COUNT_ALLOC 7
632 COUNT_FREE 0
633 SUM_NUMBER_OF_BYTES_ALLOC 14144
634 SUM_NUMBER_OF_BYTES_FREE 0
635 LOW_COUNT_USED 1
636 CURRENT_COUNT_USED 7
637 HIGH_COUNT_USED 7
638 LOW_NUMBER_OF_BYTES_USED 96
639 CURRENT_NUMBER_OF_BYTES_USED 14144
640 HIGH_NUMBER_OF_BYTES_USED 14144
641 execute dump_memory_global;
642 EVENT_NAME memory/sql/Query_cache
643 COUNT_ALLOC 4
644 COUNT_FREE 2
645 SUM_NUMBER_OF_BYTES_ALLOC 65536
646 SUM_NUMBER_OF_BYTES_FREE 32768
647 LOW_COUNT_USED 0
648 CURRENT_COUNT_USED 2
649 HIGH_COUNT_USED 2
650 LOW_NUMBER_OF_BYTES_USED 0
651 CURRENT_NUMBER_OF_BYTES_USED 32768
652 HIGH_NUMBER_OF_BYTES_USED 32768
653 EVENT_NAME memory/sql/User_level_lock
654 COUNT_ALLOC 4
655 COUNT_FREE 2
656 SUM_NUMBER_OF_BYTES_ALLOC 544
657 SUM_NUMBER_OF_BYTES_FREE 32
658 LOW_COUNT_USED 0
659 CURRENT_COUNT_USED 2
660 HIGH_COUNT_USED 4
661 LOW_NUMBER_OF_BYTES_USED 0
662 CURRENT_NUMBER_OF_BYTES_USED 512
663 HIGH_NUMBER_OF_BYTES_USED 544
664 EVENT_NAME memory/sql/user_var_entry::value
665 COUNT_ALLOC 7
666 COUNT_FREE 0
667 SUM_NUMBER_OF_BYTES_ALLOC 14144
668 SUM_NUMBER_OF_BYTES_FREE 0
669 LOW_COUNT_USED 1
670 CURRENT_COUNT_USED 7
671 HIGH_COUNT_USED 7
672 LOW_NUMBER_OF_BYTES_USED 96
673 CURRENT_NUMBER_OF_BYTES_USED 14144
674 HIGH_NUMBER_OF_BYTES_USED 14144
675 execute dump_accounts;
676 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
677 execute dump_users;
678 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
679 execute dump_hosts;
680 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
681 localhost 3 3
682 connect con3, localhost, user3, , ;
683 "================== con3 connected =================="
684 connection default;
685 "================== Step 6 =================="
686 call dump_thread();
687 username user1
688 EVENT_NAME memory/sql/User_level_lock
689 COUNT_ALLOC 1
690 COUNT_FREE 0
691 SUM_NUMBER_OF_BYTES_ALLOC 256
692 SUM_NUMBER_OF_BYTES_FREE 0
693 LOW_COUNT_USED 1
694 CURRENT_COUNT_USED 1
695 HIGH_COUNT_USED 1
696 LOW_NUMBER_OF_BYTES_USED 256
697 CURRENT_NUMBER_OF_BYTES_USED 256
698 HIGH_NUMBER_OF_BYTES_USED 256
699 username user1
700 EVENT_NAME memory/sql/user_var_entry::value
701 COUNT_ALLOC 3
702 COUNT_FREE 0
703 SUM_NUMBER_OF_BYTES_ALLOC 7024
704 SUM_NUMBER_OF_BYTES_FREE 0
705 LOW_COUNT_USED 3
706 CURRENT_COUNT_USED 3
707 HIGH_COUNT_USED 3
708 LOW_NUMBER_OF_BYTES_USED 7024
709 CURRENT_NUMBER_OF_BYTES_USED 7024
710 HIGH_NUMBER_OF_BYTES_USED 7024
711 username user2
712 EVENT_NAME memory/sql/User_level_lock
713 COUNT_ALLOC 1
714 COUNT_FREE 0
715 SUM_NUMBER_OF_BYTES_ALLOC 256
716 SUM_NUMBER_OF_BYTES_FREE 0
717 LOW_COUNT_USED 1
718 CURRENT_COUNT_USED 1
719 HIGH_COUNT_USED 1
720 LOW_NUMBER_OF_BYTES_USED 256
721 CURRENT_NUMBER_OF_BYTES_USED 256
722 HIGH_NUMBER_OF_BYTES_USED 256
723 username user2
724 EVENT_NAME memory/sql/user_var_entry::value
725 COUNT_ALLOC 3
726 COUNT_FREE 0
727 SUM_NUMBER_OF_BYTES_ALLOC 7024
728 SUM_NUMBER_OF_BYTES_FREE 0
729 LOW_COUNT_USED 3
730 CURRENT_COUNT_USED 3
731 HIGH_COUNT_USED 3
732 LOW_NUMBER_OF_BYTES_USED 7024
733 CURRENT_NUMBER_OF_BYTES_USED 7024
734 HIGH_NUMBER_OF_BYTES_USED 7024
735 username user3
736 EVENT_NAME memory/sql/User_level_lock
737 COUNT_ALLOC 0
738 COUNT_FREE 0
739 SUM_NUMBER_OF_BYTES_ALLOC 0
740 SUM_NUMBER_OF_BYTES_FREE 0
741 LOW_COUNT_USED 0
742 CURRENT_COUNT_USED 0
743 HIGH_COUNT_USED 0
744 LOW_NUMBER_OF_BYTES_USED 0
745 CURRENT_NUMBER_OF_BYTES_USED 0
746 HIGH_NUMBER_OF_BYTES_USED 0
747 username user3
748 EVENT_NAME memory/sql/user_var_entry::value
749 COUNT_ALLOC 0
750 COUNT_FREE 0
751 SUM_NUMBER_OF_BYTES_ALLOC 0
752 SUM_NUMBER_OF_BYTES_FREE 0
753 LOW_COUNT_USED 0
754 CURRENT_COUNT_USED 0
755 HIGH_COUNT_USED 0
756 LOW_NUMBER_OF_BYTES_USED 0
757 CURRENT_NUMBER_OF_BYTES_USED 0
758 HIGH_NUMBER_OF_BYTES_USED 0
759 username user4
760 status not found
761 execute dump_memory_account;
762 execute dump_memory_user;
763 execute dump_memory_host;
764 HOST localhost
765 EVENT_NAME memory/sql/User_level_lock
766 COUNT_ALLOC 4
767 COUNT_FREE 2
768 SUM_NUMBER_OF_BYTES_ALLOC 544
769 SUM_NUMBER_OF_BYTES_FREE 32
770 LOW_COUNT_USED 0
771 CURRENT_COUNT_USED 2
772 HIGH_COUNT_USED 4
773 LOW_NUMBER_OF_BYTES_USED 0
774 CURRENT_NUMBER_OF_BYTES_USED 512
775 HIGH_NUMBER_OF_BYTES_USED 544
776 HOST localhost
777 EVENT_NAME memory/sql/user_var_entry::value
778 COUNT_ALLOC 7
779 COUNT_FREE 0
780 SUM_NUMBER_OF_BYTES_ALLOC 14144
781 SUM_NUMBER_OF_BYTES_FREE 0
782 LOW_COUNT_USED 1
783 CURRENT_COUNT_USED 7
784 HIGH_COUNT_USED 7
785 LOW_NUMBER_OF_BYTES_USED 96
786 CURRENT_NUMBER_OF_BYTES_USED 14144
787 HIGH_NUMBER_OF_BYTES_USED 14144
788 execute dump_memory_global;
789 EVENT_NAME memory/sql/Query_cache
790 COUNT_ALLOC 4
791 COUNT_FREE 2
792 SUM_NUMBER_OF_BYTES_ALLOC 65536
793 SUM_NUMBER_OF_BYTES_FREE 32768
794 LOW_COUNT_USED 0
795 CURRENT_COUNT_USED 2
796 HIGH_COUNT_USED 2
797 LOW_NUMBER_OF_BYTES_USED 0
798 CURRENT_NUMBER_OF_BYTES_USED 32768
799 HIGH_NUMBER_OF_BYTES_USED 32768
800 EVENT_NAME memory/sql/User_level_lock
801 COUNT_ALLOC 4
802 COUNT_FREE 2
803 SUM_NUMBER_OF_BYTES_ALLOC 544
804 SUM_NUMBER_OF_BYTES_FREE 32
805 LOW_COUNT_USED 0
806 CURRENT_COUNT_USED 2
807 HIGH_COUNT_USED 4
808 LOW_NUMBER_OF_BYTES_USED 0
809 CURRENT_NUMBER_OF_BYTES_USED 512
810 HIGH_NUMBER_OF_BYTES_USED 544
811 EVENT_NAME memory/sql/user_var_entry::value
812 COUNT_ALLOC 7
813 COUNT_FREE 0
814 SUM_NUMBER_OF_BYTES_ALLOC 14144
815 SUM_NUMBER_OF_BYTES_FREE 0
816 LOW_COUNT_USED 1
817 CURRENT_COUNT_USED 7
818 HIGH_COUNT_USED 7
819 LOW_NUMBER_OF_BYTES_USED 96
820 CURRENT_NUMBER_OF_BYTES_USED 14144
821 HIGH_NUMBER_OF_BYTES_USED 14144
822 execute dump_accounts;
823 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
824 execute dump_users;
825 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
826 execute dump_hosts;
827 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
828 localhost 4 4
829 connection con3;
830 set GLOBAL query_cache_size=500*1024;
831 select get_lock("marker_3", 10);
832 get_lock("marker_3", 10)
833 1
834 select release_lock("marker_3");
835 release_lock("marker_3")
836 1
837 set @v1 = repeat("a", 1000);
838 set @v2 = repeat("b", 2000);
839 set @v3 = repeat("c", 4000);
840 "================== con3 marker =================="
841 connection default;
842 "================== Step 7 =================="
843 call dump_thread();
844 username user1
845 EVENT_NAME memory/sql/User_level_lock
846 COUNT_ALLOC 1
847 COUNT_FREE 0
848 SUM_NUMBER_OF_BYTES_ALLOC 256
849 SUM_NUMBER_OF_BYTES_FREE 0
850 LOW_COUNT_USED 1
851 CURRENT_COUNT_USED 1
852 HIGH_COUNT_USED 1
853 LOW_NUMBER_OF_BYTES_USED 256
854 CURRENT_NUMBER_OF_BYTES_USED 256
855 HIGH_NUMBER_OF_BYTES_USED 256
856 username user1
857 EVENT_NAME memory/sql/user_var_entry::value
858 COUNT_ALLOC 3
859 COUNT_FREE 0
860 SUM_NUMBER_OF_BYTES_ALLOC 7024
861 SUM_NUMBER_OF_BYTES_FREE 0
862 LOW_COUNT_USED 3
863 CURRENT_COUNT_USED 3
864 HIGH_COUNT_USED 3
865 LOW_NUMBER_OF_BYTES_USED 7024
866 CURRENT_NUMBER_OF_BYTES_USED 7024
867 HIGH_NUMBER_OF_BYTES_USED 7024
868 username user2
869 EVENT_NAME memory/sql/User_level_lock
870 COUNT_ALLOC 1
871 COUNT_FREE 0
872 SUM_NUMBER_OF_BYTES_ALLOC 256
873 SUM_NUMBER_OF_BYTES_FREE 0
874 LOW_COUNT_USED 1
875 CURRENT_COUNT_USED 1
876 HIGH_COUNT_USED 1
877 LOW_NUMBER_OF_BYTES_USED 256
878 CURRENT_NUMBER_OF_BYTES_USED 256
879 HIGH_NUMBER_OF_BYTES_USED 256
880 username user2
881 EVENT_NAME memory/sql/user_var_entry::value
882 COUNT_ALLOC 3
883 COUNT_FREE 0
884 SUM_NUMBER_OF_BYTES_ALLOC 7024
885 SUM_NUMBER_OF_BYTES_FREE 0
886 LOW_COUNT_USED 3
887 CURRENT_COUNT_USED 3
888 HIGH_COUNT_USED 3
889 LOW_NUMBER_OF_BYTES_USED 7024
890 CURRENT_NUMBER_OF_BYTES_USED 7024
891 HIGH_NUMBER_OF_BYTES_USED 7024
892 username user3
893 EVENT_NAME memory/sql/User_level_lock
894 COUNT_ALLOC 2
895 COUNT_FREE 1
896 SUM_NUMBER_OF_BYTES_ALLOC 272
897 SUM_NUMBER_OF_BYTES_FREE 16
898 LOW_COUNT_USED 0
899 CURRENT_COUNT_USED 1
900 HIGH_COUNT_USED 2
901 LOW_NUMBER_OF_BYTES_USED 0
902 CURRENT_NUMBER_OF_BYTES_USED 256
903 HIGH_NUMBER_OF_BYTES_USED 272
904 username user3
905 EVENT_NAME memory/sql/user_var_entry::value
906 COUNT_ALLOC 3
907 COUNT_FREE 0
908 SUM_NUMBER_OF_BYTES_ALLOC 7024
909 SUM_NUMBER_OF_BYTES_FREE 0
910 LOW_COUNT_USED 0
911 CURRENT_COUNT_USED 3
912 HIGH_COUNT_USED 3
913 LOW_NUMBER_OF_BYTES_USED 0
914 CURRENT_NUMBER_OF_BYTES_USED 7024
915 HIGH_NUMBER_OF_BYTES_USED 7024
916 username user4
917 status not found
918 execute dump_memory_account;
919 execute dump_memory_user;
920 execute dump_memory_host;
921 HOST localhost
922 EVENT_NAME memory/sql/User_level_lock
923 COUNT_ALLOC 6
924 COUNT_FREE 3
925 SUM_NUMBER_OF_BYTES_ALLOC 816
926 SUM_NUMBER_OF_BYTES_FREE 48
927 LOW_COUNT_USED 0
928 CURRENT_COUNT_USED 3
929 HIGH_COUNT_USED 4
930 LOW_NUMBER_OF_BYTES_USED 0
931 CURRENT_NUMBER_OF_BYTES_USED 768
932 HIGH_NUMBER_OF_BYTES_USED 784
933 HOST localhost
934 EVENT_NAME memory/sql/user_var_entry::value
935 COUNT_ALLOC 10
936 COUNT_FREE 0
937 SUM_NUMBER_OF_BYTES_ALLOC 21168
938 SUM_NUMBER_OF_BYTES_FREE 0
939 LOW_COUNT_USED 1
940 CURRENT_COUNT_USED 10
941 HIGH_COUNT_USED 10
942 LOW_NUMBER_OF_BYTES_USED 96
943 CURRENT_NUMBER_OF_BYTES_USED 21168
944 HIGH_NUMBER_OF_BYTES_USED 21168
945 execute dump_memory_global;
946 EVENT_NAME memory/sql/Query_cache
947 COUNT_ALLOC 6
948 COUNT_FREE 4
949 SUM_NUMBER_OF_BYTES_ALLOC 98304
950 SUM_NUMBER_OF_BYTES_FREE 65536
951 LOW_COUNT_USED 0
952 CURRENT_COUNT_USED 2
953 HIGH_COUNT_USED 2
954 LOW_NUMBER_OF_BYTES_USED 0
955 CURRENT_NUMBER_OF_BYTES_USED 32768
956 HIGH_NUMBER_OF_BYTES_USED 32768
957 EVENT_NAME memory/sql/User_level_lock
958 COUNT_ALLOC 6
959 COUNT_FREE 3
960 SUM_NUMBER_OF_BYTES_ALLOC 816
961 SUM_NUMBER_OF_BYTES_FREE 48
962 LOW_COUNT_USED 0
963 CURRENT_COUNT_USED 3
964 HIGH_COUNT_USED 4
965 LOW_NUMBER_OF_BYTES_USED 0
966 CURRENT_NUMBER_OF_BYTES_USED 768
967 HIGH_NUMBER_OF_BYTES_USED 784
968 EVENT_NAME memory/sql/user_var_entry::value
969 COUNT_ALLOC 10
970 COUNT_FREE 0
971 SUM_NUMBER_OF_BYTES_ALLOC 21168
972 SUM_NUMBER_OF_BYTES_FREE 0
973 LOW_COUNT_USED 1
974 CURRENT_COUNT_USED 10
975 HIGH_COUNT_USED 10
976 LOW_NUMBER_OF_BYTES_USED 96
977 CURRENT_NUMBER_OF_BYTES_USED 21168
978 HIGH_NUMBER_OF_BYTES_USED 21168
979 execute dump_accounts;
980 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
981 execute dump_users;
982 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
983 execute dump_hosts;
984 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
985 localhost 4 4
986 connect con4, localhost, user4, , ;
987 connect con5, localhost, user4, , ;
988 "================== con4/con5 (both user4) connected =================="
989 connection default;
990 "================== Step 8 =================="
991 call dump_thread();
992 username user1
993 EVENT_NAME memory/sql/User_level_lock
994 COUNT_ALLOC 1
995 COUNT_FREE 0
996 SUM_NUMBER_OF_BYTES_ALLOC 256
997 SUM_NUMBER_OF_BYTES_FREE 0
998 LOW_COUNT_USED 1
999 CURRENT_COUNT_USED 1
1000 HIGH_COUNT_USED 1
1001 LOW_NUMBER_OF_BYTES_USED 256
1002 CURRENT_NUMBER_OF_BYTES_USED 256
1003 HIGH_NUMBER_OF_BYTES_USED 256
1004 username user1
1005 EVENT_NAME memory/sql/user_var_entry::value
1006 COUNT_ALLOC 3
1007 COUNT_FREE 0
1008 SUM_NUMBER_OF_BYTES_ALLOC 7024
1009 SUM_NUMBER_OF_BYTES_FREE 0
1010 LOW_COUNT_USED 3
1011 CURRENT_COUNT_USED 3
1012 HIGH_COUNT_USED 3
1013 LOW_NUMBER_OF_BYTES_USED 7024
1014 CURRENT_NUMBER_OF_BYTES_USED 7024
1015 HIGH_NUMBER_OF_BYTES_USED 7024
1016 username user2
1017 EVENT_NAME memory/sql/User_level_lock
1018 COUNT_ALLOC 1
1019 COUNT_FREE 0
1020 SUM_NUMBER_OF_BYTES_ALLOC 256
1021 SUM_NUMBER_OF_BYTES_FREE 0
1022 LOW_COUNT_USED 1
1023 CURRENT_COUNT_USED 1
1024 HIGH_COUNT_USED 1
1025 LOW_NUMBER_OF_BYTES_USED 256
1026 CURRENT_NUMBER_OF_BYTES_USED 256
1027 HIGH_NUMBER_OF_BYTES_USED 256
1028 username user2
1029 EVENT_NAME memory/sql/user_var_entry::value
1030 COUNT_ALLOC 3
1031 COUNT_FREE 0
1032 SUM_NUMBER_OF_BYTES_ALLOC 7024
1033 SUM_NUMBER_OF_BYTES_FREE 0
1034 LOW_COUNT_USED 3
1035 CURRENT_COUNT_USED 3
1036 HIGH_COUNT_USED 3
1037 LOW_NUMBER_OF_BYTES_USED 7024
1038 CURRENT_NUMBER_OF_BYTES_USED 7024
1039 HIGH_NUMBER_OF_BYTES_USED 7024
1040 username user3
1041 EVENT_NAME memory/sql/User_level_lock
1042 COUNT_ALLOC 2
1043 COUNT_FREE 1
1044 SUM_NUMBER_OF_BYTES_ALLOC 272
1045 SUM_NUMBER_OF_BYTES_FREE 16
1046 LOW_COUNT_USED 0
1047 CURRENT_COUNT_USED 1
1048 HIGH_COUNT_USED 2
1049 LOW_NUMBER_OF_BYTES_USED 0
1050 CURRENT_NUMBER_OF_BYTES_USED 256
1051 HIGH_NUMBER_OF_BYTES_USED 272
1052 username user3
1053 EVENT_NAME memory/sql/user_var_entry::value
1054 COUNT_ALLOC 3
1055 COUNT_FREE 0
1056 SUM_NUMBER_OF_BYTES_ALLOC 7024
1057 SUM_NUMBER_OF_BYTES_FREE 0
1058 LOW_COUNT_USED 0
1059 CURRENT_COUNT_USED 3
1060 HIGH_COUNT_USED 3
1061 LOW_NUMBER_OF_BYTES_USED 0
1062 CURRENT_NUMBER_OF_BYTES_USED 7024
1063 HIGH_NUMBER_OF_BYTES_USED 7024
1064 username user4
1065 EVENT_NAME memory/sql/User_level_lock
1066 COUNT_ALLOC 0
1067 COUNT_FREE 0
1068 SUM_NUMBER_OF_BYTES_ALLOC 0
1069 SUM_NUMBER_OF_BYTES_FREE 0
1070 LOW_COUNT_USED 0
1071 CURRENT_COUNT_USED 0
1072 HIGH_COUNT_USED 0
1073 LOW_NUMBER_OF_BYTES_USED 0
1074 CURRENT_NUMBER_OF_BYTES_USED 0
1075 HIGH_NUMBER_OF_BYTES_USED 0
1076 username user4
1077 EVENT_NAME memory/sql/user_var_entry::value
1078 COUNT_ALLOC 0
1079 COUNT_FREE 0
1080 SUM_NUMBER_OF_BYTES_ALLOC 0
1081 SUM_NUMBER_OF_BYTES_FREE 0
1082 LOW_COUNT_USED 0
1083 CURRENT_COUNT_USED 0
1084 HIGH_COUNT_USED 0
1085 LOW_NUMBER_OF_BYTES_USED 0
1086 CURRENT_NUMBER_OF_BYTES_USED 0
1087 HIGH_NUMBER_OF_BYTES_USED 0
1088 execute dump_memory_account;
1089 execute dump_memory_user;
1090 execute dump_memory_host;
1091 HOST localhost
1092 EVENT_NAME memory/sql/User_level_lock
1093 COUNT_ALLOC 6
1094 COUNT_FREE 3
1095 SUM_NUMBER_OF_BYTES_ALLOC 816
1096 SUM_NUMBER_OF_BYTES_FREE 48
1097 LOW_COUNT_USED 0
1098 CURRENT_COUNT_USED 3
1099 HIGH_COUNT_USED 4
1100 LOW_NUMBER_OF_BYTES_USED 0
1101 CURRENT_NUMBER_OF_BYTES_USED 768
1102 HIGH_NUMBER_OF_BYTES_USED 784
1103 HOST localhost
1104 EVENT_NAME memory/sql/user_var_entry::value
1105 COUNT_ALLOC 10
1106 COUNT_FREE 0
1107 SUM_NUMBER_OF_BYTES_ALLOC 21168
1108 SUM_NUMBER_OF_BYTES_FREE 0
1109 LOW_COUNT_USED 1
1110 CURRENT_COUNT_USED 10
1111 HIGH_COUNT_USED 10
1112 LOW_NUMBER_OF_BYTES_USED 96
1113 CURRENT_NUMBER_OF_BYTES_USED 21168
1114 HIGH_NUMBER_OF_BYTES_USED 21168
1115 execute dump_memory_global;
1116 EVENT_NAME memory/sql/Query_cache
1117 COUNT_ALLOC 6
1118 COUNT_FREE 4
1119 SUM_NUMBER_OF_BYTES_ALLOC 98304
1120 SUM_NUMBER_OF_BYTES_FREE 65536
1121 LOW_COUNT_USED 0
1122 CURRENT_COUNT_USED 2
1123 HIGH_COUNT_USED 2
1124 LOW_NUMBER_OF_BYTES_USED 0
1125 CURRENT_NUMBER_OF_BYTES_USED 32768
1126 HIGH_NUMBER_OF_BYTES_USED 32768
1127 EVENT_NAME memory/sql/User_level_lock
1128 COUNT_ALLOC 6
1129 COUNT_FREE 3
1130 SUM_NUMBER_OF_BYTES_ALLOC 816
1131 SUM_NUMBER_OF_BYTES_FREE 48
1132 LOW_COUNT_USED 0
1133 CURRENT_COUNT_USED 3
1134 HIGH_COUNT_USED 4
1135 LOW_NUMBER_OF_BYTES_USED 0
1136 CURRENT_NUMBER_OF_BYTES_USED 768
1137 HIGH_NUMBER_OF_BYTES_USED 784
1138 EVENT_NAME memory/sql/user_var_entry::value
1139 COUNT_ALLOC 10
1140 COUNT_FREE 0
1141 SUM_NUMBER_OF_BYTES_ALLOC 21168
1142 SUM_NUMBER_OF_BYTES_FREE 0
1143 LOW_COUNT_USED 1
1144 CURRENT_COUNT_USED 10
1145 HIGH_COUNT_USED 10
1146 LOW_NUMBER_OF_BYTES_USED 96
1147 CURRENT_NUMBER_OF_BYTES_USED 21168
1148 HIGH_NUMBER_OF_BYTES_USED 21168
1149 execute dump_accounts;
1150 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1151 execute dump_users;
1152 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1153 execute dump_hosts;
1154 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1155 localhost 6 6
1156 connection con4;
1157 set GLOBAL query_cache_size=4000*1024;
1158 select get_lock("marker_4", 10);
1159 get_lock("marker_4", 10)
1160 1
1161 select release_lock("marker_4");
1162 release_lock("marker_4")
1163 1
1164 set @v1 = repeat("a", 1000);
1165 set @v2 = repeat("b", 2000);
1166 set @v3 = repeat("c", 4000);
1167 connection con5;
1168 select get_lock("marker_5", 10);
1169 get_lock("marker_5", 10)
1170 1
1171 select release_lock("marker_5");
1172 release_lock("marker_5")
1173 1
1174 set @v1 = repeat("a", 1000);
1175 set @v2 = repeat("b", 2000);
1176 set @v3 = repeat("c", 4000);
1177 "================== con4/con5 marker =================="
1178 connection default;
1179 "================== Step 9 =================="
1180 call dump_thread();
1181 username user1
1182 EVENT_NAME memory/sql/User_level_lock
1183 COUNT_ALLOC 1
1184 COUNT_FREE 0
1185 SUM_NUMBER_OF_BYTES_ALLOC 256
1186 SUM_NUMBER_OF_BYTES_FREE 0
1187 LOW_COUNT_USED 1
1188 CURRENT_COUNT_USED 1
1189 HIGH_COUNT_USED 1
1190 LOW_NUMBER_OF_BYTES_USED 256
1191 CURRENT_NUMBER_OF_BYTES_USED 256
1192 HIGH_NUMBER_OF_BYTES_USED 256
1193 username user1
1194 EVENT_NAME memory/sql/user_var_entry::value
1195 COUNT_ALLOC 3
1196 COUNT_FREE 0
1197 SUM_NUMBER_OF_BYTES_ALLOC 7024
1198 SUM_NUMBER_OF_BYTES_FREE 0
1199 LOW_COUNT_USED 3
1200 CURRENT_COUNT_USED 3
1201 HIGH_COUNT_USED 3
1202 LOW_NUMBER_OF_BYTES_USED 7024
1203 CURRENT_NUMBER_OF_BYTES_USED 7024
1204 HIGH_NUMBER_OF_BYTES_USED 7024
1205 username user2
1206 EVENT_NAME memory/sql/User_level_lock
1207 COUNT_ALLOC 1
1208 COUNT_FREE 0
1209 SUM_NUMBER_OF_BYTES_ALLOC 256
1210 SUM_NUMBER_OF_BYTES_FREE 0
1211 LOW_COUNT_USED 1
1212 CURRENT_COUNT_USED 1
1213 HIGH_COUNT_USED 1
1214 LOW_NUMBER_OF_BYTES_USED 256
1215 CURRENT_NUMBER_OF_BYTES_USED 256
1216 HIGH_NUMBER_OF_BYTES_USED 256
1217 username user2
1218 EVENT_NAME memory/sql/user_var_entry::value
1219 COUNT_ALLOC 3
1220 COUNT_FREE 0
1221 SUM_NUMBER_OF_BYTES_ALLOC 7024
1222 SUM_NUMBER_OF_BYTES_FREE 0
1223 LOW_COUNT_USED 3
1224 CURRENT_COUNT_USED 3
1225 HIGH_COUNT_USED 3
1226 LOW_NUMBER_OF_BYTES_USED 7024
1227 CURRENT_NUMBER_OF_BYTES_USED 7024
1228 HIGH_NUMBER_OF_BYTES_USED 7024
1229 username user3
1230 EVENT_NAME memory/sql/User_level_lock
1231 COUNT_ALLOC 2
1232 COUNT_FREE 1
1233 SUM_NUMBER_OF_BYTES_ALLOC 272
1234 SUM_NUMBER_OF_BYTES_FREE 16
1235 LOW_COUNT_USED 0
1236 CURRENT_COUNT_USED 1
1237 HIGH_COUNT_USED 2
1238 LOW_NUMBER_OF_BYTES_USED 0
1239 CURRENT_NUMBER_OF_BYTES_USED 256
1240 HIGH_NUMBER_OF_BYTES_USED 272
1241 username user3
1242 EVENT_NAME memory/sql/user_var_entry::value
1243 COUNT_ALLOC 3
1244 COUNT_FREE 0
1245 SUM_NUMBER_OF_BYTES_ALLOC 7024
1246 SUM_NUMBER_OF_BYTES_FREE 0
1247 LOW_COUNT_USED 0
1248 CURRENT_COUNT_USED 3
1249 HIGH_COUNT_USED 3
1250 LOW_NUMBER_OF_BYTES_USED 0
1251 CURRENT_NUMBER_OF_BYTES_USED 7024
1252 HIGH_NUMBER_OF_BYTES_USED 7024
1253 username user4
1254 EVENT_NAME memory/sql/User_level_lock
1255 COUNT_ALLOC 2
1256 COUNT_FREE 1
1257 SUM_NUMBER_OF_BYTES_ALLOC 272
1258 SUM_NUMBER_OF_BYTES_FREE 16
1259 LOW_COUNT_USED 0
1260 CURRENT_COUNT_USED 1
1261 HIGH_COUNT_USED 2
1262 LOW_NUMBER_OF_BYTES_USED 0
1263 CURRENT_NUMBER_OF_BYTES_USED 256
1264 HIGH_NUMBER_OF_BYTES_USED 272
1265 username user4
1266 EVENT_NAME memory/sql/user_var_entry::value
1267 COUNT_ALLOC 3
1268 COUNT_FREE 0
1269 SUM_NUMBER_OF_BYTES_ALLOC 7024
1270 SUM_NUMBER_OF_BYTES_FREE 0
1271 LOW_COUNT_USED 0
1272 CURRENT_COUNT_USED 3
1273 HIGH_COUNT_USED 3
1274 LOW_NUMBER_OF_BYTES_USED 0
1275 CURRENT_NUMBER_OF_BYTES_USED 7024
1276 HIGH_NUMBER_OF_BYTES_USED 7024
1277 execute dump_memory_account;
1278 execute dump_memory_user;
1279 execute dump_memory_host;
1280 HOST localhost
1281 EVENT_NAME memory/sql/User_level_lock
1282 COUNT_ALLOC 10
1283 COUNT_FREE 5
1284 SUM_NUMBER_OF_BYTES_ALLOC 1360
1285 SUM_NUMBER_OF_BYTES_FREE 80
1286 LOW_COUNT_USED 0
1287 CURRENT_COUNT_USED 5
1288 HIGH_COUNT_USED 8
1289 LOW_NUMBER_OF_BYTES_USED 0
1290 CURRENT_NUMBER_OF_BYTES_USED 1280
1291 HIGH_NUMBER_OF_BYTES_USED 1328
1292 HOST localhost
1293 EVENT_NAME memory/sql/user_var_entry::value
1294 COUNT_ALLOC 16
1295 COUNT_FREE 0
1296 SUM_NUMBER_OF_BYTES_ALLOC 35216
1297 SUM_NUMBER_OF_BYTES_FREE 0
1298 LOW_COUNT_USED 1
1299 CURRENT_COUNT_USED 16
1300 HIGH_COUNT_USED 16
1301 LOW_NUMBER_OF_BYTES_USED 96
1302 CURRENT_NUMBER_OF_BYTES_USED 35216
1303 HIGH_NUMBER_OF_BYTES_USED 35216
1304 execute dump_memory_global;
1305 EVENT_NAME memory/sql/Query_cache
1306 COUNT_ALLOC 8
1307 COUNT_FREE 6
1308 SUM_NUMBER_OF_BYTES_ALLOC 131072
1309 SUM_NUMBER_OF_BYTES_FREE 98304
1310 LOW_COUNT_USED 0
1311 CURRENT_COUNT_USED 2
1312 HIGH_COUNT_USED 2
1313 LOW_NUMBER_OF_BYTES_USED 0
1314 CURRENT_NUMBER_OF_BYTES_USED 32768
1315 HIGH_NUMBER_OF_BYTES_USED 32768
1316 EVENT_NAME memory/sql/User_level_lock
1317 COUNT_ALLOC 10
1318 COUNT_FREE 5
1319 SUM_NUMBER_OF_BYTES_ALLOC 1360
1320 SUM_NUMBER_OF_BYTES_FREE 80
1321 LOW_COUNT_USED 0
1322 CURRENT_COUNT_USED 5
1323 HIGH_COUNT_USED 8
1324 LOW_NUMBER_OF_BYTES_USED 0
1325 CURRENT_NUMBER_OF_BYTES_USED 1280
1326 HIGH_NUMBER_OF_BYTES_USED 1328
1327 EVENT_NAME memory/sql/user_var_entry::value
1328 COUNT_ALLOC 16
1329 COUNT_FREE 0
1330 SUM_NUMBER_OF_BYTES_ALLOC 35216
1331 SUM_NUMBER_OF_BYTES_FREE 0
1332 LOW_COUNT_USED 1
1333 CURRENT_COUNT_USED 16
1334 HIGH_COUNT_USED 16
1335 LOW_NUMBER_OF_BYTES_USED 96
1336 CURRENT_NUMBER_OF_BYTES_USED 35216
1337 HIGH_NUMBER_OF_BYTES_USED 35216
1338 execute dump_accounts;
1339 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1340 execute dump_users;
1341 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1342 execute dump_hosts;
1343 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1344 localhost 6 6
1345 disconnect con1;
1346 connection default;
1347 disconnect con5;
1348 "================== con1/con5 disconnected =================="
1349 "================== Step 10 =================="
1350 call dump_thread();
1351 username user1
1352 status not found
1353 username user2
1354 EVENT_NAME memory/sql/User_level_lock
1355 COUNT_ALLOC 1
1356 COUNT_FREE 0
1357 SUM_NUMBER_OF_BYTES_ALLOC 256
1358 SUM_NUMBER_OF_BYTES_FREE 0
1359 LOW_COUNT_USED 1
1360 CURRENT_COUNT_USED 1
1361 HIGH_COUNT_USED 1
1362 LOW_NUMBER_OF_BYTES_USED 256
1363 CURRENT_NUMBER_OF_BYTES_USED 256
1364 HIGH_NUMBER_OF_BYTES_USED 256
1365 username user2
1366 EVENT_NAME memory/sql/user_var_entry::value
1367 COUNT_ALLOC 3
1368 COUNT_FREE 0
1369 SUM_NUMBER_OF_BYTES_ALLOC 7024
1370 SUM_NUMBER_OF_BYTES_FREE 0
1371 LOW_COUNT_USED 3
1372 CURRENT_COUNT_USED 3
1373 HIGH_COUNT_USED 3
1374 LOW_NUMBER_OF_BYTES_USED 7024
1375 CURRENT_NUMBER_OF_BYTES_USED 7024
1376 HIGH_NUMBER_OF_BYTES_USED 7024
1377 username user3
1378 EVENT_NAME memory/sql/User_level_lock
1379 COUNT_ALLOC 2
1380 COUNT_FREE 1
1381 SUM_NUMBER_OF_BYTES_ALLOC 272
1382 SUM_NUMBER_OF_BYTES_FREE 16
1383 LOW_COUNT_USED 0
1384 CURRENT_COUNT_USED 1
1385 HIGH_COUNT_USED 2
1386 LOW_NUMBER_OF_BYTES_USED 0
1387 CURRENT_NUMBER_OF_BYTES_USED 256
1388 HIGH_NUMBER_OF_BYTES_USED 272
1389 username user3
1390 EVENT_NAME memory/sql/user_var_entry::value
1391 COUNT_ALLOC 3
1392 COUNT_FREE 0
1393 SUM_NUMBER_OF_BYTES_ALLOC 7024
1394 SUM_NUMBER_OF_BYTES_FREE 0
1395 LOW_COUNT_USED 0
1396 CURRENT_COUNT_USED 3
1397 HIGH_COUNT_USED 3
1398 LOW_NUMBER_OF_BYTES_USED 0
1399 CURRENT_NUMBER_OF_BYTES_USED 7024
1400 HIGH_NUMBER_OF_BYTES_USED 7024
1401 username user4
1402 EVENT_NAME memory/sql/User_level_lock
1403 COUNT_ALLOC 2
1404 COUNT_FREE 1
1405 SUM_NUMBER_OF_BYTES_ALLOC 272
1406 SUM_NUMBER_OF_BYTES_FREE 16
1407 LOW_COUNT_USED 0
1408 CURRENT_COUNT_USED 1
1409 HIGH_COUNT_USED 2
1410 LOW_NUMBER_OF_BYTES_USED 0
1411 CURRENT_NUMBER_OF_BYTES_USED 256
1412 HIGH_NUMBER_OF_BYTES_USED 272
1413 username user4
1414 EVENT_NAME memory/sql/user_var_entry::value
1415 COUNT_ALLOC 3
1416 COUNT_FREE 0
1417 SUM_NUMBER_OF_BYTES_ALLOC 7024
1418 SUM_NUMBER_OF_BYTES_FREE 0
1419 LOW_COUNT_USED 0
1420 CURRENT_COUNT_USED 3
1421 HIGH_COUNT_USED 3
1422 LOW_NUMBER_OF_BYTES_USED 0
1423 CURRENT_NUMBER_OF_BYTES_USED 7024
1424 HIGH_NUMBER_OF_BYTES_USED 7024
1425 execute dump_memory_account;
1426 execute dump_memory_user;
1427 execute dump_memory_host;
1428 HOST localhost
1429 EVENT_NAME memory/sql/User_level_lock
1430 COUNT_ALLOC 10
1431 COUNT_FREE 7
1432 SUM_NUMBER_OF_BYTES_ALLOC 1360
1433 SUM_NUMBER_OF_BYTES_FREE 592
1434 LOW_COUNT_USED 0
1435 CURRENT_COUNT_USED 3
1436 HIGH_COUNT_USED 8
1437 LOW_NUMBER_OF_BYTES_USED 0
1438 CURRENT_NUMBER_OF_BYTES_USED 768
1439 HIGH_NUMBER_OF_BYTES_USED 1328
1440 HOST localhost
1441 EVENT_NAME memory/sql/user_var_entry::value
1442 COUNT_ALLOC 16
1443 COUNT_FREE 6
1444 SUM_NUMBER_OF_BYTES_ALLOC 35216
1445 SUM_NUMBER_OF_BYTES_FREE 14048
1446 LOW_COUNT_USED 1
1447 CURRENT_COUNT_USED 10
1448 HIGH_COUNT_USED 16
1449 LOW_NUMBER_OF_BYTES_USED 96
1450 CURRENT_NUMBER_OF_BYTES_USED 21168
1451 HIGH_NUMBER_OF_BYTES_USED 35216
1452 execute dump_memory_global;
1453 EVENT_NAME memory/sql/Query_cache
1454 COUNT_ALLOC 8
1455 COUNT_FREE 6
1456 SUM_NUMBER_OF_BYTES_ALLOC 131072
1457 SUM_NUMBER_OF_BYTES_FREE 98304
1458 LOW_COUNT_USED 0
1459 CURRENT_COUNT_USED 2
1460 HIGH_COUNT_USED 2
1461 LOW_NUMBER_OF_BYTES_USED 0
1462 CURRENT_NUMBER_OF_BYTES_USED 32768
1463 HIGH_NUMBER_OF_BYTES_USED 32768
1464 EVENT_NAME memory/sql/User_level_lock
1465 COUNT_ALLOC 10
1466 COUNT_FREE 7
1467 SUM_NUMBER_OF_BYTES_ALLOC 1360
1468 SUM_NUMBER_OF_BYTES_FREE 592
1469 LOW_COUNT_USED 0
1470 CURRENT_COUNT_USED 3
1471 HIGH_COUNT_USED 8
1472 LOW_NUMBER_OF_BYTES_USED 0
1473 CURRENT_NUMBER_OF_BYTES_USED 768
1474 HIGH_NUMBER_OF_BYTES_USED 1328
1475 EVENT_NAME memory/sql/user_var_entry::value
1476 COUNT_ALLOC 16
1477 COUNT_FREE 6
1478 SUM_NUMBER_OF_BYTES_ALLOC 35216
1479 SUM_NUMBER_OF_BYTES_FREE 14048
1480 LOW_COUNT_USED 1
1481 CURRENT_COUNT_USED 10
1482 HIGH_COUNT_USED 16
1483 LOW_NUMBER_OF_BYTES_USED 96
1484 CURRENT_NUMBER_OF_BYTES_USED 21168
1485 HIGH_NUMBER_OF_BYTES_USED 35216
1486 execute dump_accounts;
1487 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1488 execute dump_users;
1489 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1490 execute dump_hosts;
1491 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1492 localhost 4 6
1493 disconnect con2;
1494 connection default;
1495 "================== con2 disconnected =================="
1496 "================== Step 11 =================="
1497 call dump_thread();
1498 username user1
1499 status not found
1500 username user2
1501 status not found
1502 username user3
1503 EVENT_NAME memory/sql/User_level_lock
1504 COUNT_ALLOC 2
1505 COUNT_FREE 1
1506 SUM_NUMBER_OF_BYTES_ALLOC 272
1507 SUM_NUMBER_OF_BYTES_FREE 16
1508 LOW_COUNT_USED 0
1509 CURRENT_COUNT_USED 1
1510 HIGH_COUNT_USED 2
1511 LOW_NUMBER_OF_BYTES_USED 0
1512 CURRENT_NUMBER_OF_BYTES_USED 256
1513 HIGH_NUMBER_OF_BYTES_USED 272
1514 username user3
1515 EVENT_NAME memory/sql/user_var_entry::value
1516 COUNT_ALLOC 3
1517 COUNT_FREE 0
1518 SUM_NUMBER_OF_BYTES_ALLOC 7024
1519 SUM_NUMBER_OF_BYTES_FREE 0
1520 LOW_COUNT_USED 0
1521 CURRENT_COUNT_USED 3
1522 HIGH_COUNT_USED 3
1523 LOW_NUMBER_OF_BYTES_USED 0
1524 CURRENT_NUMBER_OF_BYTES_USED 7024
1525 HIGH_NUMBER_OF_BYTES_USED 7024
1526 username user4
1527 EVENT_NAME memory/sql/User_level_lock
1528 COUNT_ALLOC 2
1529 COUNT_FREE 1
1530 SUM_NUMBER_OF_BYTES_ALLOC 272
1531 SUM_NUMBER_OF_BYTES_FREE 16
1532 LOW_COUNT_USED 0
1533 CURRENT_COUNT_USED 1
1534 HIGH_COUNT_USED 2
1535 LOW_NUMBER_OF_BYTES_USED 0
1536 CURRENT_NUMBER_OF_BYTES_USED 256
1537 HIGH_NUMBER_OF_BYTES_USED 272
1538 username user4
1539 EVENT_NAME memory/sql/user_var_entry::value
1540 COUNT_ALLOC 3
1541 COUNT_FREE 0
1542 SUM_NUMBER_OF_BYTES_ALLOC 7024
1543 SUM_NUMBER_OF_BYTES_FREE 0
1544 LOW_COUNT_USED 0
1545 CURRENT_COUNT_USED 3
1546 HIGH_COUNT_USED 3
1547 LOW_NUMBER_OF_BYTES_USED 0
1548 CURRENT_NUMBER_OF_BYTES_USED 7024
1549 HIGH_NUMBER_OF_BYTES_USED 7024
1550 execute dump_memory_account;
1551 execute dump_memory_user;
1552 execute dump_memory_host;
1553 HOST localhost
1554 EVENT_NAME memory/sql/User_level_lock
1555 COUNT_ALLOC 10
1556 COUNT_FREE 8
1557 SUM_NUMBER_OF_BYTES_ALLOC 1360
1558 SUM_NUMBER_OF_BYTES_FREE 848
1559 LOW_COUNT_USED 0
1560 CURRENT_COUNT_USED 2
1561 HIGH_COUNT_USED 8
1562 LOW_NUMBER_OF_BYTES_USED 0
1563 CURRENT_NUMBER_OF_BYTES_USED 512
1564 HIGH_NUMBER_OF_BYTES_USED 1328
1565 HOST localhost
1566 EVENT_NAME memory/sql/user_var_entry::value
1567 COUNT_ALLOC 16
1568 COUNT_FREE 9
1569 SUM_NUMBER_OF_BYTES_ALLOC 35216
1570 SUM_NUMBER_OF_BYTES_FREE 21072
1571 LOW_COUNT_USED 1
1572 CURRENT_COUNT_USED 7
1573 HIGH_COUNT_USED 16
1574 LOW_NUMBER_OF_BYTES_USED 96
1575 CURRENT_NUMBER_OF_BYTES_USED 14144
1576 HIGH_NUMBER_OF_BYTES_USED 35216
1577 execute dump_memory_global;
1578 EVENT_NAME memory/sql/Query_cache
1579 COUNT_ALLOC 8
1580 COUNT_FREE 6
1581 SUM_NUMBER_OF_BYTES_ALLOC 131072
1582 SUM_NUMBER_OF_BYTES_FREE 98304
1583 LOW_COUNT_USED 0
1584 CURRENT_COUNT_USED 2
1585 HIGH_COUNT_USED 2
1586 LOW_NUMBER_OF_BYTES_USED 0
1587 CURRENT_NUMBER_OF_BYTES_USED 32768
1588 HIGH_NUMBER_OF_BYTES_USED 32768
1589 EVENT_NAME memory/sql/User_level_lock
1590 COUNT_ALLOC 10
1591 COUNT_FREE 8
1592 SUM_NUMBER_OF_BYTES_ALLOC 1360
1593 SUM_NUMBER_OF_BYTES_FREE 848
1594 LOW_COUNT_USED 0
1595 CURRENT_COUNT_USED 2
1596 HIGH_COUNT_USED 8
1597 LOW_NUMBER_OF_BYTES_USED 0
1598 CURRENT_NUMBER_OF_BYTES_USED 512
1599 HIGH_NUMBER_OF_BYTES_USED 1328
1600 EVENT_NAME memory/sql/user_var_entry::value
1601 COUNT_ALLOC 16
1602 COUNT_FREE 9
1603 SUM_NUMBER_OF_BYTES_ALLOC 35216
1604 SUM_NUMBER_OF_BYTES_FREE 21072
1605 LOW_COUNT_USED 1
1606 CURRENT_COUNT_USED 7
1607 HIGH_COUNT_USED 16
1608 LOW_NUMBER_OF_BYTES_USED 96
1609 CURRENT_NUMBER_OF_BYTES_USED 14144
1610 HIGH_NUMBER_OF_BYTES_USED 35216
1611 execute dump_accounts;
1612 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1613 execute dump_users;
1614 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1615 execute dump_hosts;
1616 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1617 localhost 3 6
1618 disconnect con3;
1619 connection default;
1620 "================== con3 disconnected =================="
1621 "================== Step 12 =================="
1622 call dump_thread();
1623 username user1
1624 status not found
1625 username user2
1626 status not found
1627 username user3
1628 status not found
1629 username user4
1630 EVENT_NAME memory/sql/User_level_lock
1631 COUNT_ALLOC 2
1632 COUNT_FREE 1
1633 SUM_NUMBER_OF_BYTES_ALLOC 272
1634 SUM_NUMBER_OF_BYTES_FREE 16
1635 LOW_COUNT_USED 0
1636 CURRENT_COUNT_USED 1
1637 HIGH_COUNT_USED 2
1638 LOW_NUMBER_OF_BYTES_USED 0
1639 CURRENT_NUMBER_OF_BYTES_USED 256
1640 HIGH_NUMBER_OF_BYTES_USED 272
1641 username user4
1642 EVENT_NAME memory/sql/user_var_entry::value
1643 COUNT_ALLOC 3
1644 COUNT_FREE 0
1645 SUM_NUMBER_OF_BYTES_ALLOC 7024
1646 SUM_NUMBER_OF_BYTES_FREE 0
1647 LOW_COUNT_USED 0
1648 CURRENT_COUNT_USED 3
1649 HIGH_COUNT_USED 3
1650 LOW_NUMBER_OF_BYTES_USED 0
1651 CURRENT_NUMBER_OF_BYTES_USED 7024
1652 HIGH_NUMBER_OF_BYTES_USED 7024
1653 execute dump_memory_account;
1654 execute dump_memory_user;
1655 execute dump_memory_host;
1656 HOST localhost
1657 EVENT_NAME memory/sql/User_level_lock
1658 COUNT_ALLOC 10
1659 COUNT_FREE 9
1660 SUM_NUMBER_OF_BYTES_ALLOC 1360
1661 SUM_NUMBER_OF_BYTES_FREE 1104
1662 LOW_COUNT_USED 0
1663 CURRENT_COUNT_USED 1
1664 HIGH_COUNT_USED 8
1665 LOW_NUMBER_OF_BYTES_USED 0
1666 CURRENT_NUMBER_OF_BYTES_USED 256
1667 HIGH_NUMBER_OF_BYTES_USED 1328
1668 HOST localhost
1669 EVENT_NAME memory/sql/user_var_entry::value
1670 COUNT_ALLOC 16
1671 COUNT_FREE 12
1672 SUM_NUMBER_OF_BYTES_ALLOC 35216
1673 SUM_NUMBER_OF_BYTES_FREE 28096
1674 LOW_COUNT_USED 1
1675 CURRENT_COUNT_USED 4
1676 HIGH_COUNT_USED 16
1677 LOW_NUMBER_OF_BYTES_USED 96
1678 CURRENT_NUMBER_OF_BYTES_USED 7120
1679 HIGH_NUMBER_OF_BYTES_USED 35216
1680 execute dump_memory_global;
1681 EVENT_NAME memory/sql/Query_cache
1682 COUNT_ALLOC 8
1683 COUNT_FREE 6
1684 SUM_NUMBER_OF_BYTES_ALLOC 131072
1685 SUM_NUMBER_OF_BYTES_FREE 98304
1686 LOW_COUNT_USED 0
1687 CURRENT_COUNT_USED 2
1688 HIGH_COUNT_USED 2
1689 LOW_NUMBER_OF_BYTES_USED 0
1690 CURRENT_NUMBER_OF_BYTES_USED 32768
1691 HIGH_NUMBER_OF_BYTES_USED 32768
1692 EVENT_NAME memory/sql/User_level_lock
1693 COUNT_ALLOC 10
1694 COUNT_FREE 9
1695 SUM_NUMBER_OF_BYTES_ALLOC 1360
1696 SUM_NUMBER_OF_BYTES_FREE 1104
1697 LOW_COUNT_USED 0
1698 CURRENT_COUNT_USED 1
1699 HIGH_COUNT_USED 8
1700 LOW_NUMBER_OF_BYTES_USED 0
1701 CURRENT_NUMBER_OF_BYTES_USED 256
1702 HIGH_NUMBER_OF_BYTES_USED 1328
1703 EVENT_NAME memory/sql/user_var_entry::value
1704 COUNT_ALLOC 16
1705 COUNT_FREE 12
1706 SUM_NUMBER_OF_BYTES_ALLOC 35216
1707 SUM_NUMBER_OF_BYTES_FREE 28096
1708 LOW_COUNT_USED 1
1709 CURRENT_COUNT_USED 4
1710 HIGH_COUNT_USED 16
1711 LOW_NUMBER_OF_BYTES_USED 96
1712 CURRENT_NUMBER_OF_BYTES_USED 7120
1713 HIGH_NUMBER_OF_BYTES_USED 35216
1714 execute dump_accounts;
1715 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1716 execute dump_users;
1717 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1718 execute dump_hosts;
1719 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1720 localhost 2 6
1721 disconnect con4;
1722 connection default;
1723 "================== con4 disconnected =================="
1724 "================== Step 13 =================="
1725 call dump_thread();
1726 username user1
1727 status not found
1728 username user2
1729 status not found
1730 username user3
1731 status not found
1732 username user4
1733 status not found
1734 execute dump_memory_account;
1735 execute dump_memory_user;
1736 execute dump_memory_host;
1737 HOST localhost
1738 EVENT_NAME memory/sql/User_level_lock
1739 COUNT_ALLOC 10
1740 COUNT_FREE 10
1741 SUM_NUMBER_OF_BYTES_ALLOC 1360
1742 SUM_NUMBER_OF_BYTES_FREE 1360
1743 LOW_COUNT_USED 0
1744 CURRENT_COUNT_USED 0
1745 HIGH_COUNT_USED 8
1746 LOW_NUMBER_OF_BYTES_USED 0
1747 CURRENT_NUMBER_OF_BYTES_USED 0
1748 HIGH_NUMBER_OF_BYTES_USED 1328
1749 HOST localhost
1750 EVENT_NAME memory/sql/user_var_entry::value
1751 COUNT_ALLOC 16
1752 COUNT_FREE 15
1753 SUM_NUMBER_OF_BYTES_ALLOC 35216
1754 SUM_NUMBER_OF_BYTES_FREE 35120
1755 LOW_COUNT_USED 1
1756 CURRENT_COUNT_USED 1
1757 HIGH_COUNT_USED 16
1758 LOW_NUMBER_OF_BYTES_USED 96
1759 CURRENT_NUMBER_OF_BYTES_USED 96
1760 HIGH_NUMBER_OF_BYTES_USED 35216
1761 execute dump_memory_global;
1762 EVENT_NAME memory/sql/Query_cache
1763 COUNT_ALLOC 8
1764 COUNT_FREE 6
1765 SUM_NUMBER_OF_BYTES_ALLOC 131072
1766 SUM_NUMBER_OF_BYTES_FREE 98304
1767 LOW_COUNT_USED 0
1768 CURRENT_COUNT_USED 2
1769 HIGH_COUNT_USED 2
1770 LOW_NUMBER_OF_BYTES_USED 0
1771 CURRENT_NUMBER_OF_BYTES_USED 32768
1772 HIGH_NUMBER_OF_BYTES_USED 32768
1773 EVENT_NAME memory/sql/User_level_lock
1774 COUNT_ALLOC 10
1775 COUNT_FREE 10
1776 SUM_NUMBER_OF_BYTES_ALLOC 1360
1777 SUM_NUMBER_OF_BYTES_FREE 1360
1778 LOW_COUNT_USED 0
1779 CURRENT_COUNT_USED 0
1780 HIGH_COUNT_USED 8
1781 LOW_NUMBER_OF_BYTES_USED 0
1782 CURRENT_NUMBER_OF_BYTES_USED 0
1783 HIGH_NUMBER_OF_BYTES_USED 1328
1784 EVENT_NAME memory/sql/user_var_entry::value
1785 COUNT_ALLOC 16
1786 COUNT_FREE 15
1787 SUM_NUMBER_OF_BYTES_ALLOC 35216
1788 SUM_NUMBER_OF_BYTES_FREE 35120
1789 LOW_COUNT_USED 1
1790 CURRENT_COUNT_USED 1
1791 HIGH_COUNT_USED 16
1792 LOW_NUMBER_OF_BYTES_USED 96
1793 CURRENT_NUMBER_OF_BYTES_USED 96
1794 HIGH_NUMBER_OF_BYTES_USED 35216
1795 execute dump_accounts;
1796 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1797 execute dump_users;
1798 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1799 execute dump_hosts;
1800 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1801 localhost 1 6
1802 connection default;
1803 truncate performance_schema.memory_summary_by_thread_by_event_name;
1804 "================== MEMORY_BY_THREAD truncated =================="
1805 "================== Step 14 =================="
1806 call dump_thread();
1807 username user1
1808 status not found
1809 username user2
1810 status not found
1811 username user3
1812 status not found
1813 username user4
1814 status not found
1815 execute dump_memory_account;
1816 execute dump_memory_user;
1817 execute dump_memory_host;
1818 HOST localhost
1819 EVENT_NAME memory/sql/User_level_lock
1820 COUNT_ALLOC 10
1821 COUNT_FREE 10
1822 SUM_NUMBER_OF_BYTES_ALLOC 1360
1823 SUM_NUMBER_OF_BYTES_FREE 1360
1824 LOW_COUNT_USED 0
1825 CURRENT_COUNT_USED 0
1826 HIGH_COUNT_USED 8
1827 LOW_NUMBER_OF_BYTES_USED 0
1828 CURRENT_NUMBER_OF_BYTES_USED 0
1829 HIGH_NUMBER_OF_BYTES_USED 1328
1830 HOST localhost
1831 EVENT_NAME memory/sql/user_var_entry::value
1832 COUNT_ALLOC 16
1833 COUNT_FREE 15
1834 SUM_NUMBER_OF_BYTES_ALLOC 35216
1835 SUM_NUMBER_OF_BYTES_FREE 35120
1836 LOW_COUNT_USED 1
1837 CURRENT_COUNT_USED 1
1838 HIGH_COUNT_USED 16
1839 LOW_NUMBER_OF_BYTES_USED 96
1840 CURRENT_NUMBER_OF_BYTES_USED 96
1841 HIGH_NUMBER_OF_BYTES_USED 35216
1842 execute dump_memory_global;
1843 EVENT_NAME memory/sql/Query_cache
1844 COUNT_ALLOC 8
1845 COUNT_FREE 6
1846 SUM_NUMBER_OF_BYTES_ALLOC 131072
1847 SUM_NUMBER_OF_BYTES_FREE 98304
1848 LOW_COUNT_USED 0
1849 CURRENT_COUNT_USED 2
1850 HIGH_COUNT_USED 2
1851 LOW_NUMBER_OF_BYTES_USED 0
1852 CURRENT_NUMBER_OF_BYTES_USED 32768
1853 HIGH_NUMBER_OF_BYTES_USED 32768
1854 EVENT_NAME memory/sql/User_level_lock
1855 COUNT_ALLOC 10
1856 COUNT_FREE 10
1857 SUM_NUMBER_OF_BYTES_ALLOC 1360
1858 SUM_NUMBER_OF_BYTES_FREE 1360
1859 LOW_COUNT_USED 0
1860 CURRENT_COUNT_USED 0
1861 HIGH_COUNT_USED 8
1862 LOW_NUMBER_OF_BYTES_USED 0
1863 CURRENT_NUMBER_OF_BYTES_USED 0
1864 HIGH_NUMBER_OF_BYTES_USED 1328
1865 EVENT_NAME memory/sql/user_var_entry::value
1866 COUNT_ALLOC 16
1867 COUNT_FREE 15
1868 SUM_NUMBER_OF_BYTES_ALLOC 35216
1869 SUM_NUMBER_OF_BYTES_FREE 35120
1870 LOW_COUNT_USED 1
1871 CURRENT_COUNT_USED 1
1872 HIGH_COUNT_USED 16
1873 LOW_NUMBER_OF_BYTES_USED 96
1874 CURRENT_NUMBER_OF_BYTES_USED 96
1875 HIGH_NUMBER_OF_BYTES_USED 35216
1876 execute dump_accounts;
1877 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1878 execute dump_users;
1879 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1880 execute dump_hosts;
1881 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1882 localhost 1 6
1883 truncate performance_schema.memory_summary_by_account_by_event_name;
1884 "================== MEMORY_BY_ACCOUNT truncated =================="
1885 "================== Step 15 =================="
1886 call dump_thread();
1887 username user1
1888 status not found
1889 username user2
1890 status not found
1891 username user3
1892 status not found
1893 username user4
1894 status not found
1895 execute dump_memory_account;
1896 execute dump_memory_user;
1897 execute dump_memory_host;
1898 HOST localhost
1899 EVENT_NAME memory/sql/User_level_lock
1900 COUNT_ALLOC 10
1901 COUNT_FREE 10
1902 SUM_NUMBER_OF_BYTES_ALLOC 1360
1903 SUM_NUMBER_OF_BYTES_FREE 1360
1904 LOW_COUNT_USED 0
1905 CURRENT_COUNT_USED 0
1906 HIGH_COUNT_USED 8
1907 LOW_NUMBER_OF_BYTES_USED 0
1908 CURRENT_NUMBER_OF_BYTES_USED 0
1909 HIGH_NUMBER_OF_BYTES_USED 1328
1910 HOST localhost
1911 EVENT_NAME memory/sql/user_var_entry::value
1912 COUNT_ALLOC 16
1913 COUNT_FREE 15
1914 SUM_NUMBER_OF_BYTES_ALLOC 35216
1915 SUM_NUMBER_OF_BYTES_FREE 35120
1916 LOW_COUNT_USED 1
1917 CURRENT_COUNT_USED 1
1918 HIGH_COUNT_USED 16
1919 LOW_NUMBER_OF_BYTES_USED 96
1920 CURRENT_NUMBER_OF_BYTES_USED 96
1921 HIGH_NUMBER_OF_BYTES_USED 35216
1922 execute dump_memory_global;
1923 EVENT_NAME memory/sql/Query_cache
1924 COUNT_ALLOC 8
1925 COUNT_FREE 6
1926 SUM_NUMBER_OF_BYTES_ALLOC 131072
1927 SUM_NUMBER_OF_BYTES_FREE 98304
1928 LOW_COUNT_USED 0
1929 CURRENT_COUNT_USED 2
1930 HIGH_COUNT_USED 2
1931 LOW_NUMBER_OF_BYTES_USED 0
1932 CURRENT_NUMBER_OF_BYTES_USED 32768
1933 HIGH_NUMBER_OF_BYTES_USED 32768
1934 EVENT_NAME memory/sql/User_level_lock
1935 COUNT_ALLOC 10
1936 COUNT_FREE 10
1937 SUM_NUMBER_OF_BYTES_ALLOC 1360
1938 SUM_NUMBER_OF_BYTES_FREE 1360
1939 LOW_COUNT_USED 0
1940 CURRENT_COUNT_USED 0
1941 HIGH_COUNT_USED 8
1942 LOW_NUMBER_OF_BYTES_USED 0
1943 CURRENT_NUMBER_OF_BYTES_USED 0
1944 HIGH_NUMBER_OF_BYTES_USED 1328
1945 EVENT_NAME memory/sql/user_var_entry::value
1946 COUNT_ALLOC 16
1947 COUNT_FREE 15
1948 SUM_NUMBER_OF_BYTES_ALLOC 35216
1949 SUM_NUMBER_OF_BYTES_FREE 35120
1950 LOW_COUNT_USED 1
1951 CURRENT_COUNT_USED 1
1952 HIGH_COUNT_USED 16
1953 LOW_NUMBER_OF_BYTES_USED 96
1954 CURRENT_NUMBER_OF_BYTES_USED 96
1955 HIGH_NUMBER_OF_BYTES_USED 35216
1956 execute dump_accounts;
1957 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1958 execute dump_users;
1959 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1960 execute dump_hosts;
1961 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1962 localhost 1 6
1963 truncate performance_schema.memory_summary_by_user_by_event_name;
1964 "================== MEMORY_BY_USER truncated =================="
1965 "================== Step 16 =================="
1966 call dump_thread();
1967 username user1
1968 status not found
1969 username user2
1970 status not found
1971 username user3
1972 status not found
1973 username user4
1974 status not found
1975 execute dump_memory_account;
1976 execute dump_memory_user;
1977 execute dump_memory_host;
1978 HOST localhost
1979 EVENT_NAME memory/sql/User_level_lock
1980 COUNT_ALLOC 10
1981 COUNT_FREE 10
1982 SUM_NUMBER_OF_BYTES_ALLOC 1360
1983 SUM_NUMBER_OF_BYTES_FREE 1360
1984 LOW_COUNT_USED 0
1985 CURRENT_COUNT_USED 0
1986 HIGH_COUNT_USED 8
1987 LOW_NUMBER_OF_BYTES_USED 0
1988 CURRENT_NUMBER_OF_BYTES_USED 0
1989 HIGH_NUMBER_OF_BYTES_USED 1328
1990 HOST localhost
1991 EVENT_NAME memory/sql/user_var_entry::value
1992 COUNT_ALLOC 16
1993 COUNT_FREE 15
1994 SUM_NUMBER_OF_BYTES_ALLOC 35216
1995 SUM_NUMBER_OF_BYTES_FREE 35120
1996 LOW_COUNT_USED 1
1997 CURRENT_COUNT_USED 1
1998 HIGH_COUNT_USED 16
1999 LOW_NUMBER_OF_BYTES_USED 96
2000 CURRENT_NUMBER_OF_BYTES_USED 96
2001 HIGH_NUMBER_OF_BYTES_USED 35216
2002 execute dump_memory_global;
2003 EVENT_NAME memory/sql/Query_cache
2004 COUNT_ALLOC 8
2005 COUNT_FREE 6
2006 SUM_NUMBER_OF_BYTES_ALLOC 131072
2007 SUM_NUMBER_OF_BYTES_FREE 98304
2008 LOW_COUNT_USED 0
2009 CURRENT_COUNT_USED 2
2010 HIGH_COUNT_USED 2
2011 LOW_NUMBER_OF_BYTES_USED 0
2012 CURRENT_NUMBER_OF_BYTES_USED 32768
2013 HIGH_NUMBER_OF_BYTES_USED 32768
2014 EVENT_NAME memory/sql/User_level_lock
2015 COUNT_ALLOC 10
2016 COUNT_FREE 10
2017 SUM_NUMBER_OF_BYTES_ALLOC 1360
2018 SUM_NUMBER_OF_BYTES_FREE 1360
2019 LOW_COUNT_USED 0
2020 CURRENT_COUNT_USED 0
2021 HIGH_COUNT_USED 8
2022 LOW_NUMBER_OF_BYTES_USED 0
2023 CURRENT_NUMBER_OF_BYTES_USED 0
2024 HIGH_NUMBER_OF_BYTES_USED 1328
2025 EVENT_NAME memory/sql/user_var_entry::value
2026 COUNT_ALLOC 16
2027 COUNT_FREE 15
2028 SUM_NUMBER_OF_BYTES_ALLOC 35216
2029 SUM_NUMBER_OF_BYTES_FREE 35120
2030 LOW_COUNT_USED 1
2031 CURRENT_COUNT_USED 1
2032 HIGH_COUNT_USED 16
2033 LOW_NUMBER_OF_BYTES_USED 96
2034 CURRENT_NUMBER_OF_BYTES_USED 96
2035 HIGH_NUMBER_OF_BYTES_USED 35216
2036 execute dump_accounts;
2037 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2038 execute dump_users;
2039 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2040 execute dump_hosts;
2041 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2042 localhost 1 6
2043 truncate performance_schema.memory_summary_by_host_by_event_name;
2044 "================== MEMORY_BY_HOST truncated =================="
2045 "================== Step 17 =================="
2046 call dump_thread();
2047 username user1
2048 status not found
2049 username user2
2050 status not found
2051 username user3
2052 status not found
2053 username user4
2054 status not found
2055 execute dump_memory_account;
2056 execute dump_memory_user;
2057 execute dump_memory_host;
2058 HOST localhost
2059 EVENT_NAME memory/sql/User_level_lock
2060 COUNT_ALLOC 0
2061 COUNT_FREE 0
2062 SUM_NUMBER_OF_BYTES_ALLOC 0
2063 SUM_NUMBER_OF_BYTES_FREE 0
2064 LOW_COUNT_USED 0
2065 CURRENT_COUNT_USED 0
2066 HIGH_COUNT_USED 0
2067 LOW_NUMBER_OF_BYTES_USED 0
2068 CURRENT_NUMBER_OF_BYTES_USED 0
2069 HIGH_NUMBER_OF_BYTES_USED 0
2070 HOST localhost
2071 EVENT_NAME memory/sql/user_var_entry::value
2072 COUNT_ALLOC 1
2073 COUNT_FREE 0
2074 SUM_NUMBER_OF_BYTES_ALLOC 96
2075 SUM_NUMBER_OF_BYTES_FREE 0
2076 LOW_COUNT_USED 1
2077 CURRENT_COUNT_USED 1
2078 HIGH_COUNT_USED 1
2079 LOW_NUMBER_OF_BYTES_USED 96
2080 CURRENT_NUMBER_OF_BYTES_USED 96
2081 HIGH_NUMBER_OF_BYTES_USED 96
2082 execute dump_memory_global;
2083 EVENT_NAME memory/sql/Query_cache
2084 COUNT_ALLOC 8
2085 COUNT_FREE 6
2086 SUM_NUMBER_OF_BYTES_ALLOC 131072
2087 SUM_NUMBER_OF_BYTES_FREE 98304
2088 LOW_COUNT_USED 0
2089 CURRENT_COUNT_USED 2
2090 HIGH_COUNT_USED 2
2091 LOW_NUMBER_OF_BYTES_USED 0
2092 CURRENT_NUMBER_OF_BYTES_USED 32768
2093 HIGH_NUMBER_OF_BYTES_USED 32768
2094 EVENT_NAME memory/sql/User_level_lock
2095 COUNT_ALLOC 10
2096 COUNT_FREE 10
2097 SUM_NUMBER_OF_BYTES_ALLOC 1360
2098 SUM_NUMBER_OF_BYTES_FREE 1360
2099 LOW_COUNT_USED 0
2100 CURRENT_COUNT_USED 0
2101 HIGH_COUNT_USED 8
2102 LOW_NUMBER_OF_BYTES_USED 0
2103 CURRENT_NUMBER_OF_BYTES_USED 0
2104 HIGH_NUMBER_OF_BYTES_USED 1328
2105 EVENT_NAME memory/sql/user_var_entry::value
2106 COUNT_ALLOC 16
2107 COUNT_FREE 15
2108 SUM_NUMBER_OF_BYTES_ALLOC 35216
2109 SUM_NUMBER_OF_BYTES_FREE 35120
2110 LOW_COUNT_USED 1
2111 CURRENT_COUNT_USED 1
2112 HIGH_COUNT_USED 16
2113 LOW_NUMBER_OF_BYTES_USED 96
2114 CURRENT_NUMBER_OF_BYTES_USED 96
2115 HIGH_NUMBER_OF_BYTES_USED 35216
2116 execute dump_accounts;
2117 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2118 execute dump_users;
2119 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2120 execute dump_hosts;
2121 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2122 localhost 1 6
2123 truncate performance_schema.memory_summary_global_by_event_name;
2124 "================== MEMORY_GLOBAL truncated =================="
2125 "================== Step 18 =================="
2126 call dump_thread();
2127 username user1
2128 status not found
2129 username user2
2130 status not found
2131 username user3
2132 status not found
2133 username user4
2134 status not found
2135 execute dump_memory_account;
2136 execute dump_memory_user;
2137 execute dump_memory_host;
2138 HOST localhost
2139 EVENT_NAME memory/sql/User_level_lock
2140 COUNT_ALLOC 0
2141 COUNT_FREE 0
2142 SUM_NUMBER_OF_BYTES_ALLOC 0
2143 SUM_NUMBER_OF_BYTES_FREE 0
2144 LOW_COUNT_USED 0
2145 CURRENT_COUNT_USED 0
2146 HIGH_COUNT_USED 0
2147 LOW_NUMBER_OF_BYTES_USED 0
2148 CURRENT_NUMBER_OF_BYTES_USED 0
2149 HIGH_NUMBER_OF_BYTES_USED 0
2150 HOST localhost
2151 EVENT_NAME memory/sql/user_var_entry::value
2152 COUNT_ALLOC 1
2153 COUNT_FREE 0
2154 SUM_NUMBER_OF_BYTES_ALLOC 96
2155 SUM_NUMBER_OF_BYTES_FREE 0
2156 LOW_COUNT_USED 1
2157 CURRENT_COUNT_USED 1
2158 HIGH_COUNT_USED 1
2159 LOW_NUMBER_OF_BYTES_USED 96
2160 CURRENT_NUMBER_OF_BYTES_USED 96
2161 HIGH_NUMBER_OF_BYTES_USED 96
2162 execute dump_memory_global;
2163 EVENT_NAME memory/sql/Query_cache
2164 COUNT_ALLOC 2
2165 COUNT_FREE 0
2166 SUM_NUMBER_OF_BYTES_ALLOC 32768
2167 SUM_NUMBER_OF_BYTES_FREE 0
2168 LOW_COUNT_USED 2
2169 CURRENT_COUNT_USED 2
2170 HIGH_COUNT_USED 2
2171 LOW_NUMBER_OF_BYTES_USED 32768
2172 CURRENT_NUMBER_OF_BYTES_USED 32768
2173 HIGH_NUMBER_OF_BYTES_USED 32768
2174 EVENT_NAME memory/sql/User_level_lock
2175 COUNT_ALLOC 0
2176 COUNT_FREE 0
2177 SUM_NUMBER_OF_BYTES_ALLOC 0
2178 SUM_NUMBER_OF_BYTES_FREE 0
2179 LOW_COUNT_USED 0
2180 CURRENT_COUNT_USED 0
2181 HIGH_COUNT_USED 0
2182 LOW_NUMBER_OF_BYTES_USED 0
2183 CURRENT_NUMBER_OF_BYTES_USED 0
2184 HIGH_NUMBER_OF_BYTES_USED 0
2185 EVENT_NAME memory/sql/user_var_entry::value
2186 COUNT_ALLOC 1
2187 COUNT_FREE 0
2188 SUM_NUMBER_OF_BYTES_ALLOC 96
2189 SUM_NUMBER_OF_BYTES_FREE 0
2190 LOW_COUNT_USED 1
2191 CURRENT_COUNT_USED 1
2192 HIGH_COUNT_USED 1
2193 LOW_NUMBER_OF_BYTES_USED 96
2194 CURRENT_NUMBER_OF_BYTES_USED 96
2195 HIGH_NUMBER_OF_BYTES_USED 96
2196 execute dump_accounts;
2197 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2198 execute dump_users;
2199 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2200 execute dump_hosts;
2201 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2202 localhost 1 6
2203 truncate performance_schema.accounts;
2204 "================== ACCOUNTS truncated =================="
2205 "================== Step 19 =================="
2206 call dump_thread();
2207 username user1
2208 status not found
2209 username user2
2210 status not found
2211 username user3
2212 status not found
2213 username user4
2214 status not found
2215 execute dump_memory_account;
2216 execute dump_memory_user;
2217 execute dump_memory_host;
2218 HOST localhost
2219 EVENT_NAME memory/sql/User_level_lock
2220 COUNT_ALLOC 0
2221 COUNT_FREE 0
2222 SUM_NUMBER_OF_BYTES_ALLOC 0
2223 SUM_NUMBER_OF_BYTES_FREE 0
2224 LOW_COUNT_USED 0
2225 CURRENT_COUNT_USED 0
2226 HIGH_COUNT_USED 0
2227 LOW_NUMBER_OF_BYTES_USED 0
2228 CURRENT_NUMBER_OF_BYTES_USED 0
2229 HIGH_NUMBER_OF_BYTES_USED 0
2230 HOST localhost
2231 EVENT_NAME memory/sql/user_var_entry::value
2232 COUNT_ALLOC 1
2233 COUNT_FREE 0
2234 SUM_NUMBER_OF_BYTES_ALLOC 96
2235 SUM_NUMBER_OF_BYTES_FREE 0
2236 LOW_COUNT_USED 1
2237 CURRENT_COUNT_USED 1
2238 HIGH_COUNT_USED 1
2239 LOW_NUMBER_OF_BYTES_USED 96
2240 CURRENT_NUMBER_OF_BYTES_USED 96
2241 HIGH_NUMBER_OF_BYTES_USED 96
2242 execute dump_memory_global;
2243 EVENT_NAME memory/sql/Query_cache
2244 COUNT_ALLOC 2
2245 COUNT_FREE 0
2246 SUM_NUMBER_OF_BYTES_ALLOC 32768
2247 SUM_NUMBER_OF_BYTES_FREE 0
2248 LOW_COUNT_USED 2
2249 CURRENT_COUNT_USED 2
2250 HIGH_COUNT_USED 2
2251 LOW_NUMBER_OF_BYTES_USED 32768
2252 CURRENT_NUMBER_OF_BYTES_USED 32768
2253 HIGH_NUMBER_OF_BYTES_USED 32768
2254 EVENT_NAME memory/sql/User_level_lock
2255 COUNT_ALLOC 0
2256 COUNT_FREE 0
2257 SUM_NUMBER_OF_BYTES_ALLOC 0
2258 SUM_NUMBER_OF_BYTES_FREE 0
2259 LOW_COUNT_USED 0
2260 CURRENT_COUNT_USED 0
2261 HIGH_COUNT_USED 0
2262 LOW_NUMBER_OF_BYTES_USED 0
2263 CURRENT_NUMBER_OF_BYTES_USED 0
2264 HIGH_NUMBER_OF_BYTES_USED 0
2265 EVENT_NAME memory/sql/user_var_entry::value
2266 COUNT_ALLOC 1
2267 COUNT_FREE 0
2268 SUM_NUMBER_OF_BYTES_ALLOC 96
2269 SUM_NUMBER_OF_BYTES_FREE 0
2270 LOW_COUNT_USED 1
2271 CURRENT_COUNT_USED 1
2272 HIGH_COUNT_USED 1
2273 LOW_NUMBER_OF_BYTES_USED 96
2274 CURRENT_NUMBER_OF_BYTES_USED 96
2275 HIGH_NUMBER_OF_BYTES_USED 96
2276 execute dump_accounts;
2277 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2278 execute dump_users;
2279 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2280 execute dump_hosts;
2281 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2282 localhost 1 6
2283 truncate performance_schema.users;
2284 "================== USERS truncated =================="
2285 "================== Step 20 =================="
2286 call dump_thread();
2287 username user1
2288 status not found
2289 username user2
2290 status not found
2291 username user3
2292 status not found
2293 username user4
2294 status not found
2295 execute dump_memory_account;
2296 execute dump_memory_user;
2297 execute dump_memory_host;
2298 HOST localhost
2299 EVENT_NAME memory/sql/User_level_lock
2300 COUNT_ALLOC 0
2301 COUNT_FREE 0
2302 SUM_NUMBER_OF_BYTES_ALLOC 0
2303 SUM_NUMBER_OF_BYTES_FREE 0
2304 LOW_COUNT_USED 0
2305 CURRENT_COUNT_USED 0
2306 HIGH_COUNT_USED 0
2307 LOW_NUMBER_OF_BYTES_USED 0
2308 CURRENT_NUMBER_OF_BYTES_USED 0
2309 HIGH_NUMBER_OF_BYTES_USED 0
2310 HOST localhost
2311 EVENT_NAME memory/sql/user_var_entry::value
2312 COUNT_ALLOC 1
2313 COUNT_FREE 0
2314 SUM_NUMBER_OF_BYTES_ALLOC 96
2315 SUM_NUMBER_OF_BYTES_FREE 0
2316 LOW_COUNT_USED 1
2317 CURRENT_COUNT_USED 1
2318 HIGH_COUNT_USED 1
2319 LOW_NUMBER_OF_BYTES_USED 96
2320 CURRENT_NUMBER_OF_BYTES_USED 96
2321 HIGH_NUMBER_OF_BYTES_USED 96
2322 execute dump_memory_global;
2323 EVENT_NAME memory/sql/Query_cache
2324 COUNT_ALLOC 2
2325 COUNT_FREE 0
2326 SUM_NUMBER_OF_BYTES_ALLOC 32768
2327 SUM_NUMBER_OF_BYTES_FREE 0
2328 LOW_COUNT_USED 2
2329 CURRENT_COUNT_USED 2
2330 HIGH_COUNT_USED 2
2331 LOW_NUMBER_OF_BYTES_USED 32768
2332 CURRENT_NUMBER_OF_BYTES_USED 32768
2333 HIGH_NUMBER_OF_BYTES_USED 32768
2334 EVENT_NAME memory/sql/User_level_lock
2335 COUNT_ALLOC 0
2336 COUNT_FREE 0
2337 SUM_NUMBER_OF_BYTES_ALLOC 0
2338 SUM_NUMBER_OF_BYTES_FREE 0
2339 LOW_COUNT_USED 0
2340 CURRENT_COUNT_USED 0
2341 HIGH_COUNT_USED 0
2342 LOW_NUMBER_OF_BYTES_USED 0
2343 CURRENT_NUMBER_OF_BYTES_USED 0
2344 HIGH_NUMBER_OF_BYTES_USED 0
2345 EVENT_NAME memory/sql/user_var_entry::value
2346 COUNT_ALLOC 1
2347 COUNT_FREE 0
2348 SUM_NUMBER_OF_BYTES_ALLOC 96
2349 SUM_NUMBER_OF_BYTES_FREE 0
2350 LOW_COUNT_USED 1
2351 CURRENT_COUNT_USED 1
2352 HIGH_COUNT_USED 1
2353 LOW_NUMBER_OF_BYTES_USED 96
2354 CURRENT_NUMBER_OF_BYTES_USED 96
2355 HIGH_NUMBER_OF_BYTES_USED 96
2356 execute dump_accounts;
2357 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2358 execute dump_users;
2359 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2360 execute dump_hosts;
2361 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2362 localhost 1 6
2363 truncate performance_schema.hosts;
2364 "================== HOSTS truncated =================="
2365 "================== Step 21 =================="
2366 call dump_thread();
2367 username user1
2368 status not found
2369 username user2
2370 status not found
2371 username user3
2372 status not found
2373 username user4
2374 status not found
2375 execute dump_memory_account;
2376 execute dump_memory_user;
2377 execute dump_memory_host;
2378 HOST localhost
2379 EVENT_NAME memory/sql/User_level_lock
2380 COUNT_ALLOC 0
2381 COUNT_FREE 0
2382 SUM_NUMBER_OF_BYTES_ALLOC 0
2383 SUM_NUMBER_OF_BYTES_FREE 0
2384 LOW_COUNT_USED 0
2385 CURRENT_COUNT_USED 0
2386 HIGH_COUNT_USED 0
2387 LOW_NUMBER_OF_BYTES_USED 0
2388 CURRENT_NUMBER_OF_BYTES_USED 0
2389 HIGH_NUMBER_OF_BYTES_USED 0
2390 HOST localhost
2391 EVENT_NAME memory/sql/user_var_entry::value
2392 COUNT_ALLOC 1
2393 COUNT_FREE 0
2394 SUM_NUMBER_OF_BYTES_ALLOC 96
2395 SUM_NUMBER_OF_BYTES_FREE 0
2396 LOW_COUNT_USED 1
2397 CURRENT_COUNT_USED 1
2398 HIGH_COUNT_USED 1
2399 LOW_NUMBER_OF_BYTES_USED 96
2400 CURRENT_NUMBER_OF_BYTES_USED 96
2401 HIGH_NUMBER_OF_BYTES_USED 96
2402 execute dump_memory_global;
2403 EVENT_NAME memory/sql/Query_cache
2404 COUNT_ALLOC 2
2405 COUNT_FREE 0
2406 SUM_NUMBER_OF_BYTES_ALLOC 32768
2407 SUM_NUMBER_OF_BYTES_FREE 0
2408 LOW_COUNT_USED 2
2409 CURRENT_COUNT_USED 2
2410 HIGH_COUNT_USED 2
2411 LOW_NUMBER_OF_BYTES_USED 32768
2412 CURRENT_NUMBER_OF_BYTES_USED 32768
2413 HIGH_NUMBER_OF_BYTES_USED 32768
2414 EVENT_NAME memory/sql/User_level_lock
2415 COUNT_ALLOC 0
2416 COUNT_FREE 0
2417 SUM_NUMBER_OF_BYTES_ALLOC 0
2418 SUM_NUMBER_OF_BYTES_FREE 0
2419 LOW_COUNT_USED 0
2420 CURRENT_COUNT_USED 0
2421 HIGH_COUNT_USED 0
2422 LOW_NUMBER_OF_BYTES_USED 0
2423 CURRENT_NUMBER_OF_BYTES_USED 0
2424 HIGH_NUMBER_OF_BYTES_USED 0
2425 EVENT_NAME memory/sql/user_var_entry::value
2426 COUNT_ALLOC 1
2427 COUNT_FREE 0
2428 SUM_NUMBER_OF_BYTES_ALLOC 96
2429 SUM_NUMBER_OF_BYTES_FREE 0
2430 LOW_COUNT_USED 1
2431 CURRENT_COUNT_USED 1
2432 HIGH_COUNT_USED 1
2433 LOW_NUMBER_OF_BYTES_USED 96
2434 CURRENT_NUMBER_OF_BYTES_USED 96
2435 HIGH_NUMBER_OF_BYTES_USED 96
2436 execute dump_accounts;
2437 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2438 execute dump_users;
2439 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2440 execute dump_hosts;
2441 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2442 localhost 1 1