Debian Codegraph @

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

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