diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_2t.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_2t.result | 33 |
1 files changed, 24 insertions, 9 deletions
diff --git a/mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_2t.result b/mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_2t.result index 390a3523421..ac5cde25522 100644 --- a/mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_2t.result +++ b/mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_2t.result @@ -154,9 +154,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 @@ -215,6 +217,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; @@ -246,7 +249,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 10 TABLE test t2 0 TABLE test t3 14 +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 @@ -371,6 +376,7 @@ object_type object_schema object_name count_star TABLE test t1 10 TABLE test t2 0 TABLE test t3 14 +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; @@ -409,7 +415,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 @@ -473,9 +479,11 @@ object_type object_schema object_name count_star TABLE test t1 20 TABLE test t2 0 TABLE test t3 28 +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 @@ -544,6 +552,7 @@ object_type object_schema object_name count_star TABLE test t1 20 TABLE test t2 0 TABLE test t3 28 +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; @@ -589,7 +598,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 @@ -658,9 +667,11 @@ object_type object_schema object_name count_star TABLE test t1 30 TABLE test t2 0 TABLE test t3 42 +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 @@ -734,6 +745,7 @@ object_type object_schema object_name count_star TABLE test t1 30 TABLE test t2 0 TABLE test t3 42 +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; @@ -786,7 +798,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 @@ -860,11 +872,12 @@ object_type object_schema object_name count_star TABLE test t1 40 TABLE test t2 0 TABLE test t3 56 +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 @@ -938,6 +951,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 0 TABLE test t3 60 +connection default; flush tables; "================== flush marker ==================" "================== Step 11 ==================" @@ -1089,7 +1103,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 0 TABLE test t3 60 -"================== con1 disconnected ==================" +disconnect con1; "================== Step 13 ==================" call dump_thread(); username status @@ -1162,7 +1176,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 0 TABLE test t3 60 -"================== con2 disconnected ==================" +disconnect con2; "================== Step 14 ==================" call dump_thread(); username status @@ -1234,7 +1248,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 0 TABLE test t3 60 -"================== con3 disconnected ==================" +disconnect con3; "================== Step 15 ==================" call dump_thread(); username status @@ -1305,7 +1319,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 0 TABLE test t3 60 -"================== con4 disconnected ==================" +disconnect con4; "================== Step 16 ==================" call dump_thread(); username status @@ -1375,6 +1389,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 0 TABLE test t3 60 +connection default; truncate performance_schema.events_waits_summary_by_thread_by_event_name; "================== BY_THREAD truncated ==================" "================== Step 17 ==================" |