Debian Codegraph @

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

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