← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

Viewing changes to mysql-test/suite/perfschema/r/event_aggregate_no_a_no_h.result

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/perfschema/r/event_aggregate_no_a_no_h.result
 
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_user_locks    0
 
22
wait/synch/rwlock/sql/LOCK_grant        0
 
23
execute dump_waits_history;
 
24
event_name      count(event_name)
 
25
execute dump_stages_account;
 
26
user    host    event_name      count_star
 
27
execute dump_stages_user;
 
28
user    event_name      count_star
 
29
execute dump_stages_host;
 
30
host    event_name      count_star
 
31
execute dump_stages_global;
 
32
event_name      count_star
 
33
stage/sql/checking permissions  0
 
34
stage/sql/closing tables        0
 
35
stage/sql/init  0
 
36
stage/sql/Opening tables        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/sql/insert    0
 
50
statement/sql/select    0
 
51
execute dump_statements_history;
 
52
event_name      count(event_name)
 
53
execute dump_accounts;
 
54
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
55
execute dump_users;
 
56
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
57
root    1       1
 
58
execute dump_hosts;
 
59
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
60
"================== con1 connected =================="
 
61
"================== Step 2 =================="
 
62
call dump_thread();
 
63
username        event_name      count_star
 
64
user1   wait/io/file/sql/query_log      1
 
65
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
66
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
67
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
68
username        status
 
69
user2   not found
 
70
username        status
 
71
user3   not found
 
72
username        status
 
73
user4   not found
 
74
execute dump_waits_account;
 
75
user    host    event_name      count_star
 
76
execute dump_waits_user;
 
77
user    event_name      count_star
 
78
user1   wait/io/file/sql/query_log      1
 
79
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
80
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
81
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
82
execute dump_waits_host;
 
83
host    event_name      count_star
 
84
execute dump_waits_global;
 
85
event_name      count_star
 
86
wait/io/file/sql/query_log      1
 
87
wait/synch/mutex/sql/LOCK_connection_count      0
 
88
wait/synch/mutex/sql/LOCK_user_locks    0
 
89
wait/synch/rwlock/sql/LOCK_grant        0
 
90
execute dump_waits_history;
 
91
event_name      count(event_name)
 
92
wait/io/file/sql/query_log      1
 
93
execute dump_stages_account;
 
94
user    host    event_name      count_star
 
95
execute dump_stages_user;
 
96
user    event_name      count_star
 
97
user1   stage/sql/checking permissions  0
 
98
user1   stage/sql/closing tables        0
 
99
user1   stage/sql/init  0
 
100
user1   stage/sql/Opening tables        0
 
101
execute dump_stages_host;
 
102
host    event_name      count_star
 
103
execute dump_stages_global;
 
104
event_name      count_star
 
105
stage/sql/checking permissions  0
 
106
stage/sql/closing tables        0
 
107
stage/sql/init  0
 
108
stage/sql/Opening tables        0
 
109
execute dump_stages_history;
 
110
event_name      count(event_name)
 
111
execute dump_statements_account;
 
112
user    host    event_name      count_star
 
113
execute dump_statements_user;
 
114
user    event_name      count_star
 
115
user1   statement/com/Error     0
 
116
user1   statement/com/Quit      0
 
117
user1   statement/sql/insert    0
 
118
user1   statement/sql/select    0
 
119
execute dump_statements_host;
 
120
host    event_name      count_star
 
121
execute dump_statements_global;
 
122
event_name      count_star
 
123
statement/com/Error     0
 
124
statement/com/Quit      0
 
125
statement/sql/insert    0
 
126
statement/sql/select    0
 
127
execute dump_statements_history;
 
128
event_name      count(event_name)
 
129
execute dump_accounts;
 
130
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
131
execute dump_users;
 
132
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
133
root    1       1
 
134
user1   1       1
 
135
execute dump_hosts;
 
136
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
137
select get_lock("marker", 10);
 
138
get_lock("marker", 10)
 
139
1
 
140
select release_lock("marker");
 
141
release_lock("marker")
 
142
1
 
143
insert into test.t1 values ("marker");
 
144
"================== con1 marker =================="
 
145
"================== Step 3 =================="
 
146
call dump_thread();
 
147
username        event_name      count_star
 
148
user1   wait/io/file/sql/query_log      4
 
149
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
150
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
151
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
152
username        status
 
153
user2   not found
 
154
username        status
 
155
user3   not found
 
156
username        status
 
157
user4   not found
 
158
execute dump_waits_account;
 
159
user    host    event_name      count_star
 
160
execute dump_waits_user;
 
161
user    event_name      count_star
 
162
user1   wait/io/file/sql/query_log      4
 
163
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
164
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
165
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
166
execute dump_waits_host;
 
167
host    event_name      count_star
 
168
execute dump_waits_global;
 
169
event_name      count_star
 
170
wait/io/file/sql/query_log      4
 
171
wait/synch/mutex/sql/LOCK_connection_count      0
 
172
wait/synch/mutex/sql/LOCK_user_locks    2
 
173
wait/synch/rwlock/sql/LOCK_grant        2
 
174
execute dump_waits_history;
 
175
event_name      count(event_name)
 
176
wait/io/file/sql/query_log      4
 
177
wait/synch/mutex/sql/LOCK_user_locks    2
 
178
wait/synch/rwlock/sql/LOCK_grant        2
 
179
execute dump_stages_account;
 
180
user    host    event_name      count_star
 
181
execute dump_stages_user;
 
182
user    event_name      count_star
 
183
user1   stage/sql/checking permissions  3
 
184
user1   stage/sql/closing tables        3
 
185
user1   stage/sql/init  6
 
186
user1   stage/sql/Opening tables        3
 
187
execute dump_stages_host;
 
188
host    event_name      count_star
 
189
execute dump_stages_global;
 
190
event_name      count_star
 
191
stage/sql/checking permissions  3
 
192
stage/sql/closing tables        3
 
193
stage/sql/init  6
 
194
stage/sql/Opening tables        3
 
195
execute dump_stages_history;
 
196
event_name      count(event_name)
 
197
stage/sql/checking permissions  3
 
198
stage/sql/closing tables        3
 
199
stage/sql/init  6
 
200
stage/sql/Opening tables        3
 
201
execute dump_statements_account;
 
202
user    host    event_name      count_star
 
203
execute dump_statements_user;
 
204
user    event_name      count_star
 
205
user1   statement/com/Error     0
 
206
user1   statement/com/Quit      0
 
207
user1   statement/sql/insert    1
 
208
user1   statement/sql/select    2
 
209
execute dump_statements_host;
 
210
host    event_name      count_star
 
211
execute dump_statements_global;
 
212
event_name      count_star
 
213
statement/com/Error     0
 
214
statement/com/Quit      0
 
215
statement/sql/insert    1
 
216
statement/sql/select    2
 
217
execute dump_statements_history;
 
218
event_name      count(event_name)
 
219
statement/sql/insert    1
 
220
statement/sql/select    2
 
221
execute dump_accounts;
 
222
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
223
execute dump_users;
 
224
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
225
root    1       1
 
226
user1   1       1
 
227
execute dump_hosts;
 
228
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
229
"================== con2 connected =================="
 
230
"================== Step 4 =================="
 
231
call dump_thread();
 
232
username        event_name      count_star
 
233
user1   wait/io/file/sql/query_log      4
 
234
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
235
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
236
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
237
username        event_name      count_star
 
238
user2   wait/io/file/sql/query_log      1
 
239
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
240
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
241
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
242
username        status
 
243
user3   not found
 
244
username        status
 
245
user4   not found
 
246
execute dump_waits_account;
 
247
user    host    event_name      count_star
 
248
execute dump_waits_user;
 
249
user    event_name      count_star
 
250
user1   wait/io/file/sql/query_log      4
 
251
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
252
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
253
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
254
user2   wait/io/file/sql/query_log      1
 
255
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
256
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
257
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
258
execute dump_waits_host;
 
259
host    event_name      count_star
 
260
execute dump_waits_global;
 
261
event_name      count_star
 
262
wait/io/file/sql/query_log      5
 
263
wait/synch/mutex/sql/LOCK_connection_count      0
 
264
wait/synch/mutex/sql/LOCK_user_locks    2
 
265
wait/synch/rwlock/sql/LOCK_grant        2
 
266
execute dump_waits_history;
 
267
event_name      count(event_name)
 
268
wait/io/file/sql/query_log      5
 
269
wait/synch/mutex/sql/LOCK_user_locks    2
 
270
wait/synch/rwlock/sql/LOCK_grant        2
 
271
execute dump_stages_account;
 
272
user    host    event_name      count_star
 
273
execute dump_stages_user;
 
274
user    event_name      count_star
 
275
user1   stage/sql/checking permissions  3
 
276
user1   stage/sql/closing tables        3
 
277
user1   stage/sql/init  6
 
278
user1   stage/sql/Opening tables        3
 
279
user2   stage/sql/checking permissions  0
 
280
user2   stage/sql/closing tables        0
 
281
user2   stage/sql/init  0
 
282
user2   stage/sql/Opening tables        0
 
283
execute dump_stages_host;
 
284
host    event_name      count_star
 
285
execute dump_stages_global;
 
286
event_name      count_star
 
287
stage/sql/checking permissions  3
 
288
stage/sql/closing tables        3
 
289
stage/sql/init  6
 
290
stage/sql/Opening tables        3
 
291
execute dump_stages_history;
 
292
event_name      count(event_name)
 
293
stage/sql/checking permissions  3
 
294
stage/sql/closing tables        3
 
295
stage/sql/init  6
 
296
stage/sql/Opening tables        3
 
297
execute dump_statements_account;
 
298
user    host    event_name      count_star
 
299
execute dump_statements_user;
 
300
user    event_name      count_star
 
301
user1   statement/com/Error     0
 
302
user1   statement/com/Quit      0
 
303
user1   statement/sql/insert    1
 
304
user1   statement/sql/select    2
 
305
user2   statement/com/Error     0
 
306
user2   statement/com/Quit      0
 
307
user2   statement/sql/insert    0
 
308
user2   statement/sql/select    0
 
309
execute dump_statements_host;
 
310
host    event_name      count_star
 
311
execute dump_statements_global;
 
312
event_name      count_star
 
313
statement/com/Error     0
 
314
statement/com/Quit      0
 
315
statement/sql/insert    1
 
316
statement/sql/select    2
 
317
execute dump_statements_history;
 
318
event_name      count(event_name)
 
319
statement/sql/insert    1
 
320
statement/sql/select    2
 
321
execute dump_accounts;
 
322
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
323
execute dump_users;
 
324
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
325
root    1       1
 
326
user1   1       1
 
327
user2   1       1
 
328
execute dump_hosts;
 
329
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
330
select get_lock("marker", 10);
 
331
get_lock("marker", 10)
 
332
1
 
333
select release_lock("marker");
 
334
release_lock("marker")
 
335
1
 
336
insert into test.t1 values ("marker");
 
337
"================== con2 marker =================="
 
338
"================== Step 5 =================="
 
339
call dump_thread();
 
340
username        event_name      count_star
 
341
user1   wait/io/file/sql/query_log      4
 
342
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
343
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
344
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
345
username        event_name      count_star
 
346
user2   wait/io/file/sql/query_log      4
 
347
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
348
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
349
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
350
username        status
 
351
user3   not found
 
352
username        status
 
353
user4   not found
 
354
execute dump_waits_account;
 
355
user    host    event_name      count_star
 
356
execute dump_waits_user;
 
357
user    event_name      count_star
 
358
user1   wait/io/file/sql/query_log      4
 
359
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
360
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
361
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
362
user2   wait/io/file/sql/query_log      4
 
363
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
364
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
365
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
366
execute dump_waits_host;
 
367
host    event_name      count_star
 
368
execute dump_waits_global;
 
369
event_name      count_star
 
370
wait/io/file/sql/query_log      8
 
371
wait/synch/mutex/sql/LOCK_connection_count      0
 
372
wait/synch/mutex/sql/LOCK_user_locks    4
 
373
wait/synch/rwlock/sql/LOCK_grant        4
 
374
execute dump_waits_history;
 
375
event_name      count(event_name)
 
376
wait/io/file/sql/query_log      8
 
377
wait/synch/mutex/sql/LOCK_user_locks    4
 
378
wait/synch/rwlock/sql/LOCK_grant        4
 
379
execute dump_stages_account;
 
380
user    host    event_name      count_star
 
381
execute dump_stages_user;
 
382
user    event_name      count_star
 
383
user1   stage/sql/checking permissions  3
 
384
user1   stage/sql/closing tables        3
 
385
user1   stage/sql/init  6
 
386
user1   stage/sql/Opening tables        3
 
387
user2   stage/sql/checking permissions  3
 
388
user2   stage/sql/closing tables        3
 
389
user2   stage/sql/init  6
 
390
user2   stage/sql/Opening tables        3
 
391
execute dump_stages_host;
 
392
host    event_name      count_star
 
393
execute dump_stages_global;
 
394
event_name      count_star
 
395
stage/sql/checking permissions  6
 
396
stage/sql/closing tables        6
 
397
stage/sql/init  12
 
398
stage/sql/Opening tables        6
 
399
execute dump_stages_history;
 
400
event_name      count(event_name)
 
401
stage/sql/checking permissions  6
 
402
stage/sql/closing tables        6
 
403
stage/sql/init  12
 
404
stage/sql/Opening tables        6
 
405
execute dump_statements_account;
 
406
user    host    event_name      count_star
 
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/sql/insert    1
 
412
user1   statement/sql/select    2
 
413
user2   statement/com/Error     0
 
414
user2   statement/com/Quit      0
 
415
user2   statement/sql/insert    1
 
416
user2   statement/sql/select    2
 
417
execute dump_statements_host;
 
418
host    event_name      count_star
 
419
execute dump_statements_global;
 
420
event_name      count_star
 
421
statement/com/Error     0
 
422
statement/com/Quit      0
 
423
statement/sql/insert    2
 
424
statement/sql/select    4
 
425
execute dump_statements_history;
 
426
event_name      count(event_name)
 
427
statement/sql/insert    2
 
428
statement/sql/select    4
 
429
execute dump_accounts;
 
430
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
431
execute dump_users;
 
432
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
433
root    1       1
 
434
user1   1       1
 
435
user2   1       1
 
436
execute dump_hosts;
 
437
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
438
"================== con3 connected =================="
 
439
"================== Step 6 =================="
 
440
call dump_thread();
 
441
username        event_name      count_star
 
442
user1   wait/io/file/sql/query_log      4
 
443
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
444
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
445
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
446
username        event_name      count_star
 
447
user2   wait/io/file/sql/query_log      4
 
448
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
449
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
450
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
451
username        event_name      count_star
 
452
user3   wait/io/file/sql/query_log      1
 
453
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
454
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
455
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
456
username        status
 
457
user4   not found
 
458
execute dump_waits_account;
 
459
user    host    event_name      count_star
 
460
execute dump_waits_user;
 
461
user    event_name      count_star
 
462
user1   wait/io/file/sql/query_log      4
 
463
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
464
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
465
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
466
user2   wait/io/file/sql/query_log      4
 
467
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
468
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
469
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
470
user3   wait/io/file/sql/query_log      1
 
471
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
472
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
473
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
474
execute dump_waits_host;
 
475
host    event_name      count_star
 
476
execute dump_waits_global;
 
477
event_name      count_star
 
478
wait/io/file/sql/query_log      9
 
479
wait/synch/mutex/sql/LOCK_connection_count      0
 
480
wait/synch/mutex/sql/LOCK_user_locks    4
 
481
wait/synch/rwlock/sql/LOCK_grant        4
 
482
execute dump_waits_history;
 
483
event_name      count(event_name)
 
484
wait/io/file/sql/query_log      9
 
485
wait/synch/mutex/sql/LOCK_user_locks    4
 
486
wait/synch/rwlock/sql/LOCK_grant        4
 
487
execute dump_stages_account;
 
488
user    host    event_name      count_star
 
489
execute dump_stages_user;
 
490
user    event_name      count_star
 
491
user1   stage/sql/checking permissions  3
 
492
user1   stage/sql/closing tables        3
 
493
user1   stage/sql/init  6
 
494
user1   stage/sql/Opening tables        3
 
495
user2   stage/sql/checking permissions  3
 
496
user2   stage/sql/closing tables        3
 
497
user2   stage/sql/init  6
 
498
user2   stage/sql/Opening tables        3
 
499
user3   stage/sql/checking permissions  0
 
500
user3   stage/sql/closing tables        0
 
501
user3   stage/sql/init  0
 
502
user3   stage/sql/Opening tables        0
 
503
execute dump_stages_host;
 
504
host    event_name      count_star
 
505
execute dump_stages_global;
 
506
event_name      count_star
 
507
stage/sql/checking permissions  6
 
508
stage/sql/closing tables        6
 
509
stage/sql/init  12
 
510
stage/sql/Opening tables        6
 
511
execute dump_stages_history;
 
512
event_name      count(event_name)
 
513
stage/sql/checking permissions  6
 
514
stage/sql/closing tables        6
 
515
stage/sql/init  12
 
516
stage/sql/Opening tables        6
 
517
execute dump_statements_account;
 
518
user    host    event_name      count_star
 
519
execute dump_statements_user;
 
520
user    event_name      count_star
 
521
user1   statement/com/Error     0
 
522
user1   statement/com/Quit      0
 
