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