Debian Codegraph @

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

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