Debian Codegraph @

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