523
user1   statement/sql/insert    1
 
524
user1   statement/sql/select    2
 
525
user2   statement/com/Error     0
 
526
user2   statement/com/Quit      0
 
527
user2   statement/sql/insert    1
 
528
user2   statement/sql/select    2
 
529
user3   statement/com/Error     0
 
530
user3   statement/com/Quit      0
 
531
user3   statement/sql/insert    0
 
532
user3   statement/sql/select    0
 
533
execute dump_statements_host;
 
534
host    event_name      count_star
 
535
execute dump_statements_global;
 
536
event_name      count_star
 
537
statement/com/Error     0
 
538
statement/com/Quit      0
 
539
statement/sql/insert    2
 
540
statement/sql/select    4
 
541
execute dump_statements_history;
 
542
event_name      count(event_name)
 
543
statement/sql/insert    2
 
544
statement/sql/select    4
 
545
execute dump_accounts;
 
546
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
547
execute dump_users;
 
548
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
549
root    1       1
 
550
user1   1       1
 
551
user2   1       1
 
552
user3   1       1
 
553
execute dump_hosts;
 
554
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
555
select get_lock("marker", 10);
 
556
get_lock("marker", 10)
 
557
1
 
558
select release_lock("marker");
 
559
release_lock("marker")
 
560
1
 
561
insert into test.t1 values ("marker");
 
562
"================== con3 marker =================="
 
563
"================== Step 7 =================="
 
564
call dump_thread();
 
565
username        event_name      count_star
 
566
user1   wait/io/file/sql/query_log      4
 
567
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
568
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
569
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
570
username        event_name      count_star
 
571
user2   wait/io/file/sql/query_log      4
 
572
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
573
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
574
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
575
username        event_name      count_star
 
576
user3   wait/io/file/sql/query_log      4
 
577
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
578
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
579
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
580
username        status
 
581
user4   not found
 
582
execute dump_waits_account;
 
583
user    host    event_name      count_star
 
584
execute dump_waits_user;
 
585
user    event_name      count_star
 
586
user1   wait/io/file/sql/query_log      4
 
587
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
588
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
589
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
590
user2   wait/io/file/sql/query_log      4
 
591
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
592
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
593
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
594
user3   wait/io/file/sql/query_log      4
 
595
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
596
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
597
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
598
execute dump_waits_host;
 
599
host    event_name      count_star
 
600
execute dump_waits_global;
 
601
event_name      count_star
 
602
wait/io/file/sql/query_log      12
 
603
wait/synch/mutex/sql/LOCK_connection_count      0
 
604
wait/synch/mutex/sql/LOCK_user_locks    6
 
605
wait/synch/rwlock/sql/LOCK_grant        6
 
606
execute dump_waits_history;
 
607
event_name      count(event_name)
 
608
wait/io/file/sql/query_log      12
 
609
wait/synch/mutex/sql/LOCK_user_locks    6
 
610
wait/synch/rwlock/sql/LOCK_grant        6
 
611
execute dump_stages_account;
 
612
user    host    event_name      count_star
 
613
execute dump_stages_user;
 
614
user    event_name      count_star
 
615
user1   stage/sql/checking permissions  3
 
616
user1   stage/sql/closing tables        3
 
617
user1   stage/sql/init  6
 
618
user1   stage/sql/Opening tables        3
 
619
user2   stage/sql/checking permissions  3
 
620
user2   stage/sql/closing tables        3
 
621
user2   stage/sql/init  6
 
622
user2   stage/sql/Opening tables        3
 
623
user3   stage/sql/checking permissions  3
 
624
user3   stage/sql/closing tables        3
 
625
user3   stage/sql/init  6
 
626
user3   stage/sql/Opening tables        3
 
627
execute dump_stages_host;
 
628
host    event_name      count_star
 
629
execute dump_stages_global;
 
630
event_name      count_star
 
631
stage/sql/checking permissions  9
 
632
stage/sql/closing tables        9
 
633
stage/sql/init  18
 
634
stage/sql/Opening tables        9
 
635
execute dump_stages_history;
 
636
event_name      count(event_name)
 
637
stage/sql/checking permissions  9
 
638
stage/sql/closing tables        9
 
639
stage/sql/init  18
 
640
stage/sql/Opening tables        9
 
641
execute dump_statements_account;
 
642
user    host    event_name      count_star
 
643
execute dump_statements_user;
 
644
user    event_name      count_star
 
645
user1   statement/com/Error     0
 
646
user1   statement/com/Quit      0
 
647
user1   statement/sql/insert    1
 
648
user1   statement/sql/select    2
 
649
user2   statement/com/Error     0
 
650
user2   statement/com/Quit      0
 
651
user2   statement/sql/insert    1
 
652
user2   statement/sql/select    2
 
653
user3   statement/com/Error     0
 
654
user3   statement/com/Quit      0
 
655
user3   statement/sql/insert    1
 
656
user3   statement/sql/select    2
 
657
execute dump_statements_host;
 
658
host    event_name      count_star
 
659
execute dump_statements_global;
 
660
event_name      count_star
 
661
statement/com/Error     0
 
662
statement/com/Quit      0
 
663
statement/sql/insert    3
 
664
statement/sql/select    6
 
665
execute dump_statements_history;
 
666
event_name      count(event_name)
 
667
statement/sql/insert    3
 
668
statement/sql/select    6
 
669
execute dump_accounts;
 
670
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
671
execute dump_users;
 
672
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
673
root    1       1
 
674
user1   1       1
 
675
user2   1       1
 
676
user3   1       1
 
677
execute dump_hosts;
 
678
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
679
"================== con4 connected =================="
 
680
"================== Step 8 =================="
 
681
call dump_thread();
 
682
username        event_name      count_star
 
683
user1   wait/io/file/sql/query_log      4
 
684
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
685
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
686
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
687
username        event_name      count_star
 
688
user2   wait/io/file/sql/query_log      4
 
689
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
690
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
691
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
692
username        event_name      count_star
 
693
user3   wait/io/file/sql/query_log      4
 
694
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
695
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
696
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
697
username        event_name      count_star
 
698
user4   wait/io/file/sql/query_log      1
 
699
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
700
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
701
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
702
execute dump_waits_account;
 
703
user    host    event_name      count_star
 
704
execute dump_waits_user;
 
705
user    event_name      count_star
 
706
user1   wait/io/file/sql/query_log      4
 
707
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
708
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
709
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
710
user2   wait/io/file/sql/query_log      4
 
711
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
712
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
713
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
714
user3   wait/io/file/sql/query_log      4
 
715
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
716
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
717
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
718
user4   wait/io/file/sql/query_log      1
 
719
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
720
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
721
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
722
execute dump_waits_host;
 
723
host    event_name      count_star
 
724
execute dump_waits_global;
 
725
event_name      count_star
 
726
wait/io/file/sql/query_log      13
 
727
wait/synch/mutex/sql/LOCK_connection_count      0
 
728
wait/synch/mutex/sql/LOCK_user_locks    6
 
729
wait/synch/rwlock/sql/LOCK_grant        6
 
730
execute dump_waits_history;
 
731
event_name      count(event_name)
 
732
wait/io/file/sql/query_log      13
 
733
wait/synch/mutex/sql/LOCK_user_locks    6
 
734
wait/synch/rwlock/sql/LOCK_grant        6
 
735
execute dump_stages_account;
 
736
user    host    event_name      count_star
 
737
execute dump_stages_user;
 
738
user    event_name      count_star
 
739
user1   stage/sql/checking permissions  3
 
740
user1   stage/sql/closing tables        3
 
741
user1   stage/sql/init  6
 
742
user1   stage/sql/Opening tables        3
 
743
user2   stage/sql/checking permissions  3
 
744
user2   stage/sql/closing tables        3
 
745
user2   stage/sql/init  6
 
746
user2   stage/sql/Opening tables        3
 
747
user3   stage/sql/checking permissions  3
 
748
user3   stage/sql/closing tables        3
 
749
user3   stage/sql/init  6
 
750
user3   stage/sql/Opening tables        3
 
751
user4   stage/sql/checking permissions  0
 
752
user4   stage/sql/closing tables        0
 
753
user4   stage/sql/init  0
 
754
user4   stage/sql/Opening tables        0
 
755
execute dump_stages_host;
 
756
host    event_name      count_star
 
757
execute dump_stages_global;
 
758
event_name      count_star
 
759
stage/sql/checking permissions  9
 
760
stage/sql/closing tables        9
 
761
stage/sql/init  18
 
762
stage/sql/Opening tables        9
 
763
execute dump_stages_history;
 
764
event_name      count(event_name)
 
765
stage/sql/checking permissions  9
 
766
stage/sql/closing tables        9
 
767
stage/sql/init  18
 
768
stage/sql/Opening tables        9
 
769
execute dump_statements_account;
 
770
user    host    event_name      count_star
 
771
execute dump_statements_user;
 
772
user    event_name      count_star
 
773
user1   statement/com/Error     0
 
774
user1   statement/com/Quit      0
 
775
user1   statement/sql/insert    1
 
776
user1   statement/sql/select    2
 
777
user2   statement/com/Error     0
 
778
user2   statement/com/Quit      0
 
779
user2   statement/sql/insert    1
 
780
user2   statement/sql/select    2
 
781
user3   statement/com/Error     0
 
782
user3   statement/com/Quit      0
 
783
user3   statement/sql/insert    1
 
784
user3   statement/sql/select    2
 
785
user4   statement/com/Error     0
 
786
user4   statement/com/Quit      0
 
787
user4   statement/sql/insert    0
 
788
user4   statement/sql/select    0
 
789
execute dump_statements_host;
 
790
host    event_name      count_star
 
791
execute dump_statements_global;
 
792
event_name      count_star
 
793
statement/com/Error     0
 
794
statement/com/Quit      0
 
795
statement/sql/insert    3
 
796
statement/sql/select    6
 
797
execute dump_statements_history;
 
798
event_name      count(event_name)
 
799
statement/sql/insert    3
 
800
statement/sql/select    6
 
801
execute dump_accounts;
 
802
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
803
execute dump_users;
 
804
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
805
root    1       1
 
806
user1   1       1
 
807
user2   1       1
 
808
user3   1       1
 
809
user4   1       1
 
810
execute dump_hosts;
 
811
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
812
select get_lock("marker", 10);
 
813
get_lock("marker", 10)
 
814
1
 
815
select release_lock("marker");
 
816
release_lock("marker")
 
817
1
 
818
insert into test.t1 values ("marker");
 
819
"================== con4 marker =================="
 
820
"================== Step 9 =================="
 
821
call dump_thread();
 
822
username        event_name      count_star
 
823
user1   wait/io/file/sql/query_log      4
 
824
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
825
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
826
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
827
username        event_name      count_star
 
828
user2   wait/io/file/sql/query_log      4
 
829
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
830
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
831
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
832
username        event_name      count_star
 
833
user3   wait/io/file/sql/query_log      4
 
834
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
835
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
836
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
837
username        event_name      count_star
 
838
user4   wait/io/file/sql/query_log      4
 
839
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
840
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
841
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
842
execute dump_waits_account;
 
843
user    host    event_name      count_star
 
844
execute dump_waits_user;
 
845
user    event_name      count_star
 
846
user1   wait/io/file/sql/query_log      4
 
847
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
848
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
849
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
850
user2   wait/io/file/sql/query_log      4
 
851
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
852
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
853
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
854
user3   wait/io/file/sql/query_log      4
 
855
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
856
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
857
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
858
user4   wait/io/file/sql/query_log      4
 
859
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
860
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
861
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
862
execute dump_waits_host;
 
863
host    event_name      count_star
 
864
execute dump_waits_global;
 
865
event_name      count_star
 
866
wait/io/file/sql/query_log      16
 
867
wait/synch/mutex/sql/LOCK_connection_count      0
 
868
wait/synch/mutex/sql/LOCK_user_locks    8
 
869
wait/synch/rwlock/sql/LOCK_grant        8
 
870
execute dump_waits_history;
 
871
event_name      count(event_name)
 
872
wait/io/file/sql/query_log      16
 
873
wait/synch/mutex/sql/LOCK_user_locks    8
 
874
wait/synch/rwlock/sql/LOCK_grant        8
 
875
execute dump_stages_account;
 
876
user    host    event_name      count_star
 
877
execute dump_stages_user;
 
878
user    event_name      count_star
 
879
user1   stage/sql/checking permissions  3
 
880
user1   stage/sql/closing tables        3
 
881
user1   stage/sql/init  6
 
882
user1   stage/sql/Opening tables        3
 
883
user2   stage/sql/checking permissions  3
 
884
user2   stage/sql/closing tables        3
 
885
user2   stage/sql/init  6
 
886
user2   stage/sql/Opening tables        3
 
887
user3   stage/sql/checking permissions  3
 
888
user3   stage/sql/closing tables        3
 
889
user3   stage/sql/init  6
 
890
user3   stage/sql/Opening tables        3
 
891
user4   stage/sql/checking permissions  3
 
892
user4   stage/sql/closing tables        3
 
893
user4   stage/sql/init  6
 
894
user4   stage/sql/Opening tables        3
 
895
execute dump_stages_host;
 
896
host    event_name      count_star
 
897
execute dump_stages_global;
 
898
event_name      count_star
 
899
stage/sql/checking permissions  12
 
900
stage/sql/closing tables        12
 
901
stage/sql/init  24
 
902
stage/sql/Opening tables        12
 
903
execute dump_stages_history;
 
904
event_name      count(event_name)
 
905
stage/sql/checking permissions  12
 
906
stage/sql/closing tables        12
 
907
stage/sql/init  24
 
908
stage/sql/Opening tables        12
 
909
execute dump_statements_account;
 
910
user    host    event_name      count_star
 
911
execute dump_statements_user;
 
912
user    event_name      count_star
 
913
user1   statement/com/Error     0
 
914
user1   statement/com/Quit      0
 
915
user1   statement/sql/insert    1
 
916
user1   statement/sql/select    2
 
917
user2   statement/com/Error     0
 
918
user2   statement/com/Quit      0
 
919
user2   statement/sql/insert    1
 
920
user2   statement/sql/select    2
 
921
user3   statement/com/Error     0
 
922
user3   statement/com/Quit      0
 
923
user3   statement/sql/insert    1
 
924
user3   statement/sql/select    2
 
925
user4   statement/com/Error     0
 
926
user4   statement/com/Quit      0
 
927
user4   statement/sql/insert    1
 
928
user4   statement/sql/select    2
 
929
execute dump_statements_host;
 
930
host    event_name      count_star
 
931
execute dump_statements_global;
 
932
event_name      count_star
 
933
statement/com/Error     0
 
934
statement/com/Quit      0
 
935
statement/sql/insert    4
 
936
statement/sql/select    8
 
937
execute dump_statements_history;
 
938
event_name      count(event_name)
 
939
statement/sql/insert    4
 
940
statement/sql/select    8
 
941
execute dump_accounts;
 
942
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
943
execute dump_users;
 
944
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
945
root    1       1
 
946
user1   1       1
 
947
user2   1       1
 
948
user3   1       1
 
949
user4   1       1
 
950
execute dump_hosts;
 
951
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
952
"================== con1 disconnected =================="
 
953
"================== Step 10 =================="
 
954
call dump_thread();
 
955
username        status
 
956
user1   not found
 
957
username        event_name      count_star
 
958
user2   wait/io/file/sql/query_log      4
 
959
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
960
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
961
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
962
username        event_name      count_star
 
963
user3   wait/io/file/sql/query_log      4
 
964
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
965
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
966
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
967
username        event_name      count_star
 
968
user4   wait/io/file/sql/query_log      4
 
969
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
970
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
971
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
972
execute dump_waits_account;
 
973
user    host    event_name      count_star
 
974
execute dump_waits_user;
 
975
user    event_name      count_star
 
976
user1   wait/io/file/sql/query_log      5
 
977
user1   wait/synch/mutex/sql/LOCK_connection_count      1
 
978
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
979
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
980
user2   wait/io/file/sql/query_log      4
 
981
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
982
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
983
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
984
user3   wait/io/file/sql/query_log      4
 
985
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
986
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
987
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
988
user4   wait/io/file/sql/query_log      4
 
989
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
990
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
991
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
992
execute dump_waits_host;
 
993
host    event_name      count_star
 
994
execute dump_waits_global;
 
995
event_name      count_star
 
996
wait/io/file/sql/query_log      17
 
997
wait/synch/mutex/sql/LOCK_connection_count      1
 
998
wait/synch/mutex/sql/LOCK_user_locks    8
 
999
wait/synch/rwlock/sql/LOCK_grant        8
 
1000
execute dump_waits_history;
 
1001
event_name      count(event_name)
 
1002
wait/io/file/sql/query_log      17
 
1003
wait/synch/mutex/sql/LOCK_connection_count      1
 
1004
wait/synch/mutex/sql/LOCK_user_locks    8
 
1005
wait/synch/rwlock/sql/LOCK_grant        8
 
1006
execute dump_stages_account;
 
1007
user    host    event_name      count_star
 
1008
execute dump_stages_user;
 
1009
user    event_name      count_star
 
1010
user1   stage/sql/checking permissions  3
 
1011
user1   stage/sql/closing tables        3
 
1012
user1   stage/sql/init  7
 
1013
user1   stage/sql/Opening tables        3
 
1014
user2   stage/sql/checking permissions  3
 
