Debian Codegraph @

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

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