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