1015
user2   stage/sql/closing tables        3
 
1016
user2   stage/sql/init  6
 
1017
user2   stage/sql/Opening tables        3
 
1018
user3   stage/sql/checking permissions  3
 
1019
user3   stage/sql/closing tables        3
 
1020
user3   stage/sql/init  6
 
1021
user3   stage/sql/Opening tables        3
 
1022
user4   stage/sql/checking permissions  3
 
1023
user4   stage/sql/closing tables        3
 
1024
user4   stage/sql/init  6
 
1025
user4   stage/sql/Opening tables        3
 
1026
execute dump_stages_host;
 
1027
host    event_name      count_star
 
1028
execute dump_stages_global;
 
1029
event_name      count_star
 
1030
stage/sql/checking permissions  12
 
1031
stage/sql/closing tables        12
 
1032
stage/sql/init  25
 
1033
stage/sql/Opening tables        12
 
1034
execute dump_stages_history;
 
1035
event_name      count(event_name)
 
1036
stage/sql/checking permissions  12
 
1037
stage/sql/closing tables        12
 
1038
stage/sql/init  25
 
1039
stage/sql/Opening tables        12
 
1040
execute dump_statements_account;
 
1041
user    host    event_name      count_star
 
1042
execute dump_statements_user;
 
1043
user    event_name      count_star
 
1044
user1   statement/com/Error     0
 
1045
user1   statement/com/Quit      1
 
1046
user1   statement/sql/insert    1
 
1047
user1   statement/sql/select    2
 
1048
user2   statement/com/Error     0
 
1049
user2   statement/com/Quit      0
 
1050
user2   statement/sql/insert    1
 
1051
user2   statement/sql/select    2
 
1052
user3   statement/com/Error     0
 
1053
user3   statement/com/Quit      0
 
1054
user3   statement/sql/insert    1
 
1055
user3   statement/sql/select    2
 
1056
user4   statement/com/Error     0
 
1057
user4   statement/com/Quit      0
 
1058
user4   statement/sql/insert    1
 
1059
user4   statement/sql/select    2
 
1060
execute dump_statements_host;
 
1061
host    event_name      count_star
 
1062
execute dump_statements_global;
 
1063
event_name      count_star
 
1064
statement/com/Error     0
 
1065
statement/com/Quit      1
 
1066
statement/sql/insert    4
 
1067
statement/sql/select    8
 
1068
execute dump_statements_history;
 
1069
event_name      count(event_name)
 
1070
statement/com/Quit      1
 
1071
statement/sql/insert    4
 
1072
statement/sql/select    8
 
1073
execute dump_accounts;
 
1074
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1075
execute dump_users;
 
1076
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1077
root    1       1
 
1078
user1   0       1
 
1079
user2   1       1
 
1080
user3   1       1
 
1081
user4   1       1
 
1082
execute dump_hosts;
 
1083
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1084
"================== con2 disconnected =================="
 
1085
"================== Step 11 =================="
 
1086
call dump_thread();
 
1087
username        status
 
1088
user1   not found
 
1089
username        status
 
1090
user2   not found
 
1091
username        event_name      count_star
 
1092
user3   wait/io/file/sql/query_log      4
 
1093
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
1094
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
1095
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
1096
username        event_name      count_star
 
1097
user4   wait/io/file/sql/query_log      4
 
1098
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
1099
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
1100
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
1101
execute dump_waits_account;
 
1102
user    host    event_name      count_star
 
1103
execute dump_waits_user;
 
1104
user    event_name      count_star
 
1105
user1   wait/io/file/sql/query_log      5
 
1106
user1   wait/synch/mutex/sql/LOCK_connection_count      1
 
1107
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
1108
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
1109
user2   wait/io/file/sql/query_log      5
 
1110
user2   wait/synch/mutex/sql/LOCK_connection_count      1
 
1111
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
1112
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
1113
user3   wait/io/file/sql/query_log      4
 
1114
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
1115
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
1116
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
1117
user4   wait/io/file/sql/query_log      4
 
1118
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
1119
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
1120
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
1121
execute dump_waits_host;
 
1122
host    event_name      count_star
 
1123
execute dump_waits_global;
 
1124
event_name      count_star
 
1125
wait/io/file/sql/query_log      18
 
1126
wait/synch/mutex/sql/LOCK_connection_count      2
 
1127
wait/synch/mutex/sql/LOCK_user_locks    8
 
1128
wait/synch/rwlock/sql/LOCK_grant        8
 
1129
execute dump_waits_history;
 
1130
event_name      count(event_name)
 
1131
wait/io/file/sql/query_log      18
 
1132
wait/synch/mutex/sql/LOCK_connection_count      2
 
1133
wait/synch/mutex/sql/LOCK_user_locks    8
 
1134
wait/synch/rwlock/sql/LOCK_grant        8
 
1135
execute dump_stages_account;
 
1136
user    host    event_name      count_star
 
1137
execute dump_stages_user;
 
1138
user    event_name      count_star
 
1139
user1   stage/sql/checking permissions  3
 
1140
user1   stage/sql/closing tables        3
 
1141
user1   stage/sql/init  7
 
1142
user1   stage/sql/Opening tables        3
 
1143
user2   stage/sql/checking permissions  3
 
1144
user2   stage/sql/closing tables        3
 
1145
user2   stage/sql/init  7
 
1146
user2   stage/sql/Opening tables        3
 
1147
user3   stage/sql/checking permissions  3
 
1148
user3   stage/sql/closing tables        3
 
1149
user3   stage/sql/init  6
 
1150
user3   stage/sql/Opening tables        3
 
1151
user4   stage/sql/checking permissions  3
 
1152
user4   stage/sql/closing tables        3
 
1153
user4   stage/sql/init  6
 
1154
user4   stage/sql/Opening tables        3
 
1155
execute dump_stages_host;
 
1156
host    event_name      count_star
 
1157
execute dump_stages_global;
 
1158
event_name      count_star
 
1159
stage/sql/checking permissions  12
 
1160
stage/sql/closing tables        12
 
1161
stage/sql/init  26
 
1162
stage/sql/Opening tables        12
 
1163
execute dump_stages_history;
 
1164
event_name      count(event_name)
 
1165
stage/sql/checking permissions  12
 
1166
stage/sql/closing tables        12
 
1167
stage/sql/init  26
 
1168
stage/sql/Opening tables        12
 
1169
execute dump_statements_account;
 
1170
user    host    event_name      count_star
 
1171
execute dump_statements_user;
 
1172
user    event_name      count_star
 
1173
user1   statement/com/Error     0
 
1174
user1   statement/com/Quit      1
 
1175
user1   statement/sql/insert    1
 
1176
user1   statement/sql/select    2
 
1177
user2   statement/com/Error     0
 
1178
user2   statement/com/Quit      1
 
1179
user2   statement/sql/insert    1
 
1180
user2   statement/sql/select    2
 
1181
user3   statement/com/Error     0
 
1182
user3   statement/com/Quit      0
 
1183
user3   statement/sql/insert    1
 
1184
user3   statement/sql/select    2
 
1185
user4   statement/com/Error     0
 
1186
user4   statement/com/Quit      0
 
1187
user4   statement/sql/insert    1
 
1188
user4   statement/sql/select    2
 
1189
execute dump_statements_host;
 
1190
host    event_name      count_star
 
1191
execute dump_statements_global;
 
1192
event_name      count_star
 
1193
statement/com/Error     0
 
1194
statement/com/Quit      2
 
1195
statement/sql/insert    4
 
1196
statement/sql/select    8
 
1197
execute dump_statements_history;
 
1198
event_name      count(event_name)
 
1199
statement/com/Quit      2
 
1200
statement/sql/insert    4
 
1201
statement/sql/select    8
 
1202
execute dump_accounts;
 
1203
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1204
execute dump_users;
 
1205
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1206
root    1       1
 
1207
user1   0       1
 
1208
user2   0       1
 
1209
user3   1       1
 
1210
user4   1       1
 
1211
execute dump_hosts;
 
1212
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1213
"================== con3 disconnected =================="
 
1214
"================== Step 12 =================="
 
1215
call dump_thread();
 
1216
username        status
 
1217
user1   not found
 
1218
username        status
 
1219
user2   not found
 
1220
username        status
 
1221
user3   not found
 
1222
username        event_name      count_star
 
1223
user4   wait/io/file/sql/query_log      4
 
1224
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
1225
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
1226
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
1227
execute dump_waits_account;
 
1228
user    host    event_name      count_star
 
1229
execute dump_waits_user;
 
1230
user    event_name      count_star
 
1231
user1   wait/io/file/sql/query_log      5
 
1232
user1   wait/synch/mutex/sql/LOCK_connection_count      1
 
1233
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
1234
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
1235
user2   wait/io/file/sql/query_log      5
 
1236
user2   wait/synch/mutex/sql/LOCK_connection_count      1
 
1237
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
1238
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
1239
user3   wait/io/file/sql/query_log      5
 
1240
user3   wait/synch/mutex/sql/LOCK_connection_count      1
 
1241
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
1242
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
1243
user4   wait/io/file/sql/query_log      4
 
1244
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
1245
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
1246
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
1247
execute dump_waits_host;
 
1248
host    event_name      count_star
 
1249
execute dump_waits_global;
 
1250
event_name      count_star
 
1251
wait/io/file/sql/query_log      19
 
1252
wait/synch/mutex/sql/LOCK_connection_count      3
 
1253
wait/synch/mutex/sql/LOCK_user_locks    8
 
1254
wait/synch/rwlock/sql/LOCK_grant        8
 
1255
execute dump_waits_history;
 
1256
event_name      count(event_name)
 
1257
wait/io/file/sql/query_log      19
 
1258
wait/synch/mutex/sql/LOCK_connection_count      3
 
1259
wait/synch/mutex/sql/LOCK_user_locks    8
 
1260
wait/synch/rwlock/sql/LOCK_grant        8
 
1261
execute dump_stages_account;
 
1262
user    host    event_name      count_star
 
1263
execute dump_stages_user;
 
1264
user    event_name      count_star
 
1265
user1   stage/sql/checking permissions  3
 
1266
user1   stage/sql/closing tables        3
 
1267
user1   stage/sql/init  7
 
1268
user1   stage/sql/Opening tables        3
 
1269
user2   stage/sql/checking permissions  3
 
1270
user2   stage/sql/closing tables        3
 
1271
user2   stage/sql/init  7
 
1272
user2   stage/sql/Opening tables        3
 
1273
user3   stage/sql/checking permissions  3
 
1274
user3   stage/sql/closing tables        3
 
1275
user3   stage/sql/init  7
 
1276
user3   stage/sql/Opening tables        3
 
1277
user4   stage/sql/checking permissions  3
 
1278
user4   stage/sql/closing tables        3
 
1279
user4   stage/sql/init  6
 
1280
user4   stage/sql/Opening tables        3
 
1281
execute dump_stages_host;
 
1282
host    event_name      count_star
 
1283
execute dump_stages_global;
 
1284
event_name      count_star
 
1285
stage/sql/checking permissions  12
 
1286
stage/sql/closing tables        12
 
1287
stage/sql/init  27
 
1288
stage/sql/Opening tables        12
 
1289
execute dump_stages_history;
 
1290
event_name      count(event_name)
 
1291
stage/sql/checking permissions  12
 
1292
stage/sql/closing tables        12
 
1293
stage/sql/init  27
 
1294
stage/sql/Opening tables        12
 
1295
execute dump_statements_account;
 
1296
user    host    event_name      count_star
 
1297
execute dump_statements_user;
 
1298
user    event_name      count_star
 
1299
user1   statement/com/Error     0
 
1300
user1   statement/com/Quit      1
 
1301
user1   statement/sql/insert    1
 
1302
user1   statement/sql/select    2
 
1303
user2   statement/com/Error     0
 
1304
user2   statement/com/Quit      1
 
1305
user2   statement/sql/insert    1
 
1306
user2   statement/sql/select    2
 
1307
user3   statement/com/Error     0
 
1308
user3   statement/com/Quit      1
 
1309
user3   statement/sql/insert    1
 
1310
user3   statement/sql/select    2
 
1311
user4   statement/com/Error     0
 
1312
user4   statement/com/Quit      0
 
1313
user4   statement/sql/insert    1
 
1314
user4   statement/sql/select    2
 
1315
execute dump_statements_host;
 
1316
host    event_name      count_star
 
1317
execute dump_statements_global;
 
1318
event_name      count_star
 
1319
statement/com/Error     0
 
1320
statement/com/Quit      3
 
1321
statement/sql/insert    4
 
1322
statement/sql/select    8
 
1323
execute dump_statements_history;
 
1324
event_name      count(event_name)
 
1325
statement/com/Quit      3
 
1326
statement/sql/insert    4
 
1327
statement/sql/select    8
 
1328
execute dump_accounts;
 
1329
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1330
execute dump_users;
 
1331
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1332
root    1       1
 
1333
user1   0       1
 
1334
user2   0       1
 
1335
user3   0       1
 
1336
user4   1       1
 
1337
execute dump_hosts;
 
1338
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1339
"================== con4 disconnected =================="
 
1340
"================== Step 13 =================="
 
1341
call dump_thread();
 
1342
username        status
 
1343
user1   not found
 
1344
username        status
 
1345
user2   not found
 
1346
username        status
 
1347
user3   not found
 
1348
username        status
 
1349
user4   not found
 
1350
execute dump_waits_account;
 
1351
user    host    event_name      count_star
 
1352
execute dump_waits_user;
 
1353
user    event_name      count_star
 
1354
user1   wait/io/file/sql/query_log      5
 
1355
user1   wait/synch/mutex/sql/LOCK_connection_count      1
 
1356
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
1357
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
1358
user2   wait/io/file/sql/query_log      5
 
1359
user2   wait/synch/mutex/sql/LOCK_connection_count      1
 
1360
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
1361
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
1362
user3   wait/io/file/sql/query_log      5
 
1363
user3   wait/synch/mutex/sql/LOCK_connection_count      1
 
1364
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
1365
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
1366
user4   wait/io/file/sql/query_log      5
 
1367
user4   wait/synch/mutex/sql/LOCK_connection_count      1
 
1368
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
1369
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
1370
execute dump_waits_host;
 
1371
host    event_name      count_star
 
1372
execute dump_waits_global;
 
1373
event_name      count_star
 
1374
wait/io/file/sql/query_log      20
 
1375
wait/synch/mutex/sql/LOCK_connection_count      4
 
1376
wait/synch/mutex/sql/LOCK_user_locks    8
 
1377
wait/synch/rwlock/sql/LOCK_grant        8
 
1378
execute dump_waits_history;
 
1379
event_name      count(event_name)
 
1380
wait/io/file/sql/query_log      20
 
1381
wait/synch/mutex/sql/LOCK_connection_count      4
 
1382
wait/synch/mutex/sql/LOCK_user_locks    8
 
1383
wait/synch/rwlock/sql/LOCK_grant        8
 
1384
execute dump_stages_account;
 
1385
user    host    event_name      count_star
 
1386
execute dump_stages_user;
 
1387
user    event_name      count_star
 
1388
user1   stage/sql/checking permissions  3
 
1389
user1   stage/sql/closing tables        3
 
1390
user1   stage/sql/init  7
 
1391
user1   stage/sql/Opening tables        3
 
1392
user2   stage/sql/checking permissions  3
 
1393
user2   stage/sql/closing tables        3
 
1394
user2   stage/sql/init  7
 
1395
user2   stage/sql/Opening tables        3
 
1396
user3   stage/sql/checking permissions  3
 
1397
user3   stage/sql/closing tables        3
 
1398
user3   stage/sql/init  7
 
1399
user3   stage/sql/Opening tables        3
 
1400
user4   stage/sql/checking permissions  3
 
1401
user4   stage/sql/closing tables        3
 
1402
user4   stage/sql/init  7
 
1403
user4   stage/sql/Opening tables        3
 
1404
execute dump_stages_host;
 
1405
host    event_name      count_star
 
1406
execute dump_stages_global;
 
1407
event_name      count_star
 
1408
stage/sql/checking permissions  12
 
1409
stage/sql/closing tables        12
 
1410
stage/sql/init  28
 
1411
stage/sql/Opening tables        12
 
1412
execute dump_stages_history;
 
1413
event_name      count(event_name)
 
1414
stage/sql/checking permissions  12
 
1415
stage/sql/closing tables        12
 
1416
stage/sql/init  28
 
1417
stage/sql/Opening tables        12
 
1418
execute dump_statements_account;
 
1419
user    host    event_name      count_star
 
1420
execute dump_statements_user;
 
1421
user    event_name      count_star
 
1422
user1   statement/com/Error     0
 
1423
user1   statement/com/Quit      1
 
1424
user1   statement/sql/insert    1
 
1425
user1   statement/sql/select    2
 
1426
user2   statement/com/Error     0
 
1427
user2   statement/com/Quit      1
 
1428
user2   statement/sql/insert    1
 
1429
user2   statement/sql/select    2
 
1430
user3   statement/com/Error     0
 
1431
user3   statement/com/Quit      1
 
1432
user3   statement/sql/insert    1
 
1433
user3   statement/sql/select    2
 
1434
user4   statement/com/Error     0
 
1435
user4   statement/com/Quit      1
 
1436
user4   statement/sql/insert    1
 
1437
user4   statement/sql/select    2
 
1438
execute dump_statements_host;
 
1439
host    event_name      count_star
 
