Debian Codegraph @

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

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