diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/event_aggregate_no_h.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/event_aggregate_no_h.result | 37 |
1 files changed, 25 insertions, 12 deletions
diff --git a/mysql-test/suite/perfschema/r/event_aggregate_no_h.result b/mysql-test/suite/perfschema/r/event_aggregate_no_h.result index 0595c50e531..86edcf225c7 100644 --- a/mysql-test/suite/perfschema/r/event_aggregate_no_h.result +++ b/mysql-test/suite/perfschema/r/event_aggregate_no_h.result @@ -58,7 +58,8 @@ USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS -"================== con1 connected ==================" +connect con1, localhost, user1, , ; +connection default; "================== Step 2 ==================" call dump_thread(); username event_name count_star @@ -149,6 +150,7 @@ root 1 1 user1 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +connection con1; select get_lock("marker", 10); get_lock("marker", 10) 1 @@ -156,7 +158,7 @@ select release_lock("marker"); release_lock("marker") 1 insert into test.t1 values ("marker"); -"================== con1 marker ==================" +connection default; "================== Step 3 ==================" call dump_thread(); username event_name count_star @@ -254,7 +256,8 @@ root 1 1 user1 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS -"================== con2 connected ==================" +connect con2, localhost, user2, , ; +connection default; "================== Step 4 ==================" call dump_thread(); username event_name count_star @@ -381,6 +384,7 @@ user1 1 1 user2 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +connection con2; select get_lock("marker", 10); get_lock("marker", 10) 1 @@ -388,7 +392,7 @@ select release_lock("marker"); release_lock("marker") 1 insert into test.t1 values ("marker"); -"================== con2 marker ==================" +connection default; "================== Step 5 ==================" call dump_thread(); username event_name count_star @@ -515,7 +519,8 @@ user1 1 1 user2 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS -"================== con3 connected ==================" +connect con3, localhost, user3, , ; +connection default; "================== Step 6 ==================" call dump_thread(); username event_name count_star @@ -671,6 +676,7 @@ user2 1 1 user3 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +connection con3; select get_lock("marker", 10); get_lock("marker", 10) 1 @@ -678,7 +684,7 @@ select release_lock("marker"); release_lock("marker") 1 insert into test.t1 values ("marker"); -"================== con3 marker ==================" +connection default; "================== Step 7 ==================" call dump_thread(); username event_name count_star @@ -834,7 +840,8 @@ user2 1 1 user3 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS -"================== con4 connected ==================" +connect con4, localhost, user4, , ; +connection default; "================== Step 8 ==================" call dump_thread(); username event_name count_star @@ -1019,6 +1026,7 @@ user3 1 1 user4 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +connection con4; select get_lock("marker", 10); get_lock("marker", 10) 1 @@ -1026,7 +1034,7 @@ select release_lock("marker"); release_lock("marker") 1 insert into test.t1 values ("marker"); -"================== con4 marker ==================" +connection default; "================== Step 9 ==================" call dump_thread(); username event_name count_star @@ -1211,7 +1219,8 @@ user3 1 1 user4 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS -"================== con1 disconnected ==================" +disconnect con1; +connection default; "================== Step 10 ==================" call dump_thread(); username status @@ -1395,7 +1404,8 @@ user3 1 1 user4 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS -"================== con2 disconnected ==================" +disconnect con2; +connection default; "================== Step 11 ==================" call dump_thread(); username status @@ -1576,7 +1586,8 @@ user3 1 1 user4 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS -"================== con3 disconnected ==================" +disconnect con3; +connection default; "================== Step 12 ==================" call dump_thread(); username status @@ -1754,7 +1765,8 @@ user3 0 1 user4 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS -"================== con4 disconnected ==================" +disconnect con4; +connection default; "================== Step 13 ==================" call dump_thread(); username status @@ -1929,6 +1941,7 @@ user3 0 1 user4 0 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +connection default; truncate performance_schema.events_waits_summary_by_thread_by_event_name; "================== WAITS_BY_THREAD truncated ==================" "================== Step 14 ==================" |