1440
execute dump_statements_global;
 
1441
event_name      count_star
 
1442
statement/com/Error     0
 
1443
statement/com/Quit      4
 
1444
statement/sql/insert    4
 
1445
statement/sql/select    8
 
1446
execute dump_statements_history;
 
1447
event_name      count(event_name)
 
1448
statement/com/Quit      4
 
1449
statement/sql/insert    4
 
1450
statement/sql/select    8
 
1451
execute dump_accounts;
 
1452
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1453
execute dump_users;
 
1454
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1455
root    1       1
 
1456
user1   0       1
 
1457
user2   0       1
 
1458
user3   0       1
 
1459
user4   0       1
 
1460
execute dump_hosts;
 
1461
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1462
truncate performance_schema.events_waits_summary_by_thread_by_event_name;
 
1463
"================== WAITS_BY_THREAD truncated =================="
 
1464
"================== Step 14 =================="
 
1465
call dump_thread();
 
1466
username        status
 
1467
user1   not found
 
1468
username        status
 
1469
user2   not found
 
1470
username        status
 
1471
user3   not found
 
1472
username        status
 
1473
user4   not found
 
1474
execute dump_waits_account;
 
1475
user    host    event_name      count_star
 
1476
execute dump_waits_user;
 
1477
user    event_name      count_star
 
1478
user1   wait/io/file/sql/query_log      5
 
1479
user1   wait/synch/mutex/sql/LOCK_connection_count      1
 
1480
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
1481
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
1482
user2   wait/io/file/sql/query_log      5
 
1483
user2   wait/synch/mutex/sql/LOCK_connection_count      1
 
1484
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
1485
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
1486
user3   wait/io/file/sql/query_log      5
 
1487
user3   wait/synch/mutex/sql/LOCK_connection_count      1
 
1488
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
1489
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
1490
user4   wait/io/file/sql/query_log      5
 
1491
user4   wait/synch/mutex/sql/LOCK_connection_count      1
 
1492
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
1493
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
1494
execute dump_waits_host;
 
1495
host    event_name      count_star
 
1496
execute dump_waits_global;
 
1497
event_name      count_star
 
1498
wait/io/file/sql/query_log      20
 
1499
wait/synch/mutex/sql/LOCK_connection_count      4
 
1500
wait/synch/mutex/sql/LOCK_user_locks    8
 
1501
wait/synch/rwlock/sql/LOCK_grant        8
 
1502
execute dump_waits_history;
 
1503
event_name      count(event_name)
 
1504
wait/io/file/sql/query_log      20
 
1505
wait/synch/mutex/sql/LOCK_connection_count      4
 
1506
wait/synch/mutex/sql/LOCK_user_locks    8
 
1507
wait/synch/rwlock/sql/LOCK_grant        8
 
1508
execute dump_stages_account;
 
1509
user    host    event_name      count_star
 
1510
execute dump_stages_user;
 
1511
user    event_name      count_star
 
1512
user1   stage/sql/checking permissions  3
 
1513
user1   stage/sql/closing tables        3
 
1514
user1   stage/sql/init  7
 
1515
user1   stage/sql/Opening tables        3
 
1516
user2   stage/sql/checking permissions  3
 
1517
user2   stage/sql/closing tables        3
 
1518
user2   stage/sql/init  7
 
1519
user2   stage/sql/Opening tables        3
 
1520
user3   stage/sql/checking permissions  3
 
1521
user3   stage/sql/closing tables        3
 
1522
user3   stage/sql/init  7
 
1523
user3   stage/sql/Opening tables        3
 
1524
user4   stage/sql/checking permissions  3
 
1525
user4   stage/sql/closing tables        3
 
1526
user4   stage/sql/init  7
 
1527
user4   stage/sql/Opening tables        3
 
1528
execute dump_stages_host;
 
1529
host    event_name      count_star
 
1530
execute dump_stages_global;
 
1531
event_name      count_star
 
1532
stage/sql/checking permissions  12
 
1533
stage/sql/closing tables        12
 
1534
stage/sql/init  28
 
1535
stage/sql/Opening tables        12
 
1536
execute dump_stages_history;
 
1537
event_name      count(event_name)
 
1538
stage/sql/checking permissions  12
 
1539
stage/sql/closing tables        12
 
1540
stage/sql/init  28
 
1541
stage/sql/Opening tables        12
 
1542
execute dump_statements_account;
 
1543
user    host    event_name      count_star
 
1544
execute dump_statements_user;
 
1545
user    event_name      count_star
 
1546
user1   statement/com/Error     0
 
1547
user1   statement/com/Quit      1
 
1548
user1   statement/sql/insert    1
 
1549
user1   statement/sql/select    2
 
1550
user2   statement/com/Error     0
 
1551
user2   statement/com/Quit      1
 
1552
user2   statement/sql/insert    1
 
1553
user2   statement/sql/select    2
 
1554
user3   statement/com/Error     0
 
1555
user3   statement/com/Quit      1
 
1556
user3   statement/sql/insert    1
 
1557
user3   statement/sql/select    2
 
1558
user4   statement/com/Error     0
 
1559
user4   statement/com/Quit      1
 
1560
user4   statement/sql/insert    1
 
1561
user4   statement/sql/select    2
 
1562
execute dump_statements_host;
 
1563
host    event_name      count_star
 
1564
execute dump_statements_global;
 
1565
event_name      count_star
 
1566
statement/com/Error     0
 
1567
statement/com/Quit      4
 
1568
statement/sql/insert    4
 
1569
statement/sql/select    8
 
1570
execute dump_statements_history;
 
1571
event_name      count(event_name)
 
1572
statement/com/Quit      4
 
1573
statement/sql/insert    4
 
1574
statement/sql/select    8
 
1575
execute dump_accounts;
 
1576
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1577
execute dump_users;
 
1578
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1579
root    1       1
 
1580
user1   0       1
 
1581
user2   0       1
 
1582
user3   0       1
 
1583
user4   0       1
 
1584
execute dump_hosts;
 
1585
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1586
truncate performance_schema.events_waits_summary_by_account_by_event_name;
 
1587
"================== WAITS_BY_ACCOUNT truncated =================="
 
1588
"================== Step 15 =================="
 
1589
call dump_thread();
 
1590
username        status
 
1591
user1   not found
 
1592
username        status
 
1593
user2   not found
 
1594
username        status
 
1595
user3   not found
 
1596
username        status
 
1597
user4   not found
 
1598
execute dump_waits_account;
 
1599
user    host    event_name      count_star
 
1600
execute dump_waits_user;
 
1601
user    event_name      count_star
 
1602
user1   wait/io/file/sql/query_log      5
 
1603
user1   wait/synch/mutex/sql/LOCK_connection_count      1
 
1604
user1   wait/synch/mutex/sql/LOCK_user_locks    2
 
1605
user1   wait/synch/rwlock/sql/LOCK_grant        2
 
1606
user2   wait/io/file/sql/query_log      5
 
1607
user2   wait/synch/mutex/sql/LOCK_connection_count      1
 
1608
user2   wait/synch/mutex/sql/LOCK_user_locks    2
 
1609
user2   wait/synch/rwlock/sql/LOCK_grant        2
 
1610
user3   wait/io/file/sql/query_log      5
 
1611
user3   wait/synch/mutex/sql/LOCK_connection_count      1
 
1612
user3   wait/synch/mutex/sql/LOCK_user_locks    2
 
1613
user3   wait/synch/rwlock/sql/LOCK_grant        2
 
1614
user4   wait/io/file/sql/query_log      5
 
1615
user4   wait/synch/mutex/sql/LOCK_connection_count      1
 
1616
user4   wait/synch/mutex/sql/LOCK_user_locks    2
 
1617
user4   wait/synch/rwlock/sql/LOCK_grant        2
 
1618
execute dump_waits_host;
 
1619
host    event_name      count_star
 
1620
execute dump_waits_global;
 
1621
event_name      count_star
 
1622
wait/io/file/sql/query_log      20
 
1623
wait/synch/mutex/sql/LOCK_connection_count      4
 
1624
wait/synch/mutex/sql/LOCK_user_locks    8
 
1625
wait/synch/rwlock/sql/LOCK_grant        8
 
1626
execute dump_waits_history;
 
1627
event_name      count(event_name)
 
1628
wait/io/file/sql/query_log      20
 
1629
wait/synch/mutex/sql/LOCK_connection_count      4
 
1630
wait/synch/mutex/sql/LOCK_user_locks    8
 
1631
wait/synch/rwlock/sql/LOCK_grant        8
 
1632
execute dump_stages_account;
 
1633
user    host    event_name      count_star
 
1634
execute dump_stages_user;
 
1635
user    event_name      count_star
 
1636
user1   stage/sql/checking permissions  3
 
1637
user1   stage/sql/closing tables        3
 
1638
user1   stage/sql/init  7
 
1639
user1   stage/sql/Opening tables        3
 
1640
user2   stage/sql/checking permissions  3
 
1641
user2   stage/sql/closing tables        3
 
1642
user2   stage/sql/init  7
 
1643
user2   stage/sql/Opening tables        3
 
1644
user3   stage/sql/checking permissions  3
 
1645
user3   stage/sql/closing tables        3
 
1646
user3   stage/sql/init  7
 
1647
user3   stage/sql/Opening tables        3
 
1648
user4   stage/sql/checking permissions  3
 
1649
user4   stage/sql/closing tables        3
 
1650
user4   stage/sql/init  7
 
1651
user4   stage/sql/Opening tables        3
 
1652
execute dump_stages_host;
 
1653
host    event_name      count_star
 
1654
execute dump_stages_global;
 
1655
event_name      count_star
 
1656
stage/sql/checking permissions  12
 
1657
stage/sql/closing tables        12
 
1658
stage/sql/init  28
 
1659
stage/sql/Opening tables        12
 
1660
execute dump_stages_history;
 
1661
event_name      count(event_name)
 
1662
stage/sql/checking permissions  12
 
1663
stage/sql/closing tables        12
 
1664
stage/sql/init  28
 
1665
stage/sql/Opening tables        12
 
1666
execute dump_statements_account;
 
1667
user    host    event_name      count_star
 
1668
execute dump_statements_user;
 
1669
user    event_name      count_star
 
1670
user1   statement/com/Error     0
 
1671
user1   statement/com/Quit      1
 
1672
user1   statement/sql/insert    1
 
1673
user1   statement/sql/select    2
 
1674
user2   statement/com/Error     0
 
1675
user2   statement/com/Quit      1
 
1676
user2   statement/sql/insert    1
 
1677
user2   statement/sql/select    2
 
1678
user3   statement/com/Error     0
 
1679
user3   statement/com/Quit      1
 
1680
user3   statement/sql/insert    1
 
1681
user3   statement/sql/select    2
 
1682
user4   statement/com/Error     0
 
1683
user4   statement/com/Quit      1
 
1684
user4   statement/sql/insert    1
 
1685
user4   statement/sql/select    2
 
1686
execute dump_statements_host;
 
1687
host    event_name      count_star
 
1688
execute dump_statements_global;
 
1689
event_name      count_star
 
1690
statement/com/Error     0
 
1691
statement/com/Quit      4
 
1692
statement/sql/insert    4
 
1693
statement/sql/select    8
 
1694
execute dump_statements_history;
 
1695
event_name      count(event_name)
 
1696
statement/com/Quit      4
 
1697
statement/sql/insert    4
 
1698
statement/sql/select    8
 
1699
execute dump_accounts;
 
1700
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1701
execute dump_users;
 
1702
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1703
root    1       1
 
1704
user1   0       1
 
1705
user2   0       1
 
1706
user3   0       1
 
1707
user4   0       1
 
1708
execute dump_hosts;
 
1709
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1710
truncate performance_schema.events_waits_summary_by_user_by_event_name;
 
1711
"================== WAITS_BY_USER truncated =================="
 
1712
"================== Step 16 =================="
 
1713
call dump_thread();
 
1714
username        status
 
1715
user1   not found
 
1716
username        status
 
1717
user2   not found
 
1718
username        status
 
1719
user3   not found
 
1720
username        status
 
1721
user4   not found
 
1722
execute dump_waits_account;
 
1723
user    host    event_name      count_star
 
1724
execute dump_waits_user;
 
1725
user    event_name      count_star
 
1726
user1   wait/io/file/sql/query_log      0
 
1727
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
1728
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
1729
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
1730
user2   wait/io/file/sql/query_log      0
 
1731
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
1732
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
1733
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
1734
user3   wait/io/file/sql/query_log      0
 
1735
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
1736
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
1737
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
1738
user4   wait/io/file/sql/query_log      0
 
1739
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
1740
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
1741
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
1742
execute dump_waits_host;
 
1743
host    event_name      count_star
 
1744
execute dump_waits_global;
 
1745
event_name      count_star
 
1746
wait/io/file/sql/query_log      20
 
1747
wait/synch/mutex/sql/LOCK_connection_count      4
 
1748
wait/synch/mutex/sql/LOCK_user_locks    8
 
1749
wait/synch/rwlock/sql/LOCK_grant        8
 
1750
execute dump_waits_history;
 
1751
event_name      count(event_name)
 
1752
wait/io/file/sql/query_log      20
 
1753
wait/synch/mutex/sql/LOCK_connection_count      4
 
1754
wait/synch/mutex/sql/LOCK_user_locks    8
 
1755
wait/synch/rwlock/sql/LOCK_grant        8
 
1756
execute dump_stages_account;
 
1757
user    host    event_name      count_star
 
1758
execute dump_stages_user;
 
1759
user    event_name      count_star
 
1760
user1   stage/sql/checking permissions  3
 
1761
user1   stage/sql/closing tables        3
 
1762
user1   stage/sql/init  7
 
1763
user1   stage/sql/Opening tables        3
 
1764
user2   stage/sql/checking permissions  3
 
1765
user2   stage/sql/closing tables        3
 
1766
user2   stage/sql/init  7
 
1767
user2   stage/sql/Opening tables        3
 
1768
user3   stage/sql/checking permissions  3
 
1769
user3   stage/sql/closing tables        3
 
1770
user3   stage/sql/init  7
 
1771
user3   stage/sql/Opening tables        3
 
1772
user4   stage/sql/checking permissions  3
 
1773
user4   stage/sql/closing tables        3
 
1774
user4   stage/sql/init  7
 
1775
user4   stage/sql/Opening tables        3
 
1776
execute dump_stages_host;
 
1777
host    event_name      count_star
 
1778
execute dump_stages_global;
 
1779
event_name      count_star
 
1780
stage/sql/checking permissions  12
 
1781
stage/sql/closing tables        12
 
1782
stage/sql/init  28
 
1783
stage/sql/Opening tables        12
 
1784
execute dump_stages_history;
 
1785
event_name      count(event_name)
 
1786
stage/sql/checking permissions  12
 
1787
stage/sql/closing tables        12
 
1788
stage/sql/init  28
 
1789
stage/sql/Opening tables        12
 
1790
execute dump_statements_account;
 
1791
user    host    event_name      count_star
 
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/sql/insert    1
 
1797
user1   statement/sql/select    2
 
1798
user2   statement/com/Error     0
 
1799
user2   statement/com/Quit      1
 
1800
user2   statement/sql/insert    1
 
1801
user2   statement/sql/select    2
 
1802
user3   statement/com/Error     0
 
1803
user3   statement/com/Quit      1
 
1804
user3   statement/sql/insert    1
 
1805
user3   statement/sql/select    2
 
1806
user4   statement/com/Error     0
 
1807
user4   statement/com/Quit      1
 
1808
user4   statement/sql/insert    1
 
1809
user4   statement/sql/select    2
 
1810
execute dump_statements_host;
 
1811
host    event_name      count_star
 
1812
execute dump_statements_global;
 
1813
event_name      count_star
 
1814
statement/com/Error     0
 
1815
statement/com/Quit      4
 
1816
statement/sql/insert    4
 
1817
statement/sql/select    8
 
1818
execute dump_statements_history;
 
1819
event_name      count(event_name)
 
1820
statement/com/Quit      4
 
1821
statement/sql/insert    4
 
1822
statement/sql/select    8
 
1823
execute dump_accounts;
 
1824
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1825
execute dump_users;
 
1826
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1827
root    1       1
 
1828
user1   0       1
 
1829
user2   0       1
 
1830
user3   0       1
 
1831
user4   0       1
 
1832
execute dump_hosts;
 
1833
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1834
truncate performance_schema.events_waits_summary_by_host_by_event_name;
 
1835
"================== WAITS_BY_HOST truncated =================="
 
1836
"================== Step 17 =================="
 
1837
call dump_thread();
 
1838
username        status
 
1839
user1   not found
 
1840
username        status
 
1841
user2   not found
 
1842
username        status
 
1843
user3   not found
 
1844
username        status
 
1845
user4   not found
 
1846
execute dump_waits_account;
 
1847
user    host    event_name      count_star
 
1848
execute dump_waits_user;
 
1849
user    event_name      count_star
 
1850
user1   wait/io/file/sql/query_log      0
 
1851
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
1852
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
1853
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
1854
user2   wait/io/file/sql/query_log      0
 
1855
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
1856
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
1857
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
1858
user3   wait/io/file/sql/query_log      0
 
1859
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
1860
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
1861
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
1862
user4   wait/io/file/sql/query_log      0
 
1863
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
1864
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
1865
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
1866
execute dump_waits_host;
 
