Debian Codegraph @

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

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