diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_lock_aggregate_global_4u_3t.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/table_lock_aggregate_global_4u_3t.result | 33 |
1 files changed, 24 insertions, 9 deletions
diff --git a/mysql-test/suite/perfschema/r/table_lock_aggregate_global_4u_3t.result b/mysql-test/suite/perfschema/r/table_lock_aggregate_global_4u_3t.result index 85e1bbeb332..376333fc794 100644 --- a/mysql-test/suite/perfschema/r/table_lock_aggregate_global_4u_3t.result +++ b/mysql-test/suite/perfschema/r/table_lock_aggregate_global_4u_3t.result @@ -153,9 +153,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 @@ -214,6 +216,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; @@ -245,7 +248,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 @@ -304,9 +307,11 @@ object_type object_schema object_name count_star TABLE test t1 10 TABLE test t2 12 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 @@ -370,6 +375,7 @@ object_type object_schema object_name count_star TABLE test t1 10 TABLE test t2 12 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; @@ -408,7 +414,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 @@ -472,9 +478,11 @@ object_type object_schema object_name count_star TABLE test t1 20 TABLE test t2 24 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 @@ -543,6 +551,7 @@ object_type object_schema object_name count_star TABLE test t1 20 TABLE test t2 24 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; @@ -588,7 +597,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 @@ -657,9 +666,11 @@ object_type object_schema object_name count_star TABLE test t1 30 TABLE test t2 36 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 @@ -733,6 +744,7 @@ object_type object_schema object_name count_star TABLE test t1 30 TABLE test t2 36 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; @@ -785,7 +797,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 @@ -859,11 +871,12 @@ object_type object_schema object_name count_star TABLE test t1 40 TABLE test t2 48 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 @@ -937,6 +950,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 52 TABLE test t3 60 +connection default; flush tables; "================== flush marker ==================" "================== Step 11 ==================" @@ -1088,7 +1102,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 52 TABLE test t3 60 -"================== con1 disconnected ==================" +disconnect con1; "================== Step 13 ==================" call dump_thread(); username status @@ -1161,7 +1175,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 52 TABLE test t3 60 -"================== con2 disconnected ==================" +disconnect con2; "================== Step 14 ==================" call dump_thread(); username status @@ -1233,7 +1247,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 52 TABLE test t3 60 -"================== con3 disconnected ==================" +disconnect con3; "================== Step 15 ==================" call dump_thread(); username status @@ -1304,7 +1318,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 52 TABLE test t3 60 -"================== con4 disconnected ==================" +disconnect con4; "================== Step 16 ==================" call dump_thread(); username status @@ -1374,6 +1388,7 @@ object_type object_schema object_name count_star TABLE test t1 44 TABLE test t2 52 TABLE test t3 60 +connection default; truncate performance_schema.events_waits_summary_by_thread_by_event_name; "================== BY_THREAD truncated ==================" "================== Step 17 ==================" |