1867
host    event_name      count_star
 
1868
execute dump_waits_global;
 
1869
event_name      count_star
 
1870
wait/io/file/sql/query_log      20
 
1871
wait/synch/mutex/sql/LOCK_connection_count      4
 
1872
wait/synch/mutex/sql/LOCK_user_locks    8
 
1873
wait/synch/rwlock/sql/LOCK_grant        8
 
1874
execute dump_waits_history;
 
1875
event_name      count(event_name)
 
1876
wait/io/file/sql/query_log      20
 
1877
wait/synch/mutex/sql/LOCK_connection_count      4
 
1878
wait/synch/mutex/sql/LOCK_user_locks    8
 
1879
wait/synch/rwlock/sql/LOCK_grant        8
 
1880
execute dump_stages_account;
 
1881
user    host    event_name      count_star
 
1882
execute dump_stages_user;
 
1883
user    event_name      count_star
 
1884
user1   stage/sql/checking permissions  3
 
1885
user1   stage/sql/closing tables        3
 
1886
user1   stage/sql/init  7
 
1887
user1   stage/sql/Opening tables        3
 
1888
user2   stage/sql/checking permissions  3
 
1889
user2   stage/sql/closing tables        3
 
1890
user2   stage/sql/init  7
 
1891
user2   stage/sql/Opening tables        3
 
1892
user3   stage/sql/checking permissions  3
 
1893
user3   stage/sql/closing tables        3
 
1894
user3   stage/sql/init  7
 
1895
user3   stage/sql/Opening tables        3
 
1896
user4   stage/sql/checking permissions  3
 
1897
user4   stage/sql/closing tables        3
 
1898
user4   stage/sql/init  7
 
1899
user4   stage/sql/Opening tables        3
 
1900
execute dump_stages_host;
 
1901
host    event_name      count_star
 
1902
execute dump_stages_global;
 
1903
event_name      count_star
 
1904
stage/sql/checking permissions  12
 
1905
stage/sql/closing tables        12
 
1906
stage/sql/init  28
 
1907
stage/sql/Opening tables        12
 
1908
execute dump_stages_history;
 
1909
event_name      count(event_name)
 
1910
stage/sql/checking permissions  12
 
1911
stage/sql/closing tables        12
 
1912
stage/sql/init  28
 
1913
stage/sql/Opening tables        12
 
1914
execute dump_statements_account;
 
1915
user    host    event_name      count_star
 
1916
execute dump_statements_user;
 
1917
user    event_name      count_star
 
1918
user1   statement/com/Error     0
 
1919
user1   statement/com/Quit      1
 
1920
user1   statement/sql/insert    1
 
1921
user1   statement/sql/select    2
 
1922
user2   statement/com/Error     0
 
1923
user2   statement/com/Quit      1
 
1924
user2   statement/sql/insert    1
 
1925
user2   statement/sql/select    2
 
1926
user3   statement/com/Error     0
 
1927
user3   statement/com/Quit      1
 
1928
user3   statement/sql/insert    1
 
1929
user3   statement/sql/select    2
 
1930
user4   statement/com/Error     0
 
1931
user4   statement/com/Quit      1
 
1932
user4   statement/sql/insert    1
 
1933
user4   statement/sql/select    2
 
1934
execute dump_statements_host;
 
1935
host    event_name      count_star
 
1936
execute dump_statements_global;
 
1937
event_name      count_star
 
1938
statement/com/Error     0
 
1939
statement/com/Quit      4
 
1940
statement/sql/insert    4
 
1941
statement/sql/select    8
 
1942
execute dump_statements_history;
 
1943
event_name      count(event_name)
 
1944
statement/com/Quit      4
 
1945
statement/sql/insert    4
 
1946
statement/sql/select    8
 
1947
execute dump_accounts;
 
1948
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1949
execute dump_users;
 
1950
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1951
root    1       1
 
1952
user1   0       1
 
1953
user2   0       1
 
1954
user3   0       1
 
1955
user4   0       1
 
1956
execute dump_hosts;
 
1957
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
1958
truncate performance_schema.events_waits_summary_global_by_event_name;
 
1959
"================== WAITS_GLOBAL truncated =================="
 
1960
"================== Step 18 =================="
 
1961
call dump_thread();
 
1962
username        status
 
1963
user1   not found
 
1964
username        status
 
1965
user2   not found
 
1966
username        status
 
1967
user3   not found
 
1968
username        status
 
1969
user4   not found
 
1970
execute dump_waits_account;
 
1971
user    host    event_name      count_star
 
1972
execute dump_waits_user;
 
1973
user    event_name      count_star
 
1974
user1   wait/io/file/sql/query_log      0
 
1975
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
1976
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
1977
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
1978
user2   wait/io/file/sql/query_log      0
 
1979
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
1980
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
1981
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
1982
user3   wait/io/file/sql/query_log      0
 
1983
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
1984
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
1985
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
1986
user4   wait/io/file/sql/query_log      0
 
1987
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
1988
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
1989
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
1990
execute dump_waits_host;
 
1991
host    event_name      count_star
 
1992
execute dump_waits_global;
 
1993
event_name      count_star
 
1994
wait/io/file/sql/query_log      0
 
1995
wait/synch/mutex/sql/LOCK_connection_count      0
 
1996
wait/synch/mutex/sql/LOCK_user_locks    0
 
1997
wait/synch/rwlock/sql/LOCK_grant        0
 
1998
execute dump_waits_history;
 
1999
event_name      count(event_name)
 
2000
wait/io/file/sql/query_log      20
 
2001
wait/synch/mutex/sql/LOCK_connection_count      4
 
2002
wait/synch/mutex/sql/LOCK_user_locks    8
 
2003
wait/synch/rwlock/sql/LOCK_grant        8
 
2004
execute dump_stages_account;
 
2005
user    host    event_name      count_star
 
2006
execute dump_stages_user;
 
2007
user    event_name      count_star
 
2008
user1   stage/sql/checking permissions  3
 
2009
user1   stage/sql/closing tables        3
 
2010
user1   stage/sql/init  7
 
2011
user1   stage/sql/Opening tables        3
 
2012
user2   stage/sql/checking permissions  3
 
2013
user2   stage/sql/closing tables        3
 
2014
user2   stage/sql/init  7
 
2015
user2   stage/sql/Opening tables        3
 
2016
user3   stage/sql/checking permissions  3
 
2017
user3   stage/sql/closing tables        3
 
2018
user3   stage/sql/init  7
 
2019
user3   stage/sql/Opening tables        3
 
2020
user4   stage/sql/checking permissions  3
 
2021
user4   stage/sql/closing tables        3
 
2022
user4   stage/sql/init  7
 
2023
user4   stage/sql/Opening tables        3
 
2024
execute dump_stages_host;
 
2025
host    event_name      count_star
 
2026
execute dump_stages_global;
 
2027
event_name      count_star
 
2028
stage/sql/checking permissions  12
 
2029
stage/sql/closing tables        12
 
2030
stage/sql/init  28
 
2031
stage/sql/Opening tables        12
 
2032
execute dump_stages_history;
 
2033
event_name      count(event_name)
 
2034
stage/sql/checking permissions  12
 
2035
stage/sql/closing tables        12
 
2036
stage/sql/init  28
 
2037
stage/sql/Opening tables        12
 
2038
execute dump_statements_account;
 
2039
user    host    event_name      count_star
 
2040
execute dump_statements_user;
 
2041
user    event_name      count_star
 
2042
user1   statement/com/Error     0
 
2043
user1   statement/com/Quit      1
 
2044
user1   statement/sql/insert    1
 
2045
user1   statement/sql/select    2
 
2046
user2   statement/com/Error     0
 
2047
user2   statement/com/Quit      1
 
2048
user2   statement/sql/insert    1
 
2049
user2   statement/sql/select    2
 
2050
user3   statement/com/Error     0
 
2051
user3   statement/com/Quit      1
 
2052
user3   statement/sql/insert    1
 
2053
user3   statement/sql/select    2
 
2054
user4   statement/com/Error     0
 
2055
user4   statement/com/Quit      1
 
2056
user4   statement/sql/insert    1
 
2057
user4   statement/sql/select    2
 
2058
execute dump_statements_host;
 
2059
host    event_name      count_star
 
2060
execute dump_statements_global;
 
2061
event_name      count_star
 
2062
statement/com/Error     0
 
2063
statement/com/Quit      4
 
2064
statement/sql/insert    4
 
2065
statement/sql/select    8
 
2066
execute dump_statements_history;
 
2067
event_name      count(event_name)
 
2068
statement/com/Quit      4
 
2069
statement/sql/insert    4
 
2070
statement/sql/select    8
 
2071
execute dump_accounts;
 
2072
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2073
execute dump_users;
 
2074
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2075
root    1       1
 
2076
user1   0       1
 
2077
user2   0       1
 
2078
user3   0       1
 
2079
user4   0       1
 
2080
execute dump_hosts;
 
2081
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2082
truncate performance_schema.events_stages_summary_by_thread_by_event_name;
 
2083
"================== STAGES_BY_THREAD truncated =================="
 
2084
"================== Step 19 =================="
 
2085
call dump_thread();
 
2086
username        status
 
2087
user1   not found
 
2088
username        status
 
2089
user2   not found
 
2090
username        status
 
2091
user3   not found
 
2092
username        status
 
2093
user4   not found
 
2094
execute dump_waits_account;
 
2095
user    host    event_name      count_star
 
2096
execute dump_waits_user;
 
2097
user    event_name      count_star
 
2098
user1   wait/io/file/sql/query_log      0
 
2099
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
2100
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
2101
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
2102
user2   wait/io/file/sql/query_log      0
 
2103
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
2104
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
2105
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
2106
user3   wait/io/file/sql/query_log      0
 
2107
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
2108
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
2109
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
2110
user4   wait/io/file/sql/query_log      0
 
2111
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
2112
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
2113
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
2114
execute dump_waits_host;
 
2115
host    event_name      count_star
 
2116
execute dump_waits_global;
 
2117
event_name      count_star
 
2118
wait/io/file/sql/query_log      0
 
2119
wait/synch/mutex/sql/LOCK_connection_count      0
 
2120
wait/synch/mutex/sql/LOCK_user_locks    0
 
2121
wait/synch/rwlock/sql/LOCK_grant        0
 
2122
execute dump_waits_history;
 
2123
event_name      count(event_name)
 
2124
wait/io/file/sql/query_log      20
 
2125
wait/synch/mutex/sql/LOCK_connection_count      4
 
2126
wait/synch/mutex/sql/LOCK_user_locks    8
 
2127
wait/synch/rwlock/sql/LOCK_grant        8
 
2128
execute dump_stages_account;
 
2129
user    host    event_name      count_star
 
2130
execute dump_stages_user;
 
2131
user    event_name      count_star
 
2132
user1   stage/sql/checking permissions  3
 
2133
user1   stage/sql/closing tables        3
 
2134
user1   stage/sql/init  7
 
2135
user1   stage/sql/Opening tables        3
 
2136
user2   stage/sql/checking permissions  3
 
2137
user2   stage/sql/closing tables        3
 
2138
user2   stage/sql/init  7
 
2139
user2   stage/sql/Opening tables        3
 
2140
user3   stage/sql/checking permissions  3
 
2141
user3   stage/sql/closing tables        3
 
2142
user3   stage/sql/init  7
 
2143
user3   stage/sql/Opening tables        3
 
2144
user4   stage/sql/checking permissions  3
 
2145
user4   stage/sql/closing tables        3
 
2146
user4   stage/sql/init  7
 
2147
user4   stage/sql/Opening tables        3
 
2148
execute dump_stages_host;
 
2149
host    event_name      count_star
 
2150
execute dump_stages_global;
 
2151
event_name      count_star
 
2152
stage/sql/checking permissions  12
 
2153
stage/sql/closing tables        12
 
2154
stage/sql/init  28
 
2155
stage/sql/Opening tables        12
 
2156
execute dump_stages_history;
 
2157
event_name      count(event_name)
 
2158
stage/sql/checking permissions  12
 
2159
stage/sql/closing tables        12
 
2160
stage/sql/init  28
 
2161
stage/sql/Opening tables        12
 
2162
execute dump_statements_account;
 
2163
user    host    event_name      count_star
 
2164
execute dump_statements_user;
 
2165
user    event_name      count_star
 
2166
user1   statement/com/Error     0
 
2167
user1   statement/com/Quit      1
 
2168
user1   statement/sql/insert    1
 
2169
user1   statement/sql/select    2
 
2170
user2   statement/com/Error     0
 
2171
user2   statement/com/Quit      1
 
2172
user2   statement/sql/insert    1
 
2173
user2   statement/sql/select    2
 
2174
user3   statement/com/Error     0
 
2175
user3   statement/com/Quit      1
 
2176
user3   statement/sql/insert    1
 
2177
user3   statement/sql/select    2
 
2178
user4   statement/com/Error     0
 
2179
user4   statement/com/Quit      1
 
2180
user4   statement/sql/insert    1
 
2181
user4   statement/sql/select    2
 
2182
execute dump_statements_host;
 
2183
host    event_name      count_star
 
2184
execute dump_statements_global;
 
2185
event_name      count_star
 
2186
statement/com/Error     0
 
2187
statement/com/Quit      4
 
2188
statement/sql/insert    4
 
2189
statement/sql/select    8
 
2190
execute dump_statements_history;
 
2191
event_name      count(event_name)
 
2192
statement/com/Quit      4
 
2193
statement/sql/insert    4
 
2194
statement/sql/select    8
 
2195
execute dump_accounts;
 
2196
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2197
execute dump_users;
 
2198
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2199
root    1       1
 
2200
user1   0       1
 
2201
user2   0       1
 
2202
user3   0       1
 
2203
user4   0       1
 
2204
execute dump_hosts;
 
2205
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2206
truncate performance_schema.events_stages_summary_by_account_by_event_name;
 
2207
"================== STAGES_BY_ACCOUNT truncated =================="
 
2208
"================== Step 20 =================="
 
2209
call dump_thread();
 
2210
username        status
 
2211
user1   not found
 
2212
username        status
 
2213
user2   not found
 
2214
username        status
 
2215
user3   not found
 
2216
username        status
 
2217
user4   not found
 
2218
execute dump_waits_account;
 
2219
user    host    event_name      count_star
 
2220
execute dump_waits_user;
 
2221
user    event_name      count_star
 
2222
user1   wait/io/file/sql/query_log      0
 
2223
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
2224
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
2225
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
2226
user2   wait/io/file/sql/query_log      0
 
2227
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
2228
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
2229
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
2230
user3   wait/io/file/sql/query_log      0
 
2231
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
2232
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
2233
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
2234
user4   wait/io/file/sql/query_log      0
 
2235
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
2236
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
2237
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
2238
execute dump_waits_host;
 
2239
host    event_name      count_star
 
2240
execute dump_waits_global;
 
2241
event_name      count_star
 
2242
wait/io/file/sql/query_log      0
 
2243
wait/synch/mutex/sql/LOCK_connection_count      0
 
2244
wait/synch/mutex/sql/LOCK_user_locks    0
 
2245
wait/synch/rwlock/sql/LOCK_grant        0
 
2246
execute dump_waits_history;
 
2247
event_name      count(event_name)
 
2248
wait/io/file/sql/query_log      20
 
2249
wait/synch/mutex/sql/LOCK_connection_count      4
 
2250
wait/synch/mutex/sql/LOCK_user_locks    8
 
2251
wait/synch/rwlock/sql/LOCK_grant        8
 
2252
execute dump_stages_account;
 
2253
user    host    event_name      count_star
 
2254
execute dump_stages_user;
 
2255
user    event_name      count_star
 
2256
user1   stage/sql/checking permissions  3
 
2257
user1   stage/sql/closing tables        3
 
2258
user1   stage/sql/init  7
 
2259
user1   stage/sql/Opening tables        3
 
2260
user2   stage/sql/checking permissions  3
 
2261
user2   stage/sql/closing tables        3
 
2262
user2   stage/sql/init  7
 
2263
user2   stage/sql/Opening tables        3
 
2264
user3   stage/sql/checking permissions  3
 
2265
user3   stage/sql/closing tables        3
 
2266
user3   stage/sql/init  7
 
2267
user3   stage/sql/Opening tables        3
 
2268
user4   stage/sql/checking permissions  3
 
2269
user4   stage/sql/closing tables        3
 
2270
user4   stage/sql/init  7
 
2271
user4   stage/sql/Opening tables        3
 
2272
execute dump_stages_host;
 
2273
host    event_name      count_star
 
2274
execute dump_stages_global;
 
2275
event_name      count_star
 
2276
stage/sql/checking permissions  12
 
2277
stage/sql/closing tables        12
 
2278
stage/sql/init  28
 
2279
stage/sql/Opening tables        12
 
2280
execute dump_stages_history;
 
2281
event_name      count(event_name)
 
2282
stage/sql/checking permissions  12
 
2283
stage/sql/closing tables        12
 
2284
stage/sql/init  28
 
2285
stage/sql/Opening tables        12
 
2286
execute dump_statements_account;
 
2287
user    host    event_name      count_star
 
2288
execute dump_statements_user;
 
2289
user    event_name      count_star
 
2290
user1   statement/com/Error     0
 
2291
user1   statement/com/Quit      1
 
2292
user1   statement/sql/insert    1
 
2293
user1   statement/sql/select    2
 
