Debian Codegraph @

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

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