Debian Codegraph @

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

raw
1 "================== Step 1 =================="
2 call dump_thread();
3 username status
4 user1 not found
5 username status
6 user2 not found
7 username status
8 user3 not found
9 username status
10 user4 not found
11 execute dump_waits_account;
12 user host event_name count_star
13 execute dump_waits_user;
14 user event_name count_star
15 execute dump_waits_host;
16 host event_name count_star
17 localhost wait/io/file/sql/query_log 0
18 localhost wait/synch/rwlock/sql/LOCK_grant 0
19 execute dump_waits_global;
20 event_name count_star
21 wait/io/file/sql/query_log 0
22 wait/synch/rwlock/sql/LOCK_grant 0
23 execute dump_waits_history;
24 event_name count(event_name)
25 execute dump_stages_account;
26 user host event_name count_star
27 execute dump_stages_user;
28 user event_name count_star
29 execute dump_stages_host;
30 host event_name count_star
31 localhost stage/sql/checking permissions 0
32 localhost stage/sql/closing tables 0
33 localhost stage/sql/init 0
34 localhost stage/sql/Opening tables 0
35 localhost stage/sql/starting 0
36 execute dump_stages_global;
37 event_name count_star
38 stage/sql/checking permissions 0
39 stage/sql/closing tables 0
40 stage/sql/init 0
41 stage/sql/Opening tables 0
42 stage/sql/starting 0
43 execute dump_stages_history;
44 event_name count(event_name)
45 execute dump_statements_account;
46 user host event_name count_star
47 execute dump_statements_user;
48 user event_name count_star
49 execute dump_statements_host;
50 host event_name count_star
51 localhost statement/com/Error 0
52 localhost statement/com/Quit 0
53 localhost statement/sp/freturn 0
54 localhost statement/sql/insert 0
55 localhost statement/sql/select 0
56 execute dump_statements_global;
57 event_name count_star
58 statement/com/Error 0
59 statement/com/Quit 0
60 statement/sp/freturn 0
61 statement/sql/insert 0
62 statement/sql/select 0
63 execute dump_statements_history;
64 event_name count(event_name)
65 execute dump_transactions_account;
66 user host event_name count_star
67 execute dump_transactions_user;
68 user event_name count_star
69 execute dump_transactions_host;
70 host event_name count_star
71 localhost transaction 0
72 execute dump_transactions_global;
73 event_name count_star
74 transaction 0
75 execute dump_transactions_history;
76 event_name count(event_name)
77 execute dump_accounts;
78 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
79 root localhost 1 1
80 execute dump_users;
81 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
82 root 1 1
83 execute dump_hosts;
84 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
85 localhost 1 1
86 connect con1, localhost, user1, ,test;
87 connection default;
88 "================== Step 2 =================="
89 call dump_thread();
90 username event_name count_star
91 user1 wait/io/file/sql/query_log 1
92 user1 wait/synch/rwlock/sql/LOCK_grant 0
93 username status
94 user2 not found
95 username status
96 user3 not found
97 username status
98 user4 not found
99 execute dump_waits_account;
100 user host event_name count_star
101 user1 localhost wait/io/file/sql/query_log 1
102 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
103 execute dump_waits_user;
104 user event_name count_star
105 user1 wait/io/file/sql/query_log 1
106 user1 wait/synch/rwlock/sql/LOCK_grant 0
107 execute dump_waits_host;
108 host event_name count_star
109 localhost wait/io/file/sql/query_log 1
110 localhost wait/synch/rwlock/sql/LOCK_grant 0
111 execute dump_waits_global;
112 event_name count_star
113 wait/io/file/sql/query_log 1
114 wait/synch/rwlock/sql/LOCK_grant 0
115 execute dump_waits_history;
116 event_name count(event_name)
117 wait/io/file/sql/query_log 1
118 execute dump_stages_account;
119 user host event_name count_star
120 user1 localhost stage/sql/checking permissions 0
121 user1 localhost stage/sql/closing tables 0
122 user1 localhost stage/sql/init 0
123 user1 localhost stage/sql/Opening tables 0
124 user1 localhost stage/sql/starting 0
125 execute dump_stages_user;
126 user event_name count_star
127 user1 stage/sql/checking permissions 0
128 user1 stage/sql/closing tables 0
129 user1 stage/sql/init 0
130 user1 stage/sql/Opening tables 0
131 user1 stage/sql/starting 0
132 execute dump_stages_host;
133 host event_name count_star
134 localhost stage/sql/checking permissions 0
135 localhost stage/sql/closing tables 0
136 localhost stage/sql/init 0
137 localhost stage/sql/Opening tables 0
138 localhost stage/sql/starting 0
139 execute dump_stages_global;
140 event_name count_star
141 stage/sql/checking permissions 0
142 stage/sql/closing tables 0
143 stage/sql/init 0
144 stage/sql/Opening tables 0
145 stage/sql/starting 0
146 execute dump_stages_history;
147 event_name count(event_name)
148 execute dump_statements_account;
149 user host event_name count_star
150 user1 localhost statement/com/Error 0
151 user1 localhost statement/com/Quit 0
152 user1 localhost statement/sp/freturn 0
153 user1 localhost statement/sql/insert 0
154 user1 localhost statement/sql/select 0
155 execute dump_statements_user;
156 user event_name count_star
157 user1 statement/com/Error 0
158 user1 statement/com/Quit 0
159 user1 statement/sp/freturn 0
160 user1 statement/sql/insert 0
161 user1 statement/sql/select 0
162 execute dump_statements_host;
163 host event_name count_star
164 localhost statement/com/Error 0
165 localhost statement/com/Quit 0
166 localhost statement/sp/freturn 0
167 localhost statement/sql/insert 0
168 localhost statement/sql/select 0
169 execute dump_statements_global;
170 event_name count_star
171 statement/com/Error 0
172 statement/com/Quit 0
173 statement/sp/freturn 0
174 statement/sql/insert 0
175 statement/sql/select 0
176 execute dump_statements_history;
177 event_name count(event_name)
178 execute dump_transactions_account;
179 user host event_name count_star
180 user1 localhost transaction 0
181 execute dump_transactions_user;
182 user event_name count_star
183 user1 transaction 0
184 execute dump_transactions_host;
185 host event_name count_star
186 localhost transaction 0
187 execute dump_transactions_global;
188 event_name count_star
189 transaction 0
190 execute dump_transactions_history;
191 event_name count(event_name)
192 execute dump_accounts;
193 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
194 root localhost 1 1
195 user1 localhost 1 1
196 execute dump_users;
197 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
198 root 1 1
199 user1 1 1
200 execute dump_hosts;
201 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
202 localhost 2 2
203 connection con1;
204 select uuid_short() <> 1;
205 uuid_short() <> 1
206 1
207 select uuid_short() <> 1;
208 uuid_short() <> 1
209 1
210 start transaction;
211 insert into test.t1 values ("marker");
212 commit;
213 select test.f(10,20);
214 test.f(10,20)
215 30
216 connection default;
217 "================== Step 3 =================="
218 call dump_thread();
219 username event_name count_star
220 user1 wait/io/file/sql/query_log 7
221 user1 wait/synch/rwlock/sql/LOCK_grant 1
222 username status
223 user2 not found
224 username status
225 user3 not found
226 username status
227 user4 not found
228 execute dump_waits_account;
229 user host event_name count_star
230 user1 localhost wait/io/file/sql/query_log 7
231 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
232 execute dump_waits_user;
233 user event_name count_star
234 user1 wait/io/file/sql/query_log 7
235 user1 wait/synch/rwlock/sql/LOCK_grant 1
236 execute dump_waits_host;
237 host event_name count_star
238 localhost wait/io/file/sql/query_log 7
239 localhost wait/synch/rwlock/sql/LOCK_grant 1
240 execute dump_waits_global;
241 event_name count_star
242 wait/io/file/sql/query_log 7
243 wait/synch/rwlock/sql/LOCK_grant 1
244 execute dump_waits_history;
245 event_name count(event_name)
246 wait/io/file/sql/query_log 7
247 wait/synch/rwlock/sql/LOCK_grant 1
248 execute dump_stages_account;
249 user host event_name count_star
250 user1 localhost stage/sql/checking permissions 4
251 user1 localhost stage/sql/closing tables 12
252 user1 localhost stage/sql/init 3
253 user1 localhost stage/sql/Opening tables 8
254 user1 localhost stage/sql/starting 7
255 execute dump_stages_user;
256 user event_name count_star
257 user1 stage/sql/checking permissions 4
258 user1 stage/sql/closing tables 12
259 user1 stage/sql/init 3
260 user1 stage/sql/Opening tables 8
261 user1 stage/sql/starting 7
262 execute dump_stages_host;
263 host event_name count_star
264 localhost stage/sql/checking permissions 4
265 localhost stage/sql/closing tables 12
266 localhost stage/sql/init 3
267 localhost stage/sql/Opening tables 8
268 localhost stage/sql/starting 7
269 execute dump_stages_global;
270 event_name count_star
271 stage/sql/checking permissions 4
272 stage/sql/closing tables 12
273 stage/sql/init 3
274 stage/sql/Opening tables 8
275 stage/sql/starting 7
276 execute dump_stages_history;
277 event_name count(event_name)
278 stage/sql/checking permissions 4
279 stage/sql/closing tables 12
280 stage/sql/init 3
281 stage/sql/Opening tables 8
282 stage/sql/starting 7
283 execute dump_statements_account;
284 user host event_name count_star
285 user1 localhost statement/com/Error 0
286 user1 localhost statement/com/Quit 0
287 user1 localhost statement/sp/freturn 1
288 user1 localhost statement/sql/insert 1
289 user1 localhost statement/sql/select 3
290 execute dump_statements_user;
291 user event_name count_star
292 user1 statement/com/Error 0
293 user1 statement/com/Quit 0
294 user1 statement/sp/freturn 1
295 user1 statement/sql/insert 1
296 user1 statement/sql/select 3
297 execute dump_statements_host;
298 host event_name count_star
299 localhost statement/com/Error 0
300 localhost statement/com/Quit 0
301 localhost statement/sp/freturn 1
302 localhost statement/sql/insert 1
303 localhost statement/sql/select 3
304 execute dump_statements_global;
305 event_name count_star
306 statement/com/Error 0
307 statement/com/Quit 0
308 statement/sp/freturn 1
309 statement/sql/insert 1
310 statement/sql/select 3
311 execute dump_statements_history;
312 event_name count(event_name)
313 statement/sp/freturn 1
314 statement/sql/insert 1
315 statement/sql/select 3
316 execute dump_transactions_account;
317 user host event_name count_star
318 user1 localhost transaction 3
319 execute dump_transactions_user;
320 user event_name count_star
321 user1 transaction 3
322 execute dump_transactions_host;
323 host event_name count_star
324 localhost transaction 3
325 execute dump_transactions_global;
326 event_name count_star
327 transaction 3
328 execute dump_transactions_history;
329 event_name count(event_name)
330 transaction 3
331 execute dump_accounts;
332 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
333 root localhost 1 1
334 user1 localhost 1 1
335 execute dump_users;
336 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
337 root 1 1
338 user1 1 1
339 execute dump_hosts;
340 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
341 localhost 2 2
342 connect con2, localhost, user2, ,test;
343 connection default;
344 "================== Step 4 =================="
345 call dump_thread();
346 username event_name count_star
347 user1 wait/io/file/sql/query_log 7
348 user1 wait/synch/rwlock/sql/LOCK_grant 1
349 username event_name count_star
350 user2 wait/io/file/sql/query_log 1
351 user2 wait/synch/rwlock/sql/LOCK_grant 0
352 username status
353 user3 not found
354 username status
355 user4 not found
356 execute dump_waits_account;
357 user host event_name count_star
358 user1 localhost wait/io/file/sql/query_log 7
359 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
360 user2 localhost wait/io/file/sql/query_log 1
361 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
362 execute dump_waits_user;
363 user event_name count_star
364 user1 wait/io/file/sql/query_log 7
365 user1 wait/synch/rwlock/sql/LOCK_grant 1
366 user2 wait/io/file/sql/query_log 1
367 user2 wait/synch/rwlock/sql/LOCK_grant 0
368 execute dump_waits_host;
369 host event_name count_star
370 localhost wait/io/file/sql/query_log 8
371 localhost wait/synch/rwlock/sql/LOCK_grant 1
372 execute dump_waits_global;
373 event_name count_star
374 wait/io/file/sql/query_log 8
375 wait/synch/rwlock/sql/LOCK_grant 1
376 execute dump_waits_history;
377 event_name count(event_name)
378 wait/io/file/sql/query_log 8
379 wait/synch/rwlock/sql/LOCK_grant 1
380 execute dump_stages_account;
381 user host event_name count_star
382 user1 localhost stage/sql/checking permissions 4
383 user1 localhost stage/sql/closing tables 12
384 user1 localhost stage/sql/init 3
385 user1 localhost stage/sql/Opening tables 8
386 user1 localhost stage/sql/starting 7
387 user2 localhost stage/sql/checking permissions 0
388 user2 localhost stage/sql/closing tables 0
389 user2 localhost stage/sql/init 0
390 user2 localhost stage/sql/Opening tables 0
391 user2 localhost stage/sql/starting 0
392 execute dump_stages_user;
393 user event_name count_star
394 user1 stage/sql/checking permissions 4
395 user1 stage/sql/closing tables 12
396 user1 stage/sql/init 3
397 user1 stage/sql/Opening tables 8
398 user1 stage/sql/starting 7
399 user2 stage/sql/checking permissions 0
400 user2 stage/sql/closing tables 0
401 user2 stage/sql/init 0
402 user2 stage/sql/Opening tables 0
403 user2 stage/sql/starting 0
404 execute dump_stages_host;
405 host event_name count_star
406 localhost stage/sql/checking permissions 4
407 localhost stage/sql/closing tables 12
408 localhost stage/sql/init 3
409 localhost stage/sql/Opening tables 8
410 localhost stage/sql/starting 7
411 execute dump_stages_global;
412 event_name count_star
413 stage/sql/checking permissions 4
414 stage/sql/closing tables 12
415 stage/sql/init 3
416 stage/sql/Opening tables 8
417 stage/sql/starting 7
418 execute dump_stages_history;
419 event_name count(event_name)
420 stage/sql/checking permissions 4
421 stage/sql/closing tables 12
422 stage/sql/init 3
423 stage/sql/Opening tables 8
424 stage/sql/starting 7
425 execute dump_statements_account;
426 user host event_name count_star
427 user1 localhost statement/com/Error 0
428 user1 localhost statement/com/Quit 0
429 user1 localhost statement/sp/freturn 1
430 user1 localhost statement/sql/insert 1
431 user1 localhost statement/sql/select 3
432 user2 localhost statement/com/Error 0
433 user2 localhost statement/com/Quit 0
434 user2 localhost statement/sp/freturn 0
435 user2 localhost statement/sql/insert 0
436 user2 localhost statement/sql/select 0
437 execute dump_statements_user;
438 user event_name count_star
439 user1 statement/com/Error 0
440 user1 statement/com/Quit 0
441 user1 statement/sp/freturn 1
442 user1 statement/sql/insert 1
443 user1 statement/sql/select 3
444 user2 statement/com/Error 0
445 user2 statement/com/Quit 0
446 user2 statement/sp/freturn 0
447 user2 statement/sql/insert 0
448 user2 statement/sql/select 0
449 execute dump_statements_host;
450 host event_name count_star
451 localhost statement/com/Error 0
452 localhost statement/com/Quit 0
453 localhost statement/sp/freturn 1
454 localhost statement/sql/insert 1
455 localhost statement/sql/select 3
456 execute dump_statements_global;
457 event_name count_star
458 statement/com/Error 0
459 statement/com/Quit 0
460 statement/sp/freturn 1
461 statement/sql/insert 1
462 statement/sql/select 3
463 execute dump_statements_history;
464 event_name count(event_name)
465 statement/sp/freturn 1
466 statement/sql/insert 1
467 statement/sql/select 3
468 execute dump_transactions_account;
469 user host event_name count_star
470 user1 localhost transaction 3
471 user2 localhost transaction 0
472 execute dump_transactions_user;
473 user event_name count_star
474 user1 transaction 3
475 user2 transaction 0
476 execute dump_transactions_host;
477 host event_name count_star
478 localhost transaction 3
479 execute dump_transactions_global;
480 event_name count_star
481 transaction 3
482 execute dump_transactions_history;
483 event_name count(event_name)
484 transaction 3
485 execute dump_accounts;
486 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
487 root localhost 1 1
488 user1 localhost 1 1
489 user2 localhost 1 1
490 execute dump_users;
491 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
492 root 1 1
493 user1 1 1
494 user2 1 1
495 execute dump_hosts;
496 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
497 localhost 3 3
498 connection con2;
499 select uuid_short() <> 1;
500 uuid_short() <> 1
501 1
502 select uuid_short() <> 1;
503 uuid_short() <> 1
504 1
505 start transaction;
506 insert into test.t1 values ("marker");
507 commit;
508 select test.f(10,20);
509 test.f(10,20)
510 30
511 connection default;
512 "================== Step 5 =================="
513 call dump_thread();
514 username event_name count_star
515 user1 wait/io/file/sql/query_log 7
516 user1 wait/synch/rwlock/sql/LOCK_grant 1
517 username event_name count_star
518 user2 wait/io/file/sql/query_log 7
519 user2 wait/synch/rwlock/sql/LOCK_grant 1
520 username status
521 user3 not found
522 username status
523 user4 not found
524 execute dump_waits_account;
525 user host event_name count_star
526 user1 localhost wait/io/file/sql/query_log 7
527 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
528 user2 localhost wait/io/file/sql/query_log 7
529 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
530 execute dump_waits_user;
531 user event_name count_star
532 user1 wait/io/file/sql/query_log 7
533 user1 wait/synch/rwlock/sql/LOCK_grant 1
534 user2 wait/io/file/sql/query_log 7
535 user2 wait/synch/rwlock/sql/LOCK_grant 1
536 execute dump_waits_host;
537 host event_name count_star
538 localhost wait/io/file/sql/query_log 14
539 localhost wait/synch/rwlock/sql/LOCK_grant 2
540 execute dump_waits_global;
541 event_name count_star
542 wait/io/file/sql/query_log 14
543 wait/synch/rwlock/sql/LOCK_grant 2
544 execute dump_waits_history;
545 event_name count(event_name)
546 wait/io/file/sql/query_log 14
547 wait/synch/rwlock/sql/LOCK_grant 2
548 execute dump_stages_account;
549 user host event_name count_star
550 user1 localhost stage/sql/checking permissions 4
551 user1 localhost stage/sql/closing tables 12
552 user1 localhost stage/sql/init 3
553 user1 localhost stage/sql/Opening tables 8
554 user1 localhost stage/sql/starting 7
555 user2 localhost stage/sql/checking permissions 4
556 user2 localhost stage/sql/closing tables 11
557 user2 localhost stage/sql/init 3
558 user2 localhost stage/sql/Opening tables 7
559 user2 localhost stage/sql/starting 7
560 execute dump_stages_user;
561 user event_name count_star
562 user1 stage/sql/checking permissions 4
563 user1 stage/sql/closing tables 12
564 user1 stage/sql/init 3
565 user1 stage/sql/Opening tables 8
566 user1 stage/sql/starting 7
567 user2 stage/sql/checking permissions 4
568 user2 stage/sql/closing tables 11
569 user2 stage/sql/init 3
570 user2 stage/sql/Opening tables 7
571 user2 stage/sql/starting 7
572 execute dump_stages_host;
573 host event_name count_star
574 localhost stage/sql/checking permissions 8
575 localhost stage/sql/closing tables 23
576 localhost stage/sql/init 6
577 localhost stage/sql/Opening tables 15
578 localhost stage/sql/starting 14
579 execute dump_stages_global;
580 event_name count_star
581 stage/sql/checking permissions 8
582 stage/sql/closing tables 23
583 stage/sql/init 6
584 stage/sql/Opening tables 15
585 stage/sql/starting 14
586 execute dump_stages_history;
587 event_name count(event_name)
588 stage/sql/checking permissions 8
589 stage/sql/closing tables 23
590 stage/sql/init 6
591 stage/sql/Opening tables 15
592 stage/sql/starting 14
593 execute dump_statements_account;
594 user host event_name count_star
595 user1 localhost statement/com/Error 0
596 user1 localhost statement/com/Quit 0
597 user1 localhost statement/sp/freturn 1
598 user1 localhost statement/sql/insert 1
599 user1 localhost statement/sql/select 3
600 user2 localhost statement/com/Error 0
601 user2 localhost statement/com/Quit 0
602 user2 localhost statement/sp/freturn 1
603 user2 localhost statement/sql/insert 1
604 user2 localhost statement/sql/select 3
605 execute dump_statements_user;
606 user event_name count_star
607 user1 statement/com/Error 0
608 user1 statement/com/Quit 0
609 user1 statement/sp/freturn 1
610 user1 statement/sql/insert 1
611 user1 statement/sql/select 3
612 user2 statement/com/Error 0
613 user2 statement/com/Quit 0
614 user2 statement/sp/freturn 1
615 user2 statement/sql/insert 1
616 user2 statement/sql/select 3
617 execute dump_statements_host;
618 host event_name count_star
619 localhost statement/com/Error 0
620 localhost statement/com/Quit 0
621 localhost statement/sp/freturn 2
622 localhost statement/sql/insert 2
623 localhost statement/sql/select 6
624 execute dump_statements_global;
625 event_name count_star
626 statement/com/Error 0
627 statement/com/Quit 0
628 statement/sp/freturn 2
629 statement/sql/insert 2
630 statement/sql/select 6
631 execute dump_statements_history;
632 event_name count(event_name)
633 statement/sp/freturn 2
634 statement/sql/insert 2
635 statement/sql/select 6
636 execute dump_transactions_account;
637 user host event_name count_star
638 user1 localhost transaction 3
639 user2 localhost transaction 3
640 execute dump_transactions_user;
641 user event_name count_star
642 user1 transaction 3
643 user2 transaction 3
644 execute dump_transactions_host;
645 host event_name count_star
646 localhost transaction 6
647 execute dump_transactions_global;
648 event_name count_star
649 transaction 6
650 execute dump_transactions_history;
651 event_name count(event_name)
652 transaction 6
653 execute dump_accounts;
654 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
655 root localhost 1 1
656 user1 localhost 1 1
657 user2 localhost 1 1
658 execute dump_users;
659 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
660 root 1 1
661 user1 1 1
662 user2 1 1
663 execute dump_hosts;
664 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
665 localhost 3 3
666 connect con3, localhost, user3, ,test;
667 connection default;
668 "================== Step 6 =================="
669 call dump_thread();
670 username event_name count_star
671 user1 wait/io/file/sql/query_log 7
672 user1 wait/synch/rwlock/sql/LOCK_grant 1
673 username event_name count_star
674 user2 wait/io/file/sql/query_log 7
675 user2 wait/synch/rwlock/sql/LOCK_grant 1
676 username event_name count_star
677 user3 wait/io/file/sql/query_log 1
678 user3 wait/synch/rwlock/sql/LOCK_grant 0
679 username status
680 user4 not found
681 execute dump_waits_account;
682 user host event_name count_star
683 user1 localhost wait/io/file/sql/query_log 7
684 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
685 user2 localhost wait/io/file/sql/query_log 7
686 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
687 user3 localhost wait/io/file/sql/query_log 1
688 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
689 execute dump_waits_user;
690 user event_name count_star
691 user1 wait/io/file/sql/query_log 7
692 user1 wait/synch/rwlock/sql/LOCK_grant 1
693 user2 wait/io/file/sql/query_log 7
694 user2 wait/synch/rwlock/sql/LOCK_grant 1
695 user3 wait/io/file/sql/query_log 1
696 user3 wait/synch/rwlock/sql/LOCK_grant 0
697 execute dump_waits_host;
698 host event_name count_star
699 localhost wait/io/file/sql/query_log 15
700 localhost wait/synch/rwlock/sql/LOCK_grant 2
701 execute dump_waits_global;
702 event_name count_star
703 wait/io/file/sql/query_log 15
704 wait/synch/rwlock/sql/LOCK_grant 2
705 execute dump_waits_history;
706 event_name count(event_name)
707 wait/io/file/sql/query_log 15
708 wait/synch/rwlock/sql/LOCK_grant 2
709 execute dump_stages_account;
710 user host event_name count_star
711 user1 localhost stage/sql/checking permissions 4
712 user1 localhost stage/sql/closing tables 12
713 user1 localhost stage/sql/init 3
714 user1 localhost stage/sql/Opening tables 8
715 user1 localhost stage/sql/starting 7
716 user2 localhost stage/sql/checking permissions 4
717 user2 localhost stage/sql/closing tables 11
718 user2 localhost stage/sql/init 3
719 user2 localhost stage/sql/Opening tables 7
720 user2 localhost stage/sql/starting 7
721 user3 localhost stage/sql/checking permissions 0
722 user3 localhost stage/sql/closing tables 0
723 user3 localhost stage/sql/init 0
724 user3 localhost stage/sql/Opening tables 0
725 user3 localhost stage/sql/starting 0
726 execute dump_stages_user;
727 user event_name count_star
728 user1 stage/sql/checking permissions 4
729 user1 stage/sql/closing tables 12
730 user1 stage/sql/init 3
731 user1 stage/sql/Opening tables 8
732 user1 stage/sql/starting 7
733 user2 stage/sql/checking permissions 4
734 user2 stage/sql/closing tables 11
735 user2 stage/sql/init 3
736 user2 stage/sql/Opening tables 7
737 user2 stage/sql/starting 7
738 user3 stage/sql/checking permissions 0
739 user3 stage/sql/closing tables 0
740 user3 stage/sql/init 0
741 user3 stage/sql/Opening tables 0
742 user3 stage/sql/starting 0
743 execute dump_stages_host;
744 host event_name count_star
745 localhost stage/sql/checking permissions 8
746 localhost stage/sql/closing tables 23
747 localhost stage/sql/init 6
748 localhost stage/sql/Opening tables 15
749 localhost stage/sql/starting 14
750 execute dump_stages_global;
751 event_name count_star
752 stage/sql/checking permissions 8
753 stage/sql/closing tables 23
754 stage/sql/init 6
755 stage/sql/Opening tables 15
756 stage/sql/starting 14
757 execute dump_stages_history;
758 event_name count(event_name)
759 stage/sql/checking permissions 8
760 stage/sql/closing tables 23
761 stage/sql/init 6
762 stage/sql/Opening tables 15
763 stage/sql/starting 14
764 execute dump_statements_account;
765 user host event_name count_star
766 user1 localhost statement/com/Error 0
767 user1 localhost statement/com/Quit 0
768 user1 localhost statement/sp/freturn 1
769 user1 localhost statement/sql/insert 1
770 user1 localhost statement/sql/select 3
771 user2 localhost statement/com/Error 0
772 user2 localhost statement/com/Quit 0
773 user2 localhost statement/sp/freturn 1
774 user2 localhost statement/sql/insert 1
775 user2 localhost statement/sql/select 3
776 user3 localhost statement/com/Error 0
777 user3 localhost statement/com/Quit 0
778 user3 localhost statement/sp/freturn 0
779 user3 localhost statement/sql/insert 0
780 user3 localhost statement/sql/select 0
781 execute dump_statements_user;
782 user event_name count_star
783 user1 statement/com/Error 0
784 user1 statement/com/Quit 0
785 user1 statement/sp/freturn 1
786 user1 statement/sql/insert 1
787 user1 statement/sql/select 3
788 user2 statement/com/Error 0
789 user2 statement/com/Quit 0
790 user2 statement/sp/freturn 1
791 user2 statement/sql/insert 1
792 user2 statement/sql/select 3
793 user3 statement/com/Error 0
794 user3 statement/com/Quit 0
795 user3 statement/sp/freturn 0
796 user3 statement/sql/insert 0
797 user3 statement/sql/select 0
798 execute dump_statements_host;
799 host event_name count_star
800 localhost statement/com/Error 0
801 localhost statement/com/Quit 0
802 localhost statement/sp/freturn 2
803 localhost statement/sql/insert 2
804 localhost statement/sql/select 6
805 execute dump_statements_global;
806 event_name count_star
807 statement/com/Error 0
808 statement/com/Quit 0
809 statement/sp/freturn 2
810 statement/sql/insert 2
811 statement/sql/select 6
812 execute dump_statements_history;
813 event_name count(event_name)
814 statement/sp/freturn 2
815 statement/sql/insert 2
816 statement/sql/select 6
817 execute dump_transactions_account;
818 user host event_name count_star
819 user1 localhost transaction 3
820 user2 localhost transaction 3
821 user3 localhost transaction 0
822 execute dump_transactions_user;
823 user event_name count_star
824 user1 transaction 3
825 user2 transaction 3
826 user3 transaction 0
827 execute dump_transactions_host;
828 host event_name count_star
829 localhost transaction 6
830 execute dump_transactions_global;
831 event_name count_star
832 transaction 6
833 execute dump_transactions_history;
834 event_name count(event_name)
835 transaction 6
836 execute dump_accounts;
837 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
838 root localhost 1 1
839 user1 localhost 1 1
840 user2 localhost 1 1
841 user3 localhost 1 1
842 execute dump_users;
843 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
844 root 1 1
845 user1 1 1
846 user2 1 1
847 user3 1 1
848 execute dump_hosts;
849 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
850 localhost 4 4
851 connection con3;
852 select uuid_short() <> 1;
853 uuid_short() <> 1
854 1
855 select uuid_short() <> 1;
856 uuid_short() <> 1
857 1
858 start transaction;
859 insert into test.t1 values ("marker");
860 commit;
861 select test.f(10,20);
862 test.f(10,20)
863 30
864 connection default;
865 "================== Step 7 =================="
866 call dump_thread();
867 username event_name count_star
868 user1 wait/io/file/sql/query_log 7
869 user1 wait/synch/rwlock/sql/LOCK_grant 1
870 username event_name count_star
871 user2 wait/io/file/sql/query_log 7
872 user2 wait/synch/rwlock/sql/LOCK_grant 1
873 username event_name count_star
874 user3 wait/io/file/sql/query_log 7
875 user3 wait/synch/rwlock/sql/LOCK_grant 1
876 username status
877 user4 not found
878 execute dump_waits_account;
879 user host event_name count_star
880 user1 localhost wait/io/file/sql/query_log 7
881 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
882 user2 localhost wait/io/file/sql/query_log 7
883 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
884 user3 localhost wait/io/file/sql/query_log 7
885 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
886 execute dump_waits_user;
887 user event_name count_star
888 user1 wait/io/file/sql/query_log 7
889 user1 wait/synch/rwlock/sql/LOCK_grant 1
890 user2 wait/io/file/sql/query_log 7
891 user2 wait/synch/rwlock/sql/LOCK_grant 1
892 user3 wait/io/file/sql/query_log 7
893 user3 wait/synch/rwlock/sql/LOCK_grant 1
894 execute dump_waits_host;
895 host event_name count_star
896 localhost wait/io/file/sql/query_log 21
897 localhost wait/synch/rwlock/sql/LOCK_grant 3
898 execute dump_waits_global;
899 event_name count_star
900 wait/io/file/sql/query_log 21
901 wait/synch/rwlock/sql/LOCK_grant 3
902 execute dump_waits_history;
903 event_name count(event_name)
904 wait/io/file/sql/query_log 21
905 wait/synch/rwlock/sql/LOCK_grant 3
906 execute dump_stages_account;
907 user host event_name count_star
908 user1 localhost stage/sql/checking permissions 4
909 user1 localhost stage/sql/closing tables 12
910 user1 localhost stage/sql/init 3
911 user1 localhost stage/sql/Opening tables 8
912 user1 localhost stage/sql/starting 7
913 user2 localhost stage/sql/checking permissions 4
914 user2 localhost stage/sql/closing tables 11
915 user2 localhost stage/sql/init 3
916 user2 localhost stage/sql/Opening tables 7
917 user2 localhost stage/sql/starting 7
918 user3 localhost stage/sql/checking permissions 4
919 user3 localhost stage/sql/closing tables 11
920 user3 localhost stage/sql/init 3
921 user3 localhost stage/sql/Opening tables 7
922 user3 localhost stage/sql/starting 7
923 execute dump_stages_user;
924 user event_name count_star
925 user1 stage/sql/checking permissions 4
926 user1 stage/sql/closing tables 12
927 user1 stage/sql/init 3
928 user1 stage/sql/Opening tables 8
929 user1 stage/sql/starting 7
930 user2 stage/sql/checking permissions 4
931 user2 stage/sql/closing tables 11
932 user2 stage/sql/init 3
933 user2 stage/sql/Opening tables 7
934 user2 stage/sql/starting 7
935 user3 stage/sql/checking permissions 4
936 user3 stage/sql/closing tables 11
937 user3 stage/sql/init 3
938 user3 stage/sql/Opening tables 7
939 user3 stage/sql/starting 7
940 execute dump_stages_host;
941 host event_name count_star
942 localhost stage/sql/checking permissions 12
943 localhost stage/sql/closing tables 34
944 localhost stage/sql/init 9
945 localhost stage/sql/Opening tables 22
946 localhost stage/sql/starting 21
947 execute dump_stages_global;
948 event_name count_star
949 stage/sql/checking permissions 12
950 stage/sql/closing tables 34
951 stage/sql/init 9
952 stage/sql/Opening tables 22
953 stage/sql/starting 21
954 execute dump_stages_history;
955 event_name count(event_name)
956 stage/sql/checking permissions 12
957 stage/sql/closing tables 34
958 stage/sql/init 9
959 stage/sql/Opening tables 22
960 stage/sql/starting 21
961 execute dump_statements_account;
962 user host event_name count_star
963 user1 localhost statement/com/Error 0
964 user1 localhost statement/com/Quit 0
965 user1 localhost statement/sp/freturn 1
966 user1 localhost statement/sql/insert 1
967 user1 localhost statement/sql/select 3
968 user2 localhost statement/com/Error 0
969 user2 localhost statement/com/Quit 0
970 user2 localhost statement/sp/freturn 1
971 user2 localhost statement/sql/insert 1
972 user2 localhost statement/sql/select 3
973 user3 localhost statement/com/Error 0
974 user3 localhost statement/com/Quit 0
975 user3 localhost statement/sp/freturn 1
976 user3 localhost statement/sql/insert 1
977 user3 localhost statement/sql/select 3
978 execute dump_statements_user;
979 user event_name count_star
980 user1 statement/com/Error 0
981 user1 statement/com/Quit 0
982 user1 statement/sp/freturn 1
983 user1 statement/sql/insert 1
984 user1 statement/sql/select 3
985 user2 statement/com/Error 0
986 user2 statement/com/Quit 0
987 user2 statement/sp/freturn 1
988 user2 statement/sql/insert 1
989 user2 statement/sql/select 3
990 user3 statement/com/Error 0
991 user3 statement/com/Quit 0
992 user3 statement/sp/freturn 1
993 user3 statement/sql/insert 1
994 user3 statement/sql/select 3
995 execute dump_statements_host;
996 host event_name count_star
997 localhost statement/com/Error 0
998 localhost statement/com/Quit 0
999 localhost statement/sp/freturn 3
1000 localhost statement/sql/insert 3
1001 localhost statement/sql/select 9
1002 execute dump_statements_global;
1003 event_name count_star
1004 statement/com/Error 0
1005 statement/com/Quit 0
1006 statement/sp/freturn 3
1007 statement/sql/insert 3
1008 statement/sql/select 9
1009 execute dump_statements_history;
1010 event_name count(event_name)
1011 statement/sp/freturn 3
1012 statement/sql/insert 3
1013 statement/sql/select 9
1014 execute dump_transactions_account;
1015 user host event_name count_star
1016 user1 localhost transaction 3
1017 user2 localhost transaction 3
1018 user3 localhost transaction 3
1019 execute dump_transactions_user;
1020 user event_name count_star
1021 user1 transaction 3
1022 user2 transaction 3
1023 user3 transaction 3
1024 execute dump_transactions_host;
1025 host event_name count_star
1026 localhost transaction 9
1027 execute dump_transactions_global;
1028 event_name count_star
1029 transaction 9
1030 execute dump_transactions_history;
1031 event_name count(event_name)
1032 transaction 9
1033 execute dump_accounts;
1034 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1035 root localhost 1 1
1036 user1 localhost 1 1
1037 user2 localhost 1 1
1038 user3 localhost 1 1
1039 execute dump_users;
1040 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1041 root 1 1
1042 user1 1 1
1043 user2 1 1
1044 user3 1 1
1045 execute dump_hosts;
1046 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1047 localhost 4 4
1048 connect con4, localhost, user4, ,test;
1049 connection default;
1050 "================== Step 8 =================="
1051 call dump_thread();
1052 username event_name count_star
1053 user1 wait/io/file/sql/query_log 7
1054 user1 wait/synch/rwlock/sql/LOCK_grant 1
1055 username event_name count_star
1056 user2 wait/io/file/sql/query_log 7
1057 user2 wait/synch/rwlock/sql/LOCK_grant 1
1058 username event_name count_star
1059 user3 wait/io/file/sql/query_log 7
1060 user3 wait/synch/rwlock/sql/LOCK_grant 1
1061 username event_name count_star
1062 user4 wait/io/file/sql/query_log 1
1063 user4 wait/synch/rwlock/sql/LOCK_grant 0
1064 execute dump_waits_account;
1065 user host event_name count_star
1066 user1 localhost wait/io/file/sql/query_log 7
1067 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
1068 user2 localhost wait/io/file/sql/query_log 7
1069 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
1070 user3 localhost wait/io/file/sql/query_log 7
1071 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
1072 user4 localhost wait/io/file/sql/query_log 1
1073 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
1074 execute dump_waits_user;
1075 user event_name count_star
1076 user1 wait/io/file/sql/query_log 7
1077 user1 wait/synch/rwlock/sql/LOCK_grant 1
1078 user2 wait/io/file/sql/query_log 7
1079 user2 wait/synch/rwlock/sql/LOCK_grant 1
1080 user3 wait/io/file/sql/query_log 7
1081 user3 wait/synch/rwlock/sql/LOCK_grant 1
1082 user4 wait/io/file/sql/query_log 1
1083 user4 wait/synch/rwlock/sql/LOCK_grant 0
1084 execute dump_waits_host;
1085 host event_name count_star
1086 localhost wait/io/file/sql/query_log 22
1087 localhost wait/synch/rwlock/sql/LOCK_grant 3
1088 execute dump_waits_global;
1089 event_name count_star
1090 wait/io/file/sql/query_log 22
1091 wait/synch/rwlock/sql/LOCK_grant 3
1092 execute dump_waits_history;
1093 event_name count(event_name)
1094 wait/io/file/sql/query_log 22
1095 wait/synch/rwlock/sql/LOCK_grant 3
1096 execute dump_stages_account;
1097 user host event_name count_star
1098 user1 localhost stage/sql/checking permissions 4
1099 user1 localhost stage/sql/closing tables 12
1100 user1 localhost stage/sql/init 3
1101 user1 localhost stage/sql/Opening tables 8
1102 user1 localhost stage/sql/starting 7
1103 user2 localhost stage/sql/checking permissions 4
1104 user2 localhost stage/sql/closing tables 11
1105 user2 localhost stage/sql/init 3
1106 user2 localhost stage/sql/Opening tables 7
1107 user2 localhost stage/sql/starting 7
1108 user3 localhost stage/sql/checking permissions 4
1109 user3 localhost stage/sql/closing tables 11
1110 user3 localhost stage/sql/init 3
1111 user3 localhost stage/sql/Opening tables 7
1112 user3 localhost stage/sql/starting 7
1113 user4 localhost stage/sql/checking permissions 0
1114 user4 localhost stage/sql/closing tables 0
1115 user4 localhost stage/sql/init 0
1116 user4 localhost stage/sql/Opening tables 0
1117 user4 localhost stage/sql/starting 0
1118 execute dump_stages_user;
1119 user event_name count_star
1120 user1 stage/sql/checking permissions 4
1121 user1 stage/sql/closing tables 12
1122 user1 stage/sql/init 3
1123 user1 stage/sql/Opening tables 8
1124 user1 stage/sql/starting 7
1125 user2 stage/sql/checking permissions 4
1126 user2 stage/sql/closing tables 11
1127 user2 stage/sql/init 3
1128 user2 stage/sql/Opening tables 7
1129 user2 stage/sql/starting 7
1130 user3 stage/sql/checking permissions 4
1131 user3 stage/sql/closing tables 11
1132 user3 stage/sql/init 3
1133 user3 stage/sql/Opening tables 7
1134 user3 stage/sql/starting 7
1135 user4 stage/sql/checking permissions 0
1136 user4 stage/sql/closing tables 0
1137 user4 stage/sql/init 0
1138 user4 stage/sql/Opening tables 0
1139 user4 stage/sql/starting 0
1140 execute dump_stages_host;
1141 host event_name count_star
1142 localhost stage/sql/checking permissions 12
1143 localhost stage/sql/closing tables 34
1144 localhost stage/sql/init 9
1145 localhost stage/sql/Opening tables 22
1146 localhost stage/sql/starting 21
1147 execute dump_stages_global;
1148 event_name count_star
1149 stage/sql/checking permissions 12
1150 stage/sql/closing tables 34
1151 stage/sql/init 9
1152 stage/sql/Opening tables 22
1153 stage/sql/starting 21
1154 execute dump_stages_history;
1155 event_name count(event_name)
1156 stage/sql/checking permissions 12
1157 stage/sql/closing tables 34
1158 stage/sql/init 9
1159 stage/sql/Opening tables 22
1160 stage/sql/starting 21
1161 execute dump_statements_account;
1162 user host event_name count_star
1163 user1 localhost statement/com/Error 0
1164 user1 localhost statement/com/Quit 0
1165 user1 localhost statement/sp/freturn 1
1166 user1 localhost statement/sql/insert 1
1167 user1 localhost statement/sql/select 3
1168 user2 localhost statement/com/Error 0
1169 user2 localhost statement/com/Quit 0
1170 user2 localhost statement/sp/freturn 1
1171 user2 localhost statement/sql/insert 1
1172 user2 localhost statement/sql/select 3
1173 user3 localhost statement/com/Error 0
1174 user3 localhost statement/com/Quit 0
1175 user3 localhost statement/sp/freturn 1
1176 user3 localhost statement/sql/insert 1
1177 user3 localhost statement/sql/select 3
1178 user4 localhost statement/com/Error 0
1179 user4 localhost statement/com/Quit 0
1180 user4 localhost statement/sp/freturn 0
1181 user4 localhost statement/sql/insert 0
1182 user4 localhost statement/sql/select 0
1183 execute dump_statements_user;
1184 user event_name count_star
1185 user1 statement/com/Error 0
1186 user1 statement/com/Quit 0
1187 user1 statement/sp/freturn 1
1188 user1 statement/sql/insert 1
1189 user1 statement/sql/select 3
1190 user2 statement/com/Error 0
1191 user2 statement/com/Quit 0
1192 user2 statement/sp/freturn 1
1193 user2 statement/sql/insert 1
1194 user2 statement/sql/select 3
1195 user3 statement/com/Error 0
1196 user3 statement/com/Quit 0
1197 user3 statement/sp/freturn 1
1198 user3 statement/sql/insert 1
1199 user3 statement/sql/select 3
1200 user4 statement/com/Error 0
1201 user4 statement/com/Quit 0
1202 user4 statement/sp/freturn 0
1203 user4 statement/sql/insert 0
1204 user4 statement/sql/select 0
1205 execute dump_statements_host;
1206 host event_name count_star
1207 localhost statement/com/Error 0
1208 localhost statement/com/Quit 0
1209 localhost statement/sp/freturn 3
1210 localhost statement/sql/insert 3
1211 localhost statement/sql/select 9
1212 execute dump_statements_global;
1213 event_name count_star
1214 statement/com/Error 0
1215 statement/com/Quit 0
1216 statement/sp/freturn 3
1217 statement/sql/insert 3
1218 statement/sql/select 9
1219 execute dump_statements_history;
1220 event_name count(event_name)
1221 statement/sp/freturn 3
1222 statement/sql/insert 3
1223 statement/sql/select 9
1224 execute dump_transactions_account;
1225 user host event_name count_star
1226 user1 localhost transaction 3
1227 user2 localhost transaction 3
1228 user3 localhost transaction 3
1229 user4 localhost transaction 0
1230 execute dump_transactions_user;
1231 user event_name count_star
1232 user1 transaction 3
1233 user2 transaction 3
1234 user3 transaction 3
1235 user4 transaction 0
1236 execute dump_transactions_host;
1237 host event_name count_star
1238 localhost transaction 9
1239 execute dump_transactions_global;
1240 event_name count_star
1241 transaction 9
1242 execute dump_transactions_history;
1243 event_name count(event_name)
1244 transaction 9
1245 execute dump_accounts;
1246 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1247 root localhost 1 1
1248 user1 localhost 1 1
1249 user2 localhost 1 1
1250 user3 localhost 1 1
1251 user4 localhost 1 1
1252 execute dump_users;
1253 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1254 root 1 1
1255 user1 1 1
1256 user2 1 1
1257 user3 1 1
1258 user4 1 1
1259 execute dump_hosts;
1260 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1261 localhost 5 5
1262 connection con4;
1263 select uuid_short() <> 1;
1264 uuid_short() <> 1
1265 1
1266 select uuid_short() <> 1;
1267 uuid_short() <> 1
1268 1
1269 start transaction;
1270 insert into test.t1 values ("marker");
1271 commit;
1272 select test.f(10,20);
1273 test.f(10,20)
1274 30
1275 connection default;
1276 "================== Step 9 =================="
1277 call dump_thread();
1278 username event_name count_star
1279 user1 wait/io/file/sql/query_log 7
1280 user1 wait/synch/rwlock/sql/LOCK_grant 1
1281 username event_name count_star
1282 user2 wait/io/file/sql/query_log 7
1283 user2 wait/synch/rwlock/sql/LOCK_grant 1
1284 username event_name count_star
1285 user3 wait/io/file/sql/query_log 7
1286 user3 wait/synch/rwlock/sql/LOCK_grant 1
1287 username event_name count_star
1288 user4 wait/io/file/sql/query_log 7
1289 user4 wait/synch/rwlock/sql/LOCK_grant 1
1290 execute dump_waits_account;
1291 user host event_name count_star
1292 user1 localhost wait/io/file/sql/query_log 7
1293 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
1294 user2 localhost wait/io/file/sql/query_log 7
1295 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
1296 user3 localhost wait/io/file/sql/query_log 7
1297 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
1298 user4 localhost wait/io/file/sql/query_log 7
1299 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
1300 execute dump_waits_user;
1301 user event_name count_star
1302 user1 wait/io/file/sql/query_log 7
1303 user1 wait/synch/rwlock/sql/LOCK_grant 1
1304 user2 wait/io/file/sql/query_log 7
1305 user2 wait/synch/rwlock/sql/LOCK_grant 1
1306 user3 wait/io/file/sql/query_log 7
1307 user3 wait/synch/rwlock/sql/LOCK_grant 1
1308 user4 wait/io/file/sql/query_log 7
1309 user4 wait/synch/rwlock/sql/LOCK_grant 1
1310 execute dump_waits_host;
1311 host event_name count_star
1312 localhost wait/io/file/sql/query_log 28
1313 localhost wait/synch/rwlock/sql/LOCK_grant 4
1314 execute dump_waits_global;
1315 event_name count_star
1316 wait/io/file/sql/query_log 28
1317 wait/synch/rwlock/sql/LOCK_grant 4
1318 execute dump_waits_history;
1319 event_name count(event_name)
1320 wait/io/file/sql/query_log 28
1321 wait/synch/rwlock/sql/LOCK_grant 4
1322 execute dump_stages_account;
1323 user host event_name count_star
1324 user1 localhost stage/sql/checking permissions 4
1325 user1 localhost stage/sql/closing tables 12
1326 user1 localhost stage/sql/init 3
1327 user1 localhost stage/sql/Opening tables 8
1328 user1 localhost stage/sql/starting 7
1329 user2 localhost stage/sql/checking permissions 4
1330 user2 localhost stage/sql/closing tables 11
1331 user2 localhost stage/sql/init 3
1332 user2 localhost stage/sql/Opening tables 7
1333 user2 localhost stage/sql/starting 7
1334 user3 localhost stage/sql/checking permissions 4
1335 user3 localhost stage/sql/closing tables 11
1336 user3 localhost stage/sql/init 3
1337 user3 localhost stage/sql/Opening tables 7
1338 user3 localhost stage/sql/starting 7
1339 user4 localhost stage/sql/checking permissions 4
1340 user4 localhost stage/sql/closing tables 11
1341 user4 localhost stage/sql/init 3
1342 user4 localhost stage/sql/Opening tables 7
1343 user4 localhost stage/sql/starting 7
1344 execute dump_stages_user;
1345 user event_name count_star
1346 user1 stage/sql/checking permissions 4
1347 user1 stage/sql/closing tables 12
1348 user1 stage/sql/init 3
1349 user1 stage/sql/Opening tables 8
1350 user1 stage/sql/starting 7
1351 user2 stage/sql/checking permissions 4
1352 user2 stage/sql/closing tables 11
1353 user2 stage/sql/init 3
1354 user2 stage/sql/Opening tables 7
1355 user2 stage/sql/starting 7
1356 user3 stage/sql/checking permissions 4
1357 user3 stage/sql/closing tables 11
1358 user3 stage/sql/init 3
1359 user3 stage/sql/Opening tables 7
1360 user3 stage/sql/starting 7
1361 user4 stage/sql/checking permissions 4
1362 user4 stage/sql/closing tables 11
1363 user4 stage/sql/init 3
1364 user4 stage/sql/Opening tables 7
1365 user4 stage/sql/starting 7
1366 execute dump_stages_host;
1367 host event_name count_star
1368 localhost stage/sql/checking permissions 16
1369 localhost stage/sql/closing tables 45
1370 localhost stage/sql/init 12
1371 localhost stage/sql/Opening tables 29
1372 localhost stage/sql/starting 28
1373 execute dump_stages_global;
1374 event_name count_star
1375 stage/sql/checking permissions 16
1376 stage/sql/closing tables 45
1377 stage/sql/init 12
1378 stage/sql/Opening tables 29
1379 stage/sql/starting 28
1380 execute dump_stages_history;
1381 event_name count(event_name)
1382 stage/sql/checking permissions 16
1383 stage/sql/closing tables 45
1384 stage/sql/init 12
1385 stage/sql/Opening tables 29
1386 stage/sql/starting 28
1387 execute dump_statements_account;
1388 user host event_name count_star
1389 user1 localhost statement/com/Error 0
1390 user1 localhost statement/com/Quit 0
1391 user1 localhost statement/sp/freturn 1
1392 user1 localhost statement/sql/insert 1
1393 user1 localhost statement/sql/select 3
1394 user2 localhost statement/com/Error 0
1395 user2 localhost statement/com/Quit 0
1396 user2 localhost statement/sp/freturn 1
1397 user2 localhost statement/sql/insert 1
1398 user2 localhost statement/sql/select 3
1399 user3 localhost statement/com/Error 0
1400 user3 localhost statement/com/Quit 0
1401 user3 localhost statement/sp/freturn 1
1402 user3 localhost statement/sql/insert 1
1403 user3 localhost statement/sql/select 3
1404 user4 localhost statement/com/Error 0
1405 user4 localhost statement/com/Quit 0
1406 user4 localhost statement/sp/freturn 1
1407 user4 localhost statement/sql/insert 1
1408 user4 localhost statement/sql/select 3
1409 execute dump_statements_user;
1410 user event_name count_star
1411 user1 statement/com/Error 0
1412 user1 statement/com/Quit 0
1413 user1 statement/sp/freturn 1
1414 user1 statement/sql/insert 1
1415 user1 statement/sql/select 3
1416 user2 statement/com/Error 0
1417 user2 statement/com/Quit 0
1418 user2 statement/sp/freturn 1
1419 user2 statement/sql/insert 1
1420 user2 statement/sql/select 3
1421 user3 statement/com/Error 0
1422 user3 statement/com/Quit 0
1423 user3 statement/sp/freturn 1
1424 user3 statement/sql/insert 1
1425 user3 statement/sql/select 3
1426 user4 statement/com/Error 0
1427 user4 statement/com/Quit 0
1428 user4 statement/sp/freturn 1
1429 user4 statement/sql/insert 1
1430 user4 statement/sql/select 3
1431 execute dump_statements_host;
1432 host event_name count_star
1433 localhost statement/com/Error 0
1434 localhost statement/com/Quit 0
1435 localhost statement/sp/freturn 4
1436 localhost statement/sql/insert 4
1437 localhost statement/sql/select 12
1438 execute dump_statements_global;
1439 event_name count_star
1440 statement/com/Error 0
1441 statement/com/Quit 0
1442 statement/sp/freturn 4
1443 statement/sql/insert 4
1444 statement/sql/select 12
1445 execute dump_statements_history;
1446 event_name count(event_name)
1447 statement/sp/freturn 4
1448 statement/sql/insert 4
1449 statement/sql/select 12
1450 execute dump_transactions_account;
1451 user host event_name count_star
1452 user1 localhost transaction 3
1453 user2 localhost transaction 3
1454 user3 localhost transaction 3
1455 user4 localhost transaction 3
1456 execute dump_transactions_user;
1457 user event_name count_star
1458 user1 transaction 3
1459 user2 transaction 3
1460 user3 transaction 3
1461 user4 transaction 3
1462 execute dump_transactions_host;
1463 host event_name count_star
1464 localhost transaction 12
1465 execute dump_transactions_global;
1466 event_name count_star
1467 transaction 12
1468 execute dump_transactions_history;
1469 event_name count(event_name)
1470 transaction 12
1471 execute dump_accounts;
1472 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1473 root localhost 1 1
1474 user1 localhost 1 1
1475 user2 localhost 1 1
1476 user3 localhost 1 1
1477 user4 localhost 1 1
1478 execute dump_users;
1479 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1480 root 1 1
1481 user1 1 1
1482 user2 1 1
1483 user3 1 1
1484 user4 1 1
1485 execute dump_hosts;
1486 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1487 localhost 5 5
1488 disconnect con1;
1489 connection default;
1490 "================== Step 10 =================="
1491 call dump_thread();
1492 username status
1493 user1 not found
1494 username event_name count_star
1495 user2 wait/io/file/sql/query_log 7
1496 user2 wait/synch/rwlock/sql/LOCK_grant 1
1497 username event_name count_star
1498 user3 wait/io/file/sql/query_log 7
1499 user3 wait/synch/rwlock/sql/LOCK_grant 1
1500 username event_name count_star
1501 user4 wait/io/file/sql/query_log 7
1502 user4 wait/synch/rwlock/sql/LOCK_grant 1
1503 execute dump_waits_account;
1504 user host event_name count_star
1505 user1 localhost wait/io/file/sql/query_log 8
1506 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
1507 user2 localhost wait/io/file/sql/query_log 7
1508 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
1509 user3 localhost wait/io/file/sql/query_log 7
1510 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
1511 user4 localhost wait/io/file/sql/query_log 7
1512 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
1513 execute dump_waits_user;
1514 user event_name count_star
1515 user1 wait/io/file/sql/query_log 8
1516 user1 wait/synch/rwlock/sql/LOCK_grant 1
1517 user2 wait/io/file/sql/query_log 7
1518 user2 wait/synch/rwlock/sql/LOCK_grant 1
1519 user3 wait/io/file/sql/query_log 7
1520 user3 wait/synch/rwlock/sql/LOCK_grant 1
1521 user4 wait/io/file/sql/query_log 7
1522 user4 wait/synch/rwlock/sql/LOCK_grant 1
1523 execute dump_waits_host;
1524 host event_name count_star
1525 localhost wait/io/file/sql/query_log 29
1526 localhost wait/synch/rwlock/sql/LOCK_grant 4
1527 execute dump_waits_global;
1528 event_name count_star
1529 wait/io/file/sql/query_log 29
1530 wait/synch/rwlock/sql/LOCK_grant 4
1531 execute dump_waits_history;
1532 event_name count(event_name)
1533 wait/io/file/sql/query_log 29
1534 wait/synch/rwlock/sql/LOCK_grant 4
1535 execute dump_stages_account;
1536 user host event_name count_star
1537 user1 localhost stage/sql/checking permissions 4
1538 user1 localhost stage/sql/closing tables 12
1539 user1 localhost stage/sql/init 3
1540 user1 localhost stage/sql/Opening tables 8
1541 user1 localhost stage/sql/starting 8
1542 user2 localhost stage/sql/checking permissions 4
1543 user2 localhost stage/sql/closing tables 11
1544 user2 localhost stage/sql/init 3
1545 user2 localhost stage/sql/Opening tables 7
1546 user2 localhost stage/sql/starting 7
1547 user3 localhost stage/sql/checking permissions 4
1548 user3 localhost stage/sql/closing tables 11
1549 user3 localhost stage/sql/init 3
1550 user3 localhost stage/sql/Opening tables 7
1551 user3 localhost stage/sql/starting 7
1552 user4 localhost stage/sql/checking permissions 4
1553 user4 localhost stage/sql/closing tables 11
1554 user4 localhost stage/sql/init 3
1555 user4 localhost stage/sql/Opening tables 7
1556 user4 localhost stage/sql/starting 7
1557 execute dump_stages_user;
1558 user event_name count_star
1559 user1 stage/sql/checking permissions 4
1560 user1 stage/sql/closing tables 12
1561 user1 stage/sql/init 3
1562 user1 stage/sql/Opening tables 8
1563 user1 stage/sql/starting 8
1564 user2 stage/sql/checking permissions 4
1565 user2 stage/sql/closing tables 11
1566 user2 stage/sql/init 3
1567 user2 stage/sql/Opening tables 7
1568 user2 stage/sql/starting 7
1569 user3 stage/sql/checking permissions 4
1570 user3 stage/sql/closing tables 11
1571 user3 stage/sql/init 3
1572 user3 stage/sql/Opening tables 7
1573 user3 stage/sql/starting 7
1574 user4 stage/sql/checking permissions 4
1575 user4 stage/sql/closing tables 11
1576 user4 stage/sql/init 3
1577 user4 stage/sql/Opening tables 7
1578 user4 stage/sql/starting 7
1579 execute dump_stages_host;
1580 host event_name count_star
1581 localhost stage/sql/checking permissions 16
1582 localhost stage/sql/closing tables 45
1583 localhost stage/sql/init 12
1584 localhost stage/sql/Opening tables 29
1585 localhost stage/sql/starting 29
1586 execute dump_stages_global;
1587 event_name count_star
1588 stage/sql/checking permissions 16
1589 stage/sql/closing tables 45
1590 stage/sql/init 12
1591 stage/sql/Opening tables 29
1592 stage/sql/starting 29
1593 execute dump_stages_history;
1594 event_name count(event_name)
1595 stage/sql/checking permissions 16
1596 stage/sql/closing tables 45
1597 stage/sql/init 12
1598 stage/sql/Opening tables 29
1599 stage/sql/starting 29
1600 execute dump_statements_account;
1601 user host event_name count_star
1602 user1 localhost statement/com/Error 0
1603 user1 localhost statement/com/Quit 1
1604 user1 localhost statement/sp/freturn 1
1605 user1 localhost statement/sql/insert 1
1606 user1 localhost statement/sql/select 3
1607 user2 localhost statement/com/Error 0
1608 user2 localhost statement/com/Quit 0
1609 user2 localhost statement/sp/freturn 1
1610 user2 localhost statement/sql/insert 1
1611 user2 localhost statement/sql/select 3
1612 user3 localhost statement/com/Error 0
1613 user3 localhost statement/com/Quit 0
1614 user3 localhost statement/sp/freturn 1
1615 user3 localhost statement/sql/insert 1
1616 user3 localhost statement/sql/select 3
1617 user4 localhost statement/com/Error 0
1618 user4 localhost statement/com/Quit 0
1619 user4 localhost statement/sp/freturn 1
1620 user4 localhost statement/sql/insert 1
1621 user4 localhost statement/sql/select 3
1622 execute dump_statements_user;
1623 user event_name count_star
1624 user1 statement/com/Error 0
1625 user1 statement/com/Quit 1
1626 user1 statement/sp/freturn 1
1627 user1 statement/sql/insert 1
1628 user1 statement/sql/select 3
1629 user2 statement/com/Error 0
1630 user2 statement/com/Quit 0
1631 user2 statement/sp/freturn 1
1632 user2 statement/sql/insert 1
1633 user2 statement/sql/select 3
1634 user3 statement/com/Error 0
1635 user3 statement/com/Quit 0
1636 user3 statement/sp/freturn 1
1637 user3 statement/sql/insert 1
1638 user3 statement/sql/select 3
1639 user4 statement/com/Error 0
1640 user4 statement/com/Quit 0
1641 user4 statement/sp/freturn 1
1642 user4 statement/sql/insert 1
1643 user4 statement/sql/select 3
1644 execute dump_statements_host;
1645 host event_name count_star
1646 localhost statement/com/Error 0
1647 localhost statement/com/Quit 1
1648 localhost statement/sp/freturn 4
1649 localhost statement/sql/insert 4
1650 localhost statement/sql/select 12
1651 execute dump_statements_global;
1652 event_name count_star
1653 statement/com/Error 0
1654 statement/com/Quit 1
1655 statement/sp/freturn 4
1656 statement/sql/insert 4
1657 statement/sql/select 12
1658 execute dump_statements_history;
1659 event_name count(event_name)
1660 statement/com/Quit 1
1661 statement/sp/freturn 4
1662 statement/sql/insert 4
1663 statement/sql/select 12
1664 execute dump_transactions_account;
1665 user host event_name count_star
1666 user1 localhost transaction 3
1667 user2 localhost transaction 3
1668 user3 localhost transaction 3
1669 user4 localhost transaction 3
1670 execute dump_transactions_user;
1671 user event_name count_star
1672 user1 transaction 3
1673 user2 transaction 3
1674 user3 transaction 3
1675 user4 transaction 3
1676 execute dump_transactions_host;
1677 host event_name count_star
1678 localhost transaction 12
1679 execute dump_transactions_global;
1680 event_name count_star
1681 transaction 12
1682 execute dump_transactions_history;
1683 event_name count(event_name)
1684 transaction 12
1685 execute dump_accounts;
1686 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1687 root localhost 1 1
1688 user1 localhost 0 1
1689 user2 localhost 1 1
1690 user3 localhost 1 1
1691 user4 localhost 1 1
1692 execute dump_users;
1693 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1694 root 1 1
1695 user1 0 1
1696 user2 1 1
1697 user3 1 1
1698 user4 1 1
1699 execute dump_hosts;
1700 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1701 localhost 4 5
1702 disconnect con2;
1703 connection default;
1704 "================== Step 11 =================="
1705 call dump_thread();
1706 username status
1707 user1 not found
1708 username status
1709 user2 not found
1710 username event_name count_star
1711 user3 wait/io/file/sql/query_log 7
1712 user3 wait/synch/rwlock/sql/LOCK_grant 1
1713 username event_name count_star
1714 user4 wait/io/file/sql/query_log 7
1715 user4 wait/synch/rwlock/sql/LOCK_grant 1
1716 execute dump_waits_account;
1717 user host event_name count_star
1718 user1 localhost wait/io/file/sql/query_log 8
1719 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
1720 user2 localhost wait/io/file/sql/query_log 8
1721 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
1722 user3 localhost wait/io/file/sql/query_log 7
1723 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
1724 user4 localhost wait/io/file/sql/query_log 7
1725 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
1726 execute dump_waits_user;
1727 user event_name count_star
1728 user1 wait/io/file/sql/query_log 8
1729 user1 wait/synch/rwlock/sql/LOCK_grant 1
1730 user2 wait/io/file/sql/query_log 8
1731 user2 wait/synch/rwlock/sql/LOCK_grant 1
1732 user3 wait/io/file/sql/query_log 7
1733 user3 wait/synch/rwlock/sql/LOCK_grant 1
1734 user4 wait/io/file/sql/query_log 7
1735 user4 wait/synch/rwlock/sql/LOCK_grant 1
1736 execute dump_waits_host;
1737 host event_name count_star
1738 localhost wait/io/file/sql/query_log 30
1739 localhost wait/synch/rwlock/sql/LOCK_grant 4
1740 execute dump_waits_global;
1741 event_name count_star
1742 wait/io/file/sql/query_log 30
1743 wait/synch/rwlock/sql/LOCK_grant 4
1744 execute dump_waits_history;
1745 event_name count(event_name)
1746 wait/io/file/sql/query_log 30
1747 wait/synch/rwlock/sql/LOCK_grant 4
1748 execute dump_stages_account;
1749 user host event_name count_star
1750 user1 localhost stage/sql/checking permissions 4
1751 user1 localhost stage/sql/closing tables 12
1752 user1 localhost stage/sql/init 3
1753 user1 localhost stage/sql/Opening tables 8
1754 user1 localhost stage/sql/starting 8
1755 user2 localhost stage/sql/checking permissions 4
1756 user2 localhost stage/sql/closing tables 11
1757 user2 localhost stage/sql/init 3
1758 user2 localhost stage/sql/Opening tables 7
1759 user2 localhost stage/sql/starting 8
1760 user3 localhost stage/sql/checking permissions 4
1761 user3 localhost stage/sql/closing tables 11
1762 user3 localhost stage/sql/init 3
1763 user3 localhost stage/sql/Opening tables 7
1764 user3 localhost stage/sql/starting 7
1765 user4 localhost stage/sql/checking permissions 4
1766 user4 localhost stage/sql/closing tables 11
1767 user4 localhost stage/sql/init 3
1768 user4 localhost stage/sql/Opening tables 7
1769 user4 localhost stage/sql/starting 7
1770 execute dump_stages_user;
1771 user event_name count_star
1772 user1 stage/sql/checking permissions 4
1773 user1 stage/sql/closing tables 12
1774 user1 stage/sql/init 3
1775 user1 stage/sql/Opening tables 8
1776 user1 stage/sql/starting 8
1777 user2 stage/sql/checking permissions 4
1778 user2 stage/sql/closing tables 11
1779 user2 stage/sql/init 3
1780 user2 stage/sql/Opening tables 7
1781 user2 stage/sql/starting 8
1782 user3 stage/sql/checking permissions 4
1783 user3 stage/sql/closing tables 11
1784 user3 stage/sql/init 3
1785 user3 stage/sql/Opening tables 7
1786 user3 stage/sql/starting 7
1787 user4 stage/sql/checking permissions 4
1788 user4 stage/sql/closing tables 11
1789 user4 stage/sql/init 3
1790 user4 stage/sql/Opening tables 7
1791 user4 stage/sql/starting 7
1792 execute dump_stages_host;
1793 host event_name count_star
1794 localhost stage/sql/checking permissions 16
1795 localhost stage/sql/closing tables 45
1796 localhost stage/sql/init 12
1797 localhost stage/sql/Opening tables 29
1798 localhost stage/sql/starting 30
1799 execute dump_stages_global;
1800 event_name count_star
1801 stage/sql/checking permissions 16
1802 stage/sql/closing tables 45
1803 stage/sql/init 12
1804 stage/sql/Opening tables 29
1805 stage/sql/starting 30
1806 execute dump_stages_history;
1807 event_name count(event_name)
1808 stage/sql/checking permissions 16
1809 stage/sql/closing tables 45
1810 stage/sql/init 12
1811 stage/sql/Opening tables 29
1812 stage/sql/starting 30
1813 execute dump_statements_account;
1814 user host event_name count_star
1815 user1 localhost statement/com/Error 0
1816 user1 localhost statement/com/Quit 1
1817 user1 localhost statement/sp/freturn 1
1818 user1 localhost statement/sql/insert 1
1819 user1 localhost statement/sql/select 3
1820 user2 localhost statement/com/Error 0
1821 user2 localhost statement/com/Quit 1
1822 user2 localhost statement/sp/freturn 1
1823 user2 localhost statement/sql/insert 1
1824 user2 localhost statement/sql/select 3
1825 user3 localhost statement/com/Error 0
1826 user3 localhost statement/com/Quit 0
1827 user3 localhost statement/sp/freturn 1
1828 user3 localhost statement/sql/insert 1
1829 user3 localhost statement/sql/select 3
1830 user4 localhost statement/com/Error 0
1831 user4 localhost statement/com/Quit 0
1832 user4 localhost statement/sp/freturn 1
1833 user4 localhost statement/sql/insert 1
1834 user4 localhost statement/sql/select 3
1835 execute dump_statements_user;
1836 user event_name count_star
1837 user1 statement/com/Error 0
1838 user1 statement/com/Quit 1
1839 user1 statement/sp/freturn 1
1840 user1 statement/sql/insert 1
1841 user1 statement/sql/select 3
1842 user2 statement/com/Error 0
1843 user2 statement/com/Quit 1
1844 user2 statement/sp/freturn 1
1845 user2 statement/sql/insert 1
1846 user2 statement/sql/select 3
1847 user3 statement/com/Error 0
1848 user3 statement/com/Quit 0
1849 user3 statement/sp/freturn 1
1850 user3 statement/sql/insert 1
1851 user3 statement/sql/select 3
1852 user4 statement/com/Error 0
1853 user4 statement/com/Quit 0
1854 user4 statement/sp/freturn 1
1855 user4 statement/sql/insert 1
1856 user4 statement/sql/select 3
1857 execute dump_statements_host;
1858 host event_name count_star
1859 localhost statement/com/Error 0
1860 localhost statement/com/Quit 2
1861 localhost statement/sp/freturn 4
1862 localhost statement/sql/insert 4
1863 localhost statement/sql/select 12
1864 execute dump_statements_global;
1865 event_name count_star
1866 statement/com/Error 0
1867 statement/com/Quit 2
1868 statement/sp/freturn 4
1869 statement/sql/insert 4
1870 statement/sql/select 12
1871 execute dump_statements_history;
1872 event_name count(event_name)
1873 statement/com/Quit 2
1874 statement/sp/freturn 4
1875 statement/sql/insert 4
1876 statement/sql/select 12
1877 execute dump_transactions_account;
1878 user host event_name count_star
1879 user1 localhost transaction 3
1880 user2 localhost transaction 3
1881 user3 localhost transaction 3
1882 user4 localhost transaction 3
1883 execute dump_transactions_user;
1884 user event_name count_star
1885 user1 transaction 3
1886 user2 transaction 3
1887 user3 transaction 3
1888 user4 transaction 3
1889 execute dump_transactions_host;
1890 host event_name count_star
1891 localhost transaction 12
1892 execute dump_transactions_global;
1893 event_name count_star
1894 transaction 12
1895 execute dump_transactions_history;
1896 event_name count(event_name)
1897 transaction 12
1898 execute dump_accounts;
1899 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1900 root localhost 1 1
1901 user1 localhost 0 1
1902 user2 localhost 0 1
1903 user3 localhost 1 1
1904 user4 localhost 1 1
1905 execute dump_users;
1906 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1907 root 1 1
1908 user1 0 1
1909 user2 0 1
1910 user3 1 1
1911 user4 1 1
1912 execute dump_hosts;
1913 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1914 localhost 3 5
1915 disconnect con3;
1916 connection default;
1917 "================== Step 12 =================="
1918 call dump_thread();
1919 username status
1920 user1 not found
1921 username status
1922 user2 not found
1923 username status
1924 user3 not found
1925 username event_name count_star
1926 user4 wait/io/file/sql/query_log 7
1927 user4 wait/synch/rwlock/sql/LOCK_grant 1
1928 execute dump_waits_account;
1929 user host event_name count_star
1930 user1 localhost wait/io/file/sql/query_log 8
1931 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
1932 user2 localhost wait/io/file/sql/query_log 8
1933 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
1934 user3 localhost wait/io/file/sql/query_log 8
1935 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
1936 user4 localhost wait/io/file/sql/query_log 7
1937 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
1938 execute dump_waits_user;
1939 user event_name count_star
1940 user1 wait/io/file/sql/query_log 8
1941 user1 wait/synch/rwlock/sql/LOCK_grant 1
1942 user2 wait/io/file/sql/query_log 8
1943 user2 wait/synch/rwlock/sql/LOCK_grant 1
1944 user3 wait/io/file/sql/query_log 8
1945 user3 wait/synch/rwlock/sql/LOCK_grant 1
1946 user4 wait/io/file/sql/query_log 7
1947 user4 wait/synch/rwlock/sql/LOCK_grant 1
1948 execute dump_waits_host;
1949 host event_name count_star
1950 localhost wait/io/file/sql/query_log 31
1951 localhost wait/synch/rwlock/sql/LOCK_grant 4
1952 execute dump_waits_global;
1953 event_name count_star
1954 wait/io/file/sql/query_log 31
1955 wait/synch/rwlock/sql/LOCK_grant 4
1956 execute dump_waits_history;
1957 event_name count(event_name)
1958 wait/io/file/sql/query_log 31
1959 wait/synch/rwlock/sql/LOCK_grant 4
1960 execute dump_stages_account;
1961 user host event_name count_star
1962 user1 localhost stage/sql/checking permissions 4
1963 user1 localhost stage/sql/closing tables 12
1964 user1 localhost stage/sql/init 3
1965 user1 localhost stage/sql/Opening tables 8
1966 user1 localhost stage/sql/starting 8
1967 user2 localhost stage/sql/checking permissions 4
1968 user2 localhost stage/sql/closing tables 11
1969 user2 localhost stage/sql/init 3
1970 user2 localhost stage/sql/Opening tables 7
1971 user2 localhost stage/sql/starting 8
1972 user3 localhost stage/sql/checking permissions 4
1973 user3 localhost stage/sql/closing tables 11
1974 user3 localhost stage/sql/init 3
1975 user3 localhost stage/sql/Opening tables 7
1976 user3 localhost stage/sql/starting 8
1977 user4 localhost stage/sql/checking permissions 4
1978 user4 localhost stage/sql/closing tables 11
1979 user4 localhost stage/sql/init 3
1980 user4 localhost stage/sql/Opening tables 7
1981 user4 localhost stage/sql/starting 7
1982 execute dump_stages_user;
1983 user event_name count_star
1984 user1 stage/sql/checking permissions 4
1985 user1 stage/sql/closing tables 12
1986 user1 stage/sql/init 3
1987 user1 stage/sql/Opening tables 8
1988 user1 stage/sql/starting 8
1989 user2 stage/sql/checking permissions 4
1990 user2 stage/sql/closing tables 11
1991 user2 stage/sql/init 3
1992 user2 stage/sql/Opening tables 7
1993 user2 stage/sql/starting 8
1994 user3 stage/sql/checking permissions 4
1995 user3 stage/sql/closing tables 11
1996 user3 stage/sql/init 3
1997 user3 stage/sql/Opening tables 7
1998 user3 stage/sql/starting 8
1999 user4 stage/sql/checking permissions 4
2000 user4 stage/sql/closing tables 11
2001 user4 stage/sql/init 3
2002 user4 stage/sql/Opening tables 7
2003 user4 stage/sql/starting 7
2004 execute dump_stages_host;
2005 host event_name count_star
2006 localhost stage/sql/checking permissions 16
2007 localhost stage/sql/closing tables 45
2008 localhost stage/sql/init 12
2009 localhost stage/sql/Opening tables 29
2010 localhost stage/sql/starting 31
2011 execute dump_stages_global;
2012 event_name count_star
2013 stage/sql/checking permissions 16
2014 stage/sql/closing tables 45
2015 stage/sql/init 12
2016 stage/sql/Opening tables 29
2017 stage/sql/starting 31
2018 execute dump_stages_history;
2019 event_name count(event_name)
2020 stage/sql/checking permissions 16
2021 stage/sql/closing tables 45
2022 stage/sql/init 12
2023 stage/sql/Opening tables 29
2024 stage/sql/starting 31
2025 execute dump_statements_account;
2026 user host event_name count_star
2027 user1 localhost statement/com/Error 0
2028 user1 localhost statement/com/Quit 1
2029 user1 localhost statement/sp/freturn 1
2030 user1 localhost statement/sql/insert 1
2031 user1 localhost statement/sql/select 3
2032 user2 localhost statement/com/Error 0
2033 user2 localhost statement/com/Quit 1
2034 user2 localhost statement/sp/freturn 1
2035 user2 localhost statement/sql/insert 1
2036 user2 localhost statement/sql/select 3
2037 user3 localhost statement/com/Error 0
2038 user3 localhost statement/com/Quit 1
2039 user3 localhost statement/sp/freturn 1
2040 user3 localhost statement/sql/insert 1
2041 user3 localhost statement/sql/select 3
2042 user4 localhost statement/com/Error 0
2043 user4 localhost statement/com/Quit 0
2044 user4 localhost statement/sp/freturn 1
2045 user4 localhost statement/sql/insert 1
2046 user4 localhost statement/sql/select 3
2047 execute dump_statements_user;
2048 user event_name count_star
2049 user1 statement/com/Error 0
2050 user1 statement/com/Quit 1
2051 user1 statement/sp/freturn 1
2052 user1 statement/sql/insert 1
2053 user1 statement/sql/select 3
2054 user2 statement/com/Error 0
2055 user2 statement/com/Quit 1
2056 user2 statement/sp/freturn 1
2057 user2 statement/sql/insert 1
2058 user2 statement/sql/select 3
2059 user3 statement/com/Error 0
2060 user3 statement/com/Quit 1
2061 user3 statement/sp/freturn 1
2062 user3 statement/sql/insert 1
2063 user3 statement/sql/select 3
2064 user4 statement/com/Error 0
2065 user4 statement/com/Quit 0
2066 user4 statement/sp/freturn 1
2067 user4 statement/sql/insert 1
2068 user4 statement/sql/select 3
2069 execute dump_statements_host;
2070 host event_name count_star
2071 localhost statement/com/Error 0
2072 localhost statement/com/Quit 3
2073 localhost statement/sp/freturn 4
2074 localhost statement/sql/insert 4
2075 localhost statement/sql/select 12
2076 execute dump_statements_global;
2077 event_name count_star
2078 statement/com/Error 0
2079 statement/com/Quit 3
2080 statement/sp/freturn 4
2081 statement/sql/insert 4
2082 statement/sql/select 12
2083 execute dump_statements_history;
2084 event_name count(event_name)
2085 statement/com/Quit 3
2086 statement/sp/freturn 4
2087 statement/sql/insert 4
2088 statement/sql/select 12
2089 execute dump_transactions_account;
2090 user host event_name count_star
2091 user1 localhost transaction 3
2092 user2 localhost transaction 3
2093 user3 localhost transaction 3
2094 user4 localhost transaction 3
2095 execute dump_transactions_user;
2096 user event_name count_star
2097 user1 transaction 3
2098 user2 transaction 3
2099 user3 transaction 3
2100 user4 transaction 3
2101 execute dump_transactions_host;
2102 host event_name count_star
2103 localhost transaction 12
2104 execute dump_transactions_global;
2105 event_name count_star
2106 transaction 12
2107 execute dump_transactions_history;
2108 event_name count(event_name)
2109 transaction 12
2110 execute dump_accounts;
2111 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2112 root localhost 1 1
2113 user1 localhost 0 1
2114 user2 localhost 0 1
2115 user3 localhost 0 1
2116 user4 localhost 1 1
2117 execute dump_users;
2118 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2119 root 1 1
2120 user1 0 1
2121 user2 0 1
2122 user3 0 1
2123 user4 1 1
2124 execute dump_hosts;
2125 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2126 localhost 2 5
2127 disconnect con4;
2128 connection default;
2129 "================== Step 13 =================="
2130 call dump_thread();
2131 username status
2132 user1 not found
2133 username status
2134 user2 not found
2135 username status
2136 user3 not found
2137 username status
2138 user4 not found
2139 execute dump_waits_account;
2140 user host event_name count_star
2141 user1 localhost wait/io/file/sql/query_log 8
2142 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
2143 user2 localhost wait/io/file/sql/query_log 8
2144 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
2145 user3 localhost wait/io/file/sql/query_log 8
2146 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
2147 user4 localhost wait/io/file/sql/query_log 8
2148 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
2149 execute dump_waits_user;
2150 user event_name count_star
2151 user1 wait/io/file/sql/query_log 8
2152 user1 wait/synch/rwlock/sql/LOCK_grant 1
2153 user2 wait/io/file/sql/query_log 8
2154 user2 wait/synch/rwlock/sql/LOCK_grant 1
2155 user3 wait/io/file/sql/query_log 8
2156 user3 wait/synch/rwlock/sql/LOCK_grant 1
2157 user4 wait/io/file/sql/query_log 8
2158 user4 wait/synch/rwlock/sql/LOCK_grant 1
2159 execute dump_waits_host;
2160 host event_name count_star
2161 localhost wait/io/file/sql/query_log 32
2162 localhost wait/synch/rwlock/sql/LOCK_grant 4
2163 execute dump_waits_global;
2164 event_name count_star
2165 wait/io/file/sql/query_log 32
2166 wait/synch/rwlock/sql/LOCK_grant 4
2167 execute dump_waits_history;
2168 event_name count(event_name)
2169 wait/io/file/sql/query_log 32
2170 wait/synch/rwlock/sql/LOCK_grant 4
2171 execute dump_stages_account;
2172 user host event_name count_star
2173 user1 localhost stage/sql/checking permissions 4
2174 user1 localhost stage/sql/closing tables 12
2175 user1 localhost stage/sql/init 3
2176 user1 localhost stage/sql/Opening tables 8
2177 user1 localhost stage/sql/starting 8
2178 user2 localhost stage/sql/checking permissions 4
2179 user2 localhost stage/sql/closing tables 11
2180 user2 localhost stage/sql/init 3
2181 user2 localhost stage/sql/Opening tables 7
2182 user2 localhost stage/sql/starting 8
2183 user3 localhost stage/sql/checking permissions 4
2184 user3 localhost stage/sql/closing tables 11
2185 user3 localhost stage/sql/init 3
2186 user3 localhost stage/sql/Opening tables 7
2187 user3 localhost stage/sql/starting 8
2188 user4 localhost stage/sql/checking permissions 4
2189 user4 localhost stage/sql/closing tables 11
2190 user4 localhost stage/sql/init 3
2191 user4 localhost stage/sql/Opening tables 7
2192 user4 localhost stage/sql/starting 8
2193 execute dump_stages_user;
2194 user event_name count_star
2195 user1 stage/sql/checking permissions 4
2196 user1 stage/sql/closing tables 12
2197 user1 stage/sql/init 3
2198 user1 stage/sql/Opening tables 8
2199 user1 stage/sql/starting 8
2200 user2 stage/sql/checking permissions 4
2201 user2 stage/sql/closing tables 11
2202 user2 stage/sql/init 3
2203 user2 stage/sql/Opening tables 7
2204 user2 stage/sql/starting 8
2205 user3 stage/sql/checking permissions 4
2206 user3 stage/sql/closing tables 11
2207 user3 stage/sql/init 3
2208 user3 stage/sql/Opening tables 7
2209 user3 stage/sql/starting 8
2210 user4 stage/sql/checking permissions 4
2211 user4 stage/sql/closing tables 11
2212 user4 stage/sql/init 3
2213 user4 stage/sql/Opening tables 7
2214 user4 stage/sql/starting 8
2215 execute dump_stages_host;
2216 host event_name count_star
2217 localhost stage/sql/checking permissions 16
2218 localhost stage/sql/closing tables 45
2219 localhost stage/sql/init 12
2220 localhost stage/sql/Opening tables 29
2221 localhost stage/sql/starting 32
2222 execute dump_stages_global;
2223 event_name count_star
2224 stage/sql/checking permissions 16
2225 stage/sql/closing tables 45
2226 stage/sql/init 12
2227 stage/sql/Opening tables 29
2228 stage/sql/starting 32
2229 execute dump_stages_history;
2230 event_name count(event_name)
2231 stage/sql/checking permissions 16
2232 stage/sql/closing tables 45
2233 stage/sql/init 12
2234 stage/sql/Opening tables 29
2235 stage/sql/starting 32
2236 execute dump_statements_account;
2237 user host event_name count_star
2238 user1 localhost statement/com/Error 0
2239 user1 localhost statement/com/Quit 1
2240 user1 localhost statement/sp/freturn 1
2241 user1 localhost statement/sql/insert 1
2242 user1 localhost statement/sql/select 3
2243 user2 localhost statement/com/Error 0
2244 user2 localhost statement/com/Quit 1
2245 user2 localhost statement/sp/freturn 1
2246 user2 localhost statement/sql/insert 1
2247 user2 localhost statement/sql/select 3
2248 user3 localhost statement/com/Error 0
2249 user3 localhost statement/com/Quit 1
2250 user3 localhost statement/sp/freturn 1
2251 user3 localhost statement/sql/insert 1
2252 user3 localhost statement/sql/select 3
2253 user4 localhost statement/com/Error 0
2254 user4 localhost statement/com/Quit 1
2255 user4 localhost statement/sp/freturn 1
2256 user4 localhost statement/sql/insert 1
2257 user4 localhost statement/sql/select 3
2258 execute dump_statements_user;
2259 user event_name count_star
2260 user1 statement/com/Error 0
2261 user1 statement/com/Quit 1
2262 user1 statement/sp/freturn 1
2263 user1 statement/sql/insert 1
2264 user1 statement/sql/select 3
2265 user2 statement/com/Error 0
2266 user2 statement/com/Quit 1
2267 user2 statement/sp/freturn 1
2268 user2 statement/sql/insert 1
2269 user2 statement/sql/select 3
2270 user3 statement/com/Error 0
2271 user3 statement/com/Quit 1
2272 user3 statement/sp/freturn 1
2273 user3 statement/sql/insert 1
2274 user3 statement/sql/select 3
2275 user4 statement/com/Error 0
2276 user4 statement/com/Quit 1
2277 user4 statement/sp/freturn 1
2278 user4 statement/sql/insert 1
2279 user4 statement/sql/select 3
2280 execute dump_statements_host;
2281 host event_name count_star
2282 localhost statement/com/Error 0
2283 localhost statement/com/Quit 4
2284 localhost statement/sp/freturn 4
2285 localhost statement/sql/insert 4
2286 localhost statement/sql/select 12
2287 execute dump_statements_global;
2288 event_name count_star
2289 statement/com/Error 0
2290 statement/com/Quit 4
2291 statement/sp/freturn 4
2292 statement/sql/insert 4
2293 statement/sql/select 12
2294 execute dump_statements_history;
2295 event_name count(event_name)
2296 statement/com/Quit 4
2297 statement/sp/freturn 4
2298 statement/sql/insert 4
2299 statement/sql/select 12
2300 execute dump_transactions_account;
2301 user host event_name count_star
2302 user1 localhost transaction 3
2303 user2 localhost transaction 3
2304 user3 localhost transaction 3
2305 user4 localhost transaction 3
2306 execute dump_transactions_user;
2307 user event_name count_star
2308 user1 transaction 3
2309 user2 transaction 3
2310 user3 transaction 3
2311 user4 transaction 3
2312 execute dump_transactions_host;
2313 host event_name count_star
2314 localhost transaction 12
2315 execute dump_transactions_global;
2316 event_name count_star
2317 transaction 12
2318 execute dump_transactions_history;
2319 event_name count(event_name)
2320 transaction 12
2321 execute dump_accounts;
2322 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2323 root localhost 1 1
2324 user1 localhost 0 1
2325 user2 localhost 0 1
2326 user3 localhost 0 1
2327 user4 localhost 0 1
2328 execute dump_users;
2329 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2330 root 1 1
2331 user1 0 1
2332 user2 0 1
2333 user3 0 1
2334 user4 0 1
2335 execute dump_hosts;
2336 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2337 localhost 1 5
2338 connection default;
2339 truncate performance_schema.events_waits_summary_by_thread_by_event_name;
2340 "================== WAITS_BY_THREAD truncated =================="
2341 "================== Step 14 =================="
2342 call dump_thread();
2343 username status
2344 user1 not found
2345 username status
2346 user2 not found
2347 username status
2348 user3 not found
2349 username status
2350 user4 not found
2351 execute dump_waits_account;
2352 user host event_name count_star
2353 user1 localhost wait/io/file/sql/query_log 8
2354 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
2355 user2 localhost wait/io/file/sql/query_log 8
2356 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
2357 user3 localhost wait/io/file/sql/query_log 8
2358 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
2359 user4 localhost wait/io/file/sql/query_log 8
2360 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
2361 execute dump_waits_user;
2362 user event_name count_star
2363 user1 wait/io/file/sql/query_log 8
2364 user1 wait/synch/rwlock/sql/LOCK_grant 1
2365 user2 wait/io/file/sql/query_log 8
2366 user2 wait/synch/rwlock/sql/LOCK_grant 1
2367 user3 wait/io/file/sql/query_log 8
2368 user3 wait/synch/rwlock/sql/LOCK_grant 1
2369 user4 wait/io/file/sql/query_log 8
2370 user4 wait/synch/rwlock/sql/LOCK_grant 1
2371 execute dump_waits_host;
2372 host event_name count_star
2373 localhost wait/io/file/sql/query_log 32
2374 localhost wait/synch/rwlock/sql/LOCK_grant 4
2375 execute dump_waits_global;
2376 event_name count_star
2377 wait/io/file/sql/query_log 32
2378 wait/synch/rwlock/sql/LOCK_grant 4
2379 execute dump_waits_history;
2380 event_name count(event_name)
2381 wait/io/file/sql/query_log 32
2382 wait/synch/rwlock/sql/LOCK_grant 4
2383 execute dump_stages_account;
2384 user host event_name count_star
2385 user1 localhost stage/sql/checking permissions 4
2386 user1 localhost stage/sql/closing tables 12
2387 user1 localhost stage/sql/init 3
2388 user1 localhost stage/sql/Opening tables 8
2389 user1 localhost stage/sql/starting 8
2390 user2 localhost stage/sql/checking permissions 4
2391 user2 localhost stage/sql/closing tables 11
2392 user2 localhost stage/sql/init 3
2393 user2 localhost stage/sql/Opening tables 7
2394 user2 localhost stage/sql/starting 8
2395 user3 localhost stage/sql/checking permissions 4
2396 user3 localhost stage/sql/closing tables 11
2397 user3 localhost stage/sql/init 3
2398 user3 localhost stage/sql/Opening tables 7
2399 user3 localhost stage/sql/starting 8
2400 user4 localhost stage/sql/checking permissions 4
2401 user4 localhost stage/sql/closing tables 11
2402 user4 localhost stage/sql/init 3
2403 user4 localhost stage/sql/Opening tables 7
2404 user4 localhost stage/sql/starting 8
2405 execute dump_stages_user;
2406 user event_name count_star
2407 user1 stage/sql/checking permissions 4
2408 user1 stage/sql/closing tables 12
2409 user1 stage/sql/init 3
2410 user1 stage/sql/Opening tables 8
2411 user1 stage/sql/starting 8
2412 user2 stage/sql/checking permissions 4
2413 user2 stage/sql/closing tables 11
2414 user2 stage/sql/init 3
2415 user2 stage/sql/Opening tables 7
2416 user2 stage/sql/starting 8
2417 user3 stage/sql/checking permissions 4
2418 user3 stage/sql/closing tables 11
2419 user3 stage/sql/init 3
2420 user3 stage/sql/Opening tables 7
2421 user3 stage/sql/starting 8
2422 user4 stage/sql/checking permissions 4
2423 user4 stage/sql/closing tables 11
2424 user4 stage/sql/init 3
2425 user4 stage/sql/Opening tables 7
2426 user4 stage/sql/starting 8
2427 execute dump_stages_host;
2428 host event_name count_star
2429 localhost stage/sql/checking permissions 16
2430 localhost stage/sql/closing tables 45
2431 localhost stage/sql/init 12
2432 localhost stage/sql/Opening tables 29
2433 localhost stage/sql/starting 32
2434 execute dump_stages_global;
2435 event_name count_star
2436 stage/sql/checking permissions 16
2437 stage/sql/closing tables 45
2438 stage/sql/init 12
2439 stage/sql/Opening tables 29
2440 stage/sql/starting 32
2441 execute dump_stages_history;
2442 event_name count(event_name)
2443 stage/sql/checking permissions 16
2444 stage/sql/closing tables 45
2445 stage/sql/init 12
2446 stage/sql/Opening tables 29
2447 stage/sql/starting 32
2448 execute dump_statements_account;
2449 user host event_name count_star
2450 user1 localhost statement/com/Error 0
2451 user1 localhost statement/com/Quit 1
2452 user1 localhost statement/sp/freturn 1
2453 user1 localhost statement/sql/insert 1
2454 user1 localhost statement/sql/select 3
2455 user2 localhost statement/com/Error 0
2456 user2 localhost statement/com/Quit 1
2457 user2 localhost statement/sp/freturn 1
2458 user2 localhost statement/sql/insert 1
2459 user2 localhost statement/sql/select 3
2460 user3 localhost statement/com/Error 0
2461 user3 localhost statement/com/Quit 1
2462 user3 localhost statement/sp/freturn 1
2463 user3 localhost statement/sql/insert 1
2464 user3 localhost statement/sql/select 3
2465 user4 localhost statement/com/Error 0
2466 user4 localhost statement/com/Quit 1
2467 user4 localhost statement/sp/freturn 1
2468 user4 localhost statement/sql/insert 1
2469 user4 localhost statement/sql/select 3
2470 execute dump_statements_user;
2471 user event_name count_star
2472 user1 statement/com/Error 0
2473 user1 statement/com/Quit 1
2474 user1 statement/sp/freturn 1
2475 user1 statement/sql/insert 1
2476 user1 statement/sql/select 3
2477 user2 statement/com/Error 0
2478 user2 statement/com/Quit 1
2479 user2 statement/sp/freturn 1
2480 user2 statement/sql/insert 1
2481 user2 statement/sql/select 3
2482 user3 statement/com/Error 0
2483 user3 statement/com/Quit 1
2484 user3 statement/sp/freturn 1
2485 user3 statement/sql/insert 1
2486 user3 statement/sql/select 3
2487 user4 statement/com/Error 0
2488 user4 statement/com/Quit 1
2489 user4 statement/sp/freturn 1
2490 user4 statement/sql/insert 1
2491 user4 statement/sql/select 3
2492 execute dump_statements_host;
2493 host event_name count_star
2494 localhost statement/com/Error 0
2495 localhost statement/com/Quit 4
2496 localhost statement/sp/freturn 4
2497 localhost statement/sql/insert 4
2498 localhost statement/sql/select 12
2499 execute dump_statements_global;
2500 event_name count_star
2501 statement/com/Error 0
2502 statement/com/Quit 4
2503 statement/sp/freturn 4
2504 statement/sql/insert 4
2505 statement/sql/select 12
2506 execute dump_statements_history;
2507 event_name count(event_name)
2508 statement/com/Quit 4
2509 statement/sp/freturn 4
2510 statement/sql/insert 4
2511 statement/sql/select 12
2512 execute dump_transactions_account;
2513 user host event_name count_star
2514 user1 localhost transaction 3
2515 user2 localhost transaction 3
2516 user3 localhost transaction 3
2517 user4 localhost transaction 3
2518 execute dump_transactions_user;
2519 user event_name count_star
2520 user1 transaction 3
2521 user2 transaction 3
2522 user3 transaction 3
2523 user4 transaction 3
2524 execute dump_transactions_host;
2525 host event_name count_star
2526 localhost transaction 12
2527 execute dump_transactions_global;
2528 event_name count_star
2529 transaction 12
2530 execute dump_transactions_history;
2531 event_name count(event_name)
2532 transaction 12
2533 execute dump_accounts;
2534 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2535 root localhost 1 1
2536 user1 localhost 0 1
2537 user2 localhost 0 1
2538 user3 localhost 0 1
2539 user4 localhost 0 1
2540 execute dump_users;
2541 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2542 root 1 1
2543 user1 0 1
2544 user2 0 1
2545 user3 0 1
2546 user4 0 1
2547 execute dump_hosts;
2548 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2549 localhost 1 5
2550 truncate performance_schema.events_waits_summary_by_account_by_event_name;
2551 "================== WAITS_BY_ACCOUNT truncated =================="
2552 "================== Step 15 =================="
2553 call dump_thread();
2554 username status
2555 user1 not found
2556 username status
2557 user2 not found
2558 username status
2559 user3 not found
2560 username status
2561 user4 not found
2562 execute dump_waits_account;
2563 user host event_name count_star
2564 user1 localhost wait/io/file/sql/query_log 0
2565 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
2566 user2 localhost wait/io/file/sql/query_log 0
2567 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
2568 user3 localhost wait/io/file/sql/query_log 0
2569 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
2570 user4 localhost wait/io/file/sql/query_log 0
2571 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
2572 execute dump_waits_user;
2573 user event_name count_star
2574 user1 wait/io/file/sql/query_log 8
2575 user1 wait/synch/rwlock/sql/LOCK_grant 1
2576 user2 wait/io/file/sql/query_log 8
2577 user2 wait/synch/rwlock/sql/LOCK_grant 1
2578 user3 wait/io/file/sql/query_log 8
2579 user3 wait/synch/rwlock/sql/LOCK_grant 1
2580 user4 wait/io/file/sql/query_log 8
2581 user4 wait/synch/rwlock/sql/LOCK_grant 1
2582 execute dump_waits_host;
2583 host event_name count_star
2584 localhost wait/io/file/sql/query_log 32
2585 localhost wait/synch/rwlock/sql/LOCK_grant 4
2586 execute dump_waits_global;
2587 event_name count_star
2588 wait/io/file/sql/query_log 32
2589 wait/synch/rwlock/sql/LOCK_grant 4
2590 execute dump_waits_history;
2591 event_name count(event_name)
2592 wait/io/file/sql/query_log 32
2593 wait/synch/rwlock/sql/LOCK_grant 4
2594 execute dump_stages_account;
2595 user host event_name count_star
2596 user1 localhost stage/sql/checking permissions 4
2597 user1 localhost stage/sql/closing tables 12
2598 user1 localhost stage/sql/init 3
2599 user1 localhost stage/sql/Opening tables 8
2600 user1 localhost stage/sql/starting 8
2601 user2 localhost stage/sql/checking permissions 4
2602 user2 localhost stage/sql/closing tables 11
2603 user2 localhost stage/sql/init 3
2604 user2 localhost stage/sql/Opening tables 7
2605 user2 localhost stage/sql/starting 8
2606 user3 localhost stage/sql/checking permissions 4
2607 user3 localhost stage/sql/closing tables 11
2608 user3 localhost stage/sql/init 3
2609 user3 localhost stage/sql/Opening tables 7
2610 user3 localhost stage/sql/starting 8
2611 user4 localhost stage/sql/checking permissions 4
2612 user4 localhost stage/sql/closing tables 11
2613 user4 localhost stage/sql/init 3
2614 user4 localhost stage/sql/Opening tables 7
2615 user4 localhost stage/sql/starting 8
2616 execute dump_stages_user;
2617 user event_name count_star
2618 user1 stage/sql/checking permissions 4
2619 user1 stage/sql/closing tables 12
2620 user1 stage/sql/init 3
2621 user1 stage/sql/Opening tables 8
2622 user1 stage/sql/starting 8
2623 user2 stage/sql/checking permissions 4
2624 user2 stage/sql/closing tables 11
2625 user2 stage/sql/init 3
2626 user2 stage/sql/Opening tables 7
2627 user2 stage/sql/starting 8
2628 user3 stage/sql/checking permissions 4
2629 user3 stage/sql/closing tables 11
2630 user3 stage/sql/init 3
2631 user3 stage/sql/Opening tables 7
2632 user3 stage/sql/starting 8
2633 user4 stage/sql/checking permissions 4
2634 user4 stage/sql/closing tables 11
2635 user4 stage/sql/init 3
2636 user4 stage/sql/Opening tables 7
2637 user4 stage/sql/starting 8
2638 execute dump_stages_host;
2639 host event_name count_star
2640 localhost stage/sql/checking permissions 16
2641 localhost stage/sql/closing tables 45
2642 localhost stage/sql/init 12
2643 localhost stage/sql/Opening tables 29
2644 localhost stage/sql/starting 32
2645 execute dump_stages_global;
2646 event_name count_star
2647 stage/sql/checking permissions 16
2648 stage/sql/closing tables 45
2649 stage/sql/init 12
2650 stage/sql/Opening tables 29
2651 stage/sql/starting 32
2652 execute dump_stages_history;
2653 event_name count(event_name)
2654 stage/sql/checking permissions 16
2655 stage/sql/closing tables 45
2656 stage/sql/init 12
2657 stage/sql/Opening tables 29
2658 stage/sql/starting 32
2659 execute dump_statements_account;
2660 user host event_name count_star
2661 user1 localhost statement/com/Error 0
2662 user1 localhost statement/com/Quit 1
2663 user1 localhost statement/sp/freturn 1
2664 user1 localhost statement/sql/insert 1
2665 user1 localhost statement/sql/select 3
2666 user2 localhost statement/com/Error 0
2667 user2 localhost statement/com/Quit 1
2668 user2 localhost statement/sp/freturn 1
2669 user2 localhost statement/sql/insert 1
2670 user2 localhost statement/sql/select 3
2671 user3 localhost statement/com/Error 0
2672 user3 localhost statement/com/Quit 1
2673 user3 localhost statement/sp/freturn 1
2674 user3 localhost statement/sql/insert 1
2675 user3 localhost statement/sql/select 3
2676 user4 localhost statement/com/Error 0
2677 user4 localhost statement/com/Quit 1
2678 user4 localhost statement/sp/freturn 1
2679 user4 localhost statement/sql/insert 1
2680 user4 localhost statement/sql/select 3
2681 execute dump_statements_user;
2682 user event_name count_star
2683 user1 statement/com/Error 0
2684 user1 statement/com/Quit 1
2685 user1 statement/sp/freturn 1
2686 user1 statement/sql/insert 1
2687 user1 statement/sql/select 3
2688 user2 statement/com/Error 0
2689 user2 statement/com/Quit 1
2690 user2 statement/sp/freturn 1
2691 user2 statement/sql/insert 1
2692 user2 statement/sql/select 3
2693 user3 statement/com/Error 0
2694 user3 statement/com/Quit 1
2695 user3 statement/sp/freturn 1
2696 user3 statement/sql/insert 1
2697 user3 statement/sql/select 3
2698 user4 statement/com/Error 0
2699 user4 statement/com/Quit 1
2700 user4 statement/sp/freturn 1
2701 user4 statement/sql/insert 1
2702 user4 statement/sql/select 3
2703 execute dump_statements_host;
2704 host event_name count_star
2705 localhost statement/com/Error 0
2706 localhost statement/com/Quit 4
2707 localhost statement/sp/freturn 4
2708 localhost statement/sql/insert 4
2709 localhost statement/sql/select 12
2710 execute dump_statements_global;
2711 event_name count_star
2712 statement/com/Error 0
2713 statement/com/Quit 4
2714 statement/sp/freturn 4
2715 statement/sql/insert 4
2716 statement/sql/select 12
2717 execute dump_statements_history;
2718 event_name count(event_name)
2719 statement/com/Quit 4
2720 statement/sp/freturn 4
2721 statement/sql/insert 4
2722 statement/sql/select 12
2723 execute dump_transactions_account;
2724 user host event_name count_star
2725 user1 localhost transaction 3
2726 user2 localhost transaction 3
2727 user3 localhost transaction 3
2728 user4 localhost transaction 3
2729 execute dump_transactions_user;
2730 user event_name count_star
2731 user1 transaction 3
2732 user2 transaction 3
2733 user3 transaction 3
2734 user4 transaction 3
2735 execute dump_transactions_host;
2736 host event_name count_star
2737 localhost transaction 12
2738 execute dump_transactions_global;
2739 event_name count_star
2740 transaction 12
2741 execute dump_transactions_history;
2742 event_name count(event_name)
2743 transaction 12
2744 execute dump_accounts;
2745 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2746 root localhost 1 1
2747 user1 localhost 0 1
2748 user2 localhost 0 1
2749 user3 localhost 0 1
2750 user4 localhost 0 1
2751 execute dump_users;
2752 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2753 root 1 1
2754 user1 0 1
2755 user2 0 1
2756 user3 0 1
2757 user4 0 1
2758 execute dump_hosts;
2759 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2760 localhost 1 5
2761 truncate performance_schema.events_waits_summary_by_user_by_event_name;
2762 "================== WAITS_BY_USER truncated =================="
2763 "================== Step 16 =================="
2764 call dump_thread();
2765 username status
2766 user1 not found
2767 username status
2768 user2 not found
2769 username status
2770 user3 not found
2771 username status
2772 user4 not found
2773 execute dump_waits_account;
2774 user host event_name count_star
2775 user1 localhost wait/io/file/sql/query_log 0
2776 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
2777 user2 localhost wait/io/file/sql/query_log 0
2778 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
2779 user3 localhost wait/io/file/sql/query_log 0
2780 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
2781 user4 localhost wait/io/file/sql/query_log 0
2782 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
2783 execute dump_waits_user;
2784 user event_name count_star
2785 user1 wait/io/file/sql/query_log 0
2786 user1 wait/synch/rwlock/sql/LOCK_grant 0
2787 user2 wait/io/file/sql/query_log 0
2788 user2 wait/synch/rwlock/sql/LOCK_grant 0
2789 user3 wait/io/file/sql/query_log 0
2790 user3 wait/synch/rwlock/sql/LOCK_grant 0
2791 user4 wait/io/file/sql/query_log 0
2792 user4 wait/synch/rwlock/sql/LOCK_grant 0
2793 execute dump_waits_host;
2794 host event_name count_star
2795 localhost wait/io/file/sql/query_log 32
2796 localhost wait/synch/rwlock/sql/LOCK_grant 4
2797 execute dump_waits_global;
2798 event_name count_star
2799 wait/io/file/sql/query_log 32
2800 wait/synch/rwlock/sql/LOCK_grant 4
2801 execute dump_waits_history;
2802 event_name count(event_name)
2803 wait/io/file/sql/query_log 32
2804 wait/synch/rwlock/sql/LOCK_grant 4
2805 execute dump_stages_account;
2806 user host event_name count_star
2807 user1 localhost stage/sql/checking permissions 4
2808 user1 localhost stage/sql/closing tables 12
2809 user1 localhost stage/sql/init 3
2810 user1 localhost stage/sql/Opening tables 8
2811 user1 localhost stage/sql/starting 8
2812 user2 localhost stage/sql/checking permissions 4
2813 user2 localhost stage/sql/closing tables 11
2814 user2 localhost stage/sql/init 3
2815 user2 localhost stage/sql/Opening tables 7
2816 user2 localhost stage/sql/starting 8
2817 user3 localhost stage/sql/checking permissions 4
2818 user3 localhost stage/sql/closing tables 11
2819 user3 localhost stage/sql/init 3
2820 user3 localhost stage/sql/Opening tables 7
2821 user3 localhost stage/sql/starting 8
2822 user4 localhost stage/sql/checking permissions 4
2823 user4 localhost stage/sql/closing tables 11
2824 user4 localhost stage/sql/init 3
2825 user4 localhost stage/sql/Opening tables 7
2826 user4 localhost stage/sql/starting 8
2827 execute dump_stages_user;
2828 user event_name count_star
2829 user1 stage/sql/checking permissions 4
2830 user1 stage/sql/closing tables 12
2831 user1 stage/sql/init 3
2832 user1 stage/sql/Opening tables 8
2833 user1 stage/sql/starting 8
2834 user2 stage/sql/checking permissions 4
2835 user2 stage/sql/closing tables 11
2836 user2 stage/sql/init 3
2837 user2 stage/sql/Opening tables 7
2838 user2 stage/sql/starting 8
2839 user3 stage/sql/checking permissions 4
2840 user3 stage/sql/closing tables 11
2841 user3 stage/sql/init 3
2842 user3 stage/sql/Opening tables 7
2843 user3 stage/sql/starting 8
2844 user4 stage/sql/checking permissions 4
2845 user4 stage/sql/closing tables 11
2846 user4 stage/sql/init 3
2847 user4 stage/sql/Opening tables 7
2848 user4 stage/sql/starting 8
2849 execute dump_stages_host;
2850 host event_name count_star
2851 localhost stage/sql/checking permissions 16
2852 localhost stage/sql/closing tables 45
2853 localhost stage/sql/init 12
2854 localhost stage/sql/Opening tables 29
2855 localhost stage/sql/starting 32
2856 execute dump_stages_global;
2857 event_name count_star
2858 stage/sql/checking permissions 16
2859 stage/sql/closing tables 45
2860 stage/sql/init 12
2861 stage/sql/Opening tables 29
2862 stage/sql/starting 32
2863 execute dump_stages_history;
2864 event_name count(event_name)
2865 stage/sql/checking permissions 16
2866 stage/sql/closing tables 45
2867 stage/sql/init 12
2868 stage/sql/Opening tables 29
2869 stage/sql/starting 32
2870 execute dump_statements_account;
2871 user host event_name count_star
2872 user1 localhost statement/com/Error 0
2873 user1 localhost statement/com/Quit 1
2874 user1 localhost statement/sp/freturn 1
2875 user1 localhost statement/sql/insert 1
2876 user1 localhost statement/sql/select 3
2877 user2 localhost statement/com/Error 0
2878 user2 localhost statement/com/Quit 1
2879 user2 localhost statement/sp/freturn 1
2880 user2 localhost statement/sql/insert 1
2881 user2 localhost statement/sql/select 3
2882 user3 localhost statement/com/Error 0
2883 user3 localhost statement/com/Quit 1
2884 user3 localhost statement/sp/freturn 1
2885 user3 localhost statement/sql/insert 1
2886 user3 localhost statement/sql/select 3
2887 user4 localhost statement/com/Error 0
2888 user4 localhost statement/com/Quit 1
2889 user4 localhost statement/sp/freturn 1
2890 user4 localhost statement/sql/insert 1
2891 user4 localhost statement/sql/select 3
2892 execute dump_statements_user;
2893 user event_name count_star
2894 user1 statement/com/Error 0
2895 user1 statement/com/Quit 1
2896 user1 statement/sp/freturn 1
2897 user1 statement/sql/insert 1
2898 user1 statement/sql/select 3
2899 user2 statement/com/Error 0
2900 user2 statement/com/Quit 1
2901 user2 statement/sp/freturn 1
2902 user2 statement/sql/insert 1
2903 user2 statement/sql/select 3
2904 user3 statement/com/Error 0
2905 user3 statement/com/Quit 1
2906 user3 statement/sp/freturn 1
2907 user3 statement/sql/insert 1
2908 user3 statement/sql/select 3
2909 user4 statement/com/Error 0
2910 user4 statement/com/Quit 1
2911 user4 statement/sp/freturn 1
2912 user4 statement/sql/insert 1
2913 user4 statement/sql/select 3
2914 execute dump_statements_host;
2915 host event_name count_star
2916 localhost statement/com/Error 0
2917 localhost statement/com/Quit 4
2918 localhost statement/sp/freturn 4
2919 localhost statement/sql/insert 4
2920 localhost statement/sql/select 12
2921 execute dump_statements_global;
2922 event_name count_star
2923 statement/com/Error 0
2924 statement/com/Quit 4
2925 statement/sp/freturn 4
2926 statement/sql/insert 4
2927 statement/sql/select 12
2928 execute dump_statements_history;
2929 event_name count(event_name)
2930 statement/com/Quit 4
2931 statement/sp/freturn 4
2932 statement/sql/insert 4
2933 statement/sql/select 12
2934 execute dump_transactions_account;
2935 user host event_name count_star
2936 user1 localhost transaction 3
2937 user2 localhost transaction 3
2938 user3 localhost transaction 3
2939 user4 localhost transaction 3
2940 execute dump_transactions_user;
2941 user event_name count_star
2942 user1 transaction 3
2943 user2 transaction 3
2944 user3 transaction 3
2945 user4 transaction 3
2946 execute dump_transactions_host;
2947 host event_name count_star
2948 localhost transaction 12
2949 execute dump_transactions_global;
2950 event_name count_star
2951 transaction 12
2952 execute dump_transactions_history;
2953 event_name count(event_name)
2954 transaction 12
2955 execute dump_accounts;
2956 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2957 root localhost 1 1
2958 user1 localhost 0 1
2959 user2 localhost 0 1
2960 user3 localhost 0 1
2961 user4 localhost 0 1
2962 execute dump_users;
2963 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2964 root 1 1
2965 user1 0 1
2966 user2 0 1
2967 user3 0 1
2968 user4 0 1
2969 execute dump_hosts;
2970 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2971 localhost 1 5
2972 truncate performance_schema.events_waits_summary_by_host_by_event_name;
2973 "================== WAITS_BY_HOST truncated =================="
2974 "================== Step 17 =================="
2975 call dump_thread();
2976 username status
2977 user1 not found
2978 username status
2979 user2 not found
2980 username status
2981 user3 not found
2982 username status
2983 user4 not found
2984 execute dump_waits_account;
2985 user host event_name count_star
2986 user1 localhost wait/io/file/sql/query_log 0
2987 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
2988 user2 localhost wait/io/file/sql/query_log 0
2989 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
2990 user3 localhost wait/io/file/sql/query_log 0
2991 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
2992 user4 localhost wait/io/file/sql/query_log 0
2993 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
2994 execute dump_waits_user;
2995 user event_name count_star
2996 user1 wait/io/file/sql/query_log 0
2997 user1 wait/synch/rwlock/sql/LOCK_grant 0
2998 user2 wait/io/file/sql/query_log 0
2999 user2 wait/synch/rwlock/sql/LOCK_grant 0
3000 user3 wait/io/file/sql/query_log 0
3001 user3 wait/synch/rwlock/sql/LOCK_grant 0
3002 user4 wait/io/file/sql/query_log 0
3003 user4 wait/synch/rwlock/sql/LOCK_grant 0
3004 execute dump_waits_host;
3005 host event_name count_star
3006 localhost wait/io/file/sql/query_log 0
3007 localhost wait/synch/rwlock/sql/LOCK_grant 0
3008 execute dump_waits_global;
3009 event_name count_star
3010 wait/io/file/sql/query_log 32
3011 wait/synch/rwlock/sql/LOCK_grant 4
3012 execute dump_waits_history;
3013 event_name count(event_name)
3014 wait/io/file/sql/query_log 32
3015 wait/synch/rwlock/sql/LOCK_grant 4
3016 execute dump_stages_account;
3017 user host event_name count_star
3018 user1 localhost stage/sql/checking permissions 4
3019 user1 localhost stage/sql/closing tables 12
3020 user1 localhost stage/sql/init 3
3021 user1 localhost stage/sql/Opening tables 8
3022 user1 localhost stage/sql/starting 8
3023 user2 localhost stage/sql/checking permissions 4
3024 user2 localhost stage/sql/closing tables 11
3025 user2 localhost stage/sql/init 3
3026 user2 localhost stage/sql/Opening tables 7
3027 user2 localhost stage/sql/starting 8
3028 user3 localhost stage/sql/checking permissions 4
3029 user3 localhost stage/sql/closing tables 11
3030 user3 localhost stage/sql/init 3
3031 user3 localhost stage/sql/Opening tables 7
3032 user3 localhost stage/sql/starting 8
3033 user4 localhost stage/sql/checking permissions 4
3034 user4 localhost stage/sql/closing tables 11
3035 user4 localhost stage/sql/init 3
3036 user4 localhost stage/sql/Opening tables 7
3037 user4 localhost stage/sql/starting 8
3038 execute dump_stages_user;
3039 user event_name count_star
3040 user1 stage/sql/checking permissions 4
3041 user1 stage/sql/closing tables 12
3042 user1 stage/sql/init 3
3043 user1 stage/sql/Opening tables 8
3044 user1 stage/sql/starting 8
3045 user2 stage/sql/checking permissions 4
3046 user2 stage/sql/closing tables 11
3047 user2 stage/sql/init 3
3048 user2 stage/sql/Opening tables 7
3049 user2 stage/sql/starting 8
3050 user3 stage/sql/checking permissions 4
3051 user3 stage/sql/closing tables 11
3052 user3 stage/sql/init 3
3053 user3 stage/sql/Opening tables 7
3054 user3 stage/sql/starting 8
3055 user4 stage/sql/checking permissions 4
3056 user4 stage/sql/closing tables 11
3057 user4 stage/sql/init 3
3058 user4 stage/sql/Opening tables 7
3059 user4 stage/sql/starting 8
3060 execute dump_stages_host;
3061 host event_name count_star
3062 localhost stage/sql/checking permissions 16
3063 localhost stage/sql/closing tables 45
3064 localhost stage/sql/init 12
3065 localhost stage/sql/Opening tables 29
3066 localhost stage/sql/starting 32
3067 execute dump_stages_global;
3068 event_name count_star
3069 stage/sql/checking permissions 16
3070 stage/sql/closing tables 45
3071 stage/sql/init 12
3072 stage/sql/Opening tables 29
3073 stage/sql/starting 32
3074 execute dump_stages_history;
3075 event_name count(event_name)
3076 stage/sql/checking permissions 16
3077 stage/sql/closing tables 45
3078 stage/sql/init 12
3079 stage/sql/Opening tables 29
3080 stage/sql/starting 32
3081 execute dump_statements_account;
3082 user host event_name count_star
3083 user1 localhost statement/com/Error 0
3084 user1 localhost statement/com/Quit 1
3085 user1 localhost statement/sp/freturn 1
3086 user1 localhost statement/sql/insert 1
3087 user1 localhost statement/sql/select 3
3088 user2 localhost statement/com/Error 0
3089 user2 localhost statement/com/Quit 1
3090 user2 localhost statement/sp/freturn 1
3091 user2 localhost statement/sql/insert 1
3092 user2 localhost statement/sql/select 3
3093 user3 localhost statement/com/Error 0
3094 user3 localhost statement/com/Quit 1
3095 user3 localhost statement/sp/freturn 1
3096 user3 localhost statement/sql/insert 1
3097 user3 localhost statement/sql/select 3
3098 user4 localhost statement/com/Error 0
3099 user4 localhost statement/com/Quit 1
3100 user4 localhost statement/sp/freturn 1
3101 user4 localhost statement/sql/insert 1
3102 user4 localhost statement/sql/select 3
3103 execute dump_statements_user;
3104 user event_name count_star
3105 user1 statement/com/Error 0
3106 user1 statement/com/Quit 1
3107 user1 statement/sp/freturn 1
3108 user1 statement/sql/insert 1
3109 user1 statement/sql/select 3
3110 user2 statement/com/Error 0
3111 user2 statement/com/Quit 1
3112 user2 statement/sp/freturn 1
3113 user2 statement/sql/insert 1
3114 user2 statement/sql/select 3
3115 user3 statement/com/Error 0
3116 user3 statement/com/Quit 1
3117 user3 statement/sp/freturn 1
3118 user3 statement/sql/insert 1
3119 user3 statement/sql/select 3
3120 user4 statement/com/Error 0
3121 user4 statement/com/Quit 1
3122 user4 statement/sp/freturn 1
3123 user4 statement/sql/insert 1
3124 user4 statement/sql/select 3
3125 execute dump_statements_host;
3126 host event_name count_star
3127 localhost statement/com/Error 0
3128 localhost statement/com/Quit 4
3129 localhost statement/sp/freturn 4
3130 localhost statement/sql/insert 4
3131 localhost statement/sql/select 12
3132 execute dump_statements_global;
3133 event_name count_star
3134 statement/com/Error 0
3135 statement/com/Quit 4
3136 statement/sp/freturn 4
3137 statement/sql/insert 4
3138 statement/sql/select 12
3139 execute dump_statements_history;
3140 event_name count(event_name)
3141 statement/com/Quit 4
3142 statement/sp/freturn 4
3143 statement/sql/insert 4
3144 statement/sql/select 12
3145 execute dump_transactions_account;
3146 user host event_name count_star
3147 user1 localhost transaction 3
3148 user2 localhost transaction 3
3149 user3 localhost transaction 3
3150 user4 localhost transaction 3
3151 execute dump_transactions_user;
3152 user event_name count_star
3153 user1 transaction 3
3154 user2 transaction 3
3155 user3 transaction 3
3156 user4 transaction 3
3157 execute dump_transactions_host;
3158 host event_name count_star
3159 localhost transaction 12
3160 execute dump_transactions_global;
3161 event_name count_star
3162 transaction 12
3163 execute dump_transactions_history;
3164 event_name count(event_name)
3165 transaction 12
3166 execute dump_accounts;
3167 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3168 root localhost 1 1
3169 user1 localhost 0 1
3170 user2 localhost 0 1
3171 user3 localhost 0 1
3172 user4 localhost 0 1
3173 execute dump_users;
3174 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3175 root 1 1
3176 user1 0 1
3177 user2 0 1
3178 user3 0 1
3179 user4 0 1
3180 execute dump_hosts;
3181 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3182 localhost 1 5
3183 truncate performance_schema.events_waits_summary_global_by_event_name;
3184 "================== WAITS_GLOBAL truncated =================="
3185 "================== Step 18 =================="
3186 call dump_thread();
3187 username status
3188 user1 not found
3189 username status
3190 user2 not found
3191 username status
3192 user3 not found
3193 username status
3194 user4 not found
3195 execute dump_waits_account;
3196 user host event_name count_star
3197 user1 localhost wait/io/file/sql/query_log 0
3198 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
3199 user2 localhost wait/io/file/sql/query_log 0
3200 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
3201 user3 localhost wait/io/file/sql/query_log 0
3202 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
3203 user4 localhost wait/io/file/sql/query_log 0
3204 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
3205 execute dump_waits_user;
3206 user event_name count_star
3207 user1 wait/io/file/sql/query_log 0
3208 user1 wait/synch/rwlock/sql/LOCK_grant 0
3209 user2 wait/io/file/sql/query_log 0
3210 user2 wait/synch/rwlock/sql/LOCK_grant 0
3211 user3 wait/io/file/sql/query_log 0
3212 user3 wait/synch/rwlock/sql/LOCK_grant 0
3213 user4 wait/io/file/sql/query_log 0
3214 user4 wait/synch/rwlock/sql/LOCK_grant 0
3215 execute dump_waits_host;
3216 host event_name count_star
3217 localhost wait/io/file/sql/query_log 0
3218 localhost wait/synch/rwlock/sql/LOCK_grant 0
3219 execute dump_waits_global;
3220 event_name count_star
3221 wait/io/file/sql/query_log 0
3222 wait/synch/rwlock/sql/LOCK_grant 0
3223 execute dump_waits_history;
3224 event_name count(event_name)
3225 wait/io/file/sql/query_log 32
3226 wait/synch/rwlock/sql/LOCK_grant 4
3227 execute dump_stages_account;
3228 user host event_name count_star
3229 user1 localhost stage/sql/checking permissions 4
3230 user1 localhost stage/sql/closing tables 12
3231 user1 localhost stage/sql/init 3
3232 user1 localhost stage/sql/Opening tables 8
3233 user1 localhost stage/sql/starting 8
3234 user2 localhost stage/sql/checking permissions 4
3235 user2 localhost stage/sql/closing tables 11
3236 user2 localhost stage/sql/init 3
3237 user2 localhost stage/sql/Opening tables 7
3238 user2 localhost stage/sql/starting 8
3239 user3 localhost stage/sql/checking permissions 4
3240 user3 localhost stage/sql/closing tables 11
3241 user3 localhost stage/sql/init 3
3242 user3 localhost stage/sql/Opening tables 7
3243 user3 localhost stage/sql/starting 8
3244 user4 localhost stage/sql/checking permissions 4
3245 user4 localhost stage/sql/closing tables 11
3246 user4 localhost stage/sql/init 3
3247 user4 localhost stage/sql/Opening tables 7
3248 user4 localhost stage/sql/starting 8
3249 execute dump_stages_user;
3250 user event_name count_star
3251 user1 stage/sql/checking permissions 4
3252 user1 stage/sql/closing tables 12
3253 user1 stage/sql/init 3
3254 user1 stage/sql/Opening tables 8
3255 user1 stage/sql/starting 8
3256 user2 stage/sql/checking permissions 4
3257 user2 stage/sql/closing tables 11
3258 user2 stage/sql/init 3
3259 user2 stage/sql/Opening tables 7
3260 user2 stage/sql/starting 8
3261 user3 stage/sql/checking permissions 4
3262 user3 stage/sql/closing tables 11
3263 user3 stage/sql/init 3
3264 user3 stage/sql/Opening tables 7
3265 user3 stage/sql/starting 8
3266 user4 stage/sql/checking permissions 4
3267 user4 stage/sql/closing tables 11
3268 user4 stage/sql/init 3
3269 user4 stage/sql/Opening tables 7
3270 user4 stage/sql/starting 8
3271 execute dump_stages_host;
3272 host event_name count_star
3273 localhost stage/sql/checking permissions 16
3274 localhost stage/sql/closing tables 45
3275 localhost stage/sql/init 12
3276 localhost stage/sql/Opening tables 29
3277 localhost stage/sql/starting 32
3278 execute dump_stages_global;
3279 event_name count_star
3280 stage/sql/checking permissions 16
3281 stage/sql/closing tables 45
3282 stage/sql/init 12
3283 stage/sql/Opening tables 29
3284 stage/sql/starting 32
3285 execute dump_stages_history;
3286 event_name count(event_name)
3287 stage/sql/checking permissions 16
3288 stage/sql/closing tables 45
3289 stage/sql/init 12
3290 stage/sql/Opening tables 29
3291 stage/sql/starting 32
3292 execute dump_statements_account;
3293 user host event_name count_star
3294 user1 localhost statement/com/Error 0
3295 user1 localhost statement/com/Quit 1
3296 user1 localhost statement/sp/freturn 1
3297 user1 localhost statement/sql/insert 1
3298 user1 localhost statement/sql/select 3
3299 user2 localhost statement/com/Error 0
3300 user2 localhost statement/com/Quit 1
3301 user2 localhost statement/sp/freturn 1
3302 user2 localhost statement/sql/insert 1
3303 user2 localhost statement/sql/select 3
3304 user3 localhost statement/com/Error 0
3305 user3 localhost statement/com/Quit 1
3306 user3 localhost statement/sp/freturn 1
3307 user3 localhost statement/sql/insert 1
3308 user3 localhost statement/sql/select 3
3309 user4 localhost statement/com/Error 0
3310 user4 localhost statement/com/Quit 1
3311 user4 localhost statement/sp/freturn 1
3312 user4 localhost statement/sql/insert 1
3313 user4 localhost statement/sql/select 3
3314 execute dump_statements_user;
3315 user event_name count_star
3316 user1 statement/com/Error 0
3317 user1 statement/com/Quit 1
3318 user1 statement/sp/freturn 1
3319 user1 statement/sql/insert 1
3320 user1 statement/sql/select 3
3321 user2 statement/com/Error 0
3322 user2 statement/com/Quit 1
3323 user2 statement/sp/freturn 1
3324 user2 statement/sql/insert 1
3325 user2 statement/sql/select 3
3326 user3 statement/com/Error 0
3327 user3 statement/com/Quit 1
3328 user3 statement/sp/freturn 1
3329 user3 statement/sql/insert 1
3330 user3 statement/sql/select 3
3331 user4 statement/com/Error 0
3332 user4 statement/com/Quit 1
3333 user4 statement/sp/freturn 1
3334 user4 statement/sql/insert 1
3335 user4 statement/sql/select 3
3336 execute dump_statements_host;
3337 host event_name count_star
3338 localhost statement/com/Error 0
3339 localhost statement/com/Quit 4
3340 localhost statement/sp/freturn 4
3341 localhost statement/sql/insert 4
3342 localhost statement/sql/select 12
3343 execute dump_statements_global;
3344 event_name count_star
3345 statement/com/Error 0
3346 statement/com/Quit 4
3347 statement/sp/freturn 4
3348 statement/sql/insert 4
3349 statement/sql/select 12
3350 execute dump_statements_history;
3351 event_name count(event_name)
3352 statement/com/Quit 4
3353 statement/sp/freturn 4
3354 statement/sql/insert 4
3355 statement/sql/select 12
3356 execute dump_transactions_account;
3357 user host event_name count_star
3358 user1 localhost transaction 3
3359 user2 localhost transaction 3
3360 user3 localhost transaction 3
3361 user4 localhost transaction 3
3362 execute dump_transactions_user;
3363 user event_name count_star
3364 user1 transaction 3
3365 user2 transaction 3
3366 user3 transaction 3
3367 user4 transaction 3
3368 execute dump_transactions_host;
3369 host event_name count_star
3370 localhost transaction 12
3371 execute dump_transactions_global;
3372 event_name count_star
3373 transaction 12
3374 execute dump_transactions_history;
3375 event_name count(event_name)
3376 transaction 12
3377 execute dump_accounts;
3378 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3379 root localhost 1 1
3380 user1 localhost 0 1
3381 user2 localhost 0 1
3382 user3 localhost 0 1
3383 user4 localhost 0 1
3384 execute dump_users;
3385 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3386 root 1 1
3387 user1 0 1
3388 user2 0 1
3389 user3 0 1
3390 user4 0 1
3391 execute dump_hosts;
3392 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3393 localhost 1 5
3394 truncate performance_schema.events_stages_summary_by_thread_by_event_name;
3395 "================== STAGES_BY_THREAD truncated =================="
3396 "================== Step 19 =================="
3397 call dump_thread();
3398 username status
3399 user1 not found
3400 username status
3401 user2 not found
3402 username status
3403 user3 not found
3404 username status
3405 user4 not found
3406 execute dump_waits_account;
3407 user host event_name count_star
3408 user1 localhost wait/io/file/sql/query_log 0
3409 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
3410 user2 localhost wait/io/file/sql/query_log 0
3411 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
3412 user3 localhost wait/io/file/sql/query_log 0
3413 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
3414 user4 localhost wait/io/file/sql/query_log 0
3415 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
3416 execute dump_waits_user;
3417 user event_name count_star
3418 user1 wait/io/file/sql/query_log 0
3419 user1 wait/synch/rwlock/sql/LOCK_grant 0
3420 user2 wait/io/file/sql/query_log 0
3421 user2 wait/synch/rwlock/sql/LOCK_grant 0
3422 user3 wait/io/file/sql/query_log 0
3423 user3 wait/synch/rwlock/sql/LOCK_grant 0
3424 user4 wait/io/file/sql/query_log 0
3425 user4 wait/synch/rwlock/sql/LOCK_grant 0
3426 execute dump_waits_host;
3427 host event_name count_star
3428 localhost wait/io/file/sql/query_log 0
3429 localhost wait/synch/rwlock/sql/LOCK_grant 0
3430 execute dump_waits_global;
3431 event_name count_star
3432 wait/io/file/sql/query_log 0
3433 wait/synch/rwlock/sql/LOCK_grant 0
3434 execute dump_waits_history;
3435 event_name count(event_name)
3436 wait/io/file/sql/query_log 32
3437 wait/synch/rwlock/sql/LOCK_grant 4
3438 execute dump_stages_account;
3439 user host event_name count_star
3440 user1 localhost stage/sql/checking permissions 4
3441 user1 localhost stage/sql/closing tables 12
3442 user1 localhost stage/sql/init 3
3443 user1 localhost stage/sql/Opening tables 8
3444 user1 localhost stage/sql/starting 8
3445 user2 localhost stage/sql/checking permissions 4
3446 user2 localhost stage/sql/closing tables 11
3447 user2 localhost stage/sql/init 3
3448 user2 localhost stage/sql/Opening tables 7
3449 user2 localhost stage/sql/starting 8
3450 user3 localhost stage/sql/checking permissions 4
3451 user3 localhost stage/sql/closing tables 11
3452 user3 localhost stage/sql/init 3
3453 user3 localhost stage/sql/Opening tables 7
3454 user3 localhost stage/sql/starting 8
3455 user4 localhost stage/sql/checking permissions 4
3456 user4 localhost stage/sql/closing tables 11
3457 user4 localhost stage/sql/init 3
3458 user4 localhost stage/sql/Opening tables 7
3459 user4 localhost stage/sql/starting 8
3460 execute dump_stages_user;
3461 user event_name count_star
3462 user1 stage/sql/checking permissions 4
3463 user1 stage/sql/closing tables 12
3464 user1 stage/sql/init 3
3465 user1 stage/sql/Opening tables 8
3466 user1 stage/sql/starting 8
3467 user2 stage/sql/checking permissions 4
3468 user2 stage/sql/closing tables 11
3469 user2 stage/sql/init 3
3470 user2 stage/sql/Opening tables 7
3471 user2 stage/sql/starting 8
3472 user3 stage/sql/checking permissions 4
3473 user3 stage/sql/closing tables 11
3474 user3 stage/sql/init 3
3475 user3 stage/sql/Opening tables 7
3476 user3 stage/sql/starting 8
3477 user4 stage/sql/checking permissions 4
3478 user4 stage/sql/closing tables 11
3479 user4 stage/sql/init 3
3480 user4 stage/sql/Opening tables 7
3481 user4 stage/sql/starting 8
3482 execute dump_stages_host;
3483 host event_name count_star
3484 localhost stage/sql/checking permissions 16
3485 localhost stage/sql/closing tables 45
3486 localhost stage/sql/init 12
3487 localhost stage/sql/Opening tables 29
3488 localhost stage/sql/starting 32
3489 execute dump_stages_global;
3490 event_name count_star
3491 stage/sql/checking permissions 16
3492 stage/sql/closing tables 45
3493 stage/sql/init 12
3494 stage/sql/Opening tables 29
3495 stage/sql/starting 32
3496 execute dump_stages_history;
3497 event_name count(event_name)
3498 stage/sql/checking permissions 16
3499 stage/sql/closing tables 45
3500 stage/sql/init 12
3501 stage/sql/Opening tables 29
3502 stage/sql/starting 32
3503 execute dump_statements_account;
3504 user host event_name count_star
3505 user1 localhost statement/com/Error 0
3506 user1 localhost statement/com/Quit 1
3507 user1 localhost statement/sp/freturn 1
3508 user1 localhost statement/sql/insert 1
3509 user1 localhost statement/sql/select 3
3510 user2 localhost statement/com/Error 0
3511 user2 localhost statement/com/Quit 1
3512 user2 localhost statement/sp/freturn 1
3513 user2 localhost statement/sql/insert 1
3514 user2 localhost statement/sql/select 3
3515 user3 localhost statement/com/Error 0
3516 user3 localhost statement/com/Quit 1
3517 user3 localhost statement/sp/freturn 1
3518 user3 localhost statement/sql/insert 1
3519 user3 localhost statement/sql/select 3
3520 user4 localhost statement/com/Error 0
3521 user4 localhost statement/com/Quit 1
3522 user4 localhost statement/sp/freturn 1
3523 user4 localhost statement/sql/insert 1
3524 user4 localhost statement/sql/select 3
3525 execute dump_statements_user;
3526 user event_name count_star
3527 user1 statement/com/Error 0
3528 user1 statement/com/Quit 1
3529 user1 statement/sp/freturn 1
3530 user1 statement/sql/insert 1
3531 user1 statement/sql/select 3
3532 user2 statement/com/Error 0
3533 user2 statement/com/Quit 1
3534 user2 statement/sp/freturn 1
3535 user2 statement/sql/insert 1
3536 user2 statement/sql/select 3
3537 user3 statement/com/Error 0
3538 user3 statement/com/Quit 1
3539 user3 statement/sp/freturn 1
3540 user3 statement/sql/insert 1
3541 user3 statement/sql/select 3
3542 user4 statement/com/Error 0
3543 user4 statement/com/Quit 1
3544 user4 statement/sp/freturn 1
3545 user4 statement/sql/insert 1
3546 user4 statement/sql/select 3
3547 execute dump_statements_host;
3548 host event_name count_star
3549 localhost statement/com/Error 0
3550 localhost statement/com/Quit 4
3551 localhost statement/sp/freturn 4
3552 localhost statement/sql/insert 4
3553 localhost statement/sql/select 12
3554 execute dump_statements_global;
3555 event_name count_star
3556 statement/com/Error 0
3557 statement/com/Quit 4
3558 statement/sp/freturn 4
3559 statement/sql/insert 4
3560 statement/sql/select 12
3561 execute dump_statements_history;
3562 event_name count(event_name)
3563 statement/com/Quit 4
3564 statement/sp/freturn 4
3565 statement/sql/insert 4
3566 statement/sql/select 12
3567 execute dump_transactions_account;
3568 user host event_name count_star
3569 user1 localhost transaction 3
3570 user2 localhost transaction 3
3571 user3 localhost transaction 3
3572 user4 localhost transaction 3
3573 execute dump_transactions_user;
3574 user event_name count_star
3575 user1 transaction 3
3576 user2 transaction 3
3577 user3 transaction 3
3578 user4 transaction 3
3579 execute dump_transactions_host;
3580 host event_name count_star
3581 localhost transaction 12
3582 execute dump_transactions_global;
3583 event_name count_star
3584 transaction 12
3585 execute dump_transactions_history;
3586 event_name count(event_name)
3587 transaction 12
3588 execute dump_accounts;
3589 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3590 root localhost 1 1
3591 user1 localhost 0 1
3592 user2 localhost 0 1
3593 user3 localhost 0 1
3594 user4 localhost 0 1
3595 execute dump_users;
3596 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3597 root 1 1
3598 user1 0 1
3599 user2 0 1
3600 user3 0 1
3601 user4 0 1
3602 execute dump_hosts;
3603 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3604 localhost 1 5
3605 truncate performance_schema.events_stages_summary_by_account_by_event_name;
3606 "================== STAGES_BY_ACCOUNT truncated =================="
3607 "================== Step 20 =================="
3608 call dump_thread();
3609 username status
3610 user1 not found
3611 username status
3612 user2 not found
3613 username status
3614 user3 not found
3615 username status
3616 user4 not found
3617 execute dump_waits_account;
3618 user host event_name count_star
3619 user1 localhost wait/io/file/sql/query_log 0
3620 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
3621 user2 localhost wait/io/file/sql/query_log 0
3622 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
3623 user3 localhost wait/io/file/sql/query_log 0
3624 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
3625 user4 localhost wait/io/file/sql/query_log 0
3626 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
3627 execute dump_waits_user;
3628 user event_name count_star
3629 user1 wait/io/file/sql/query_log 0
3630 user1 wait/synch/rwlock/sql/LOCK_grant 0
3631 user2 wait/io/file/sql/query_log 0
3632 user2 wait/synch/rwlock/sql/LOCK_grant 0
3633 user3 wait/io/file/sql/query_log 0
3634 user3 wait/synch/rwlock/sql/LOCK_grant 0
3635 user4 wait/io/file/sql/query_log 0
3636 user4 wait/synch/rwlock/sql/LOCK_grant 0
3637 execute dump_waits_host;
3638 host event_name count_star
3639 localhost wait/io/file/sql/query_log 0
3640 localhost wait/synch/rwlock/sql/LOCK_grant 0
3641 execute dump_waits_global;
3642 event_name count_star
3643 wait/io/file/sql/query_log 0
3644 wait/synch/rwlock/sql/LOCK_grant 0
3645 execute dump_waits_history;
3646 event_name count(event_name)
3647 wait/io/file/sql/query_log 32
3648 wait/synch/rwlock/sql/LOCK_grant 4
3649 execute dump_stages_account;
3650 user host event_name count_star
3651 user1 localhost stage/sql/checking permissions 0
3652 user1 localhost stage/sql/closing tables 0
3653 user1 localhost stage/sql/init 0
3654 user1 localhost stage/sql/Opening tables 0
3655 user1 localhost stage/sql/starting 0
3656 user2 localhost stage/sql/checking permissions 0
3657 user2 localhost stage/sql/closing tables 0
3658 user2 localhost stage/sql/init 0
3659 user2 localhost stage/sql/Opening tables 0
3660 user2 localhost stage/sql/starting 0
3661 user3 localhost stage/sql/checking permissions 0
3662 user3 localhost stage/sql/closing tables 0
3663 user3 localhost stage/sql/init 0
3664 user3 localhost stage/sql/Opening tables 0
3665 user3 localhost stage/sql/starting 0
3666 user4 localhost stage/sql/checking permissions 0
3667 user4 localhost stage/sql/closing tables 0
3668 user4 localhost stage/sql/init 0
3669 user4 localhost stage/sql/Opening tables 0
3670 user4 localhost stage/sql/starting 0
3671 execute dump_stages_user;
3672 user event_name count_star
3673 user1 stage/sql/checking permissions 4
3674 user1 stage/sql/closing tables 12
3675 user1 stage/sql/init 3
3676 user1 stage/sql/Opening tables 8
3677 user1 stage/sql/starting 8
3678 user2 stage/sql/checking permissions 4
3679 user2 stage/sql/closing tables 11
3680 user2 stage/sql/init 3
3681 user2 stage/sql/Opening tables 7
3682 user2 stage/sql/starting 8
3683 user3 stage/sql/checking permissions 4
3684 user3 stage/sql/closing tables 11
3685 user3 stage/sql/init 3
3686 user3 stage/sql/Opening tables 7
3687 user3 stage/sql/starting 8
3688 user4 stage/sql/checking permissions 4
3689 user4 stage/sql/closing tables 11
3690 user4 stage/sql/init 3
3691 user4 stage/sql/Opening tables 7
3692 user4 stage/sql/starting 8
3693 execute dump_stages_host;
3694 host event_name count_star
3695 localhost stage/sql/checking permissions 16
3696 localhost stage/sql/closing tables 45
3697 localhost stage/sql/init 12
3698 localhost stage/sql/Opening tables 29
3699 localhost stage/sql/starting 32
3700 execute dump_stages_global;
3701 event_name count_star
3702 stage/sql/checking permissions 16
3703 stage/sql/closing tables 45
3704 stage/sql/init 12
3705 stage/sql/Opening tables 29
3706 stage/sql/starting 32
3707 execute dump_stages_history;
3708 event_name count(event_name)
3709 stage/sql/checking permissions 16
3710 stage/sql/closing tables 45
3711 stage/sql/init 12
3712 stage/sql/Opening tables 29
3713 stage/sql/starting 32
3714 execute dump_statements_account;
3715 user host event_name count_star
3716 user1 localhost statement/com/Error 0
3717 user1 localhost statement/com/Quit 1
3718 user1 localhost statement/sp/freturn 1
3719 user1 localhost statement/sql/insert 1
3720 user1 localhost statement/sql/select 3
3721 user2 localhost statement/com/Error 0
3722 user2 localhost statement/com/Quit 1
3723 user2 localhost statement/sp/freturn 1
3724 user2 localhost statement/sql/insert 1
3725 user2 localhost statement/sql/select 3
3726 user3 localhost statement/com/Error 0
3727 user3 localhost statement/com/Quit 1
3728 user3 localhost statement/sp/freturn 1
3729 user3 localhost statement/sql/insert 1
3730 user3 localhost statement/sql/select 3
3731 user4 localhost statement/com/Error 0
3732 user4 localhost statement/com/Quit 1
3733 user4 localhost statement/sp/freturn 1
3734 user4 localhost statement/sql/insert 1
3735 user4 localhost statement/sql/select 3
3736 execute dump_statements_user;
3737 user event_name count_star
3738 user1 statement/com/Error 0
3739 user1 statement/com/Quit 1
3740 user1 statement/sp/freturn 1
3741 user1 statement/sql/insert 1
3742 user1 statement/sql/select 3
3743 user2 statement/com/Error 0
3744 user2 statement/com/Quit 1
3745 user2 statement/sp/freturn 1
3746 user2 statement/sql/insert 1
3747 user2 statement/sql/select 3
3748 user3 statement/com/Error 0
3749 user3 statement/com/Quit 1
3750 user3 statement/sp/freturn 1
3751 user3 statement/sql/insert 1
3752 user3 statement/sql/select 3
3753 user4 statement/com/Error 0
3754 user4 statement/com/Quit 1
3755 user4 statement/sp/freturn 1
3756 user4 statement/sql/insert 1
3757 user4 statement/sql/select 3
3758 execute dump_statements_host;
3759 host event_name count_star
3760 localhost statement/com/Error 0
3761 localhost statement/com/Quit 4
3762 localhost statement/sp/freturn 4
3763 localhost statement/sql/insert 4
3764 localhost statement/sql/select 12
3765 execute dump_statements_global;
3766 event_name count_star
3767 statement/com/Error 0
3768 statement/com/Quit 4
3769 statement/sp/freturn 4
3770 statement/sql/insert 4
3771 statement/sql/select 12
3772 execute dump_statements_history;
3773 event_name count(event_name)
3774 statement/com/Quit 4
3775 statement/sp/freturn 4
3776 statement/sql/insert 4
3777 statement/sql/select 12
3778 execute dump_transactions_account;
3779 user host event_name count_star
3780 user1 localhost transaction 3
3781 user2 localhost transaction 3
3782 user3 localhost transaction 3
3783 user4 localhost transaction 3
3784 execute dump_transactions_user;
3785 user event_name count_star
3786 user1 transaction 3
3787 user2 transaction 3
3788 user3 transaction 3
3789 user4 transaction 3
3790 execute dump_transactions_host;
3791 host event_name count_star
3792 localhost transaction 12
3793 execute dump_transactions_global;
3794 event_name count_star
3795 transaction 12
3796 execute dump_transactions_history;
3797 event_name count(event_name)
3798 transaction 12
3799 execute dump_accounts;
3800 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3801 root localhost 1 1
3802 user1 localhost 0 1
3803 user2 localhost 0 1
3804 user3 localhost 0 1
3805 user4 localhost 0 1
3806 execute dump_users;
3807 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3808 root 1 1
3809 user1 0 1
3810 user2 0 1
3811 user3 0 1
3812 user4 0 1
3813 execute dump_hosts;
3814 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3815 localhost 1 5
3816 truncate performance_schema.events_stages_summary_by_user_by_event_name;
3817 "================== STAGES_BY_USER truncated =================="
3818 "================== Step 21 =================="
3819 call dump_thread();
3820 username status
3821 user1 not found
3822 username status
3823 user2 not found
3824 username status
3825 user3 not found
3826 username status
3827 user4 not found
3828 execute dump_waits_account;
3829 user host event_name count_star
3830 user1 localhost wait/io/file/sql/query_log 0
3831 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
3832 user2 localhost wait/io/file/sql/query_log 0
3833 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
3834 user3 localhost wait/io/file/sql/query_log 0
3835 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
3836 user4 localhost wait/io/file/sql/query_log 0
3837 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
3838 execute dump_waits_user;
3839 user event_name count_star
3840 user1 wait/io/file/sql/query_log 0
3841 user1 wait/synch/rwlock/sql/LOCK_grant 0
3842 user2 wait/io/file/sql/query_log 0
3843 user2 wait/synch/rwlock/sql/LOCK_grant 0
3844 user3 wait/io/file/sql/query_log 0
3845 user3 wait/synch/rwlock/sql/LOCK_grant 0
3846 user4 wait/io/file/sql/query_log 0
3847 user4 wait/synch/rwlock/sql/LOCK_grant 0
3848 execute dump_waits_host;
3849 host event_name count_star
3850 localhost wait/io/file/sql/query_log 0
3851 localhost wait/synch/rwlock/sql/LOCK_grant 0
3852 execute dump_waits_global;
3853 event_name count_star
3854 wait/io/file/sql/query_log 0
3855 wait/synch/rwlock/sql/LOCK_grant 0
3856 execute dump_waits_history;
3857 event_name count(event_name)
3858 wait/io/file/sql/query_log 32
3859 wait/synch/rwlock/sql/LOCK_grant 4
3860 execute dump_stages_account;
3861 user host event_name count_star
3862 user1 localhost stage/sql/checking permissions 0
3863 user1 localhost stage/sql/closing tables 0
3864 user1 localhost stage/sql/init 0
3865 user1 localhost stage/sql/Opening tables 0
3866 user1 localhost stage/sql/starting 0
3867 user2 localhost stage/sql/checking permissions 0
3868 user2 localhost stage/sql/closing tables 0
3869 user2 localhost stage/sql/init 0
3870 user2 localhost stage/sql/Opening tables 0
3871 user2 localhost stage/sql/starting 0
3872 user3 localhost stage/sql/checking permissions 0
3873 user3 localhost stage/sql/closing tables 0
3874 user3 localhost stage/sql/init 0
3875 user3 localhost stage/sql/Opening tables 0
3876 user3 localhost stage/sql/starting 0
3877 user4 localhost stage/sql/checking permissions 0
3878 user4 localhost stage/sql/closing tables 0
3879 user4 localhost stage/sql/init 0
3880 user4 localhost stage/sql/Opening tables 0
3881 user4 localhost stage/sql/starting 0
3882 execute dump_stages_user;
3883 user event_name count_star
3884 user1 stage/sql/checking permissions 0
3885 user1 stage/sql/closing tables 0
3886 user1 stage/sql/init 0
3887 user1 stage/sql/Opening tables 0
3888 user1 stage/sql/starting 0
3889 user2 stage/sql/checking permissions 0
3890 user2 stage/sql/closing tables 0
3891 user2 stage/sql/init 0
3892 user2 stage/sql/Opening tables 0
3893 user2 stage/sql/starting 0
3894 user3 stage/sql/checking permissions 0
3895 user3 stage/sql/closing tables 0
3896 user3 stage/sql/init 0
3897 user3 stage/sql/Opening tables 0
3898 user3 stage/sql/starting 0
3899 user4 stage/sql/checking permissions 0
3900 user4 stage/sql/closing tables 0
3901 user4 stage/sql/init 0
3902 user4 stage/sql/Opening tables 0
3903 user4 stage/sql/starting 0
3904 execute dump_stages_host;
3905 host event_name count_star
3906 localhost stage/sql/checking permissions 16
3907 localhost stage/sql/closing tables 45
3908 localhost stage/sql/init 12
3909 localhost stage/sql/Opening tables 29
3910 localhost stage/sql/starting 32
3911 execute dump_stages_global;
3912 event_name count_star
3913 stage/sql/checking permissions 16
3914 stage/sql/closing tables 45
3915 stage/sql/init 12
3916 stage/sql/Opening tables 29
3917 stage/sql/starting 32
3918 execute dump_stages_history;
3919 event_name count(event_name)
3920 stage/sql/checking permissions 16
3921 stage/sql/closing tables 45
3922 stage/sql/init 12
3923 stage/sql/Opening tables 29
3924 stage/sql/starting 32
3925 execute dump_statements_account;
3926 user host event_name count_star
3927 user1 localhost statement/com/Error 0
3928 user1 localhost statement/com/Quit 1
3929 user1 localhost statement/sp/freturn 1
3930 user1 localhost statement/sql/insert 1
3931 user1 localhost statement/sql/select 3
3932 user2 localhost statement/com/Error 0
3933 user2 localhost statement/com/Quit 1
3934 user2 localhost statement/sp/freturn 1
3935 user2 localhost statement/sql/insert 1
3936 user2 localhost statement/sql/select 3
3937 user3 localhost statement/com/Error 0
3938 user3 localhost statement/com/Quit 1
3939 user3 localhost statement/sp/freturn 1
3940 user3 localhost statement/sql/insert 1
3941 user3 localhost statement/sql/select 3
3942 user4 localhost statement/com/Error 0
3943 user4 localhost statement/com/Quit 1
3944 user4 localhost statement/sp/freturn 1
3945 user4 localhost statement/sql/insert 1
3946 user4 localhost statement/sql/select 3
3947 execute dump_statements_user;
3948 user event_name count_star
3949 user1 statement/com/Error 0
3950 user1 statement/com/Quit 1
3951 user1 statement/sp/freturn 1
3952 user1 statement/sql/insert 1
3953 user1 statement/sql/select 3
3954 user2 statement/com/Error 0
3955 user2 statement/com/Quit 1
3956 user2 statement/sp/freturn 1
3957 user2 statement/sql/insert 1
3958 user2 statement/sql/select 3
3959 user3 statement/com/Error 0
3960 user3 statement/com/Quit 1
3961 user3 statement/sp/freturn 1
3962 user3 statement/sql/insert 1
3963 user3 statement/sql/select 3
3964 user4 statement/com/Error 0
3965 user4 statement/com/Quit 1
3966 user4 statement/sp/freturn 1
3967 user4 statement/sql/insert 1
3968 user4 statement/sql/select 3
3969 execute dump_statements_host;
3970 host event_name count_star
3971 localhost statement/com/Error 0
3972 localhost statement/com/Quit 4
3973 localhost statement/sp/freturn 4
3974 localhost statement/sql/insert 4
3975 localhost statement/sql/select 12
3976 execute dump_statements_global;
3977 event_name count_star
3978 statement/com/Error 0
3979 statement/com/Quit 4
3980 statement/sp/freturn 4
3981 statement/sql/insert 4
3982 statement/sql/select 12
3983 execute dump_statements_history;
3984 event_name count(event_name)
3985 statement/com/Quit 4
3986 statement/sp/freturn 4
3987 statement/sql/insert 4
3988 statement/sql/select 12
3989 execute dump_transactions_account;
3990 user host event_name count_star
3991 user1 localhost transaction 3
3992 user2 localhost transaction 3
3993 user3 localhost transaction 3
3994 user4 localhost transaction 3
3995 execute dump_transactions_user;
3996 user event_name count_star
3997 user1 transaction 3
3998 user2 transaction 3
3999 user3 transaction 3
4000 user4 transaction 3
4001 execute dump_transactions_host;
4002 host event_name count_star
4003 localhost transaction 12
4004 execute dump_transactions_global;
4005 event_name count_star
4006 transaction 12
4007 execute dump_transactions_history;
4008 event_name count(event_name)
4009 transaction 12
4010 execute dump_accounts;
4011 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4012 root localhost 1 1
4013 user1 localhost 0 1
4014 user2 localhost 0 1
4015 user3 localhost 0 1
4016 user4 localhost 0 1
4017 execute dump_users;
4018 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4019 root 1 1
4020 user1 0 1
4021 user2 0 1
4022 user3 0 1
4023 user4 0 1
4024 execute dump_hosts;
4025 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4026 localhost 1 5
4027 truncate performance_schema.events_stages_summary_by_host_by_event_name;
4028 "================== STAGES_BY_HOST truncated =================="
4029 "================== Step 22 =================="
4030 call dump_thread();
4031 username status
4032 user1 not found
4033 username status
4034 user2 not found
4035 username status
4036 user3 not found
4037 username status
4038 user4 not found
4039 execute dump_waits_account;
4040 user host event_name count_star
4041 user1 localhost wait/io/file/sql/query_log 0
4042 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
4043 user2 localhost wait/io/file/sql/query_log 0
4044 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
4045 user3 localhost wait/io/file/sql/query_log 0
4046 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
4047 user4 localhost wait/io/file/sql/query_log 0
4048 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
4049 execute dump_waits_user;
4050 user event_name count_star
4051 user1 wait/io/file/sql/query_log 0
4052 user1 wait/synch/rwlock/sql/LOCK_grant 0
4053 user2 wait/io/file/sql/query_log 0
4054 user2 wait/synch/rwlock/sql/LOCK_grant 0
4055 user3 wait/io/file/sql/query_log 0
4056 user3 wait/synch/rwlock/sql/LOCK_grant 0
4057 user4 wait/io/file/sql/query_log 0
4058 user4 wait/synch/rwlock/sql/LOCK_grant 0
4059 execute dump_waits_host;
4060 host event_name count_star
4061 localhost wait/io/file/sql/query_log 0
4062 localhost wait/synch/rwlock/sql/LOCK_grant 0
4063 execute dump_waits_global;
4064 event_name count_star
4065 wait/io/file/sql/query_log 0
4066 wait/synch/rwlock/sql/LOCK_grant 0
4067 execute dump_waits_history;
4068 event_name count(event_name)
4069 wait/io/file/sql/query_log 32
4070 wait/synch/rwlock/sql/LOCK_grant 4
4071 execute dump_stages_account;
4072 user host event_name count_star
4073 user1 localhost stage/sql/checking permissions 0
4074 user1 localhost stage/sql/closing tables 0
4075 user1 localhost stage/sql/init 0
4076 user1 localhost stage/sql/Opening tables 0
4077 user1 localhost stage/sql/starting 0
4078 user2 localhost stage/sql/checking permissions 0
4079 user2 localhost stage/sql/closing tables 0
4080 user2 localhost stage/sql/init 0
4081 user2 localhost stage/sql/Opening tables 0
4082 user2 localhost stage/sql/starting 0
4083 user3 localhost stage/sql/checking permissions 0
4084 user3 localhost stage/sql/closing tables 0
4085 user3 localhost stage/sql/init 0
4086 user3 localhost stage/sql/Opening tables 0
4087 user3 localhost stage/sql/starting 0
4088 user4 localhost stage/sql/checking permissions 0
4089 user4 localhost stage/sql/closing tables 0
4090 user4 localhost stage/sql/init 0
4091 user4 localhost stage/sql/Opening tables 0
4092 user4 localhost stage/sql/starting 0
4093 execute dump_stages_user;
4094 user event_name count_star
4095 user1 stage/sql/checking permissions 0
4096 user1 stage/sql/closing tables 0
4097 user1 stage/sql/init 0
4098 user1 stage/sql/Opening tables 0
4099 user1 stage/sql/starting 0
4100 user2 stage/sql/checking permissions 0
4101 user2 stage/sql/closing tables 0
4102 user2 stage/sql/init 0
4103 user2 stage/sql/Opening tables 0
4104 user2 stage/sql/starting 0
4105 user3 stage/sql/checking permissions 0
4106 user3 stage/sql/closing tables 0
4107 user3 stage/sql/init 0
4108 user3 stage/sql/Opening tables 0
4109 user3 stage/sql/starting 0
4110 user4 stage/sql/checking permissions 0
4111 user4 stage/sql/closing tables 0
4112 user4 stage/sql/init 0
4113 user4 stage/sql/Opening tables 0
4114 user4 stage/sql/starting 0
4115 execute dump_stages_host;
4116 host event_name count_star
4117 localhost stage/sql/checking permissions 0
4118 localhost stage/sql/closing tables 0
4119 localhost stage/sql/init 0
4120 localhost stage/sql/Opening tables 0
4121 localhost stage/sql/starting 0
4122 execute dump_stages_global;
4123 event_name count_star
4124 stage/sql/checking permissions 16
4125 stage/sql/closing tables 45
4126 stage/sql/init 12
4127 stage/sql/Opening tables 29
4128 stage/sql/starting 32
4129 execute dump_stages_history;
4130 event_name count(event_name)
4131 stage/sql/checking permissions 16
4132 stage/sql/closing tables 45
4133 stage/sql/init 12
4134 stage/sql/Opening tables 29
4135 stage/sql/starting 32
4136 execute dump_statements_account;
4137 user host event_name count_star
4138 user1 localhost statement/com/Error 0
4139 user1 localhost statement/com/Quit 1
4140 user1 localhost statement/sp/freturn 1
4141 user1 localhost statement/sql/insert 1
4142 user1 localhost statement/sql/select 3
4143 user2 localhost statement/com/Error 0
4144 user2 localhost statement/com/Quit 1
4145 user2 localhost statement/sp/freturn 1
4146 user2 localhost statement/sql/insert 1
4147 user2 localhost statement/sql/select 3
4148 user3 localhost statement/com/Error 0
4149 user3 localhost statement/com/Quit 1
4150 user3 localhost statement/sp/freturn 1
4151 user3 localhost statement/sql/insert 1
4152 user3 localhost statement/sql/select 3
4153 user4 localhost statement/com/Error 0
4154 user4 localhost statement/com/Quit 1
4155 user4 localhost statement/sp/freturn 1
4156 user4 localhost statement/sql/insert 1
4157 user4 localhost statement/sql/select 3
4158 execute dump_statements_user;
4159 user event_name count_star
4160 user1 statement/com/Error 0
4161 user1 statement/com/Quit 1
4162 user1 statement/sp/freturn 1
4163 user1 statement/sql/insert 1
4164 user1 statement/sql/select 3
4165 user2 statement/com/Error 0
4166 user2 statement/com/Quit 1
4167 user2 statement/sp/freturn 1
4168 user2 statement/sql/insert 1
4169 user2 statement/sql/select 3
4170 user3 statement/com/Error 0
4171 user3 statement/com/Quit 1
4172 user3 statement/sp/freturn 1
4173 user3 statement/sql/insert 1
4174 user3 statement/sql/select 3
4175 user4 statement/com/Error 0
4176 user4 statement/com/Quit 1
4177 user4 statement/sp/freturn 1
4178 user4 statement/sql/insert 1
4179 user4 statement/sql/select 3
4180 execute dump_statements_host;
4181 host event_name count_star
4182 localhost statement/com/Error 0
4183 localhost statement/com/Quit 4
4184 localhost statement/sp/freturn 4
4185 localhost statement/sql/insert 4
4186 localhost statement/sql/select 12
4187 execute dump_statements_global;
4188 event_name count_star
4189 statement/com/Error 0
4190 statement/com/Quit 4
4191 statement/sp/freturn 4
4192 statement/sql/insert 4
4193 statement/sql/select 12
4194 execute dump_statements_history;
4195 event_name count(event_name)
4196 statement/com/Quit 4
4197 statement/sp/freturn 4
4198 statement/sql/insert 4
4199 statement/sql/select 12
4200 execute dump_transactions_account;
4201 user host event_name count_star
4202 user1 localhost transaction 3
4203 user2 localhost transaction 3
4204 user3 localhost transaction 3
4205 user4 localhost transaction 3
4206 execute dump_transactions_user;
4207 user event_name count_star
4208 user1 transaction 3
4209 user2 transaction 3
4210 user3 transaction 3
4211 user4 transaction 3
4212 execute dump_transactions_host;
4213 host event_name count_star
4214 localhost transaction 12
4215 execute dump_transactions_global;
4216 event_name count_star
4217 transaction 12
4218 execute dump_transactions_history;
4219 event_name count(event_name)
4220 transaction 12
4221 execute dump_accounts;
4222 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4223 root localhost 1 1
4224 user1 localhost 0 1
4225 user2 localhost 0 1
4226 user3 localhost 0 1
4227 user4 localhost 0 1
4228 execute dump_users;
4229 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4230 root 1 1
4231 user1 0 1
4232 user2 0 1
4233 user3 0 1
4234 user4 0 1
4235 execute dump_hosts;
4236 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4237 localhost 1 5
4238 truncate performance_schema.events_stages_summary_global_by_event_name;
4239 "================== STAGES_GLOBAL truncated =================="
4240 "================== Step 23 =================="
4241 call dump_thread();
4242 username status
4243 user1 not found
4244 username status
4245 user2 not found
4246 username status
4247 user3 not found
4248 username status
4249 user4 not found
4250 execute dump_waits_account;
4251 user host event_name count_star
4252 user1 localhost wait/io/file/sql/query_log 0
4253 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
4254 user2 localhost wait/io/file/sql/query_log 0
4255 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
4256 user3 localhost wait/io/file/sql/query_log 0
4257 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
4258 user4 localhost wait/io/file/sql/query_log 0
4259 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
4260 execute dump_waits_user;
4261 user event_name count_star
4262 user1 wait/io/file/sql/query_log 0
4263 user1 wait/synch/rwlock/sql/LOCK_grant 0
4264 user2 wait/io/file/sql/query_log 0
4265 user2 wait/synch/rwlock/sql/LOCK_grant 0
4266 user3 wait/io/file/sql/query_log 0
4267 user3 wait/synch/rwlock/sql/LOCK_grant 0
4268 user4 wait/io/file/sql/query_log 0
4269 user4 wait/synch/rwlock/sql/LOCK_grant 0
4270 execute dump_waits_host;
4271 host event_name count_star
4272 localhost wait/io/file/sql/query_log 0
4273 localhost wait/synch/rwlock/sql/LOCK_grant 0
4274 execute dump_waits_global;
4275 event_name count_star
4276 wait/io/file/sql/query_log 0
4277 wait/synch/rwlock/sql/LOCK_grant 0
4278 execute dump_waits_history;
4279 event_name count(event_name)
4280 wait/io/file/sql/query_log 32
4281 wait/synch/rwlock/sql/LOCK_grant 4
4282 execute dump_stages_account;
4283 user host event_name count_star
4284 user1 localhost stage/sql/checking permissions 0
4285 user1 localhost stage/sql/closing tables 0
4286 user1 localhost stage/sql/init 0
4287 user1 localhost stage/sql/Opening tables 0
4288 user1 localhost stage/sql/starting 0
4289 user2 localhost stage/sql/checking permissions 0
4290 user2 localhost stage/sql/closing tables 0
4291 user2 localhost stage/sql/init 0
4292 user2 localhost stage/sql/Opening tables 0
4293 user2 localhost stage/sql/starting 0
4294 user3 localhost stage/sql/checking permissions 0
4295 user3 localhost stage/sql/closing tables 0
4296 user3 localhost stage/sql/init 0
4297 user3 localhost stage/sql/Opening tables 0
4298 user3 localhost stage/sql/starting 0
4299 user4 localhost stage/sql/checking permissions 0
4300 user4 localhost stage/sql/closing tables 0
4301 user4 localhost stage/sql/init 0
4302 user4 localhost stage/sql/Opening tables 0
4303 user4 localhost stage/sql/starting 0
4304 execute dump_stages_user;
4305 user event_name count_star
4306 user1 stage/sql/checking permissions 0
4307 user1 stage/sql/closing tables 0
4308 user1 stage/sql/init 0
4309 user1 stage/sql/Opening tables 0
4310 user1 stage/sql/starting 0
4311 user2 stage/sql/checking permissions 0
4312 user2 stage/sql/closing tables 0
4313 user2 stage/sql/init 0
4314 user2 stage/sql/Opening tables 0
4315 user2 stage/sql/starting 0
4316 user3 stage/sql/checking permissions 0
4317 user3 stage/sql/closing tables 0
4318 user3 stage/sql/init 0
4319 user3 stage/sql/Opening tables 0
4320 user3 stage/sql/starting 0
4321 user4 stage/sql/checking permissions 0
4322 user4 stage/sql/closing tables 0
4323 user4 stage/sql/init 0
4324 user4 stage/sql/Opening tables 0
4325 user4 stage/sql/starting 0
4326 execute dump_stages_host;
4327 host event_name count_star
4328 localhost stage/sql/checking permissions 0
4329 localhost stage/sql/closing tables 0
4330 localhost stage/sql/init 0
4331 localhost stage/sql/Opening tables 0
4332 localhost stage/sql/starting 0
4333 execute dump_stages_global;
4334 event_name count_star
4335 stage/sql/checking permissions 0
4336 stage/sql/closing tables 0
4337 stage/sql/init 0
4338 stage/sql/Opening tables 0
4339 stage/sql/starting 0
4340 execute dump_stages_history;
4341 event_name count(event_name)
4342 stage/sql/checking permissions 16
4343 stage/sql/closing tables 45
4344 stage/sql/init 12
4345 stage/sql/Opening tables 29
4346 stage/sql/starting 32
4347 execute dump_statements_account;
4348 user host event_name count_star
4349 user1 localhost statement/com/Error 0
4350 user1 localhost statement/com/Quit 1
4351 user1 localhost statement/sp/freturn 1
4352 user1 localhost statement/sql/insert 1
4353 user1 localhost statement/sql/select 3
4354 user2 localhost statement/com/Error 0
4355 user2 localhost statement/com/Quit 1
4356 user2 localhost statement/sp/freturn 1
4357 user2 localhost statement/sql/insert 1
4358 user2 localhost statement/sql/select 3
4359 user3 localhost statement/com/Error 0
4360 user3 localhost statement/com/Quit 1
4361 user3 localhost statement/sp/freturn 1
4362 user3 localhost statement/sql/insert 1
4363 user3 localhost statement/sql/select 3
4364 user4 localhost statement/com/Error 0
4365 user4 localhost statement/com/Quit 1
4366 user4 localhost statement/sp/freturn 1
4367 user4 localhost statement/sql/insert 1
4368 user4 localhost statement/sql/select 3
4369 execute dump_statements_user;
4370 user event_name count_star
4371 user1 statement/com/Error 0
4372 user1 statement/com/Quit 1
4373 user1 statement/sp/freturn 1
4374 user1 statement/sql/insert 1
4375 user1 statement/sql/select 3
4376 user2 statement/com/Error 0
4377 user2 statement/com/Quit 1
4378 user2 statement/sp/freturn 1
4379 user2 statement/sql/insert 1
4380 user2 statement/sql/select 3
4381 user3 statement/com/Error 0
4382 user3 statement/com/Quit 1
4383 user3 statement/sp/freturn 1
4384 user3 statement/sql/insert 1
4385 user3 statement/sql/select 3
4386 user4 statement/com/Error 0
4387 user4 statement/com/Quit 1
4388 user4 statement/sp/freturn 1
4389 user4 statement/sql/insert 1
4390 user4 statement/sql/select 3
4391 execute dump_statements_host;
4392 host event_name count_star
4393 localhost statement/com/Error 0
4394 localhost statement/com/Quit 4
4395 localhost statement/sp/freturn 4
4396 localhost statement/sql/insert 4
4397 localhost statement/sql/select 12
4398 execute dump_statements_global;
4399 event_name count_star
4400 statement/com/Error 0
4401 statement/com/Quit 4
4402 statement/sp/freturn 4
4403 statement/sql/insert 4
4404 statement/sql/select 12
4405 execute dump_statements_history;
4406 event_name count(event_name)
4407 statement/com/Quit 4
4408 statement/sp/freturn 4
4409 statement/sql/insert 4
4410 statement/sql/select 12
4411 execute dump_transactions_account;
4412 user host event_name count_star
4413 user1 localhost transaction 3
4414 user2 localhost transaction 3
4415 user3 localhost transaction 3
4416 user4 localhost transaction 3
4417 execute dump_transactions_user;
4418 user event_name count_star
4419 user1 transaction 3
4420 user2 transaction 3
4421 user3 transaction 3
4422 user4 transaction 3
4423 execute dump_transactions_host;
4424 host event_name count_star
4425 localhost transaction 12
4426 execute dump_transactions_global;
4427 event_name count_star
4428 transaction 12
4429 execute dump_transactions_history;
4430 event_name count(event_name)
4431 transaction 12
4432 execute dump_accounts;
4433 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4434 root localhost 1 1
4435 user1 localhost 0 1
4436 user2 localhost 0 1
4437 user3 localhost 0 1
4438 user4 localhost 0 1
4439 execute dump_users;
4440 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4441 root 1 1
4442 user1 0 1
4443 user2 0 1
4444 user3 0 1
4445 user4 0 1
4446 execute dump_hosts;
4447 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4448 localhost 1 5
4449 truncate performance_schema.events_statements_summary_by_thread_by_event_name;
4450 "================== STATEMENTS_BY_THREAD truncated =================="
4451 "================== Step 24 =================="
4452 call dump_thread();
4453 username status
4454 user1 not found
4455 username status
4456 user2 not found
4457 username status
4458 user3 not found
4459 username status
4460 user4 not found
4461 execute dump_waits_account;
4462 user host event_name count_star
4463 user1 localhost wait/io/file/sql/query_log 0
4464 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
4465 user2 localhost wait/io/file/sql/query_log 0
4466 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
4467 user3 localhost wait/io/file/sql/query_log 0
4468 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
4469 user4 localhost wait/io/file/sql/query_log 0
4470 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
4471 execute dump_waits_user;
4472 user event_name count_star
4473 user1 wait/io/file/sql/query_log 0
4474 user1 wait/synch/rwlock/sql/LOCK_grant 0
4475 user2 wait/io/file/sql/query_log 0
4476 user2 wait/synch/rwlock/sql/LOCK_grant 0
4477 user3 wait/io/file/sql/query_log 0
4478 user3 wait/synch/rwlock/sql/LOCK_grant 0
4479 user4 wait/io/file/sql/query_log 0
4480 user4 wait/synch/rwlock/sql/LOCK_grant 0
4481 execute dump_waits_host;
4482 host event_name count_star
4483 localhost wait/io/file/sql/query_log 0
4484 localhost wait/synch/rwlock/sql/LOCK_grant 0
4485 execute dump_waits_global;
4486 event_name count_star
4487 wait/io/file/sql/query_log 0
4488 wait/synch/rwlock/sql/LOCK_grant 0
4489 execute dump_waits_history;
4490 event_name count(event_name)
4491 wait/io/file/sql/query_log 32
4492 wait/synch/rwlock/sql/LOCK_grant 4
4493 execute dump_stages_account;
4494 user host event_name count_star
4495 user1 localhost stage/sql/checking permissions 0
4496 user1 localhost stage/sql/closing tables 0
4497 user1 localhost stage/sql/init 0
4498 user1 localhost stage/sql/Opening tables 0
4499 user1 localhost stage/sql/starting 0
4500 user2 localhost stage/sql/checking permissions 0
4501 user2 localhost stage/sql/closing tables 0
4502 user2 localhost stage/sql/init 0
4503 user2 localhost stage/sql/Opening tables 0
4504 user2 localhost stage/sql/starting 0
4505 user3 localhost stage/sql/checking permissions 0
4506 user3 localhost stage/sql/closing tables 0
4507 user3 localhost stage/sql/init 0
4508 user3 localhost stage/sql/Opening tables 0
4509 user3 localhost stage/sql/starting 0
4510 user4 localhost stage/sql/checking permissions 0
4511 user4 localhost stage/sql/closing tables 0
4512 user4 localhost stage/sql/init 0
4513 user4 localhost stage/sql/Opening tables 0
4514 user4 localhost stage/sql/starting 0
4515 execute dump_stages_user;
4516 user event_name count_star
4517 user1 stage/sql/checking permissions 0
4518 user1 stage/sql/closing tables 0
4519 user1 stage/sql/init 0
4520 user1 stage/sql/Opening tables 0
4521 user1 stage/sql/starting 0
4522 user2 stage/sql/checking permissions 0
4523 user2 stage/sql/closing tables 0
4524 user2 stage/sql/init 0
4525 user2 stage/sql/Opening tables 0
4526 user2 stage/sql/starting 0
4527 user3 stage/sql/checking permissions 0
4528 user3 stage/sql/closing tables 0
4529 user3 stage/sql/init 0
4530 user3 stage/sql/Opening tables 0
4531 user3 stage/sql/starting 0
4532 user4 stage/sql/checking permissions 0
4533 user4 stage/sql/closing tables 0
4534 user4 stage/sql/init 0
4535 user4 stage/sql/Opening tables 0
4536 user4 stage/sql/starting 0
4537 execute dump_stages_host;
4538 host event_name count_star
4539 localhost stage/sql/checking permissions 0
4540 localhost stage/sql/closing tables 0
4541 localhost stage/sql/init 0
4542 localhost stage/sql/Opening tables 0
4543 localhost stage/sql/starting 0
4544 execute dump_stages_global;
4545 event_name count_star
4546 stage/sql/checking permissions 0
4547 stage/sql/closing tables 0
4548 stage/sql/init 0
4549 stage/sql/Opening tables 0
4550 stage/sql/starting 0
4551 execute dump_stages_history;
4552 event_name count(event_name)
4553 stage/sql/checking permissions 16
4554 stage/sql/closing tables 45
4555 stage/sql/init 12
4556 stage/sql/Opening tables 29
4557 stage/sql/starting 32
4558 execute dump_statements_account;
4559 user host event_name count_star
4560 user1 localhost statement/com/Error 0
4561 user1 localhost statement/com/Quit 1
4562 user1 localhost statement/sp/freturn 1
4563 user1 localhost statement/sql/insert 1
4564 user1 localhost statement/sql/select 3
4565 user2 localhost statement/com/Error 0
4566 user2 localhost statement/com/Quit 1
4567 user2 localhost statement/sp/freturn 1
4568 user2 localhost statement/sql/insert 1
4569 user2 localhost statement/sql/select 3
4570 user3 localhost statement/com/Error 0
4571 user3 localhost statement/com/Quit 1
4572 user3 localhost statement/sp/freturn 1
4573 user3 localhost statement/sql/insert 1
4574 user3 localhost statement/sql/select 3
4575 user4 localhost statement/com/Error 0
4576 user4 localhost statement/com/Quit 1
4577 user4 localhost statement/sp/freturn 1
4578 user4 localhost statement/sql/insert 1
4579 user4 localhost statement/sql/select 3
4580 execute dump_statements_user;
4581 user event_name count_star
4582 user1 statement/com/Error 0
4583 user1 statement/com/Quit 1
4584 user1 statement/sp/freturn 1
4585 user1 statement/sql/insert 1
4586 user1 statement/sql/select 3
4587 user2 statement/com/Error 0
4588 user2 statement/com/Quit 1
4589 user2 statement/sp/freturn 1
4590 user2 statement/sql/insert 1
4591 user2 statement/sql/select 3
4592 user3 statement/com/Error 0
4593 user3 statement/com/Quit 1
4594 user3 statement/sp/freturn 1
4595 user3 statement/sql/insert 1
4596 user3 statement/sql/select 3
4597 user4 statement/com/Error 0
4598 user4 statement/com/Quit 1
4599 user4 statement/sp/freturn 1
4600 user4 statement/sql/insert 1
4601 user4 statement/sql/select 3
4602 execute dump_statements_host;
4603 host event_name count_star
4604 localhost statement/com/Error 0
4605 localhost statement/com/Quit 4
4606 localhost statement/sp/freturn 4
4607 localhost statement/sql/insert 4
4608 localhost statement/sql/select 12
4609 execute dump_statements_global;
4610 event_name count_star
4611 statement/com/Error 0
4612 statement/com/Quit 4
4613 statement/sp/freturn 4
4614 statement/sql/insert 4
4615 statement/sql/select 12
4616 execute dump_statements_history;
4617 event_name count(event_name)
4618 statement/com/Quit 4
4619 statement/sp/freturn 4
4620 statement/sql/insert 4
4621 statement/sql/select 12
4622 execute dump_transactions_account;
4623 user host event_name count_star
4624 user1 localhost transaction 3
4625 user2 localhost transaction 3
4626 user3 localhost transaction 3
4627 user4 localhost transaction 3
4628 execute dump_transactions_user;
4629 user event_name count_star
4630 user1 transaction 3
4631 user2 transaction 3
4632 user3 transaction 3
4633 user4 transaction 3
4634 execute dump_transactions_host;
4635 host event_name count_star
4636 localhost transaction 12
4637 execute dump_transactions_global;
4638 event_name count_star
4639 transaction 12
4640 execute dump_transactions_history;
4641 event_name count(event_name)
4642 transaction 12
4643 execute dump_accounts;
4644 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4645 root localhost 1 1
4646 user1 localhost 0 1
4647 user2 localhost 0 1
4648 user3 localhost 0 1
4649 user4 localhost 0 1
4650 execute dump_users;
4651 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
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 localhost 1 5
4660 truncate performance_schema.events_statements_summary_by_account_by_event_name;
4661 "================== STATEMENTS_BY_ACCOUNT truncated =================="
4662 "================== Step 25 =================="
4663 call dump_thread();
4664 username status
4665 user1 not found
4666 username status
4667 user2 not found
4668 username status
4669 user3 not found
4670 username status
4671 user4 not found
4672 execute dump_waits_account;
4673 user host event_name count_star
4674 user1 localhost wait/io/file/sql/query_log 0
4675 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
4676 user2 localhost wait/io/file/sql/query_log 0
4677 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
4678 user3 localhost wait/io/file/sql/query_log 0
4679 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
4680 user4 localhost wait/io/file/sql/query_log 0
4681 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
4682 execute dump_waits_user;
4683 user event_name count_star
4684 user1 wait/io/file/sql/query_log 0
4685 user1 wait/synch/rwlock/sql/LOCK_grant 0
4686 user2 wait/io/file/sql/query_log 0
4687 user2 wait/synch/rwlock/sql/LOCK_grant 0
4688 user3 wait/io/file/sql/query_log 0
4689 user3 wait/synch/rwlock/sql/LOCK_grant 0
4690 user4 wait/io/file/sql/query_log 0
4691 user4 wait/synch/rwlock/sql/LOCK_grant 0
4692 execute dump_waits_host;
4693 host event_name count_star
4694 localhost wait/io/file/sql/query_log 0
4695 localhost wait/synch/rwlock/sql/LOCK_grant 0
4696 execute dump_waits_global;
4697 event_name count_star
4698 wait/io/file/sql/query_log 0
4699 wait/synch/rwlock/sql/LOCK_grant 0
4700 execute dump_waits_history;
4701 event_name count(event_name)
4702 wait/io/file/sql/query_log 32
4703 wait/synch/rwlock/sql/LOCK_grant 4
4704 execute dump_stages_account;
4705 user host event_name count_star
4706 user1 localhost stage/sql/checking permissions 0
4707 user1 localhost stage/sql/closing tables 0
4708 user1 localhost stage/sql/init 0
4709 user1 localhost stage/sql/Opening tables 0
4710 user1 localhost stage/sql/starting 0
4711 user2 localhost stage/sql/checking permissions 0
4712 user2 localhost stage/sql/closing tables 0
4713 user2 localhost stage/sql/init 0
4714 user2 localhost stage/sql/Opening tables 0
4715 user2 localhost stage/sql/starting 0
4716 user3 localhost stage/sql/checking permissions 0
4717 user3 localhost stage/sql/closing tables 0
4718 user3 localhost stage/sql/init 0
4719 user3 localhost stage/sql/Opening tables 0
4720 user3 localhost stage/sql/starting 0
4721 user4 localhost stage/sql/checking permissions 0
4722 user4 localhost stage/sql/closing tables 0
4723 user4 localhost stage/sql/init 0
4724 user4 localhost stage/sql/Opening tables 0
4725 user4 localhost stage/sql/starting 0
4726 execute dump_stages_user;
4727 user event_name count_star
4728 user1 stage/sql/checking permissions 0
4729 user1 stage/sql/closing tables 0
4730 user1 stage/sql/init 0
4731 user1 stage/sql/Opening tables 0
4732 user1 stage/sql/starting 0
4733 user2 stage/sql/checking permissions 0
4734 user2 stage/sql/closing tables 0
4735 user2 stage/sql/init 0
4736 user2 stage/sql/Opening tables 0
4737 user2 stage/sql/starting 0
4738 user3 stage/sql/checking permissions 0
4739 user3 stage/sql/closing tables 0
4740 user3 stage/sql/init 0
4741 user3 stage/sql/Opening tables 0
4742 user3 stage/sql/starting 0
4743 user4 stage/sql/checking permissions 0
4744 user4 stage/sql/closing tables 0
4745 user4 stage/sql/init 0
4746 user4 stage/sql/Opening tables 0
4747 user4 stage/sql/starting 0
4748 execute dump_stages_host;
4749 host event_name count_star
4750 localhost stage/sql/checking permissions 0
4751 localhost stage/sql/closing tables 0
4752 localhost stage/sql/init 0
4753 localhost stage/sql/Opening tables 0
4754 localhost stage/sql/starting 0
4755 execute dump_stages_global;
4756 event_name count_star
4757 stage/sql/checking permissions 0
4758 stage/sql/closing tables 0
4759 stage/sql/init 0
4760 stage/sql/Opening tables 0
4761 stage/sql/starting 0
4762 execute dump_stages_history;
4763 event_name count(event_name)
4764 stage/sql/checking permissions 16
4765 stage/sql/closing tables 45
4766 stage/sql/init 12
4767 stage/sql/Opening tables 29
4768 stage/sql/starting 32
4769 execute dump_statements_account;
4770 user host event_name count_star
4771 user1 localhost statement/com/Error 0
4772 user1 localhost statement/com/Quit 0
4773 user1 localhost statement/sp/freturn 0
4774 user1 localhost statement/sql/insert 0
4775 user1 localhost statement/sql/select 0
4776 user2 localhost statement/com/Error 0
4777 user2 localhost statement/com/Quit 0
4778 user2 localhost statement/sp/freturn 0
4779 user2 localhost statement/sql/insert 0
4780 user2 localhost statement/sql/select 0
4781 user3 localhost statement/com/Error 0
4782 user3 localhost statement/com/Quit 0
4783 user3 localhost statement/sp/freturn 0
4784 user3 localhost statement/sql/insert 0
4785 user3 localhost statement/sql/select 0
4786 user4 localhost statement/com/Error 0
4787 user4 localhost statement/com/Quit 0
4788 user4 localhost statement/sp/freturn 0
4789 user4 localhost statement/sql/insert 0
4790 user4 localhost statement/sql/select 0
4791 execute dump_statements_user;
4792 user event_name count_star
4793 user1 statement/com/Error 0
4794 user1 statement/com/Quit 1
4795 user1 statement/sp/freturn 1
4796 user1 statement/sql/insert 1
4797 user1 statement/sql/select 3
4798 user2 statement/com/Error 0
4799 user2 statement/com/Quit 1
4800 user2 statement/sp/freturn 1
4801 user2 statement/sql/insert 1
4802 user2 statement/sql/select 3
4803 user3 statement/com/Error 0
4804 user3 statement/com/Quit 1
4805 user3 statement/sp/freturn 1
4806 user3 statement/sql/insert 1
4807 user3 statement/sql/select 3
4808 user4 statement/com/Error 0
4809 user4 statement/com/Quit 1
4810 user4 statement/sp/freturn 1
4811 user4 statement/sql/insert 1
4812 user4 statement/sql/select 3
4813 execute dump_statements_host;
4814 host event_name count_star
4815 localhost statement/com/Error 0
4816 localhost statement/com/Quit 4
4817 localhost statement/sp/freturn 4
4818 localhost statement/sql/insert 4
4819 localhost statement/sql/select 12
4820 execute dump_statements_global;
4821 event_name count_star
4822 statement/com/Error 0
4823 statement/com/Quit 4
4824 statement/sp/freturn 4
4825 statement/sql/insert 4
4826 statement/sql/select 12
4827 execute dump_statements_history;
4828 event_name count(event_name)
4829 statement/com/Quit 4
4830 statement/sp/freturn 4
4831 statement/sql/insert 4
4832 statement/sql/select 12
4833 execute dump_transactions_account;
4834 user host event_name count_star
4835 user1 localhost transaction 3
4836 user2 localhost transaction 3
4837 user3 localhost transaction 3
4838 user4 localhost transaction 3
4839 execute dump_transactions_user;
4840 user event_name count_star
4841 user1 transaction 3
4842 user2 transaction 3
4843 user3 transaction 3
4844 user4 transaction 3
4845 execute dump_transactions_host;
4846 host event_name count_star
4847 localhost transaction 12
4848 execute dump_transactions_global;
4849 event_name count_star
4850 transaction 12
4851 execute dump_transactions_history;
4852 event_name count(event_name)
4853 transaction 12
4854 execute dump_accounts;
4855 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4856 root localhost 1 1
4857 user1 localhost 0 1
4858 user2 localhost 0 1
4859 user3 localhost 0 1
4860 user4 localhost 0 1
4861 execute dump_users;
4862 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4863 root 1 1
4864 user1 0 1
4865 user2 0 1
4866 user3 0 1
4867 user4 0 1
4868 execute dump_hosts;
4869 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
4870 localhost 1 5
4871 truncate performance_schema.events_statements_summary_by_user_by_event_name;
4872 "================== STATEMENTS_BY_USER truncated =================="
4873 "================== Step 26 =================="
4874 call dump_thread();
4875 username status
4876 user1 not found
4877 username status
4878 user2 not found
4879 username status
4880 user3 not found
4881 username status
4882 user4 not found
4883 execute dump_waits_account;
4884 user host event_name count_star
4885 user1 localhost wait/io/file/sql/query_log 0
4886 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
4887 user2 localhost wait/io/file/sql/query_log 0
4888 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
4889 user3 localhost wait/io/file/sql/query_log 0
4890 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
4891 user4 localhost wait/io/file/sql/query_log 0
4892 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
4893 execute dump_waits_user;
4894 user event_name count_star
4895 user1 wait/io/file/sql/query_log 0
4896 user1 wait/synch/rwlock/sql/LOCK_grant 0
4897 user2 wait/io/file/sql/query_log 0
4898 user2 wait/synch/rwlock/sql/LOCK_grant 0
4899 user3 wait/io/file/sql/query_log 0
4900 user3 wait/synch/rwlock/sql/LOCK_grant 0
4901 user4 wait/io/file/sql/query_log 0
4902 user4 wait/synch/rwlock/sql/LOCK_grant 0
4903 execute dump_waits_host;
4904 host event_name count_star
4905 localhost wait/io/file/sql/query_log 0
4906 localhost wait/synch/rwlock/sql/LOCK_grant 0
4907 execute dump_waits_global;
4908 event_name count_star
4909 wait/io/file/sql/query_log 0
4910 wait/synch/rwlock/sql/LOCK_grant 0
4911 execute dump_waits_history;
4912 event_name count(event_name)
4913 wait/io/file/sql/query_log 32
4914 wait/synch/rwlock/sql/LOCK_grant 4
4915 execute dump_stages_account;
4916 user host event_name count_star
4917 user1 localhost stage/sql/checking permissions 0
4918 user1 localhost stage/sql/closing tables 0
4919 user1 localhost stage/sql/init 0
4920 user1 localhost stage/sql/Opening tables 0
4921 user1 localhost stage/sql/starting 0
4922 user2 localhost stage/sql/checking permissions 0
4923 user2 localhost stage/sql/closing tables 0
4924 user2 localhost stage/sql/init 0
4925 user2 localhost stage/sql/Opening tables 0
4926 user2 localhost stage/sql/starting 0
4927 user3 localhost stage/sql/checking permissions 0
4928 user3 localhost stage/sql/closing tables 0
4929 user3 localhost stage/sql/init 0
4930 user3 localhost stage/sql/Opening tables 0
4931 user3 localhost stage/sql/starting 0
4932 user4 localhost stage/sql/checking permissions 0
4933 user4 localhost stage/sql/closing tables 0
4934 user4 localhost stage/sql/init 0
4935 user4 localhost stage/sql/Opening tables 0
4936 user4 localhost stage/sql/starting 0
4937 execute dump_stages_user;
4938 user event_name count_star
4939 user1 stage/sql/checking permissions 0
4940 user1 stage/sql/closing tables 0
4941 user1 stage/sql/init 0
4942 user1 stage/sql/Opening tables 0
4943 user1 stage/sql/starting 0
4944 user2 stage/sql/checking permissions 0
4945 user2 stage/sql/closing tables 0
4946 user2 stage/sql/init 0
4947 user2 stage/sql/Opening tables 0
4948 user2 stage/sql/starting 0
4949 user3 stage/sql/checking permissions 0
4950 user3 stage/sql/closing tables 0
4951 user3 stage/sql/init 0
4952 user3 stage/sql/Opening tables 0
4953 user3 stage/sql/starting 0
4954 user4 stage/sql/checking permissions 0
4955 user4 stage/sql/closing tables 0
4956 user4 stage/sql/init 0
4957 user4 stage/sql/Opening tables 0
4958 user4 stage/sql/starting 0
4959 execute dump_stages_host;
4960 host event_name count_star
4961 localhost stage/sql/checking permissions 0
4962 localhost stage/sql/closing tables 0
4963 localhost stage/sql/init 0
4964 localhost stage/sql/Opening tables 0
4965 localhost stage/sql/starting 0
4966 execute dump_stages_global;
4967 event_name count_star
4968 stage/sql/checking permissions 0
4969 stage/sql/closing tables 0
4970 stage/sql/init 0
4971 stage/sql/Opening tables 0
4972 stage/sql/starting 0
4973 execute dump_stages_history;
4974 event_name count(event_name)
4975 stage/sql/checking permissions 16
4976 stage/sql/closing tables 45
4977 stage/sql/init 12
4978 stage/sql/Opening tables 29
4979 stage/sql/starting 32
4980 execute dump_statements_account;
4981 user host event_name count_star
4982 user1 localhost statement/com/Error 0
4983 user1 localhost statement/com/Quit 0
4984 user1 localhost statement/sp/freturn 0
4985 user1 localhost statement/sql/insert 0
4986 user1 localhost statement/sql/select 0
4987 user2 localhost statement/com/Error 0
4988 user2 localhost statement/com/Quit 0
4989 user2 localhost statement/sp/freturn 0
4990 user2 localhost statement/sql/insert 0
4991 user2 localhost statement/sql/select 0
4992 user3 localhost statement/com/Error 0
4993 user3 localhost statement/com/Quit 0
4994 user3 localhost statement/sp/freturn 0
4995 user3 localhost statement/sql/insert 0
4996 user3 localhost statement/sql/select 0
4997 user4 localhost statement/com/Error 0
4998 user4 localhost statement/com/Quit 0
4999 user4 localhost statement/sp/freturn 0
5000 user4 localhost statement/sql/insert 0
5001 user4 localhost statement/sql/select 0
5002 execute dump_statements_user;
5003 user event_name count_star
5004 user1 statement/com/Error 0
5005 user1 statement/com/Quit 0
5006 user1 statement/sp/freturn 0
5007 user1 statement/sql/insert 0
5008 user1 statement/sql/select 0
5009 user2 statement/com/Error 0
5010 user2 statement/com/Quit 0
5011 user2 statement/sp/freturn 0
5012 user2 statement/sql/insert 0
5013 user2 statement/sql/select 0
5014 user3 statement/com/Error 0
5015 user3 statement/com/Quit 0
5016 user3 statement/sp/freturn 0
5017 user3 statement/sql/insert 0
5018 user3 statement/sql/select 0
5019 user4 statement/com/Error 0
5020 user4 statement/com/Quit 0
5021 user4 statement/sp/freturn 0
5022 user4 statement/sql/insert 0
5023 user4 statement/sql/select 0
5024 execute dump_statements_host;
5025 host event_name count_star
5026 localhost statement/com/Error 0
5027 localhost statement/com/Quit 4
5028 localhost statement/sp/freturn 4
5029 localhost statement/sql/insert 4
5030 localhost statement/sql/select 12
5031 execute dump_statements_global;
5032 event_name count_star
5033 statement/com/Error 0
5034 statement/com/Quit 4
5035 statement/sp/freturn 4
5036 statement/sql/insert 4
5037 statement/sql/select 12
5038 execute dump_statements_history;
5039 event_name count(event_name)
5040 statement/com/Quit 4
5041 statement/sp/freturn 4
5042 statement/sql/insert 4
5043 statement/sql/select 12
5044 execute dump_transactions_account;
5045 user host event_name count_star
5046 user1 localhost transaction 3
5047 user2 localhost transaction 3
5048 user3 localhost transaction 3
5049 user4 localhost transaction 3
5050 execute dump_transactions_user;
5051 user event_name count_star
5052 user1 transaction 3
5053 user2 transaction 3
5054 user3 transaction 3
5055 user4 transaction 3
5056 execute dump_transactions_host;
5057 host event_name count_star
5058 localhost transaction 12
5059 execute dump_transactions_global;
5060 event_name count_star
5061 transaction 12
5062 execute dump_transactions_history;
5063 event_name count(event_name)
5064 transaction 12
5065 execute dump_accounts;
5066 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5067 root localhost 1 1
5068 user1 localhost 0 1
5069 user2 localhost 0 1
5070 user3 localhost 0 1
5071 user4 localhost 0 1
5072 execute dump_users;
5073 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5074 root 1 1
5075 user1 0 1
5076 user2 0 1
5077 user3 0 1
5078 user4 0 1
5079 execute dump_hosts;
5080 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5081 localhost 1 5
5082 truncate performance_schema.events_statements_summary_by_host_by_event_name;
5083 "================== STATEMENTS_BY_HOST truncated =================="
5084 "================== Step 27 =================="
5085 call dump_thread();
5086 username status
5087 user1 not found
5088 username status
5089 user2 not found
5090 username status
5091 user3 not found
5092 username status
5093 user4 not found
5094 execute dump_waits_account;
5095 user host event_name count_star
5096 user1 localhost wait/io/file/sql/query_log 0
5097 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
5098 user2 localhost wait/io/file/sql/query_log 0
5099 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
5100 user3 localhost wait/io/file/sql/query_log 0
5101 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
5102 user4 localhost wait/io/file/sql/query_log 0
5103 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
5104 execute dump_waits_user;
5105 user event_name count_star
5106 user1 wait/io/file/sql/query_log 0
5107 user1 wait/synch/rwlock/sql/LOCK_grant 0
5108 user2 wait/io/file/sql/query_log 0
5109 user2 wait/synch/rwlock/sql/LOCK_grant 0
5110 user3 wait/io/file/sql/query_log 0
5111 user3 wait/synch/rwlock/sql/LOCK_grant 0
5112 user4 wait/io/file/sql/query_log 0
5113 user4 wait/synch/rwlock/sql/LOCK_grant 0
5114 execute dump_waits_host;
5115 host event_name count_star
5116 localhost wait/io/file/sql/query_log 0
5117 localhost wait/synch/rwlock/sql/LOCK_grant 0
5118 execute dump_waits_global;
5119 event_name count_star
5120 wait/io/file/sql/query_log 0
5121 wait/synch/rwlock/sql/LOCK_grant 0
5122 execute dump_waits_history;
5123 event_name count(event_name)
5124 wait/io/file/sql/query_log 32
5125 wait/synch/rwlock/sql/LOCK_grant 4
5126 execute dump_stages_account;
5127 user host event_name count_star
5128 user1 localhost stage/sql/checking permissions 0
5129 user1 localhost stage/sql/closing tables 0
5130 user1 localhost stage/sql/init 0
5131 user1 localhost stage/sql/Opening tables 0
5132 user1 localhost stage/sql/starting 0
5133 user2 localhost stage/sql/checking permissions 0
5134 user2 localhost stage/sql/closing tables 0
5135 user2 localhost stage/sql/init 0
5136 user2 localhost stage/sql/Opening tables 0
5137 user2 localhost stage/sql/starting 0
5138 user3 localhost stage/sql/checking permissions 0
5139 user3 localhost stage/sql/closing tables 0
5140 user3 localhost stage/sql/init 0
5141 user3 localhost stage/sql/Opening tables 0
5142 user3 localhost stage/sql/starting 0
5143 user4 localhost stage/sql/checking permissions 0
5144 user4 localhost stage/sql/closing tables 0
5145 user4 localhost stage/sql/init 0
5146 user4 localhost stage/sql/Opening tables 0
5147 user4 localhost stage/sql/starting 0
5148 execute dump_stages_user;
5149 user event_name count_star
5150 user1 stage/sql/checking permissions 0
5151 user1 stage/sql/closing tables 0
5152 user1 stage/sql/init 0
5153 user1 stage/sql/Opening tables 0
5154 user1 stage/sql/starting 0
5155 user2 stage/sql/checking permissions 0
5156 user2 stage/sql/closing tables 0
5157 user2 stage/sql/init 0
5158 user2 stage/sql/Opening tables 0
5159 user2 stage/sql/starting 0
5160 user3 stage/sql/checking permissions 0
5161 user3 stage/sql/closing tables 0
5162 user3 stage/sql/init 0
5163 user3 stage/sql/Opening tables 0
5164 user3 stage/sql/starting 0
5165 user4 stage/sql/checking permissions 0
5166 user4 stage/sql/closing tables 0
5167 user4 stage/sql/init 0
5168 user4 stage/sql/Opening tables 0
5169 user4 stage/sql/starting 0
5170 execute dump_stages_host;
5171 host event_name count_star
5172 localhost stage/sql/checking permissions 0
5173 localhost stage/sql/closing tables 0
5174 localhost stage/sql/init 0
5175 localhost stage/sql/Opening tables 0
5176 localhost stage/sql/starting 0
5177 execute dump_stages_global;
5178 event_name count_star
5179 stage/sql/checking permissions 0
5180 stage/sql/closing tables 0
5181 stage/sql/init 0
5182 stage/sql/Opening tables 0
5183 stage/sql/starting 0
5184 execute dump_stages_history;
5185 event_name count(event_name)
5186 stage/sql/checking permissions 16
5187 stage/sql/closing tables 45
5188 stage/sql/init 12
5189 stage/sql/Opening tables 29
5190 stage/sql/starting 32
5191 execute dump_statements_account;
5192 user host event_name count_star
5193 user1 localhost statement/com/Error 0
5194 user1 localhost statement/com/Quit 0
5195 user1 localhost statement/sp/freturn 0
5196 user1 localhost statement/sql/insert 0
5197 user1 localhost statement/sql/select 0
5198 user2 localhost statement/com/Error 0
5199 user2 localhost statement/com/Quit 0
5200 user2 localhost statement/sp/freturn 0
5201 user2 localhost statement/sql/insert 0
5202 user2 localhost statement/sql/select 0
5203 user3 localhost statement/com/Error 0
5204 user3 localhost statement/com/Quit 0
5205 user3 localhost statement/sp/freturn 0
5206 user3 localhost statement/sql/insert 0
5207 user3 localhost statement/sql/select 0
5208 user4 localhost statement/com/Error 0
5209 user4 localhost statement/com/Quit 0
5210 user4 localhost statement/sp/freturn 0
5211 user4 localhost statement/sql/insert 0
5212 user4 localhost statement/sql/select 0
5213 execute dump_statements_user;
5214 user event_name count_star
5215 user1 statement/com/Error 0
5216 user1 statement/com/Quit 0
5217 user1 statement/sp/freturn 0
5218 user1 statement/sql/insert 0
5219 user1 statement/sql/select 0
5220 user2 statement/com/Error 0
5221 user2 statement/com/Quit 0
5222 user2 statement/sp/freturn 0
5223 user2 statement/sql/insert 0
5224 user2 statement/sql/select 0
5225 user3 statement/com/Error 0
5226 user3 statement/com/Quit 0
5227 user3 statement/sp/freturn 0
5228 user3 statement/sql/insert 0
5229 user3 statement/sql/select 0
5230 user4 statement/com/Error 0
5231 user4 statement/com/Quit 0
5232 user4 statement/sp/freturn 0
5233 user4 statement/sql/insert 0
5234 user4 statement/sql/select 0
5235 execute dump_statements_host;
5236 host event_name count_star
5237 localhost statement/com/Error 0
5238 localhost statement/com/Quit 0
5239 localhost statement/sp/freturn 0
5240 localhost statement/sql/insert 0
5241 localhost statement/sql/select 0
5242 execute dump_statements_global;
5243 event_name count_star
5244 statement/com/Error 0
5245 statement/com/Quit 4
5246 statement/sp/freturn 4
5247 statement/sql/insert 4
5248 statement/sql/select 12
5249 execute dump_statements_history;
5250 event_name count(event_name)
5251 statement/com/Quit 4
5252 statement/sp/freturn 4
5253 statement/sql/insert 4
5254 statement/sql/select 12
5255 execute dump_transactions_account;
5256 user host event_name count_star
5257 user1 localhost transaction 3
5258 user2 localhost transaction 3
5259 user3 localhost transaction 3
5260 user4 localhost transaction 3
5261 execute dump_transactions_user;
5262 user event_name count_star
5263 user1 transaction 3
5264 user2 transaction 3
5265 user3 transaction 3
5266 user4 transaction 3
5267 execute dump_transactions_host;
5268 host event_name count_star
5269 localhost transaction 12
5270 execute dump_transactions_global;
5271 event_name count_star
5272 transaction 12
5273 execute dump_transactions_history;
5274 event_name count(event_name)
5275 transaction 12
5276 execute dump_accounts;
5277 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5278 root localhost 1 1
5279 user1 localhost 0 1
5280 user2 localhost 0 1
5281 user3 localhost 0 1
5282 user4 localhost 0 1
5283 execute dump_users;
5284 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5285 root 1 1
5286 user1 0 1
5287 user2 0 1
5288 user3 0 1
5289 user4 0 1
5290 execute dump_hosts;
5291 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5292 localhost 1 5
5293 truncate performance_schema.events_statements_summary_global_by_event_name;
5294 "================== STATEMENTS_GLOBAL truncated =================="
5295 "================== Step 28 =================="
5296 call dump_thread();
5297 username status
5298 user1 not found
5299 username status
5300 user2 not found
5301 username status
5302 user3 not found
5303 username status
5304 user4 not found
5305 execute dump_waits_account;
5306 user host event_name count_star
5307 user1 localhost wait/io/file/sql/query_log 0
5308 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
5309 user2 localhost wait/io/file/sql/query_log 0
5310 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
5311 user3 localhost wait/io/file/sql/query_log 0
5312 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
5313 user4 localhost wait/io/file/sql/query_log 0
5314 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
5315 execute dump_waits_user;
5316 user event_name count_star
5317 user1 wait/io/file/sql/query_log 0
5318 user1 wait/synch/rwlock/sql/LOCK_grant 0
5319 user2 wait/io/file/sql/query_log 0
5320 user2 wait/synch/rwlock/sql/LOCK_grant 0
5321 user3 wait/io/file/sql/query_log 0
5322 user3 wait/synch/rwlock/sql/LOCK_grant 0
5323 user4 wait/io/file/sql/query_log 0
5324 user4 wait/synch/rwlock/sql/LOCK_grant 0
5325 execute dump_waits_host;
5326 host event_name count_star
5327 localhost wait/io/file/sql/query_log 0
5328 localhost wait/synch/rwlock/sql/LOCK_grant 0
5329 execute dump_waits_global;
5330 event_name count_star
5331 wait/io/file/sql/query_log 0
5332 wait/synch/rwlock/sql/LOCK_grant 0
5333 execute dump_waits_history;
5334 event_name count(event_name)
5335 wait/io/file/sql/query_log 32
5336 wait/synch/rwlock/sql/LOCK_grant 4
5337 execute dump_stages_account;
5338 user host event_name count_star
5339 user1 localhost stage/sql/checking permissions 0
5340 user1 localhost stage/sql/closing tables 0
5341 user1 localhost stage/sql/init 0
5342 user1 localhost stage/sql/Opening tables 0
5343 user1 localhost stage/sql/starting 0
5344 user2 localhost stage/sql/checking permissions 0
5345 user2 localhost stage/sql/closing tables 0
5346 user2 localhost stage/sql/init 0
5347 user2 localhost stage/sql/Opening tables 0
5348 user2 localhost stage/sql/starting 0
5349 user3 localhost stage/sql/checking permissions 0
5350 user3 localhost stage/sql/closing tables 0
5351 user3 localhost stage/sql/init 0
5352 user3 localhost stage/sql/Opening tables 0
5353 user3 localhost stage/sql/starting 0
5354 user4 localhost stage/sql/checking permissions 0
5355 user4 localhost stage/sql/closing tables 0
5356 user4 localhost stage/sql/init 0
5357 user4 localhost stage/sql/Opening tables 0
5358 user4 localhost stage/sql/starting 0
5359 execute dump_stages_user;
5360 user event_name count_star
5361 user1 stage/sql/checking permissions 0
5362 user1 stage/sql/closing tables 0
5363 user1 stage/sql/init 0
5364 user1 stage/sql/Opening tables 0
5365 user1 stage/sql/starting 0
5366 user2 stage/sql/checking permissions 0
5367 user2 stage/sql/closing tables 0
5368 user2 stage/sql/init 0
5369 user2 stage/sql/Opening tables 0
5370 user2 stage/sql/starting 0
5371 user3 stage/sql/checking permissions 0
5372 user3 stage/sql/closing tables 0
5373 user3 stage/sql/init 0
5374 user3 stage/sql/Opening tables 0
5375 user3 stage/sql/starting 0
5376 user4 stage/sql/checking permissions 0
5377 user4 stage/sql/closing tables 0
5378 user4 stage/sql/init 0
5379 user4 stage/sql/Opening tables 0
5380 user4 stage/sql/starting 0
5381 execute dump_stages_host;
5382 host event_name count_star
5383 localhost stage/sql/checking permissions 0
5384 localhost stage/sql/closing tables 0
5385 localhost stage/sql/init 0
5386 localhost stage/sql/Opening tables 0
5387 localhost stage/sql/starting 0
5388 execute dump_stages_global;
5389 event_name count_star
5390 stage/sql/checking permissions 0
5391 stage/sql/closing tables 0
5392 stage/sql/init 0
5393 stage/sql/Opening tables 0
5394 stage/sql/starting 0
5395 execute dump_stages_history;
5396 event_name count(event_name)
5397 stage/sql/checking permissions 16
5398 stage/sql/closing tables 45
5399 stage/sql/init 12
5400 stage/sql/Opening tables 29
5401 stage/sql/starting 32
5402 execute dump_statements_account;
5403 user host event_name count_star
5404 user1 localhost statement/com/Error 0
5405 user1 localhost statement/com/Quit 0
5406 user1 localhost statement/sp/freturn 0
5407 user1 localhost statement/sql/insert 0
5408 user1 localhost statement/sql/select 0
5409 user2 localhost statement/com/Error 0
5410 user2 localhost statement/com/Quit 0
5411 user2 localhost statement/sp/freturn 0
5412 user2 localhost statement/sql/insert 0
5413 user2 localhost statement/sql/select 0
5414 user3 localhost statement/com/Error 0
5415 user3 localhost statement/com/Quit 0
5416 user3 localhost statement/sp/freturn 0
5417 user3 localhost statement/sql/insert 0
5418 user3 localhost statement/sql/select 0
5419 user4 localhost statement/com/Error 0
5420 user4 localhost statement/com/Quit 0
5421 user4 localhost statement/sp/freturn 0
5422 user4 localhost statement/sql/insert 0
5423 user4 localhost statement/sql/select 0
5424 execute dump_statements_user;
5425 user event_name count_star
5426 user1 statement/com/Error 0
5427 user1 statement/com/Quit 0
5428 user1 statement/sp/freturn 0
5429 user1 statement/sql/insert 0
5430 user1 statement/sql/select 0
5431 user2 statement/com/Error 0
5432 user2 statement/com/Quit 0
5433 user2 statement/sp/freturn 0
5434 user2 statement/sql/insert 0
5435 user2 statement/sql/select 0
5436 user3 statement/com/Error 0
5437 user3 statement/com/Quit 0
5438 user3 statement/sp/freturn 0
5439 user3 statement/sql/insert 0
5440 user3 statement/sql/select 0
5441 user4 statement/com/Error 0
5442 user4 statement/com/Quit 0
5443 user4 statement/sp/freturn 0
5444 user4 statement/sql/insert 0
5445 user4 statement/sql/select 0
5446 execute dump_statements_host;
5447 host event_name count_star
5448 localhost statement/com/Error 0
5449 localhost statement/com/Quit 0
5450 localhost statement/sp/freturn 0
5451 localhost statement/sql/insert 0
5452 localhost statement/sql/select 0
5453 execute dump_statements_global;
5454 event_name count_star
5455 statement/com/Error 0
5456 statement/com/Quit 0
5457 statement/sp/freturn 0
5458 statement/sql/insert 0
5459 statement/sql/select 0
5460 execute dump_statements_history;
5461 event_name count(event_name)
5462 statement/com/Quit 4
5463 statement/sp/freturn 4
5464 statement/sql/insert 4
5465 statement/sql/select 12
5466 execute dump_transactions_account;
5467 user host event_name count_star
5468 user1 localhost transaction 3
5469 user2 localhost transaction 3
5470 user3 localhost transaction 3
5471 user4 localhost transaction 3
5472 execute dump_transactions_user;
5473 user event_name count_star
5474 user1 transaction 3
5475 user2 transaction 3
5476 user3 transaction 3
5477 user4 transaction 3
5478 execute dump_transactions_host;
5479 host event_name count_star
5480 localhost transaction 12
5481 execute dump_transactions_global;
5482 event_name count_star
5483 transaction 12
5484 execute dump_transactions_history;
5485 event_name count(event_name)
5486 transaction 12
5487 execute dump_accounts;
5488 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5489 root localhost 1 1
5490 user1 localhost 0 1
5491 user2 localhost 0 1
5492 user3 localhost 0 1
5493 user4 localhost 0 1
5494 execute dump_users;
5495 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5496 root 1 1
5497 user1 0 1
5498 user2 0 1
5499 user3 0 1
5500 user4 0 1
5501 execute dump_hosts;
5502 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5503 localhost 1 5
5504 truncate performance_schema.events_transactions_summary_by_thread_by_event_name;
5505 "================== TRANSACTIONS_BY_THREAD truncated =================="
5506 "================== Step 29 =================="
5507 call dump_thread();
5508 username status
5509 user1 not found
5510 username status
5511 user2 not found
5512 username status
5513 user3 not found
5514 username status
5515 user4 not found
5516 execute dump_waits_account;
5517 user host event_name count_star
5518 user1 localhost wait/io/file/sql/query_log 0
5519 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
5520 user2 localhost wait/io/file/sql/query_log 0
5521 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
5522 user3 localhost wait/io/file/sql/query_log 0
5523 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
5524 user4 localhost wait/io/file/sql/query_log 0
5525 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
5526 execute dump_waits_user;
5527 user event_name count_star
5528 user1 wait/io/file/sql/query_log 0
5529 user1 wait/synch/rwlock/sql/LOCK_grant 0
5530 user2 wait/io/file/sql/query_log 0
5531 user2 wait/synch/rwlock/sql/LOCK_grant 0
5532 user3 wait/io/file/sql/query_log 0
5533 user3 wait/synch/rwlock/sql/LOCK_grant 0
5534 user4 wait/io/file/sql/query_log 0
5535 user4 wait/synch/rwlock/sql/LOCK_grant 0
5536 execute dump_waits_host;
5537 host event_name count_star
5538 localhost wait/io/file/sql/query_log 0
5539 localhost wait/synch/rwlock/sql/LOCK_grant 0
5540 execute dump_waits_global;
5541 event_name count_star
5542 wait/io/file/sql/query_log 0
5543 wait/synch/rwlock/sql/LOCK_grant 0
5544 execute dump_waits_history;
5545 event_name count(event_name)
5546 wait/io/file/sql/query_log 32
5547 wait/synch/rwlock/sql/LOCK_grant 4
5548 execute dump_stages_account;
5549 user host event_name count_star
5550 user1 localhost stage/sql/checking permissions 0
5551 user1 localhost stage/sql/closing tables 0
5552 user1 localhost stage/sql/init 0
5553 user1 localhost stage/sql/Opening tables 0
5554 user1 localhost stage/sql/starting 0
5555 user2 localhost stage/sql/checking permissions 0
5556 user2 localhost stage/sql/closing tables 0
5557 user2 localhost stage/sql/init 0
5558 user2 localhost stage/sql/Opening tables 0
5559 user2 localhost stage/sql/starting 0
5560 user3 localhost stage/sql/checking permissions 0
5561 user3 localhost stage/sql/closing tables 0
5562 user3 localhost stage/sql/init 0
5563 user3 localhost stage/sql/Opening tables 0
5564 user3 localhost stage/sql/starting 0
5565 user4 localhost stage/sql/checking permissions 0
5566 user4 localhost stage/sql/closing tables 0
5567 user4 localhost stage/sql/init 0
5568 user4 localhost stage/sql/Opening tables 0
5569 user4 localhost stage/sql/starting 0
5570 execute dump_stages_user;
5571 user event_name count_star
5572 user1 stage/sql/checking permissions 0
5573 user1 stage/sql/closing tables 0
5574 user1 stage/sql/init 0
5575 user1 stage/sql/Opening tables 0
5576 user1 stage/sql/starting 0
5577 user2 stage/sql/checking permissions 0
5578 user2 stage/sql/closing tables 0
5579 user2 stage/sql/init 0
5580 user2 stage/sql/Opening tables 0
5581 user2 stage/sql/starting 0
5582 user3 stage/sql/checking permissions 0
5583 user3 stage/sql/closing tables 0
5584 user3 stage/sql/init 0
5585 user3 stage/sql/Opening tables 0
5586 user3 stage/sql/starting 0
5587 user4 stage/sql/checking permissions 0
5588 user4 stage/sql/closing tables 0
5589 user4 stage/sql/init 0
5590 user4 stage/sql/Opening tables 0
5591 user4 stage/sql/starting 0
5592 execute dump_stages_host;
5593 host event_name count_star
5594 localhost stage/sql/checking permissions 0
5595 localhost stage/sql/closing tables 0
5596 localhost stage/sql/init 0
5597 localhost stage/sql/Opening tables 0
5598 localhost stage/sql/starting 0
5599 execute dump_stages_global;
5600 event_name count_star
5601 stage/sql/checking permissions 0
5602 stage/sql/closing tables 0
5603 stage/sql/init 0
5604 stage/sql/Opening tables 0
5605 stage/sql/starting 0
5606 execute dump_stages_history;
5607 event_name count(event_name)
5608 stage/sql/checking permissions 16
5609 stage/sql/closing tables 45
5610 stage/sql/init 12
5611 stage/sql/Opening tables 29
5612 stage/sql/starting 32
5613 execute dump_statements_account;
5614 user host event_name count_star
5615 user1 localhost statement/com/Error 0
5616 user1 localhost statement/com/Quit 0
5617 user1 localhost statement/sp/freturn 0
5618 user1 localhost statement/sql/insert 0
5619 user1 localhost statement/sql/select 0
5620 user2 localhost statement/com/Error 0
5621 user2 localhost statement/com/Quit 0
5622 user2 localhost statement/sp/freturn 0
5623 user2 localhost statement/sql/insert 0
5624 user2 localhost statement/sql/select 0
5625 user3 localhost statement/com/Error 0
5626 user3 localhost statement/com/Quit 0
5627 user3 localhost statement/sp/freturn 0
5628 user3 localhost statement/sql/insert 0
5629 user3 localhost statement/sql/select 0
5630 user4 localhost statement/com/Error 0
5631 user4 localhost statement/com/Quit 0
5632 user4 localhost statement/sp/freturn 0
5633 user4 localhost statement/sql/insert 0
5634 user4 localhost statement/sql/select 0
5635 execute dump_statements_user;
5636 user event_name count_star
5637 user1 statement/com/Error 0
5638 user1 statement/com/Quit 0
5639 user1 statement/sp/freturn 0
5640 user1 statement/sql/insert 0
5641 user1 statement/sql/select 0
5642 user2 statement/com/Error 0
5643 user2 statement/com/Quit 0
5644 user2 statement/sp/freturn 0
5645 user2 statement/sql/insert 0
5646 user2 statement/sql/select 0
5647 user3 statement/com/Error 0
5648 user3 statement/com/Quit 0
5649 user3 statement/sp/freturn 0
5650 user3 statement/sql/insert 0
5651 user3 statement/sql/select 0
5652 user4 statement/com/Error 0
5653 user4 statement/com/Quit 0
5654 user4 statement/sp/freturn 0
5655 user4 statement/sql/insert 0
5656 user4 statement/sql/select 0
5657 execute dump_statements_host;
5658 host event_name count_star
5659 localhost statement/com/Error 0
5660 localhost statement/com/Quit 0
5661 localhost statement/sp/freturn 0
5662 localhost statement/sql/insert 0
5663 localhost statement/sql/select 0
5664 execute dump_statements_global;
5665 event_name count_star
5666 statement/com/Error 0
5667 statement/com/Quit 0
5668 statement/sp/freturn 0
5669 statement/sql/insert 0
5670 statement/sql/select 0
5671 execute dump_statements_history;
5672 event_name count(event_name)
5673 statement/com/Quit 4
5674 statement/sp/freturn 4
5675 statement/sql/insert 4
5676 statement/sql/select 12
5677 execute dump_transactions_account;
5678 user host event_name count_star
5679 user1 localhost transaction 3
5680 user2 localhost transaction 3
5681 user3 localhost transaction 3
5682 user4 localhost transaction 3
5683 execute dump_transactions_user;
5684 user event_name count_star
5685 user1 transaction 3
5686 user2 transaction 3
5687 user3 transaction 3
5688 user4 transaction 3
5689 execute dump_transactions_host;
5690 host event_name count_star
5691 localhost transaction 12
5692 execute dump_transactions_global;
5693 event_name count_star
5694 transaction 12
5695 execute dump_transactions_history;
5696 event_name count(event_name)
5697 transaction 12
5698 execute dump_accounts;
5699 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5700 root localhost 1 1
5701 user1 localhost 0 1
5702 user2 localhost 0 1
5703 user3 localhost 0 1
5704 user4 localhost 0 1
5705 execute dump_users;
5706 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5707 root 1 1
5708 user1 0 1
5709 user2 0 1
5710 user3 0 1
5711 user4 0 1
5712 execute dump_hosts;
5713 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5714 localhost 1 5
5715 truncate performance_schema.events_transactions_summary_by_account_by_event_name;
5716 "================== TRANSACTIONS_BY_ACCOUNT truncated =================="
5717 "================== Step 30 =================="
5718 call dump_thread();
5719 username status
5720 user1 not found
5721 username status
5722 user2 not found
5723 username status
5724 user3 not found
5725 username status
5726 user4 not found
5727 execute dump_waits_account;
5728 user host event_name count_star
5729 user1 localhost wait/io/file/sql/query_log 0
5730 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
5731 user2 localhost wait/io/file/sql/query_log 0
5732 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
5733 user3 localhost wait/io/file/sql/query_log 0
5734 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
5735 user4 localhost wait/io/file/sql/query_log 0
5736 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
5737 execute dump_waits_user;
5738 user event_name count_star
5739 user1 wait/io/file/sql/query_log 0
5740 user1 wait/synch/rwlock/sql/LOCK_grant 0
5741 user2 wait/io/file/sql/query_log 0
5742 user2 wait/synch/rwlock/sql/LOCK_grant 0
5743 user3 wait/io/file/sql/query_log 0
5744 user3 wait/synch/rwlock/sql/LOCK_grant 0
5745 user4 wait/io/file/sql/query_log 0
5746 user4 wait/synch/rwlock/sql/LOCK_grant 0
5747 execute dump_waits_host;
5748 host event_name count_star
5749 localhost wait/io/file/sql/query_log 0
5750 localhost wait/synch/rwlock/sql/LOCK_grant 0
5751 execute dump_waits_global;
5752 event_name count_star
5753 wait/io/file/sql/query_log 0
5754 wait/synch/rwlock/sql/LOCK_grant 0
5755 execute dump_waits_history;
5756 event_name count(event_name)
5757 wait/io/file/sql/query_log 32
5758 wait/synch/rwlock/sql/LOCK_grant 4
5759 execute dump_stages_account;
5760 user host event_name count_star
5761 user1 localhost stage/sql/checking permissions 0
5762 user1 localhost stage/sql/closing tables 0
5763 user1 localhost stage/sql/init 0
5764 user1 localhost stage/sql/Opening tables 0
5765 user1 localhost stage/sql/starting 0
5766 user2 localhost stage/sql/checking permissions 0
5767 user2 localhost stage/sql/closing tables 0
5768 user2 localhost stage/sql/init 0
5769 user2 localhost stage/sql/Opening tables 0
5770 user2 localhost stage/sql/starting 0
5771 user3 localhost stage/sql/checking permissions 0
5772 user3 localhost stage/sql/closing tables 0
5773 user3 localhost stage/sql/init 0
5774 user3 localhost stage/sql/Opening tables 0
5775 user3 localhost stage/sql/starting 0
5776 user4 localhost stage/sql/checking permissions 0
5777 user4 localhost stage/sql/closing tables 0
5778 user4 localhost stage/sql/init 0
5779 user4 localhost stage/sql/Opening tables 0
5780 user4 localhost stage/sql/starting 0
5781 execute dump_stages_user;
5782 user event_name count_star
5783 user1 stage/sql/checking permissions 0
5784 user1 stage/sql/closing tables 0
5785 user1 stage/sql/init 0
5786 user1 stage/sql/Opening tables 0
5787 user1 stage/sql/starting 0
5788 user2 stage/sql/checking permissions 0
5789 user2 stage/sql/closing tables 0
5790 user2 stage/sql/init 0
5791 user2 stage/sql/Opening tables 0
5792 user2 stage/sql/starting 0
5793 user3 stage/sql/checking permissions 0
5794 user3 stage/sql/closing tables 0
5795 user3 stage/sql/init 0
5796 user3 stage/sql/Opening tables 0
5797 user3 stage/sql/starting 0
5798 user4 stage/sql/checking permissions 0
5799 user4 stage/sql/closing tables 0
5800 user4 stage/sql/init 0
5801 user4 stage/sql/Opening tables 0
5802 user4 stage/sql/starting 0
5803 execute dump_stages_host;
5804 host event_name count_star
5805 localhost stage/sql/checking permissions 0
5806 localhost stage/sql/closing tables 0
5807 localhost stage/sql/init 0
5808 localhost stage/sql/Opening tables 0
5809 localhost stage/sql/starting 0
5810 execute dump_stages_global;
5811 event_name count_star
5812 stage/sql/checking permissions 0
5813 stage/sql/closing tables 0
5814 stage/sql/init 0
5815 stage/sql/Opening tables 0
5816 stage/sql/starting 0
5817 execute dump_stages_history;
5818 event_name count(event_name)
5819 stage/sql/checking permissions 16
5820 stage/sql/closing tables 45
5821 stage/sql/init 12
5822 stage/sql/Opening tables 29
5823 stage/sql/starting 32
5824 execute dump_statements_account;
5825 user host event_name count_star
5826 user1 localhost statement/com/Error 0
5827 user1 localhost statement/com/Quit 0
5828 user1 localhost statement/sp/freturn 0
5829 user1 localhost statement/sql/insert 0
5830 user1 localhost statement/sql/select 0
5831 user2 localhost statement/com/Error 0
5832 user2 localhost statement/com/Quit 0
5833 user2 localhost statement/sp/freturn 0
5834 user2 localhost statement/sql/insert 0
5835 user2 localhost statement/sql/select 0
5836 user3 localhost statement/com/Error 0
5837 user3 localhost statement/com/Quit 0
5838 user3 localhost statement/sp/freturn 0
5839 user3 localhost statement/sql/insert 0
5840 user3 localhost statement/sql/select 0
5841 user4 localhost statement/com/Error 0
5842 user4 localhost statement/com/Quit 0
5843 user4 localhost statement/sp/freturn 0
5844 user4 localhost statement/sql/insert 0
5845 user4 localhost statement/sql/select 0
5846 execute dump_statements_user;
5847 user event_name count_star
5848 user1 statement/com/Error 0
5849 user1 statement/com/Quit 0
5850 user1 statement/sp/freturn 0
5851 user1 statement/sql/insert 0
5852 user1 statement/sql/select 0
5853 user2 statement/com/Error 0
5854 user2 statement/com/Quit 0
5855 user2 statement/sp/freturn 0
5856 user2 statement/sql/insert 0
5857 user2 statement/sql/select 0
5858 user3 statement/com/Error 0
5859 user3 statement/com/Quit 0
5860 user3 statement/sp/freturn 0
5861 user3 statement/sql/insert 0
5862 user3 statement/sql/select 0
5863 user4 statement/com/Error 0
5864 user4 statement/com/Quit 0
5865 user4 statement/sp/freturn 0
5866 user4 statement/sql/insert 0
5867 user4 statement/sql/select 0
5868 execute dump_statements_host;
5869 host event_name count_star
5870 localhost statement/com/Error 0
5871 localhost statement/com/Quit 0
5872 localhost statement/sp/freturn 0
5873 localhost statement/sql/insert 0
5874 localhost statement/sql/select 0
5875 execute dump_statements_global;
5876 event_name count_star
5877 statement/com/Error 0
5878 statement/com/Quit 0
5879 statement/sp/freturn 0
5880 statement/sql/insert 0
5881 statement/sql/select 0
5882 execute dump_statements_history;
5883 event_name count(event_name)
5884 statement/com/Quit 4
5885 statement/sp/freturn 4
5886 statement/sql/insert 4
5887 statement/sql/select 12
5888 execute dump_transactions_account;
5889 user host event_name count_star
5890 user1 localhost transaction 0
5891 user2 localhost transaction 0
5892 user3 localhost transaction 0
5893 user4 localhost transaction 0
5894 execute dump_transactions_user;
5895 user event_name count_star
5896 user1 transaction 3
5897 user2 transaction 3
5898 user3 transaction 3
5899 user4 transaction 3
5900 execute dump_transactions_host;
5901 host event_name count_star
5902 localhost transaction 12
5903 execute dump_transactions_global;
5904 event_name count_star
5905 transaction 12
5906 execute dump_transactions_history;
5907 event_name count(event_name)
5908 transaction 12
5909 execute dump_accounts;
5910 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5911 root localhost 1 1
5912 user1 localhost 0 1
5913 user2 localhost 0 1
5914 user3 localhost 0 1
5915 user4 localhost 0 1
5916 execute dump_users;
5917 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5918 root 1 1
5919 user1 0 1
5920 user2 0 1
5921 user3 0 1
5922 user4 0 1
5923 execute dump_hosts;
5924 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
5925 localhost 1 5
5926 truncate performance_schema.events_transactions_summary_by_user_by_event_name;
5927 "================== TRANSACTIONS_BY_USER truncated =================="
5928 "================== Step 31 =================="
5929 call dump_thread();
5930 username status
5931 user1 not found
5932 username status
5933 user2 not found
5934 username status
5935 user3 not found
5936 username status
5937 user4 not found
5938 execute dump_waits_account;
5939 user host event_name count_star
5940 user1 localhost wait/io/file/sql/query_log 0
5941 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
5942 user2 localhost wait/io/file/sql/query_log 0
5943 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
5944 user3 localhost wait/io/file/sql/query_log 0
5945 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
5946 user4 localhost wait/io/file/sql/query_log 0
5947 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
5948 execute dump_waits_user;
5949 user event_name count_star
5950 user1 wait/io/file/sql/query_log 0
5951 user1 wait/synch/rwlock/sql/LOCK_grant 0
5952 user2 wait/io/file/sql/query_log 0
5953 user2 wait/synch/rwlock/sql/LOCK_grant 0
5954 user3 wait/io/file/sql/query_log 0
5955 user3 wait/synch/rwlock/sql/LOCK_grant 0
5956 user4 wait/io/file/sql/query_log 0
5957 user4 wait/synch/rwlock/sql/LOCK_grant 0
5958 execute dump_waits_host;
5959 host event_name count_star
5960 localhost wait/io/file/sql/query_log 0
5961 localhost wait/synch/rwlock/sql/LOCK_grant 0
5962 execute dump_waits_global;
5963 event_name count_star
5964 wait/io/file/sql/query_log 0
5965 wait/synch/rwlock/sql/LOCK_grant 0
5966 execute dump_waits_history;
5967 event_name count(event_name)
5968 wait/io/file/sql/query_log 32
5969 wait/synch/rwlock/sql/LOCK_grant 4
5970 execute dump_stages_account;
5971 user host event_name count_star
5972 user1 localhost stage/sql/checking permissions 0
5973 user1 localhost stage/sql/closing tables 0
5974 user1 localhost stage/sql/init 0
5975 user1 localhost stage/sql/Opening tables 0
5976 user1 localhost stage/sql/starting 0
5977 user2 localhost stage/sql/checking permissions 0
5978 user2 localhost stage/sql/closing tables 0
5979 user2 localhost stage/sql/init 0
5980 user2 localhost stage/sql/Opening tables 0
5981 user2 localhost stage/sql/starting 0
5982 user3 localhost stage/sql/checking permissions 0
5983 user3 localhost stage/sql/closing tables 0
5984 user3 localhost stage/sql/init 0
5985 user3 localhost stage/sql/Opening tables 0
5986 user3 localhost stage/sql/starting 0
5987 user4 localhost stage/sql/checking permissions 0
5988 user4 localhost stage/sql/closing tables 0
5989 user4 localhost stage/sql/init 0
5990 user4 localhost stage/sql/Opening tables 0
5991 user4 localhost stage/sql/starting 0
5992 execute dump_stages_user;
5993 user event_name count_star
5994 user1 stage/sql/checking permissions 0
5995 user1 stage/sql/closing tables 0
5996 user1 stage/sql/init 0
5997 user1 stage/sql/Opening tables 0
5998 user1 stage/sql/starting 0
5999 user2 stage/sql/checking permissions 0
6000 user2 stage/sql/closing tables 0
6001 user2 stage/sql/init 0
6002 user2 stage/sql/Opening tables 0
6003 user2 stage/sql/starting 0
6004 user3 stage/sql/checking permissions 0
6005 user3 stage/sql/closing tables 0
6006 user3 stage/sql/init 0
6007 user3 stage/sql/Opening tables 0
6008 user3 stage/sql/starting 0
6009 user4 stage/sql/checking permissions 0
6010 user4 stage/sql/closing tables 0
6011 user4 stage/sql/init 0
6012 user4 stage/sql/Opening tables 0
6013 user4 stage/sql/starting 0
6014 execute dump_stages_host;
6015 host event_name count_star
6016 localhost stage/sql/checking permissions 0
6017 localhost stage/sql/closing tables 0
6018 localhost stage/sql/init 0
6019 localhost stage/sql/Opening tables 0
6020 localhost stage/sql/starting 0
6021 execute dump_stages_global;
6022 event_name count_star
6023 stage/sql/checking permissions 0
6024 stage/sql/closing tables 0
6025 stage/sql/init 0
6026 stage/sql/Opening tables 0
6027 stage/sql/starting 0
6028 execute dump_stages_history;
6029 event_name count(event_name)
6030 stage/sql/checking permissions 16
6031 stage/sql/closing tables 45
6032 stage/sql/init 12
6033 stage/sql/Opening tables 29
6034 stage/sql/starting 32
6035 execute dump_statements_account;
6036 user host event_name count_star
6037 user1 localhost statement/com/Error 0
6038 user1 localhost statement/com/Quit 0
6039 user1 localhost statement/sp/freturn 0
6040 user1 localhost statement/sql/insert 0
6041 user1 localhost statement/sql/select 0
6042 user2 localhost statement/com/Error 0
6043 user2 localhost statement/com/Quit 0
6044 user2 localhost statement/sp/freturn 0
6045 user2 localhost statement/sql/insert 0
6046 user2 localhost statement/sql/select 0
6047 user3 localhost statement/com/Error 0
6048 user3 localhost statement/com/Quit 0
6049 user3 localhost statement/sp/freturn 0
6050 user3 localhost statement/sql/insert 0
6051 user3 localhost statement/sql/select 0
6052 user4 localhost statement/com/Error 0
6053 user4 localhost statement/com/Quit 0
6054 user4 localhost statement/sp/freturn 0
6055 user4 localhost statement/sql/insert 0
6056 user4 localhost statement/sql/select 0
6057 execute dump_statements_user;
6058 user event_name count_star
6059 user1 statement/com/Error 0
6060 user1 statement/com/Quit 0
6061 user1 statement/sp/freturn 0
6062 user1 statement/sql/insert 0
6063 user1 statement/sql/select 0
6064 user2 statement/com/Error 0
6065 user2 statement/com/Quit 0
6066 user2 statement/sp/freturn 0
6067 user2 statement/sql/insert 0
6068 user2 statement/sql/select 0
6069 user3 statement/com/Error 0
6070 user3 statement/com/Quit 0
6071 user3 statement/sp/freturn 0
6072 user3 statement/sql/insert 0
6073 user3 statement/sql/select 0
6074 user4 statement/com/Error 0
6075 user4 statement/com/Quit 0
6076 user4 statement/sp/freturn 0
6077 user4 statement/sql/insert 0
6078 user4 statement/sql/select 0
6079 execute dump_statements_host;
6080 host event_name count_star
6081 localhost statement/com/Error 0
6082 localhost statement/com/Quit 0
6083 localhost statement/sp/freturn 0
6084 localhost statement/sql/insert 0
6085 localhost statement/sql/select 0
6086 execute dump_statements_global;
6087 event_name count_star
6088 statement/com/Error 0
6089 statement/com/Quit 0
6090 statement/sp/freturn 0
6091 statement/sql/insert 0
6092 statement/sql/select 0
6093 execute dump_statements_history;
6094 event_name count(event_name)
6095 statement/com/Quit 4
6096 statement/sp/freturn 4
6097 statement/sql/insert 4
6098 statement/sql/select 12
6099 execute dump_transactions_account;
6100 user host event_name count_star
6101 user1 localhost transaction 0
6102 user2 localhost transaction 0
6103 user3 localhost transaction 0
6104 user4 localhost transaction 0
6105 execute dump_transactions_user;
6106 user event_name count_star
6107 user1 transaction 0
6108 user2 transaction 0
6109 user3 transaction 0
6110 user4 transaction 0
6111 execute dump_transactions_host;
6112 host event_name count_star
6113 localhost transaction 12
6114 execute dump_transactions_global;
6115 event_name count_star
6116 transaction 12
6117 execute dump_transactions_history;
6118 event_name count(event_name)
6119 transaction 12
6120 execute dump_accounts;
6121 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6122 root localhost 1 1
6123 user1 localhost 0 1
6124 user2 localhost 0 1
6125 user3 localhost 0 1
6126 user4 localhost 0 1
6127 execute dump_users;
6128 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6129 root 1 1
6130 user1 0 1
6131 user2 0 1
6132 user3 0 1
6133 user4 0 1
6134 execute dump_hosts;
6135 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6136 localhost 1 5
6137 truncate performance_schema.events_transactions_summary_by_host_by_event_name;
6138 "================== TRANSACTIONS_BY_HOST truncated =================="
6139 "================== Step 32 =================="
6140 call dump_thread();
6141 username status
6142 user1 not found
6143 username status
6144 user2 not found
6145 username status
6146 user3 not found
6147 username status
6148 user4 not found
6149 execute dump_waits_account;
6150 user host event_name count_star
6151 user1 localhost wait/io/file/sql/query_log 0
6152 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
6153 user2 localhost wait/io/file/sql/query_log 0
6154 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
6155 user3 localhost wait/io/file/sql/query_log 0
6156 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
6157 user4 localhost wait/io/file/sql/query_log 0
6158 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
6159 execute dump_waits_user;
6160 user event_name count_star
6161 user1 wait/io/file/sql/query_log 0
6162 user1 wait/synch/rwlock/sql/LOCK_grant 0
6163 user2 wait/io/file/sql/query_log 0
6164 user2 wait/synch/rwlock/sql/LOCK_grant 0
6165 user3 wait/io/file/sql/query_log 0
6166 user3 wait/synch/rwlock/sql/LOCK_grant 0
6167 user4 wait/io/file/sql/query_log 0
6168 user4 wait/synch/rwlock/sql/LOCK_grant 0
6169 execute dump_waits_host;
6170 host event_name count_star
6171 localhost wait/io/file/sql/query_log 0
6172 localhost wait/synch/rwlock/sql/LOCK_grant 0
6173 execute dump_waits_global;
6174 event_name count_star
6175 wait/io/file/sql/query_log 0
6176 wait/synch/rwlock/sql/LOCK_grant 0
6177 execute dump_waits_history;
6178 event_name count(event_name)
6179 wait/io/file/sql/query_log 32
6180 wait/synch/rwlock/sql/LOCK_grant 4
6181 execute dump_stages_account;
6182 user host event_name count_star
6183 user1 localhost stage/sql/checking permissions 0
6184 user1 localhost stage/sql/closing tables 0
6185 user1 localhost stage/sql/init 0
6186 user1 localhost stage/sql/Opening tables 0
6187 user1 localhost stage/sql/starting 0
6188 user2 localhost stage/sql/checking permissions 0
6189 user2 localhost stage/sql/closing tables 0
6190 user2 localhost stage/sql/init 0
6191 user2 localhost stage/sql/Opening tables 0
6192 user2 localhost stage/sql/starting 0
6193 user3 localhost stage/sql/checking permissions 0
6194 user3 localhost stage/sql/closing tables 0
6195 user3 localhost stage/sql/init 0
6196 user3 localhost stage/sql/Opening tables 0
6197 user3 localhost stage/sql/starting 0
6198 user4 localhost stage/sql/checking permissions 0
6199 user4 localhost stage/sql/closing tables 0
6200 user4 localhost stage/sql/init 0
6201 user4 localhost stage/sql/Opening tables 0
6202 user4 localhost stage/sql/starting 0
6203 execute dump_stages_user;
6204 user event_name count_star
6205 user1 stage/sql/checking permissions 0
6206 user1 stage/sql/closing tables 0
6207 user1 stage/sql/init 0
6208 user1 stage/sql/Opening tables 0
6209 user1 stage/sql/starting 0
6210 user2 stage/sql/checking permissions 0
6211 user2 stage/sql/closing tables 0
6212 user2 stage/sql/init 0
6213 user2 stage/sql/Opening tables 0
6214 user2 stage/sql/starting 0
6215 user3 stage/sql/checking permissions 0
6216 user3 stage/sql/closing tables 0
6217 user3 stage/sql/init 0
6218 user3 stage/sql/Opening tables 0
6219 user3 stage/sql/starting 0
6220 user4 stage/sql/checking permissions 0
6221 user4 stage/sql/closing tables 0
6222 user4 stage/sql/init 0
6223 user4 stage/sql/Opening tables 0
6224 user4 stage/sql/starting 0
6225 execute dump_stages_host;
6226 host event_name count_star
6227 localhost stage/sql/checking permissions 0
6228 localhost stage/sql/closing tables 0
6229 localhost stage/sql/init 0
6230 localhost stage/sql/Opening tables 0
6231 localhost stage/sql/starting 0
6232 execute dump_stages_global;
6233 event_name count_star
6234 stage/sql/checking permissions 0
6235 stage/sql/closing tables 0
6236 stage/sql/init 0
6237 stage/sql/Opening tables 0
6238 stage/sql/starting 0
6239 execute dump_stages_history;
6240 event_name count(event_name)
6241 stage/sql/checking permissions 16
6242 stage/sql/closing tables 45
6243 stage/sql/init 12
6244 stage/sql/Opening tables 29
6245 stage/sql/starting 32
6246 execute dump_statements_account;
6247 user host event_name count_star
6248 user1 localhost statement/com/Error 0
6249 user1 localhost statement/com/Quit 0
6250 user1 localhost statement/sp/freturn 0
6251 user1 localhost statement/sql/insert 0
6252 user1 localhost statement/sql/select 0
6253 user2 localhost statement/com/Error 0
6254 user2 localhost statement/com/Quit 0
6255 user2 localhost statement/sp/freturn 0
6256 user2 localhost statement/sql/insert 0
6257 user2 localhost statement/sql/select 0
6258 user3 localhost statement/com/Error 0
6259 user3 localhost statement/com/Quit 0
6260 user3 localhost statement/sp/freturn 0
6261 user3 localhost statement/sql/insert 0
6262 user3 localhost statement/sql/select 0
6263 user4 localhost statement/com/Error 0
6264 user4 localhost statement/com/Quit 0
6265 user4 localhost statement/sp/freturn 0
6266 user4 localhost statement/sql/insert 0
6267 user4 localhost statement/sql/select 0
6268 execute dump_statements_user;
6269 user event_name count_star
6270 user1 statement/com/Error 0
6271 user1 statement/com/Quit 0
6272 user1 statement/sp/freturn 0
6273 user1 statement/sql/insert 0
6274 user1 statement/sql/select 0
6275 user2 statement/com/Error 0
6276 user2 statement/com/Quit 0
6277 user2 statement/sp/freturn 0
6278 user2 statement/sql/insert 0
6279 user2 statement/sql/select 0
6280 user3 statement/com/Error 0
6281 user3 statement/com/Quit 0
6282 user3 statement/sp/freturn 0
6283 user3 statement/sql/insert 0
6284 user3 statement/sql/select 0
6285 user4 statement/com/Error 0
6286 user4 statement/com/Quit 0
6287 user4 statement/sp/freturn 0
6288 user4 statement/sql/insert 0
6289 user4 statement/sql/select 0
6290 execute dump_statements_host;
6291 host event_name count_star
6292 localhost statement/com/Error 0
6293 localhost statement/com/Quit 0
6294 localhost statement/sp/freturn 0
6295 localhost statement/sql/insert 0
6296 localhost statement/sql/select 0
6297 execute dump_statements_global;
6298 event_name count_star
6299 statement/com/Error 0
6300 statement/com/Quit 0
6301 statement/sp/freturn 0
6302 statement/sql/insert 0
6303 statement/sql/select 0
6304 execute dump_statements_history;
6305 event_name count(event_name)
6306 statement/com/Quit 4
6307 statement/sp/freturn 4
6308 statement/sql/insert 4
6309 statement/sql/select 12
6310 execute dump_transactions_account;
6311 user host event_name count_star
6312 user1 localhost transaction 0
6313 user2 localhost transaction 0
6314 user3 localhost transaction 0
6315 user4 localhost transaction 0
6316 execute dump_transactions_user;
6317 user event_name count_star
6318 user1 transaction 0
6319 user2 transaction 0
6320 user3 transaction 0
6321 user4 transaction 0
6322 execute dump_transactions_host;
6323 host event_name count_star
6324 localhost transaction 0
6325 execute dump_transactions_global;
6326 event_name count_star
6327 transaction 12
6328 execute dump_transactions_history;
6329 event_name count(event_name)
6330 transaction 12
6331 execute dump_accounts;
6332 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6333 root localhost 1 1
6334 user1 localhost 0 1
6335 user2 localhost 0 1
6336 user3 localhost 0 1
6337 user4 localhost 0 1
6338 execute dump_users;
6339 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6340 root 1 1
6341 user1 0 1
6342 user2 0 1
6343 user3 0 1
6344 user4 0 1
6345 execute dump_hosts;
6346 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6347 localhost 1 5
6348 truncate performance_schema.events_transactions_summary_global_by_event_name;
6349 "================== TRANSACTIONS_GLOBAL truncated =================="
6350 "================== Step 33 =================="
6351 call dump_thread();
6352 username status
6353 user1 not found
6354 username status
6355 user2 not found
6356 username status
6357 user3 not found
6358 username status
6359 user4 not found
6360 execute dump_waits_account;
6361 user host event_name count_star
6362 user1 localhost wait/io/file/sql/query_log 0
6363 user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
6364 user2 localhost wait/io/file/sql/query_log 0
6365 user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
6366 user3 localhost wait/io/file/sql/query_log 0
6367 user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
6368 user4 localhost wait/io/file/sql/query_log 0
6369 user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
6370 execute dump_waits_user;
6371 user event_name count_star
6372 user1 wait/io/file/sql/query_log 0
6373 user1 wait/synch/rwlock/sql/LOCK_grant 0
6374 user2 wait/io/file/sql/query_log 0
6375 user2 wait/synch/rwlock/sql/LOCK_grant 0
6376 user3 wait/io/file/sql/query_log 0
6377 user3 wait/synch/rwlock/sql/LOCK_grant 0
6378 user4 wait/io/file/sql/query_log 0
6379 user4 wait/synch/rwlock/sql/LOCK_grant 0
6380 execute dump_waits_host;
6381 host event_name count_star
6382 localhost wait/io/file/sql/query_log 0
6383 localhost wait/synch/rwlock/sql/LOCK_grant 0
6384 execute dump_waits_global;
6385 event_name count_star
6386 wait/io/file/sql/query_log 0
6387 wait/synch/rwlock/sql/LOCK_grant 0
6388 execute dump_waits_history;
6389 event_name count(event_name)
6390 wait/io/file/sql/query_log 32
6391 wait/synch/rwlock/sql/LOCK_grant 4
6392 execute dump_stages_account;
6393 user host event_name count_star
6394 user1 localhost stage/sql/checking permissions 0
6395 user1 localhost stage/sql/closing tables 0
6396 user1 localhost stage/sql/init 0
6397 user1 localhost stage/sql/Opening tables 0
6398 user1 localhost stage/sql/starting 0
6399 user2 localhost stage/sql/checking permissions 0
6400 user2 localhost stage/sql/closing tables 0
6401 user2 localhost stage/sql/init 0
6402 user2 localhost stage/sql/Opening tables 0
6403 user2 localhost stage/sql/starting 0
6404 user3 localhost stage/sql/checking permissions 0
6405 user3 localhost stage/sql/closing tables 0
6406 user3 localhost stage/sql/init 0
6407 user3 localhost stage/sql/Opening tables 0
6408 user3 localhost stage/sql/starting 0
6409 user4 localhost stage/sql/checking permissions 0
6410 user4 localhost stage/sql/closing tables 0
6411 user4 localhost stage/sql/init 0
6412 user4 localhost stage/sql/Opening tables 0
6413 user4 localhost stage/sql/starting 0
6414 execute dump_stages_user;
6415 user event_name count_star
6416 user1 stage/sql/checking permissions 0
6417 user1 stage/sql/closing tables 0
6418 user1 stage/sql/init 0
6419 user1 stage/sql/Opening tables 0
6420 user1 stage/sql/starting 0
6421 user2 stage/sql/checking permissions 0
6422 user2 stage/sql/closing tables 0
6423 user2 stage/sql/init 0
6424 user2 stage/sql/Opening tables 0
6425 user2 stage/sql/starting 0
6426 user3 stage/sql/checking permissions 0
6427 user3 stage/sql/closing tables 0
6428 user3 stage/sql/init 0
6429 user3 stage/sql/Opening tables 0
6430 user3 stage/sql/starting 0
6431 user4 stage/sql/checking permissions 0
6432 user4 stage/sql/closing tables 0
6433 user4 stage/sql/init 0
6434 user4 stage/sql/Opening tables 0
6435 user4 stage/sql/starting 0
6436 execute dump_stages_host;
6437 host event_name count_star
6438 localhost stage/sql/checking permissions 0
6439 localhost stage/sql/closing tables 0
6440 localhost stage/sql/init 0
6441 localhost stage/sql/Opening tables 0
6442 localhost stage/sql/starting 0
6443 execute dump_stages_global;
6444 event_name count_star
6445 stage/sql/checking permissions 0
6446 stage/sql/closing tables 0
6447 stage/sql/init 0
6448 stage/sql/Opening tables 0
6449 stage/sql/starting 0
6450 execute dump_stages_history;
6451 event_name count(event_name)
6452 stage/sql/checking permissions 16
6453 stage/sql/closing tables 45
6454 stage/sql/init 12
6455 stage/sql/Opening tables 29
6456 stage/sql/starting 32
6457 execute dump_statements_account;
6458 user host event_name count_star
6459 user1 localhost statement/com/Error 0
6460 user1 localhost statement/com/Quit 0
6461 user1 localhost statement/sp/freturn 0
6462 user1 localhost statement/sql/insert 0
6463 user1 localhost statement/sql/select 0
6464 user2 localhost statement/com/Error 0
6465 user2 localhost statement/com/Quit 0
6466 user2 localhost statement/sp/freturn 0
6467 user2 localhost statement/sql/insert 0
6468 user2 localhost statement/sql/select 0
6469 user3 localhost statement/com/Error 0
6470 user3 localhost statement/com/Quit 0
6471 user3 localhost statement/sp/freturn 0
6472 user3 localhost statement/sql/insert 0
6473 user3 localhost statement/sql/select 0
6474 user4 localhost statement/com/Error 0
6475 user4 localhost statement/com/Quit 0
6476 user4 localhost statement/sp/freturn 0
6477 user4 localhost statement/sql/insert 0
6478 user4 localhost statement/sql/select 0
6479 execute dump_statements_user;
6480 user event_name count_star
6481 user1 statement/com/Error 0
6482 user1 statement/com/Quit 0
6483 user1 statement/sp/freturn 0
6484 user1 statement/sql/insert 0
6485 user1 statement/sql/select 0
6486 user2 statement/com/Error 0
6487 user2 statement/com/Quit 0
6488 user2 statement/sp/freturn 0
6489 user2 statement/sql/insert 0
6490 user2 statement/sql/select 0
6491 user3 statement/com/Error 0
6492 user3 statement/com/Quit 0
6493 user3 statement/sp/freturn 0
6494 user3 statement/sql/insert 0
6495 user3 statement/sql/select 0
6496 user4 statement/com/Error 0
6497 user4 statement/com/Quit 0
6498 user4 statement/sp/freturn 0
6499 user4 statement/sql/insert 0
6500 user4 statement/sql/select 0
6501 execute dump_statements_host;
6502 host event_name count_star
6503 localhost statement/com/Error 0
6504 localhost statement/com/Quit 0
6505 localhost statement/sp/freturn 0
6506 localhost statement/sql/insert 0
6507 localhost statement/sql/select 0
6508 execute dump_statements_global;
6509 event_name count_star
6510 statement/com/Error 0
6511 statement/com/Quit 0
6512 statement/sp/freturn 0
6513 statement/sql/insert 0
6514 statement/sql/select 0
6515 execute dump_statements_history;
6516 event_name count(event_name)
6517 statement/com/Quit 4
6518 statement/sp/freturn 4
6519 statement/sql/insert 4
6520 statement/sql/select 12
6521 execute dump_transactions_account;
6522 user host event_name count_star
6523 user1 localhost transaction 0
6524 user2 localhost transaction 0
6525 user3 localhost transaction 0
6526 user4 localhost transaction 0
6527 execute dump_transactions_user;
6528 user event_name count_star
6529 user1 transaction 0
6530 user2 transaction 0
6531 user3 transaction 0
6532 user4 transaction 0
6533 execute dump_transactions_host;
6534 host event_name count_star
6535 localhost transaction 0
6536 execute dump_transactions_global;
6537 event_name count_star
6538 transaction 0
6539 execute dump_transactions_history;
6540 event_name count(event_name)
6541 transaction 12
6542 execute dump_accounts;
6543 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6544 root localhost 1 1
6545 user1 localhost 0 1
6546 user2 localhost 0 1
6547 user3 localhost 0 1
6548 user4 localhost 0 1
6549 execute dump_users;
6550 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6551 root 1 1
6552 user1 0 1
6553 user2 0 1
6554 user3 0 1
6555 user4 0 1
6556 execute dump_hosts;
6557 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6558 localhost 1 5
6559 truncate performance_schema.accounts;
6560 "================== ACCOUNTS truncated =================="
6561 "================== Step 34 =================="
6562 call dump_thread();
6563 username status
6564 user1 not found
6565 username status
6566 user2 not found
6567 username status
6568 user3 not found
6569 username status
6570 user4 not found
6571 execute dump_waits_account;
6572 user host event_name count_star
6573 execute dump_waits_user;
6574 user event_name count_star
6575 user1 wait/io/file/sql/query_log 0
6576 user1 wait/synch/rwlock/sql/LOCK_grant 0
6577 user2 wait/io/file/sql/query_log 0
6578 user2 wait/synch/rwlock/sql/LOCK_grant 0
6579 user3 wait/io/file/sql/query_log 0
6580 user3 wait/synch/rwlock/sql/LOCK_grant 0
6581 user4 wait/io/file/sql/query_log 0
6582 user4 wait/synch/rwlock/sql/LOCK_grant 0
6583 execute dump_waits_host;
6584 host event_name count_star
6585 localhost wait/io/file/sql/query_log 0
6586 localhost wait/synch/rwlock/sql/LOCK_grant 0
6587 execute dump_waits_global;
6588 event_name count_star
6589 wait/io/file/sql/query_log 0
6590 wait/synch/rwlock/sql/LOCK_grant 0
6591 execute dump_waits_history;
6592 event_name count(event_name)
6593 wait/io/file/sql/query_log 32
6594 wait/synch/rwlock/sql/LOCK_grant 4
6595 execute dump_stages_account;
6596 user host event_name count_star
6597 execute dump_stages_user;
6598 user event_name count_star
6599 user1 stage/sql/checking permissions 0
6600 user1 stage/sql/closing tables 0
6601 user1 stage/sql/init 0
6602 user1 stage/sql/Opening tables 0
6603 user1 stage/sql/starting 0
6604 user2 stage/sql/checking permissions 0
6605 user2 stage/sql/closing tables 0
6606 user2 stage/sql/init 0
6607 user2 stage/sql/Opening tables 0
6608 user2 stage/sql/starting 0
6609 user3 stage/sql/checking permissions 0
6610 user3 stage/sql/closing tables 0
6611 user3 stage/sql/init 0
6612 user3 stage/sql/Opening tables 0
6613 user3 stage/sql/starting 0
6614 user4 stage/sql/checking permissions 0
6615 user4 stage/sql/closing tables 0
6616 user4 stage/sql/init 0
6617 user4 stage/sql/Opening tables 0
6618 user4 stage/sql/starting 0
6619 execute dump_stages_host;
6620 host event_name count_star
6621 localhost stage/sql/checking permissions 0
6622 localhost stage/sql/closing tables 0
6623 localhost stage/sql/init 0
6624 localhost stage/sql/Opening tables 0
6625 localhost stage/sql/starting 0
6626 execute dump_stages_global;
6627 event_name count_star
6628 stage/sql/checking permissions 0
6629 stage/sql/closing tables 0
6630 stage/sql/init 0
6631 stage/sql/Opening tables 0
6632 stage/sql/starting 0
6633 execute dump_stages_history;
6634 event_name count(event_name)
6635 stage/sql/checking permissions 16
6636 stage/sql/closing tables 45
6637 stage/sql/init 12
6638 stage/sql/Opening tables 29
6639 stage/sql/starting 32
6640 execute dump_statements_account;
6641 user host event_name count_star
6642 execute dump_statements_user;
6643 user event_name count_star
6644 user1 statement/com/Error 0
6645 user1 statement/com/Quit 0
6646 user1 statement/sp/freturn 0
6647 user1 statement/sql/insert 0
6648 user1 statement/sql/select 0
6649 user2 statement/com/Error 0
6650 user2 statement/com/Quit 0
6651 user2 statement/sp/freturn 0
6652 user2 statement/sql/insert 0
6653 user2 statement/sql/select 0
6654 user3 statement/com/Error 0
6655 user3 statement/com/Quit 0
6656 user3 statement/sp/freturn 0
6657 user3 statement/sql/insert 0
6658 user3 statement/sql/select 0
6659 user4 statement/com/Error 0
6660 user4 statement/com/Quit 0
6661 user4 statement/sp/freturn 0
6662 user4 statement/sql/insert 0
6663 user4 statement/sql/select 0
6664 execute dump_statements_host;
6665 host event_name count_star
6666 localhost statement/com/Error 0
6667 localhost statement/com/Quit 0
6668 localhost statement/sp/freturn 0
6669 localhost statement/sql/insert 0
6670 localhost statement/sql/select 0
6671 execute dump_statements_global;
6672 event_name count_star
6673 statement/com/Error 0
6674 statement/com/Quit 0
6675 statement/sp/freturn 0
6676 statement/sql/insert 0
6677 statement/sql/select 0
6678 execute dump_statements_history;
6679 event_name count(event_name)
6680 statement/com/Quit 4
6681 statement/sp/freturn 4
6682 statement/sql/insert 4
6683 statement/sql/select 12
6684 execute dump_transactions_account;
6685 user host event_name count_star
6686 execute dump_transactions_user;
6687 user event_name count_star
6688 user1 transaction 0
6689 user2 transaction 0
6690 user3 transaction 0
6691 user4 transaction 0
6692 execute dump_transactions_host;
6693 host event_name count_star
6694 localhost transaction 0
6695 execute dump_transactions_global;
6696 event_name count_star
6697 transaction 0
6698 execute dump_transactions_history;
6699 event_name count(event_name)
6700 transaction 12
6701 execute dump_accounts;
6702 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6703 root localhost 1 1
6704 execute dump_users;
6705 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6706 root 1 1
6707 user1 0 1
6708 user2 0 1
6709 user3 0 1
6710 user4 0 1
6711 execute dump_hosts;
6712 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6713 localhost 1 5
6714 truncate performance_schema.users;
6715 "================== USERS truncated =================="
6716 "================== Step 35 =================="
6717 call dump_thread();
6718 username status
6719 user1 not found
6720 username status
6721 user2 not found
6722 username status
6723 user3 not found
6724 username status
6725 user4 not found
6726 execute dump_waits_account;
6727 user host event_name count_star
6728 execute dump_waits_user;
6729 user event_name count_star
6730 execute dump_waits_host;
6731 host event_name count_star
6732 localhost wait/io/file/sql/query_log 0
6733 localhost wait/synch/rwlock/sql/LOCK_grant 0
6734 execute dump_waits_global;
6735 event_name count_star
6736 wait/io/file/sql/query_log 0
6737 wait/synch/rwlock/sql/LOCK_grant 0
6738 execute dump_waits_history;
6739 event_name count(event_name)
6740 wait/io/file/sql/query_log 32
6741 wait/synch/rwlock/sql/LOCK_grant 4
6742 execute dump_stages_account;
6743 user host event_name count_star
6744 execute dump_stages_user;
6745 user event_name count_star
6746 execute dump_stages_host;
6747 host event_name count_star
6748 localhost stage/sql/checking permissions 0
6749 localhost stage/sql/closing tables 0
6750 localhost stage/sql/init 0
6751 localhost stage/sql/Opening tables 0
6752 localhost stage/sql/starting 0
6753 execute dump_stages_global;
6754 event_name count_star
6755 stage/sql/checking permissions 0
6756 stage/sql/closing tables 0
6757 stage/sql/init 0
6758 stage/sql/Opening tables 0
6759 stage/sql/starting 0
6760 execute dump_stages_history;
6761 event_name count(event_name)
6762 stage/sql/checking permissions 16
6763 stage/sql/closing tables 45
6764 stage/sql/init 12
6765 stage/sql/Opening tables 29
6766 stage/sql/starting 32
6767 execute dump_statements_account;
6768 user host event_name count_star
6769 execute dump_statements_user;
6770 user event_name count_star
6771 execute dump_statements_host;
6772 host event_name count_star
6773 localhost statement/com/Error 0
6774 localhost statement/com/Quit 0
6775 localhost statement/sp/freturn 0
6776 localhost statement/sql/insert 0
6777 localhost statement/sql/select 0
6778 execute dump_statements_global;
6779 event_name count_star
6780 statement/com/Error 0
6781 statement/com/Quit 0
6782 statement/sp/freturn 0
6783 statement/sql/insert 0
6784 statement/sql/select 0
6785 execute dump_statements_history;
6786 event_name count(event_name)
6787 statement/com/Quit 4
6788 statement/sp/freturn 4
6789 statement/sql/insert 4
6790 statement/sql/select 12
6791 execute dump_transactions_account;
6792 user host event_name count_star
6793 execute dump_transactions_user;
6794 user event_name count_star
6795 execute dump_transactions_host;
6796 host event_name count_star
6797 localhost transaction 0
6798 execute dump_transactions_global;
6799 event_name count_star
6800 transaction 0
6801 execute dump_transactions_history;
6802 event_name count(event_name)
6803 transaction 12
6804 execute dump_accounts;
6805 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6806 root localhost 1 1
6807 execute dump_users;
6808 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6809 root 1 1
6810 execute dump_hosts;
6811 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6812 localhost 1 5
6813 truncate performance_schema.hosts;
6814 "================== HOSTS truncated =================="
6815 "================== Step 36 =================="
6816 call dump_thread();
6817 username status
6818 user1 not found
6819 username status
6820 user2 not found
6821 username status
6822 user3 not found
6823 username status
6824 user4 not found
6825 execute dump_waits_account;
6826 user host event_name count_star
6827 execute dump_waits_user;
6828 user event_name count_star
6829 execute dump_waits_host;
6830 host event_name count_star
6831 localhost wait/io/file/sql/query_log 0
6832 localhost wait/synch/rwlock/sql/LOCK_grant 0
6833 execute dump_waits_global;
6834 event_name count_star
6835 wait/io/file/sql/query_log 0
6836 wait/synch/rwlock/sql/LOCK_grant 0
6837 execute dump_waits_history;
6838 event_name count(event_name)
6839 wait/io/file/sql/query_log 32
6840 wait/synch/rwlock/sql/LOCK_grant 4
6841 execute dump_stages_account;
6842 user host event_name count_star
6843 execute dump_stages_user;
6844 user event_name count_star
6845 execute dump_stages_host;
6846 host event_name count_star
6847 localhost stage/sql/checking permissions 0
6848 localhost stage/sql/closing tables 0
6849 localhost stage/sql/init 0
6850 localhost stage/sql/Opening tables 0
6851 localhost stage/sql/starting 0
6852 execute dump_stages_global;
6853 event_name count_star
6854 stage/sql/checking permissions 0
6855 stage/sql/closing tables 0
6856 stage/sql/init 0
6857 stage/sql/Opening tables 0
6858 stage/sql/starting 0
6859 execute dump_stages_history;
6860 event_name count(event_name)
6861 stage/sql/checking permissions 16
6862 stage/sql/closing tables 45
6863 stage/sql/init 12
6864 stage/sql/Opening tables 29
6865 stage/sql/starting 32
6866 execute dump_statements_account;
6867 user host event_name count_star
6868 execute dump_statements_user;
6869 user event_name count_star
6870 execute dump_statements_host;
6871 host event_name count_star
6872 localhost statement/com/Error 0
6873 localhost statement/com/Quit 0
6874 localhost statement/sp/freturn 0
6875 localhost statement/sql/insert 0
6876 localhost statement/sql/select 0
6877 execute dump_statements_global;
6878 event_name count_star
6879 statement/com/Error 0
6880 statement/com/Quit 0
6881 statement/sp/freturn 0
6882 statement/sql/insert 0
6883 statement/sql/select 0
6884 execute dump_statements_history;
6885 event_name count(event_name)
6886 statement/com/Quit 4
6887 statement/sp/freturn 4
6888 statement/sql/insert 4
6889 statement/sql/select 12
6890 execute dump_transactions_account;
6891 user host event_name count_star
6892 execute dump_transactions_user;
6893 user event_name count_star
6894 execute dump_transactions_host;
6895 host event_name count_star
6896 localhost transaction 0
6897 execute dump_transactions_global;
6898 event_name count_star
6899 transaction 0
6900 execute dump_transactions_history;
6901 event_name count(event_name)
6902 transaction 12
6903 execute dump_accounts;
6904 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6905 root localhost 1 1
6906 execute dump_users;
6907 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6908 root 1 1
6909 execute dump_hosts;
6910 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6911 localhost 1 1