2294
user2   statement/com/Error     0
 
2295
user2   statement/com/Quit      1
 
2296
user2   statement/sql/insert    1
 
2297
user2   statement/sql/select    2
 
2298
user3   statement/com/Error     0
 
2299
user3   statement/com/Quit      1
 
2300
user3   statement/sql/insert    1
 
2301
user3   statement/sql/select    2
 
2302
user4   statement/com/Error     0
 
2303
user4   statement/com/Quit      1
 
2304
user4   statement/sql/insert    1
 
2305
user4   statement/sql/select    2
 
2306
execute dump_statements_host;
 
2307
host    event_name      count_star
 
2308
execute dump_statements_global;
 
2309
event_name      count_star
 
2310
statement/com/Error     0
 
2311
statement/com/Quit      4
 
2312
statement/sql/insert    4
 
2313
statement/sql/select    8
 
2314
execute dump_statements_history;
 
2315
event_name      count(event_name)
 
2316
statement/com/Quit      4
 
2317
statement/sql/insert    4
 
2318
statement/sql/select    8
 
2319
execute dump_accounts;
 
2320
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2321
execute dump_users;
 
2322
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2323
root    1       1
 
2324
user1   0       1
 
2325
user2   0       1
 
2326
user3   0       1
 
2327
user4   0       1
 
2328
execute dump_hosts;
 
2329
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2330
truncate performance_schema.events_stages_summary_by_user_by_event_name;
 
2331
"================== STAGES_BY_USER truncated =================="
 
2332
"================== Step 21 =================="
 
2333
call dump_thread();
 
2334
username        status
 
2335
user1   not found
 
2336
username        status
 
2337
user2   not found
 
2338
username        status
 
2339
user3   not found
 
2340
username        status
 
2341
user4   not found
 
2342
execute dump_waits_account;
 
2343
user    host    event_name      count_star
 
2344
execute dump_waits_user;
 
2345
user    event_name      count_star
 
2346
user1   wait/io/file/sql/query_log      0
 
2347
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
2348
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
2349
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
2350
user2   wait/io/file/sql/query_log      0
 
2351
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
2352
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
2353
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
2354
user3   wait/io/file/sql/query_log      0
 
2355
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
2356
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
2357
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
2358
user4   wait/io/file/sql/query_log      0
 
2359
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
2360
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
2361
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
2362
execute dump_waits_host;
 
2363
host    event_name      count_star
 
2364
execute dump_waits_global;
 
2365
event_name      count_star
 
2366
wait/io/file/sql/query_log      0
 
2367
wait/synch/mutex/sql/LOCK_connection_count      0
 
2368
wait/synch/mutex/sql/LOCK_user_locks    0
 
2369
wait/synch/rwlock/sql/LOCK_grant        0
 
2370
execute dump_waits_history;
 
2371
event_name      count(event_name)
 
2372
wait/io/file/sql/query_log      20
 
2373
wait/synch/mutex/sql/LOCK_connection_count      4
 
2374
wait/synch/mutex/sql/LOCK_user_locks    8
 
2375
wait/synch/rwlock/sql/LOCK_grant        8
 
2376
execute dump_stages_account;
 
2377
user    host    event_name      count_star
 
2378
execute dump_stages_user;
 
2379
user    event_name      count_star
 
2380
user1   stage/sql/checking permissions  0
 
2381
user1   stage/sql/closing tables        0
 
2382
user1   stage/sql/init  0
 
2383
user1   stage/sql/Opening tables        0
 
2384
user2   stage/sql/checking permissions  0
 
2385
user2   stage/sql/closing tables        0
 
2386
user2   stage/sql/init  0
 
2387
user2   stage/sql/Opening tables        0
 
2388
user3   stage/sql/checking permissions  0
 
2389
user3   stage/sql/closing tables        0
 
2390
user3   stage/sql/init  0
 
2391
user3   stage/sql/Opening tables        0
 
2392
user4   stage/sql/checking permissions  0
 
2393
user4   stage/sql/closing tables        0
 
2394
user4   stage/sql/init  0
 
2395
user4   stage/sql/Opening tables        0
 
2396
execute dump_stages_host;
 
2397
host    event_name      count_star
 
2398
execute dump_stages_global;
 
2399
event_name      count_star
 
2400
stage/sql/checking permissions  12
 
2401
stage/sql/closing tables        12
 
2402
stage/sql/init  28
 
2403
stage/sql/Opening tables        12
 
2404
execute dump_stages_history;
 
2405
event_name      count(event_name)
 
2406
stage/sql/checking permissions  12
 
2407
stage/sql/closing tables        12
 
2408
stage/sql/init  28
 
2409
stage/sql/Opening tables        12
 
2410
execute dump_statements_account;
 
2411
user    host    event_name      count_star
 
2412
execute dump_statements_user;
 
2413
user    event_name      count_star
 
2414
user1   statement/com/Error     0
 
2415
user1   statement/com/Quit      1
 
2416
user1   statement/sql/insert    1
 
2417
user1   statement/sql/select    2
 
2418
user2   statement/com/Error     0
 
2419
user2   statement/com/Quit      1
 
2420
user2   statement/sql/insert    1
 
2421
user2   statement/sql/select    2
 
2422
user3   statement/com/Error     0
 
2423
user3   statement/com/Quit      1
 
2424
user3   statement/sql/insert    1
 
2425
user3   statement/sql/select    2
 
2426
user4   statement/com/Error     0
 
2427
user4   statement/com/Quit      1
 
2428
user4   statement/sql/insert    1
 
2429
user4   statement/sql/select    2
 
2430
execute dump_statements_host;
 
2431
host    event_name      count_star
 
2432
execute dump_statements_global;
 
2433
event_name      count_star
 
2434
statement/com/Error     0
 
2435
statement/com/Quit      4
 
2436
statement/sql/insert    4
 
2437
statement/sql/select    8
 
2438
execute dump_statements_history;
 
2439
event_name      count(event_name)
 
2440
statement/com/Quit      4
 
2441
statement/sql/insert    4
 
2442
statement/sql/select    8
 
2443
execute dump_accounts;
 
2444
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2445
execute dump_users;
 
2446
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2447
root    1       1
 
2448
user1   0       1
 
2449
user2   0       1
 
2450
user3   0       1
 
2451
user4   0       1
 
2452
execute dump_hosts;
 
2453
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2454
truncate performance_schema.events_stages_summary_by_host_by_event_name;
 
2455
"================== STAGES_BY_HOST truncated =================="
 
2456
"================== Step 22 =================="
 
2457
call dump_thread();
 
2458
username        status
 
2459
user1   not found
 
2460
username        status
 
2461
user2   not found
 
2462
username        status
 
2463
user3   not found
 
2464
username        status
 
2465
user4   not found
 
2466
execute dump_waits_account;
 
2467
user    host    event_name      count_star
 
2468
execute dump_waits_user;
 
2469
user    event_name      count_star
 
2470
user1   wait/io/file/sql/query_log      0
 
2471
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
2472
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
2473
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
2474
user2   wait/io/file/sql/query_log      0
 
2475
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
2476
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
2477
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
2478
user3   wait/io/file/sql/query_log      0
 
2479
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
2480
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
2481
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
2482
user4   wait/io/file/sql/query_log      0
 
2483
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
2484
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
2485
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
2486
execute dump_waits_host;
 
2487
host    event_name      count_star
 
2488
execute dump_waits_global;
 
2489
event_name      count_star
 
2490
wait/io/file/sql/query_log      0
 
2491
wait/synch/mutex/sql/LOCK_connection_count      0
 
2492
wait/synch/mutex/sql/LOCK_user_locks    0
 
2493
wait/synch/rwlock/sql/LOCK_grant        0
 
2494
execute dump_waits_history;
 
2495
event_name      count(event_name)
 
2496
wait/io/file/sql/query_log      20
 
2497
wait/synch/mutex/sql/LOCK_connection_count      4
 
2498
wait/synch/mutex/sql/LOCK_user_locks    8
 
2499
wait/synch/rwlock/sql/LOCK_grant        8
 
2500
execute dump_stages_account;
 
2501
user    host    event_name      count_star
 
2502
execute dump_stages_user;
 
2503
user    event_name      count_star
 
2504
user1   stage/sql/checking permissions  0
 
2505
user1   stage/sql/closing tables        0
 
2506
user1   stage/sql/init  0
 
2507
user1   stage/sql/Opening tables        0
 
2508
user2   stage/sql/checking permissions  0
 
2509
user2   stage/sql/closing tables        0
 
2510
user2   stage/sql/init  0
 
2511
user2   stage/sql/Opening tables        0
 
2512
user3   stage/sql/checking permissions  0
 
2513
user3   stage/sql/closing tables        0
 
2514
user3   stage/sql/init  0
 
2515
user3   stage/sql/Opening tables        0
 
2516
user4   stage/sql/checking permissions  0
 
2517
user4   stage/sql/closing tables        0
 
2518
user4   stage/sql/init  0
 
2519
user4   stage/sql/Opening tables        0
 
2520
execute dump_stages_host;
 
2521
host    event_name      count_star
 
2522
execute dump_stages_global;
 
2523
event_name      count_star
 
2524
stage/sql/checking permissions  12
 
2525
stage/sql/closing tables        12
 
2526
stage/sql/init  28
 
2527
stage/sql/Opening tables        12
 
2528
execute dump_stages_history;
 
2529
event_name      count(event_name)
 
2530
stage/sql/checking permissions  12
 
2531
stage/sql/closing tables        12
 
2532
stage/sql/init  28
 
2533
stage/sql/Opening tables        12
 
2534
execute dump_statements_account;
 
2535
user    host    event_name      count_star
 
2536
execute dump_statements_user;
 
2537
user    event_name      count_star
 
2538
user1   statement/com/Error     0
 
2539
user1   statement/com/Quit      1
 
2540
user1   statement/sql/insert    1
 
2541
user1   statement/sql/select    2
 
2542
user2   statement/com/Error     0
 
2543
user2   statement/com/Quit      1
 
2544
user2   statement/sql/insert    1
 
2545
user2   statement/sql/select    2
 
2546
user3   statement/com/Error     0
 
2547
user3   statement/com/Quit      1
 
2548
user3   statement/sql/insert    1
 
2549
user3   statement/sql/select    2
 
2550
user4   statement/com/Error     0
 
2551
user4   statement/com/Quit      1
 
2552
user4   statement/sql/insert    1
 
2553
user4   statement/sql/select    2
 
2554
execute dump_statements_host;
 
2555
host    event_name      count_star
 
2556
execute dump_statements_global;
 
2557
event_name      count_star
 
2558
statement/com/Error     0
 
2559
statement/com/Quit      4
 
2560
statement/sql/insert    4
 
2561
statement/sql/select    8
 
2562
execute dump_statements_history;
 
2563
event_name      count(event_name)
 
2564
statement/com/Quit      4
 
2565
statement/sql/insert    4
 
2566
statement/sql/select    8
 
2567
execute dump_accounts;
 
2568
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2569
execute dump_users;
 
2570
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2571
root    1       1
 
2572
user1   0       1
 
2573
user2   0       1
 
2574
user3   0       1
 
2575
user4   0       1
 
2576
execute dump_hosts;
 
2577
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2578
truncate performance_schema.events_stages_summary_global_by_event_name;
 
2579
"================== STAGES_GLOBAL truncated =================="
 
2580
"================== Step 23 =================="
 
2581
call dump_thread();
 
2582
username        status
 
2583
user1   not found
 
2584
username        status
 
2585
user2   not found
 
2586
username        status
 
2587
user3   not found
 
2588
username        status
 
2589
user4   not found
 
2590
execute dump_waits_account;
 
2591
user    host    event_name      count_star
 
2592
execute dump_waits_user;
 
2593
user    event_name      count_star
 
2594
user1   wait/io/file/sql/query_log      0
 
2595
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
2596
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
2597
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
2598
user2   wait/io/file/sql/query_log      0
 
2599
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
2600
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
2601
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
2602
user3   wait/io/file/sql/query_log      0
 
2603
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
2604
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
2605
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
2606
user4   wait/io/file/sql/query_log      0
 
2607
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
2608
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
2609
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
2610
execute dump_waits_host;
 
2611
host    event_name      count_star
 
2612
execute dump_waits_global;
 
2613
event_name      count_star
 
2614
wait/io/file/sql/query_log      0
 
2615
wait/synch/mutex/sql/LOCK_connection_count      0
 
2616
wait/synch/mutex/sql/LOCK_user_locks    0
 
2617
wait/synch/rwlock/sql/LOCK_grant        0
 
2618
execute dump_waits_history;
 
2619
event_name      count(event_name)
 
2620
wait/io/file/sql/query_log      20
 
2621
wait/synch/mutex/sql/LOCK_connection_count      4
 
2622
wait/synch/mutex/sql/LOCK_user_locks    8
 
2623
wait/synch/rwlock/sql/LOCK_grant        8
 
2624
execute dump_stages_account;
 
2625
user    host    event_name      count_star
 
2626
execute dump_stages_user;
 
2627
user    event_name      count_star
 
2628
user1   stage/sql/checking permissions  0
 
2629
user1   stage/sql/closing tables        0
 
2630
user1   stage/sql/init  0
 
2631
user1   stage/sql/Opening tables        0
 
2632
user2   stage/sql/checking permissions  0
 
2633
user2   stage/sql/closing tables        0
 
2634
user2   stage/sql/init  0
 
2635
user2   stage/sql/Opening tables        0
 
2636
user3   stage/sql/checking permissions  0
 
2637
user3   stage/sql/closing tables        0
 
2638
user3   stage/sql/init  0
 
2639
user3   stage/sql/Opening tables        0
 
2640
user4   stage/sql/checking permissions  0
 
2641
user4   stage/sql/closing tables        0
 
2642
user4   stage/sql/init  0
 
2643
user4   stage/sql/Opening tables        0
 
2644
execute dump_stages_host;
 
2645
host    event_name      count_star
 
2646
execute dump_stages_global;
 
2647
event_name      count_star
 
2648
stage/sql/checking permissions  0
 
2649
stage/sql/closing tables        0
 
2650
stage/sql/init  0
 
2651
stage/sql/Opening tables        0
 
2652
execute dump_stages_history;
 
2653
event_name      count(event_name)
 
2654
stage/sql/checking permissions  12
 
2655
stage/sql/closing tables        12
 
2656
stage/sql/init  28
 
2657
stage/sql/Opening tables        12
 
2658
execute dump_statements_account;
 
2659
user    host    event_name      count_star
 
2660
execute dump_statements_user;
 
2661
user    event_name      count_star
 
2662
user1   statement/com/Error     0
 
2663
user1   statement/com/Quit      1
 
2664
user1   statement/sql/insert    1
 
2665
user1   statement/sql/select    2
 
2666
user2   statement/com/Error     0
 
2667
user2   statement/com/Quit      1
 
2668
user2   statement/sql/insert    1
 
2669
user2   statement/sql/select    2
 
2670
user3   statement/com/Error     0
 
2671
user3   statement/com/Quit      1
 
2672
user3   statement/sql/insert    1
 
2673
user3   statement/sql/select    2
 
2674
user4   statement/com/Error     0
 
2675
user4   statement/com/Quit      1
 
2676
user4   statement/sql/insert    1
 
2677
user4   statement/sql/select    2
 
2678
execute dump_statements_host;
 
2679
host    event_name      count_star
 
2680
execute dump_statements_global;
 
2681
event_name      count_star
 
2682
statement/com/Error     0
 
2683
statement/com/Quit      4
 
2684
statement/sql/insert    4
 
2685
statement/sql/select    8
 
2686
execute dump_statements_history;
 
2687
event_name      count(event_name)
 
2688
statement/com/Quit      4
 
2689
statement/sql/insert    4
 
2690
statement/sql/select    8
 
2691
execute dump_accounts;
 
2692
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2693
execute dump_users;
 
2694
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2695
root    1       1
 
2696
user1   0       1
 
2697
user2   0       1
 
2698
user3   0       1
 
2699
user4   0       1
 
2700
execute dump_hosts;
 
2701
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2702
truncate performance_schema.events_statements_summary_by_thread_by_event_name;
 
2703
"================== STATEMENTS_BY_THREAD truncated =================="
 
2704
"================== Step 24 =================="
 
2705
call dump_thread();
 
2706
username        status
 
2707
user1   not found
 
2708
username        status
 
2709
user2   not found
 
2710
username        status
 
2711
user3   not found
 
2712
username        status
 
2713
user4   not found
 
2714
execute dump_waits_account;
 
2715
user    host    event_name      count_star
 
2716
execute dump_waits_user;
 
2717
user    event_name      count_star
 
2718
user1   wait/io/file/sql/query_log      0
 
2719
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
2720
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
2721
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
2722
user2   wait/io/file/sql/query_log      0
 
2723
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
2724
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
2725
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
2726
user3   wait/io/file/sql/query_log      0
 
2727
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
2728
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
2729
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
2730
user4   wait/io/file/sql/query_log      0
 
2731
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
2732
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
2733
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
2734
execute dump_waits_host;
 
2735
host    event_name      count_star
 
2736
execute dump_waits_global;
 
2737
event_name      count_star
 
2738
wait/io/file/sql/query_log      0
 
2739
wait/synch/mutex/sql/LOCK_connection_count      0
 
2740
wait/synch/mutex/sql/LOCK_user_locks    0
 
