diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_2t.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_2t.result | 33 |
1 files changed, 24 insertions, 9 deletions
diff --git a/mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_2t.result b/mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_2t.result index 7aec1bba281..c5481451fd3 100644 --- a/mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_2t.result +++ b/mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_2t.result @@ -152,9 +152,11 @@ object_type object_schema object_name count_star TABLE test t1 0 TABLE test t2 0 TABLE test t3 0 +connect con1, localhost, user1, , ; select concat(current_user(), " is connected") as status; status user1@localhost is connected +connection default; "================== Step 2 ==================" call dump_thread(); username event_name count_star @@ -213,6 +215,7 @@ object_type object_schema object_name count_star TABLE test t1 0 TABLE test t2 0 TABLE test t3 0 +connection con1; insert into test.t1 set a=101, b=1, c=1; insert into test.t2 set a=102, b=2, c=2; insert into test.t2 set a=103, b=3, c=3; @@ -244,7 +247,7 @@ a b c d select * from test.t3 where b=5; a b c d 105 5 5 1 -"================== con1 marker ==================" +connection default; "================== Step 3 ==================" call dump_thread(); username event_name count_star @@ -305,9 +308,11 @@ object_type object_schema object_name count_star TABLE test t1 8 TABLE test t2 0 TABLE test t3 17 +connect con2, localhost, user2, , ; select concat(current_user(), " is connected") as status; status user2@localhost is connected +connection default; "================== Step 4 ==================" call dump_thread(); username event_name count_star @@ -373,6 +378,7 @@ object_type object_schema object_name count_star TABLE test t1 8 TABLE test t2 0 TABLE test t3 17 +connection con2; insert into test.t1 set a=201, b=1, c=1; insert into test.t2 set a=202, b=2, c=2; insert into test.t2 set a=203, b=3, c=3; @@ -411,7 +417,7 @@ select * from test.t3 where b=5; a b c d 105 5 5 2 205 5 5 1 -"================== con2 marker ==================" +connection default; "================== Step 5 ==================" call dump_thread(); username event_name count_star @@ -477,9 +483,11 @@ object_type object_schema object_name count_star TABLE test t1 8 TABLE test t2 0 TABLE test t3 17 +connect con3, localhost, user3, , ; select concat(current_user(), " is connected") as status; status user3@localhost is connected +connection default; "================== Step 6 ==================" call dump_thread(); username event_name count_star @@ -550,6 +558,7 @@ object_type object_schema object_name count_star TABLE test t1 8 TABLE test t2 0 TABLE test t3 17 +connection con3; insert into test.t1 set a=301, b=1, c=1; insert into test.t2 set a=302, b=2, c=2; insert into test.t2 set a=303, b=3, c=3; @@ -595,7 +604,7 @@ a b c d 105 5 5 3 205 5 5 2 305 5 5 1 -"================== con3 marker ==================" +connection default; "================== Step 7 ==================" call dump_thread(); username event_name count_star @@ -666,9 +675,11 @@ object_type object_schema object_name count_star TABLE test t1 23 TABLE test t2 0 TABLE test t3 54 +connect con4, localhost, user4, , ; select concat(current_user(), " is connected") as status; status user4@localhost is connected +connection default; "================== Step 8 ==================" call dump_thread(); username event_name count_star @@ -744,6 +755,7 @@ object_type object_schema object_name count_star TABLE test t1 23 TABLE test t2 0 TABLE test t3 54 +connection con4; insert into test.t1 set a=401, b=1, c=1; insert into test.t2 set a=402, b=2, c=2; insert into test.t2 set a=403, b=3, c=3; @@ -796,7 +808,7 @@ a b c d 205 5 5 3 305 5 5 2 405 5 5 1 -"================== con4 marker ==================" +connection default; "================== Step 9 ==================" call dump_thread(); username event_name count_star @@ -872,11 +884,12 @@ object_type object_schema object_name count_star TABLE test t1 23 TABLE test t2 0 TABLE test t3 54 +connection con1; lock tables test.t1 read, test.t2 read, test.t3 read; unlock tables; lock tables test.t1 write, test.t2 write, test.t3 write; unlock tables; -"================== con1 marker ==================" +connection default; "================== Step 10 ==================" call dump_thread(); username event_name count_star @@ -952,6 +965,7 @@ object_type object_schema object_name count_star TABLE test t1 23 TABLE test t2 0 TABLE test t3 54 +connection default; flush tables; "================== flush marker ==================" "================== Step 11 ==================" @@ -1107,7 +1121,7 @@ object_type object_schema object_name count_star TABLE test t1 23 TABLE test t2 0 TABLE test t3 54 -"================== con1 disconnected ==================" +disconnect con1; "================== Step 13 ==================" call dump_thread(); username status @@ -1182,7 +1196,7 @@ object_type object_schema object_name count_star TABLE test t1 23 TABLE test t2 0 TABLE test t3 54 -"================== con2 disconnected ==================" +disconnect con2; "================== Step 14 ==================" call dump_thread(); username status @@ -1256,7 +1270,7 @@ object_type object_schema object_name count_star TABLE test t1 23 TABLE test t2 0 TABLE test t3 54 -"================== con3 disconnected ==================" +disconnect con3; "================== Step 15 ==================" call dump_thread(); username status @@ -1329,7 +1343,7 @@ object_type object_schema object_name count_star TABLE test t1 23 TABLE test t2 0 TABLE test t3 54 -"================== con4 disconnected ==================" +disconnect con4; "================== Step 16 ==================" call dump_thread(); username status @@ -1401,6 +1415,7 @@ object_type object_schema object_name count_star TABLE test t1 23 TABLE test t2 0 TABLE test t3 54 +connection default; truncate performance_schema.events_waits_summary_by_thread_by_event_name; "================== BY_THREAD truncated ==================" "================== Step 17 ==================" |