Debian Codegraph @

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