2741
wait/synch/rwlock/sql/LOCK_grant        0
 
2742
execute dump_waits_history;
 
2743
event_name      count(event_name)
 
2744
wait/io/file/sql/query_log      20
 
2745
wait/synch/mutex/sql/LOCK_connection_count      4
 
2746
wait/synch/mutex/sql/LOCK_user_locks    8
 
2747
wait/synch/rwlock/sql/LOCK_grant        8
 
2748
execute dump_stages_account;
 
2749
user    host    event_name      count_star
 
2750
execute dump_stages_user;
 
2751
user    event_name      count_star
 
2752
user1   stage/sql/checking permissions  0
 
2753
user1   stage/sql/closing tables        0
 
2754
user1   stage/sql/init  0
 
2755
user1   stage/sql/Opening tables        0
 
2756
user2   stage/sql/checking permissions  0
 
2757
user2   stage/sql/closing tables        0
 
2758
user2   stage/sql/init  0
 
2759
user2   stage/sql/Opening tables        0
 
2760
user3   stage/sql/checking permissions  0
 
2761
user3   stage/sql/closing tables        0
 
2762
user3   stage/sql/init  0
 
2763
user3   stage/sql/Opening tables        0
 
2764
user4   stage/sql/checking permissions  0
 
2765
user4   stage/sql/closing tables        0
 
2766
user4   stage/sql/init  0
 
2767
user4   stage/sql/Opening tables        0
 
2768
execute dump_stages_host;
 
2769
host    event_name      count_star
 
2770
execute dump_stages_global;
 
2771
event_name      count_star
 
2772
stage/sql/checking permissions  0
 
2773
stage/sql/closing tables        0
 
2774
stage/sql/init  0
 
2775
stage/sql/Opening tables        0
 
2776
execute dump_stages_history;
 
2777
event_name      count(event_name)
 
2778
stage/sql/checking permissions  12
 
2779
stage/sql/closing tables        12
 
2780
stage/sql/init  28
 
2781
stage/sql/Opening tables        12
 
2782
execute dump_statements_account;
 
2783
user    host    event_name      count_star
 
2784
execute dump_statements_user;
 
2785
user    event_name      count_star
 
2786
user1   statement/com/Error     0
 
2787
user1   statement/com/Quit      1
 
2788
user1   statement/sql/insert    1
 
2789
user1   statement/sql/select    2
 
2790
user2   statement/com/Error     0
 
2791
user2   statement/com/Quit      1
 
2792
user2   statement/sql/insert    1
 
2793
user2   statement/sql/select    2
 
2794
user3   statement/com/Error     0
 
2795
user3   statement/com/Quit      1
 
2796
user3   statement/sql/insert    1
 
2797
user3   statement/sql/select    2
 
2798
user4   statement/com/Error     0
 
2799
user4   statement/com/Quit      1
 
2800
user4   statement/sql/insert    1
 
2801
user4   statement/sql/select    2
 
2802
execute dump_statements_host;
 
2803
host    event_name      count_star
 
2804
execute dump_statements_global;
 
2805
event_name      count_star
 
2806
statement/com/Error     0
 
2807
statement/com/Quit      4
 
2808
statement/sql/insert    4
 
2809
statement/sql/select    8
 
2810
execute dump_statements_history;
 
2811
event_name      count(event_name)
 
2812
statement/com/Quit      4
 
2813
statement/sql/insert    4
 
2814
statement/sql/select    8
 
2815
execute dump_accounts;
 
2816
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2817
execute dump_users;
 
2818
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2819
root    1       1
 
2820
user1   0       1
 
2821
user2   0       1
 
2822
user3   0       1
 
2823
user4   0       1
 
2824
execute dump_hosts;
 
2825
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2826
truncate performance_schema.events_statements_summary_by_account_by_event_name;
 
2827
"================== STATEMENTS_BY_ACCOUNT truncated =================="
 
2828
"================== Step 25 =================="
 
2829
call dump_thread();
 
2830
username        status
 
2831
user1   not found
 
2832
username        status
 
2833
user2   not found
 
2834
username        status
 
2835
user3   not found
 
2836
username        status
 
2837
user4   not found
 
2838
execute dump_waits_account;
 
2839
user    host    event_name      count_star
 
2840
execute dump_waits_user;
 
2841
user    event_name      count_star
 
2842
user1   wait/io/file/sql/query_log      0
 
2843
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
2844
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
2845
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
2846
user2   wait/io/file/sql/query_log      0
 
2847
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
2848
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
2849
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
2850
user3   wait/io/file/sql/query_log      0
 
2851
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
2852
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
2853
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
2854
user4   wait/io/file/sql/query_log      0
 
2855
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
2856
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
2857
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
2858
execute dump_waits_host;
 
2859
host    event_name      count_star
 
2860
execute dump_waits_global;
 
2861
event_name      count_star
 
2862
wait/io/file/sql/query_log      0
 
2863
wait/synch/mutex/sql/LOCK_connection_count      0
 
2864
wait/synch/mutex/sql/LOCK_user_locks    0
 
2865
wait/synch/rwlock/sql/LOCK_grant        0
 
2866
execute dump_waits_history;
 
2867
event_name      count(event_name)
 
2868
wait/io/file/sql/query_log      20
 
2869
wait/synch/mutex/sql/LOCK_connection_count      4
 
2870
wait/synch/mutex/sql/LOCK_user_locks    8
 
2871
wait/synch/rwlock/sql/LOCK_grant        8
 
2872
execute dump_stages_account;
 
2873
user    host    event_name      count_star
 
2874
execute dump_stages_user;
 
2875
user    event_name      count_star
 
2876
user1   stage/sql/checking permissions  0
 
2877
user1   stage/sql/closing tables        0
 
2878
user1   stage/sql/init  0
 
2879
user1   stage/sql/Opening tables        0
 
2880
user2   stage/sql/checking permissions  0
 
2881
user2   stage/sql/closing tables        0
 
2882
user2   stage/sql/init  0
 
2883
user2   stage/sql/Opening tables        0
 
2884
user3   stage/sql/checking permissions  0
 
2885
user3   stage/sql/closing tables        0
 
2886
user3   stage/sql/init  0
 
2887
user3   stage/sql/Opening tables        0
 
2888
user4   stage/sql/checking permissions  0
 
2889
user4   stage/sql/closing tables        0
 
2890
user4   stage/sql/init  0
 
2891
user4   stage/sql/Opening tables        0
 
2892
execute dump_stages_host;
 
2893
host    event_name      count_star
 
2894
execute dump_stages_global;
 
2895
event_name      count_star
 
2896
stage/sql/checking permissions  0
 
2897
stage/sql/closing tables        0
 
2898
stage/sql/init  0
 
2899
stage/sql/Opening tables        0
 
2900
execute dump_stages_history;
 
2901
event_name      count(event_name)
 
2902
stage/sql/checking permissions  12
 
2903
stage/sql/closing tables        12
 
2904
stage/sql/init  28
 
2905
stage/sql/Opening tables        12
 
2906
execute dump_statements_account;
 
2907
user    host    event_name      count_star
 
2908
execute dump_statements_user;
 
2909
user    event_name      count_star
 
2910
user1   statement/com/Error     0
 
2911
user1   statement/com/Quit      1
 
2912
user1   statement/sql/insert    1
 
2913
user1   statement/sql/select    2
 
2914
user2   statement/com/Error     0
 
2915
user2   statement/com/Quit      1
 
2916
user2   statement/sql/insert    1
 
2917
user2   statement/sql/select    2
 
2918
user3   statement/com/Error     0
 
2919
user3   statement/com/Quit      1
 
2920
user3   statement/sql/insert    1
 
2921
user3   statement/sql/select    2
 
2922
user4   statement/com/Error     0
 
2923
user4   statement/com/Quit      1
 
2924
user4   statement/sql/insert    1
 
2925
user4   statement/sql/select    2
 
2926
execute dump_statements_host;
 
2927
host    event_name      count_star
 
2928
execute dump_statements_global;
 
2929
event_name      count_star
 
2930
statement/com/Error     0
 
2931
statement/com/Quit      4
 
2932
statement/sql/insert    4
 
2933
statement/sql/select    8
 
2934
execute dump_statements_history;
 
2935
event_name      count(event_name)
 
2936
statement/com/Quit      4
 
2937
statement/sql/insert    4
 
2938
statement/sql/select    8
 
2939
execute dump_accounts;
 
2940
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2941
execute dump_users;
 
2942
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2943
root    1       1
 
2944
user1   0       1
 
2945
user2   0       1
 
2946
user3   0       1
 
2947
user4   0       1
 
2948
execute dump_hosts;
 
2949
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
2950
truncate performance_schema.events_statements_summary_by_user_by_event_name;
 
2951
"================== STATEMENTS_BY_USER truncated =================="
 
2952
"================== Step 26 =================="
 
2953
call dump_thread();
 
2954
username        status
 
2955
user1   not found
 
2956
username        status
 
2957
user2   not found
 
2958
username        status
 
2959
user3   not found
 
2960
username        status
 
2961
user4   not found
 
2962
execute dump_waits_account;
 
2963
user    host    event_name      count_star
 
2964
execute dump_waits_user;
 
2965
user    event_name      count_star
 
2966
user1   wait/io/file/sql/query_log      0
 
2967
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
2968
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
2969
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
2970
user2   wait/io/file/sql/query_log      0
 
2971
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
2972
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
2973
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
2974
user3   wait/io/file/sql/query_log      0
 
2975
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
2976
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
2977
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
2978
user4   wait/io/file/sql/query_log      0
 
2979
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
2980
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
2981
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
2982
execute dump_waits_host;
 
2983
host    event_name      count_star
 
2984
execute dump_waits_global;
 
2985
event_name      count_star
 
2986
wait/io/file/sql/query_log      0
 
2987
wait/synch/mutex/sql/LOCK_connection_count      0
 
2988
wait/synch/mutex/sql/LOCK_user_locks    0
 
2989
wait/synch/rwlock/sql/LOCK_grant        0
 
2990
execute dump_waits_history;
 
2991
event_name      count(event_name)
 
2992
wait/io/file/sql/query_log      20
 
2993
wait/synch/mutex/sql/LOCK_connection_count      4
 
2994
wait/synch/mutex/sql/LOCK_user_locks    8
 
2995
wait/synch/rwlock/sql/LOCK_grant        8
 
2996
execute dump_stages_account;
 
2997
user    host    event_name      count_star
 
2998
execute dump_stages_user;
 
2999
user    event_name      count_star
 
3000
user1   stage/sql/checking permissions  0
 
3001
user1   stage/sql/closing tables        0
 
3002
user1   stage/sql/init  0
 
3003
user1   stage/sql/Opening tables        0
 
3004
user2   stage/sql/checking permissions  0
 
3005
user2   stage/sql/closing tables        0
 
3006
user2   stage/sql/init  0
 
3007
user2   stage/sql/Opening tables        0
 
3008
user3   stage/sql/checking permissions  0
 
3009
user3   stage/sql/closing tables        0
 
3010
user3   stage/sql/init  0
 
3011
user3   stage/sql/Opening tables        0
 
3012
user4   stage/sql/checking permissions  0
 
3013
user4   stage/sql/closing tables        0
 
3014
user4   stage/sql/init  0
 
3015
user4   stage/sql/Opening tables        0
 
3016
execute dump_stages_host;
 
3017
host    event_name      count_star
 
3018
execute dump_stages_global;
 
3019
event_name      count_star
 
3020
stage/sql/checking permissions  0
 
3021
stage/sql/closing tables        0
 
3022
stage/sql/init  0
 
3023
stage/sql/Opening tables        0
 
3024
execute dump_stages_history;
 
3025
event_name      count(event_name)
 
3026
stage/sql/checking permissions  12
 
3027
stage/sql/closing tables        12
 
3028
stage/sql/init  28
 
3029
stage/sql/Opening tables        12
 
3030
execute dump_statements_account;
 
3031
user    host    event_name      count_star
 
3032
execute dump_statements_user;
 
3033
user    event_name      count_star
 
3034
user1   statement/com/Error     0
 
3035
user1   statement/com/Quit      0
 
3036
user1   statement/sql/insert    0
 
3037
user1   statement/sql/select    0
 
3038
user2   statement/com/Error     0
 
3039
user2   statement/com/Quit      0
 
3040
user2   statement/sql/insert    0
 
3041
user2   statement/sql/select    0
 
3042
user3   statement/com/Error     0
 
3043
user3   statement/com/Quit      0
 
3044
user3   statement/sql/insert    0
 
3045
user3   statement/sql/select    0
 
3046
user4   statement/com/Error     0
 
3047
user4   statement/com/Quit      0
 
3048
user4   statement/sql/insert    0
 
3049
user4   statement/sql/select    0
 
3050
execute dump_statements_host;
 
3051
host    event_name      count_star
 
3052
execute dump_statements_global;
 
3053
event_name      count_star
 
3054
statement/com/Error     0
 
3055
statement/com/Quit      4
 
3056
statement/sql/insert    4
 
3057
statement/sql/select    8
 
3058
execute dump_statements_history;
 
3059
event_name      count(event_name)
 
3060
statement/com/Quit      4
 
3061
statement/sql/insert    4
 
3062
statement/sql/select    8
 
3063
execute dump_accounts;
 
3064
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3065
execute dump_users;
 
3066
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3067
root    1       1
 
3068
user1   0       1
 
3069
user2   0       1
 
3070
user3   0       1
 
3071
user4   0       1
 
3072
execute dump_hosts;
 
3073
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3074
truncate performance_schema.events_statements_summary_by_host_by_event_name;
 
3075
"================== STATEMENTS_BY_HOST truncated =================="
 
3076
"================== Step 27 =================="
 
3077
call dump_thread();
 
3078
username        status
 
3079
user1   not found
 
3080
username        status
 
3081
user2   not found
 
3082
username        status
 
3083
user3   not found
 
3084
username        status
 
3085
user4   not found
 
3086
execute dump_waits_account;
 
3087
user    host    event_name      count_star
 
3088
execute dump_waits_user;
 
3089
user    event_name      count_star
 
3090
user1   wait/io/file/sql/query_log      0
 
3091
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
3092
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
3093
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
3094
user2   wait/io/file/sql/query_log      0
 
3095
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
3096
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
3097
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
3098
user3   wait/io/file/sql/query_log      0
 
3099
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
3100
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
3101
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
3102
user4   wait/io/file/sql/query_log      0
 
3103
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
3104
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
3105
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
3106
execute dump_waits_host;
 
3107
host    event_name      count_star
 
3108
execute dump_waits_global;
 
3109
event_name      count_star
 
3110
wait/io/file/sql/query_log      0
 
3111
wait/synch/mutex/sql/LOCK_connection_count      0
 
3112
wait/synch/mutex/sql/LOCK_user_locks    0
 
3113
wait/synch/rwlock/sql/LOCK_grant        0
 
3114
execute dump_waits_history;
 
3115
event_name      count(event_name)
 
3116
wait/io/file/sql/query_log      20
 
3117
wait/synch/mutex/sql/LOCK_connection_count      4
 
3118
wait/synch/mutex/sql/LOCK_user_locks    8
 
3119
wait/synch/rwlock/sql/LOCK_grant        8
 
3120
execute dump_stages_account;
 
3121
user    host    event_name      count_star
 
3122
execute dump_stages_user;
 
3123
user    event_name      count_star
 
3124
user1   stage/sql/checking permissions  0
 
3125
user1   stage/sql/closing tables        0
 
3126
user1   stage/sql/init  0
 
3127
user1   stage/sql/Opening tables        0
 
3128
user2   stage/sql/checking permissions  0
 
3129
user2   stage/sql/closing tables        0
 
3130
user2   stage/sql/init  0
 
3131
user2   stage/sql/Opening tables        0
 
3132
user3   stage/sql/checking permissions  0
 
3133
user3   stage/sql/closing tables        0
 
3134
user3   stage/sql/init  0
 
3135
user3   stage/sql/Opening tables        0
 
3136
user4   stage/sql/checking permissions  0
 
3137
user4   stage/sql/closing tables        0
 
3138
user4   stage/sql/init  0
 
3139
user4   stage/sql/Opening tables        0
 
3140
execute dump_stages_host;
 
3141
host    event_name      count_star
 
3142
execute dump_stages_global;
 
3143
event_name      count_star
 
3144
stage/sql/checking permissions  0
 
3145
stage/sql/closing tables        0
 
3146
stage/sql/init  0
 
3147
stage/sql/Opening tables        0
 
3148
execute dump_stages_history;
 
3149
event_name      count(event_name)
 
3150
stage/sql/checking permissions  12
 
3151
stage/sql/closing tables        12
 
3152
stage/sql/init  28
 
3153
stage/sql/Opening tables        12
 
3154
execute dump_statements_account;
 
3155
user    host    event_name      count_star
 
3156
execute dump_statements_user;
 
3157
user    event_name      count_star
 
3158
user1   statement/com/Error     0
 
3159
user1   statement/com/Quit      0
 
3160
user1   statement/sql/insert    0
 
3161
user1   statement/sql/select    0
 
3162
user2   statement/com/Error     0
 
3163
user2   statement/com/Quit      0
 
3164
user2   statement/sql/insert    0
 
3165
user2   statement/sql/select    0
 
3166
user3   statement/com/Error     0
 
3167
user3   statement/com/Quit      0
 
3168
user3   statement/sql/insert    0
 
3169
user3   statement/sql/select    0
 
3170
user4   statement/com/Error     0
 
3171
user4   statement/com/Quit      0
 
3172
user4   statement/sql/insert    0
 
3173
user4   statement/sql/select    0
 
3174
execute dump_statements_host;
 
3175
host    event_name      count_star
 
3176
execute dump_statements_global;
 
3177
event_name      count_star
 
3178
statement/com/Error     0
 
3179
statement/com/Quit      4
 
3180
statement/sql/insert    4
 
3181
statement/sql/select    8
 
3182
execute dump_statements_history;
 
3183
event_name      count(event_name)
 
3184
statement/com/Quit      4
 
3185
statement/sql/insert    4
 
3186
statement/sql/select    8
 
3187
execute dump_accounts;
 
3188
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3189
execute dump_users;
 
3190
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3191
root    1       1
 
3192
user1   0       1
 
3193
user2   0       1
 
3194
user3   0       1
 
3195
user4   0       1
 
3196
execute dump_hosts;
 
3197
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3198
truncate performance_schema.events_statements_summary_global_by_event_name;
 
3199
"================== STATEMENTS_GLOBAL truncated =================="
 
3200
"================== Step 28 =================="
 
3201
call dump_thread();
 
3202
username        status
 
3203
user1   not found
 
3204
username        status
 
3205
user2   not found
 
3206
username        status
 
3207
user3   not found
 
3208
username        status
 
3209
user4   not found
 
3210
execute dump_waits_account;
 
3211
user    host    event_name      count_star
 
3212
execute dump_waits_user;
 
3213
user    event_name      count_star
 
3214
user1   wait/io/file/sql/query_log      0
 
3215
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
3216
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
3217
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
3218
user2   wait/io/file/sql/query_log      0
 
3219
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
3220
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
3221
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
3222
user3   wait/io/file/sql/query_log      0
 
3223
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
3224
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
3225
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
3226
user4   wait/io/file/sql/query_log      0
 
3227
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
3228
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
3229
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
3230
execute dump_waits_host;
 
3231
host    event_name      count_star
 
3232
execute dump_waits_global;
 
3233
event_name      count_star
 
3234
wait/io/file/sql/query_log      0
 
3235
wait/synch/mutex/sql/LOCK_connection_count      0
 
3236
wait/synch/mutex/sql/LOCK_user_locks    0
 
3237
wait/synch/rwlock/sql/LOCK_grant        0
 
3238
execute dump_waits_history;
 
3239
event_name      count(event_name)
 
3240
wait/io/file/sql/query_log      20
 
3241
wait/synch/mutex/sql/LOCK_connection_count      4
 
3242
wait/synch/mutex/sql/LOCK_user_locks    8
 
3243
wait/synch/rwlock/sql/LOCK_grant        8
 
3244
execute dump_stages_account;
 
3245
user    host    event_name      count_star
 
3246
execute dump_stages_user;
 
3247
user    event_name      count_star
 
3248
user1   stage/sql/checking permissions  0
 
3249
user1   stage/sql/closing tables        0
 
3250
user1   stage/sql/init  0
 
3251
user1   stage/sql/Opening tables        0
 
3252
user2   stage/sql/checking permissions  0
 
3253
user2   stage/sql/closing tables        0
 
3254
user2   stage/sql/init  0
 
3255
user2   stage/sql/Opening tables        0
 
3256
user3   stage/sql/checking permissions  0
 
3257
user3   stage/sql/closing tables        0
 
3258
user3   stage/sql/init  0
 
3259
user3   stage/sql/Opening tables        0
 
3260
user4   stage/sql/checking permissions  0
 
3261
user4   stage/sql/closing tables        0
 
3262
user4   stage/sql/init  0
 
3263
user4   stage/sql/Opening tables        0
 
3264
execute dump_stages_host;
 
3265
host    event_name      count_star
 
3266
execute dump_stages_global;
 
3267
event_name      count_star
 
3268
stage/sql/checking permissions  0
 
3269
stage/sql/closing tables        0
 
3270
stage/sql/init  0
 
3271
stage/sql/Opening tables        0
 
3272
execute dump_stages_history;
 
3273
event_name      count(event_name)
 
3274
stage/sql/checking permissions  12
 
3275
stage/sql/closing tables        12
 
3276
stage/sql/init  28
 
3277
stage/sql/Opening tables        12
 
3278
execute dump_statements_account;
 
3279
user    host    event_name      count_star
 
3280
execute dump_statements_user;
 
3281
user    event_name      count_star
 
3282
user1   statement/com/Error     0
 
3283
user1   statement/com/Quit      0
 
3284
user1   statement/sql/insert    0
 
3285
user1   statement/sql/select    0
 
3286
user2   statement/com/Error     0
 
3287
user2   statement/com/Quit      0
 
3288
user2   statement/sql/insert    0
 
3289
user2   statement/sql/select    0
 
3290
user3   statement/com/Error     0
 
3291
user3   statement/com/Quit      0
 
3292
user3   statement/sql/insert    0
 
3293
user3   statement/sql/select    0
 
3294
user4   statement/com/Error     0
 
3295
user4   statement/com/Quit      0
 
3296
user4   statement/sql/insert    0
 
3297
user4   statement/sql/select    0
 
3298
execute dump_statements_host;
 
3299
host    event_name      count_star
 
3300
execute dump_statements_global;
 
3301
event_name      count_star
 
3302
statement/com/Error     0
 
3303
statement/com/Quit      0
 
3304
statement/sql/insert    0
 
3305
statement/sql/select    0
 
3306
execute dump_statements_history;
 
3307
event_name      count(event_name)
 
3308
statement/com/Quit      4
 
3309
statement/sql/insert    4
 
3310
statement/sql/select    8
 
3311
execute dump_accounts;
 
3312
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3313
execute dump_users;
 
3314
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3315
root    1       1
 
3316
user1   0       1
 
3317
user2   0       1
 
3318
user3   0       1
 
3319
user4   0       1
 
3320
execute dump_hosts;
 
3321
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3322
truncate performance_schema.accounts;
 
3323
"================== ACCOUNTS truncated =================="
 
3324
"================== Step 29 =================="
 
3325
call dump_thread();
 
3326
username        status
 
3327
user1   not found
 
3328
username        status
 
3329
user2   not found
 
3330
username        status
 
3331
user3   not found
 
3332
username        status
 
3333
user4   not found
 
3334
execute dump_waits_account;
 
3335
user    host    event_name      count_star
 
3336
execute dump_waits_user;
 
3337
user    event_name      count_star
 
3338
user1   wait/io/file/sql/query_log      0
 
3339
user1   wait/synch/mutex/sql/LOCK_connection_count      0
 
3340
user1   wait/synch/mutex/sql/LOCK_user_locks    0
 
3341
user1   wait/synch/rwlock/sql/LOCK_grant        0
 
3342
user2   wait/io/file/sql/query_log      0
 
3343
user2   wait/synch/mutex/sql/LOCK_connection_count      0
 
3344
user2   wait/synch/mutex/sql/LOCK_user_locks    0
 
3345
user2   wait/synch/rwlock/sql/LOCK_grant        0
 
3346
user3   wait/io/file/sql/query_log      0
 
3347
user3   wait/synch/mutex/sql/LOCK_connection_count      0
 
3348
user3   wait/synch/mutex/sql/LOCK_user_locks    0
 
3349
user3   wait/synch/rwlock/sql/LOCK_grant        0
 
3350
user4   wait/io/file/sql/query_log      0
 
3351
user4   wait/synch/mutex/sql/LOCK_connection_count      0
 
3352
user4   wait/synch/mutex/sql/LOCK_user_locks    0
 
3353
user4   wait/synch/rwlock/sql/LOCK_grant        0
 
3354
execute dump_waits_host;
 
3355
host    event_name      count_star
 
3356
execute dump_waits_global;
 
3357
event_name      count_star
 
3358
wait/io/file/sql/query_log      0
 
3359
wait/synch/mutex/sql/LOCK_connection_count      0
 
3360
wait/synch/mutex/sql/LOCK_user_locks    0
 
3361
wait/synch/rwlock/sql/LOCK_grant        0
 
3362
execute dump_waits_history;
 
3363
event_name      count(event_name)
 
3364
wait/io/file/sql/query_log      20
 
3365
wait/synch/mutex/sql/LOCK_connection_count      4
 
3366
wait/synch/mutex/sql/LOCK_user_locks    8
 
3367
wait/synch/rwlock/sql/LOCK_grant        8
 
3368
execute dump_stages_account;
 
3369
user    host    event_name      count_star
 
3370
execute dump_stages_user;
 
3371
user    event_name      count_star
 
3372
user1   stage/sql/checking permissions  0
 
3373
user1   stage/sql/closing tables        0
 
3374
user1   stage/sql/init  0
 
3375
user1   stage/sql/Opening tables        0
 
3376
user2   stage/sql/checking permissions  0
 
3377
user2   stage/sql/closing tables        0
 
3378
user2   stage/sql/init  0
 
3379
user2   stage/sql/Opening tables        0
 
3380
user3   stage/sql/checking permissions  0
 
3381
user3   stage/sql/closing tables        0
 
3382
user3   stage/sql/init  0
 
3383
user3   stage/sql/Opening tables        0
 
3384
user4   stage/sql/checking permissions  0
 
3385
user4   stage/sql/closing tables        0
 
3386
user4   stage/sql/init  0
 
3387
user4   stage/sql/Opening tables        0
 
3388
execute dump_stages_host;
 
3389
host    event_name      count_star
 
3390
execute dump_stages_global;
 
3391
event_name      count_star
 
3392
stage/sql/checking permissions  0
 
3393
stage/sql/closing tables        0
 
3394
stage/sql/init  0
 
3395
stage/sql/Opening tables        0
 
3396
execute dump_stages_history;
 
3397
event_name      count(event_name)
 
3398
stage/sql/checking permissions  12
 
3399
stage/sql/closing tables        12
 
3400
stage/sql/init  28
 
3401
stage/sql/Opening tables        12
 
3402
execute dump_statements_account;
 
3403
user    host    event_name      count_star
 
3404
execute dump_statements_user;
 
3405
user    event_name      count_star
 
3406
user1   statement/com/Error     0
 
3407
user1   statement/com/Quit      0
 
3408
user1   statement/sql/insert    0
 
3409
user1   statement/sql/select    0
 
3410
user2   statement/com/Error     0
 
3411
user2   statement/com/Quit      0
 
3412
user2   statement/sql/insert    0
 
3413
user2   statement/sql/select    0
 
3414
user3   statement/com/Error     0
 
3415
user3   statement/com/Quit      0
 
3416
user3   statement/sql/insert    0
 
3417
user3   statement/sql/select    0
 
3418
user4   statement/com/Error     0
 
3419
user4   statement/com/Quit      0
 
3420
user4   statement/sql/insert    0
 
3421
user4   statement/sql/select    0
 
3422
execute dump_statements_host;
 
3423
host    event_name      count_star
 
3424
execute dump_statements_global;
 
3425
event_name      count_star
 
3426
statement/com/Error     0
 
3427
statement/com/Quit      0
 
3428
statement/sql/insert    0
 
3429
statement/sql/select    0
 
3430
execute dump_statements_history;
 
3431
event_name      count(event_name)
 
3432
statement/com/Quit      4
 
3433
statement/sql/insert    4
 
3434
statement/sql/select    8
 
3435
execute dump_accounts;
 
3436
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3437
execute dump_users;
 
3438
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3439
root    1       1
 
3440
user1   0       1
 
3441
user2   0       1
 
3442
user3   0       1
 
3443
user4   0       1
 
3444
execute dump_hosts;
 
3445
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3446
truncate performance_schema.users;
 
3447
"================== USERS truncated =================="
 
3448
"================== Step 30 =================="
 
3449
call dump_thread();
 
3450
username        status
 
3451
user1   not found
 
3452
username        status
 
3453
user2   not found
 
3454
username        status
 
3455
user3   not found
 
3456
username        status
 
3457
user4   not found
 
3458
execute dump_waits_account;
 
3459
user    host    event_name      count_star
 
3460
execute dump_waits_user;
 
3461
user    event_name      count_star
 
3462
execute dump_waits_host;
 
3463
host    event_name      count_star
 
3464
execute dump_waits_global;
 
3465
event_name      count_star
 
3466
wait/io/file/sql/query_log      0
 
3467
wait/synch/mutex/sql/LOCK_connection_count      0
 
3468
wait/synch/mutex/sql/LOCK_user_locks    0
 
3469
wait/synch/rwlock/sql/LOCK_grant        0
 
3470
execute dump_waits_history;
 
3471
event_name      count(event_name)
 
3472
wait/io/file/sql/query_log      20
 
3473
wait/synch/mutex/sql/LOCK_connection_count      4
 
3474
wait/synch/mutex/sql/LOCK_user_locks    8
 
3475
wait/synch/rwlock/sql/LOCK_grant        8
 
3476
execute dump_stages_account;
 
3477
user    host    event_name      count_star
 
3478
execute dump_stages_user;
 
3479
user    event_name      count_star
 
3480
execute dump_stages_host;
 
3481
host    event_name      count_star
 
3482
execute dump_stages_global;
 
3483
event_name      count_star
 
3484
stage/sql/checking permissions  0
 
3485
stage/sql/closing tables        0
 
3486
stage/sql/init  0
 
3487
stage/sql/Opening tables        0
 
3488
execute dump_stages_history;
 
3489
event_name      count(event_name)
 
3490
stage/sql/checking permissions  12
 
3491
stage/sql/closing tables        12
 
3492
stage/sql/init  28
 
3493
stage/sql/Opening tables        12
 
3494
execute dump_statements_account;
 
3495
user    host    event_name      count_star
 
3496
execute dump_statements_user;
 
3497
user    event_name      count_star
 
3498
execute dump_statements_host;
 
3499
host    event_name      count_star
 
3500
execute dump_statements_global;
 
3501
event_name      count_star
 
3502
statement/com/Error     0
 
3503
statement/com/Quit      0
 
3504
statement/sql/insert    0
 
3505
statement/sql/select    0
 
3506
execute dump_statements_history;
 
3507
event_name      count(event_name)
 
3508
statement/com/Quit      4
 
3509
statement/sql/insert    4
 
3510
statement/sql/select    8
 
3511
execute dump_accounts;
 
3512
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3513
execute dump_users;
 
3514
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3515
root    1       1
 
3516
execute dump_hosts;
 
3517
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3518
truncate performance_schema.hosts;
 
3519
"================== HOSTS truncated =================="
 
3520
"================== Step 31 =================="
 
3521
call dump_thread();
 
3522
username        status
 
3523
user1   not found
 
3524
username        status
 
3525
user2   not found
 
3526
username        status
 
3527
user3   not found
 
3528
username        status
 
3529
user4   not found
 
3530
execute dump_waits_account;
 
3531
user    host    event_name      count_star
 
3532
execute dump_waits_user;
 
3533
user    event_name      count_star
 
3534
execute dump_waits_host;
 
3535
host    event_name      count_star
 
3536
execute dump_waits_global;
 
3537
event_name      count_star
 
3538
wait/io/file/sql/query_log      0
 
3539
wait/synch/mutex/sql/LOCK_connection_count      0
 
3540
wait/synch/mutex/sql/LOCK_user_locks    0
 
3541
wait/synch/rwlock/sql/LOCK_grant        0
 
3542
execute dump_waits_history;
 
3543
event_name      count(event_name)
 
3544
wait/io/file/sql/query_log      20
 
3545
wait/synch/mutex/sql/LOCK_connection_count      4
 
3546
wait/synch/mutex/sql/LOCK_user_locks    8
 
3547
wait/synch/rwlock/sql/LOCK_grant        8
 
3548
execute dump_stages_account;
 
3549
user    host    event_name      count_star
 
3550
execute dump_stages_user;
 
3551
user    event_name      count_star
 
3552
execute dump_stages_host;
 
3553
host    event_name      count_star
 
3554
execute dump_stages_global;
 
3555
event_name      count_star
 
3556
stage/sql/checking permissions  0
 
3557
stage/sql/closing tables        0
 
3558
stage/sql/init  0
 
3559
stage/sql/Opening tables        0
 
3560
execute dump_stages_history;
 
3561
event_name      count(event_name)
 
3562
stage/sql/checking permissions  12
 
3563
stage/sql/closing tables        12
 
3564
stage/sql/init  28
 
3565
stage/sql/Opening tables        12
 
3566
execute dump_statements_account;
 
3567
user    host    event_name      count_star
 
3568
execute dump_statements_user;
 
3569
user    event_name      count_star
 
3570
execute dump_statements_host;
 
3571
host    event_name      count_star
 
3572
execute dump_statements_global;
 
3573
event_name      count_star
 
3574
statement/com/Error     0
 
3575
statement/com/Quit      0
 
3576
statement/sql/insert    0
 
3577
statement/sql/select    0
 
3578
execute dump_statements_history;
 
3579
event_name      count(event_name)
 
3580
statement/com/Quit      4
 
3581
statement/sql/insert    4
 
3582
statement/sql/select    8
 
3583
execute dump_accounts;
 
3584
USER    HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3585
execute dump_users;
 
3586
USER    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS
 
3587
root    1       1
 
3588
execute dump_hosts;
 
3589
HOST    CURRENT_CONNECTIONS     TOTAL_CONNECTIONS