diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_io_aggregate_hist_4u_2t.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/table_io_aggregate_hist_4u_2t.result | 1044 |
1 files changed, 491 insertions, 553 deletions
diff --git a/mysql-test/suite/perfschema/r/table_io_aggregate_hist_4u_2t.result b/mysql-test/suite/perfschema/r/table_io_aggregate_hist_4u_2t.result index 914bcc7084b..a19d3798e8b 100644 --- a/mysql-test/suite/perfschema/r/table_io_aggregate_hist_4u_2t.result +++ b/mysql-test/suite/perfschema/r/table_io_aggregate_hist_4u_2t.result @@ -4,11 +4,11 @@ delete from performance_schema.setup_objects where object_name='t2'; select * from performance_schema.setup_actors order by USER, HOST, ROLE; -HOST USER ROLE -localhost user1 % -localhost user2 % -localhost user3 % -localhost user4 % +HOST USER ROLE ENABLED HISTORY +localhost user1 % YES YES +localhost user2 % YES YES +localhost user3 % YES YES +localhost user4 % YES YES select * from performance_schema.setup_objects order by object_type, object_schema, object_name; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED @@ -22,6 +22,9 @@ events_stages_history_long YES events_statements_current YES events_statements_history YES events_statements_history_long YES +events_transactions_current YES +events_transactions_history YES +events_transactions_history_long YES events_waits_current YES events_waits_history YES events_waits_history_long YES @@ -65,28 +68,20 @@ execute dump_waits_history; event_name count(event_name) object_type object_schema object_name execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 0 0 0 0 0 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 0 0 0 0 0 0 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 0 0 0 0 0 0 0 TABLE test t3 index_b 0 0 0 0 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 0 0 0 0 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 @@ -128,28 +123,20 @@ execute dump_waits_history; event_name count(event_name) object_type object_schema object_name execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 0 0 0 0 0 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 0 0 0 0 0 0 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 0 0 0 0 0 0 0 TABLE test t3 index_b 0 0 0 0 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 0 0 0 0 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 @@ -180,18 +167,18 @@ update test.t3 set d=d+1; update test.t1 set d=d+1 where a=101; update test.t2 set d=d+1 where a=101; update test.t3 set d=d+1 where a=101; -select * from test.t1 where b=5; +select * from test.t1 force index(index_b) where b=5; a b c d -select * from test.t2 where b=5; +select * from test.t2 force index(index_b) where b=5; a b c d -select * from test.t3 where b=5; +select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 1 connection default; -"================== Step 3 ==================" +"================== Step 3-A ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 username status user2 not found @@ -201,53 +188,105 @@ username status user4 not found execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 25 +localhost wait/io/table/sql/handler 23 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 25 +wait/io/table/sql/handler 23 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 8 TABLE test t1 -wait/io/table/sql/handler 17 TABLE test t3 +wait/io/table/sql/handler 15 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 6 4 2 4 1 1 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 2 1 1 1 0 1 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 14 8 6 8 3 3 0 -TABLE test t3 index_b 2 2 0 2 0 0 0 +TABLE test t3 NULL 13 7 6 7 3 3 0 +TABLE test t3 index_b 1 1 0 1 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 1 1 0 1 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 8 5 3 5 1 2 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 17 11 6 11 3 3 0 +TABLE test t3 15 9 6 9 3 3 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 8 TABLE test t2 0 -TABLE test t3 17 +TABLE test t3 15 +connection con1; +flush tables; +"================== con1 FLUSH ==================" +connection default; +"================== Step 3-B ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 23 +user1 wait/lock/table/sql/handler 0 +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 23 +user1 localhost wait/lock/table/sql/handler 0 +execute dump_waits_user; +user event_name count_star +user1 wait/io/table/sql/handler 23 +user1 wait/lock/table/sql/handler 0 +execute dump_waits_host; +host event_name count_star +localhost wait/io/table/sql/handler 23 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 23 +wait/lock/table/sql/handler 0 +execute dump_waits_history; +event_name count(event_name) object_type object_schema object_name +wait/io/table/sql/handler 8 TABLE test t1 +wait/io/table/sql/handler 15 TABLE test t3 +execute dump_waits_index_io; +object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete +TABLE test t1 NULL 6 4 2 4 1 1 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 +TABLE test t1 index_cb 0 0 0 0 0 0 0 +TABLE test t1 PRIMARY 2 1 1 1 0 1 0 +TABLE test t3 NULL 13 7 6 7 3 3 0 +TABLE test t3 index_b 1 1 0 1 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 1 1 0 1 0 0 0 +execute dump_waits_table_io; +object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete +TABLE test t1 8 5 3 5 1 2 0 +TABLE test t3 15 9 6 9 3 3 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 +execute dump_objects_summary; +object_type object_schema object_name count_star +TABLE test t1 8 +TABLE test t2 0 +TABLE test t3 15 connect con2, localhost, user2, , ; select concat(current_user(), " is connected") as status; status @@ -256,7 +295,7 @@ connection default; "================== Step 4 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 username event_name count_star user2 wait/io/table/sql/handler 0 @@ -267,57 +306,51 @@ username status user4 not found execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 25 +localhost wait/io/table/sql/handler 23 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 25 +wait/io/table/sql/handler 23 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name wait/io/table/sql/handler 8 TABLE test t1 -wait/io/table/sql/handler 17 TABLE test t3 +wait/io/table/sql/handler 15 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 6 4 2 4 1 1 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 2 1 1 1 0 1 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 14 8 6 8 3 3 0 -TABLE test t3 index_b 2 2 0 2 0 0 0 +TABLE test t3 NULL 13 7 6 7 3 3 0 +TABLE test t3 index_b 1 1 0 1 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 1 1 0 1 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 8 5 3 5 1 2 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 17 11 6 11 3 3 0 +TABLE test t3 15 9 6 9 3 3 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 8 TABLE test t2 0 -TABLE test t3 17 +TABLE test t3 15 connection con2; insert into test.t1 set a=201, b=1, c=1; insert into test.t2 set a=202, b=2, c=2; @@ -349,11 +382,11 @@ update test.t3 set d=d+1; update test.t1 set d=d+1 where a=201; update test.t2 set d=d+1 where a=201; update test.t3 set d=d+1 where a=201; -select * from test.t1 where b=5; +select * from test.t1 force index(index_b) where b=5; a b c d -select * from test.t2 where b=5; +select * from test.t2 force index(index_b) where b=5; a b c d -select * from test.t3 where b=5; +select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 2 205 5 5 1 @@ -361,10 +394,10 @@ connection default; "================== Step 5 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 username event_name count_star -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username status user3 not found @@ -372,57 +405,51 @@ username status user4 not found execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 64 +localhost wait/io/table/sql/handler 58 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 64 +wait/io/table/sql/handler 58 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 20 TABLE test t1 -wait/io/table/sql/handler 44 TABLE test t3 +wait/io/table/sql/handler 18 TABLE test t1 +wait/io/table/sql/handler 40 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 15 10 5 10 2 3 0 -TABLE test t1 index_b 1 1 0 1 0 0 0 +TABLE test t1 NULL 14 9 5 9 2 3 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 4 2 2 2 0 2 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 37 22 15 22 6 9 0 -TABLE test t3 index_b 5 5 0 5 0 0 0 +TABLE test t3 NULL 35 20 15 20 6 9 0 +TABLE test t3 index_b 3 3 0 3 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 2 2 0 2 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 20 13 7 13 2 5 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 44 29 15 29 6 9 0 +TABLE test t1 18 11 7 11 2 5 0 +TABLE test t3 40 25 15 25 6 9 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 20 +TABLE test t1 18 TABLE test t2 0 -TABLE test t3 44 +TABLE test t3 40 connect con3, localhost, user3, , ; select concat(current_user(), " is connected") as status; status @@ -431,10 +458,10 @@ connection default; "================== Step 6 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 username event_name count_star -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star user3 wait/io/table/sql/handler 0 @@ -443,61 +470,55 @@ username status user4 not found execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 user3 localhost wait/io/table/sql/handler 0 user3 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 user3 wait/io/table/sql/handler 0 user3 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 64 +localhost wait/io/table/sql/handler 58 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 64 +wait/io/table/sql/handler 58 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 20 TABLE test t1 -wait/io/table/sql/handler 44 TABLE test t3 +wait/io/table/sql/handler 18 TABLE test t1 +wait/io/table/sql/handler 40 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 15 10 5 10 2 3 0 -TABLE test t1 index_b 1 1 0 1 0 0 0 +TABLE test t1 NULL 14 9 5 9 2 3 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 4 2 2 2 0 2 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 37 22 15 22 6 9 0 -TABLE test t3 index_b 5 5 0 5 0 0 0 +TABLE test t3 NULL 35 20 15 20 6 9 0 +TABLE test t3 index_b 3 3 0 3 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 2 2 0 2 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 20 13 7 13 2 5 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 44 29 15 29 6 9 0 +TABLE test t1 18 11 7 11 2 5 0 +TABLE test t3 40 25 15 25 6 9 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 20 +TABLE test t1 18 TABLE test t2 0 -TABLE test t3 44 +TABLE test t3 40 connection con3; insert into test.t1 set a=301, b=1, c=1; insert into test.t2 set a=302, b=2, c=2; @@ -535,11 +556,11 @@ update test.t3 set d=d+1; update test.t1 set d=d+1 where a=301; update test.t2 set d=d+1 where a=301; update test.t3 set d=d+1 where a=301; -select * from test.t1 where b=5; +select * from test.t1 force index(index_b) where b=5; a b c d -select * from test.t2 where b=5; +select * from test.t2 force index(index_b) where b=5; a b c d -select * from test.t3 where b=5; +select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 3 205 5 5 2 @@ -548,73 +569,67 @@ connection default; "================== Step 7 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 username event_name count_star -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username status user4 not found execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 116 +localhost wait/io/table/sql/handler 106 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 116 +wait/io/table/sql/handler 106 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 35 TABLE test t1 -wait/io/table/sql/handler 81 TABLE test t3 +wait/io/table/sql/handler 31 TABLE test t1 +wait/io/table/sql/handler 75 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 27 18 9 18 3 6 0 -TABLE test t1 index_b 2 2 0 2 0 0 0 +TABLE test t1 NULL 25 16 9 16 3 6 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 6 3 3 3 0 3 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 69 42 27 42 9 18 0 -TABLE test t3 index_b 9 9 0 9 0 0 0 +TABLE test t3 NULL 66 39 27 39 9 18 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 3 3 0 3 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 35 23 12 23 3 9 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 81 54 27 54 9 18 0 +TABLE test t1 31 19 12 19 3 9 0 +TABLE test t3 75 48 27 48 9 18 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 35 +TABLE test t1 31 TABLE test t2 0 -TABLE test t3 81 +TABLE test t3 75 connect con4, localhost, user4, , ; select concat(current_user(), " is connected") as status; status @@ -623,78 +638,72 @@ connection default; "================== Step 8 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 username event_name count_star -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star user4 wait/io/table/sql/handler 0 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 user4 localhost wait/io/table/sql/handler 0 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 user4 wait/io/table/sql/handler 0 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 116 +localhost wait/io/table/sql/handler 106 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 116 +wait/io/table/sql/handler 106 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 35 TABLE test t1 -wait/io/table/sql/handler 81 TABLE test t3 +wait/io/table/sql/handler 31 TABLE test t1 +wait/io/table/sql/handler 75 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 27 18 9 18 3 6 0 -TABLE test t1 index_b 2 2 0 2 0 0 0 +TABLE test t1 NULL 25 16 9 16 3 6 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 6 3 3 3 0 3 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 69 42 27 42 9 18 0 -TABLE test t3 index_b 9 9 0 9 0 0 0 +TABLE test t3 NULL 66 39 27 39 9 18 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 3 3 0 3 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 35 23 12 23 3 9 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 81 54 27 54 9 18 0 +TABLE test t1 31 19 12 19 3 9 0 +TABLE test t3 75 48 27 48 9 18 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 35 +TABLE test t1 31 TABLE test t2 0 -TABLE test t3 81 +TABLE test t3 75 connection con4; insert into test.t1 set a=401, b=1, c=1; insert into test.t2 set a=402, b=2, c=2; @@ -738,11 +747,11 @@ update test.t3 set d=d+1; update test.t1 set d=d+1 where a=401; update test.t2 set d=d+1 where a=401; update test.t3 set d=d+1 where a=401; -select * from test.t1 where b=5; +select * from test.t1 force index(index_b) where b=5; a b c d -select * from test.t2 where b=5; +select * from test.t2 force index(index_b) where b=5; a b c d -select * from test.t3 where b=5; +select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 4 205 5 5 3 @@ -752,78 +761,72 @@ connection default; "================== Step 9 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 username event_name count_star -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 -user4 localhost wait/io/table/sql/handler 65 +user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 connection con1; lock tables test.t1 read, test.t2 read, test.t3 read; unlock tables; @@ -833,309 +836,285 @@ connection default; "================== Step 10 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 username event_name count_star -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 -user4 localhost wait/io/table/sql/handler 65 +user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 connection default; flush tables; "================== flush marker ==================" "================== Step 11 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 username event_name count_star -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 -user4 localhost wait/io/table/sql/handler 65 +user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 set global read_only=1; set global read_only=0; "================== global read_only marker ==================" "================== Step 12 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 username event_name count_star -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 -user4 localhost wait/io/table/sql/handler 65 +user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 disconnect con1; "================== Step 13 ==================" call dump_thread(); username status user1 not found username event_name count_star -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 username event_name count_star -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 -user4 localhost wait/io/table/sql/handler 65 +user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 disconnect con2; "================== Step 14 ==================" call dump_thread(); @@ -1144,72 +1123,66 @@ user1 not found username status user2 not found username event_name count_star -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 username event_name count_star -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 -user4 localhost wait/io/table/sql/handler 65 +user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 disconnect con3; "================== Step 15 ==================" call dump_thread(); @@ -1220,69 +1193,63 @@ user2 not found username status user3 not found username event_name count_star -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 -user4 localhost wait/io/table/sql/handler 65 +user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 disconnect con4; "================== Step 16 ==================" call dump_thread(); @@ -1296,65 +1263,59 @@ username status user4 not found execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 -user4 localhost wait/io/table/sql/handler 65 +user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 connection default; truncate performance_schema.events_waits_summary_by_thread_by_event_name; "================== BY_THREAD truncated ==================" @@ -1370,65 +1331,59 @@ username status user4 not found execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/table/sql/handler 25 +user1 localhost wait/io/table/sql/handler 23 user1 localhost wait/lock/table/sql/handler 0 -user2 localhost wait/io/table/sql/handler 39 +user2 localhost wait/io/table/sql/handler 35 user2 localhost wait/lock/table/sql/handler 0 -user3 localhost wait/io/table/sql/handler 52 +user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 0 -user4 localhost wait/io/table/sql/handler 65 +user4 localhost wait/io/table/sql/handler 61 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 truncate performance_schema.events_waits_summary_by_account_by_event_name; "================== BY_ACCOUNT truncated ==================" "================== Step 18 ==================" @@ -1453,55 +1408,49 @@ user4 localhost wait/io/table/sql/handler 0 user4 localhost wait/lock/table/sql/handler 0 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 25 +user1 wait/io/table/sql/handler 23 user1 wait/lock/table/sql/handler 0 -user2 wait/io/table/sql/handler 39 +user2 wait/io/table/sql/handler 35 user2 wait/lock/table/sql/handler 0 -user3 wait/io/table/sql/handler 52 +user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 0 -user4 wait/io/table/sql/handler 65 +user4 wait/io/table/sql/handler 61 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 truncate performance_schema.events_waits_summary_by_user_by_event_name; "================== BY_USER truncated ==================" "================== Step 19 ==================" @@ -1536,45 +1485,39 @@ user4 wait/io/table/sql/handler 0 user4 wait/lock/table/sql/handler 0 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 181 +localhost wait/io/table/sql/handler 167 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 truncate performance_schema.events_waits_summary_by_host_by_event_name; "================== BY_HOST truncated ==================" "================== Step 21 ==================" @@ -1613,41 +1556,35 @@ localhost wait/io/table/sql/handler 0 localhost wait/lock/table/sql/handler 0 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 181 +wait/io/table/sql/handler 167 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 42 28 14 28 4 10 0 -TABLE test t1 index_b 3 3 0 3 0 0 0 +TABLE test t1 NULL 39 25 14 25 4 10 0 +TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 8 4 4 4 0 4 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 -TABLE test t3 NULL 110 68 42 68 12 30 0 -TABLE test t3 index_b 14 14 0 14 0 0 0 +TABLE test t3 NULL 106 64 42 64 12 30 0 +TABLE test t3 index_b 10 10 0 10 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 TABLE test t3 PRIMARY 4 4 0 4 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 53 35 18 35 4 14 0 -TABLE test t2 0 0 0 0 0 0 0 -TABLE test t3 128 86 42 86 12 30 0 +TABLE test t1 47 29 18 29 4 14 0 +TABLE test t3 120 78 42 78 12 30 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 53 +TABLE test t1 47 TABLE test t2 0 -TABLE test t3 128 +TABLE test t3 120 truncate performance_schema.events_waits_summary_global_by_event_name; "================== GLOBAL truncated ==================" "================== Step 21 ==================" @@ -1690,18 +1627,14 @@ wait/io/table/sql/handler 0 wait/lock/table/sql/handler 0 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 53 TABLE test t1 -wait/io/table/sql/handler 128 TABLE test t3 +wait/io/table/sql/handler 47 TABLE test t1 +wait/io/table/sql/handler 120 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 NULL 0 0 0 0 0 0 0 TABLE test t1 index_b 0 0 0 0 0 0 0 TABLE test t1 index_cb 0 0 0 0 0 0 0 TABLE test t1 PRIMARY 0 0 0 0 0 0 0 -TABLE test t2 NULL 0 0 0 0 0 0 0 -TABLE test t2 index_b 0 0 0 0 0 0 0 -TABLE test t2 index_cb 0 0 0 0 0 0 0 -TABLE test t2 PRIMARY 0 0 0 0 0 0 0 TABLE test t3 NULL 0 0 0 0 0 0 0 TABLE test t3 index_b 0 0 0 0 0 0 0 TABLE test t3 index_cb 0 0 0 0 0 0 0 @@ -1709,19 +1642,17 @@ TABLE test t3 PRIMARY 0 0 0 0 0 0 0 execute dump_waits_table_io; object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete TABLE test t1 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 TABLE test t3 0 0 0 0 0 0 0 execute dump_waits_table_lock; -object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external -TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 TABLE test t2 0 TABLE test t3 0 -show status like "performance_schema%"; +show global status like "performance_schema%"; Variable_name Value Performance_schema_accounts_lost 0 Performance_schema_cond_classes_lost 0 @@ -1731,9 +1662,15 @@ Performance_schema_file_classes_lost 0 Performance_schema_file_handles_lost 0 Performance_schema_file_instances_lost 0 Performance_schema_hosts_lost 0 +Performance_schema_index_stat_lost 0 Performance_schema_locker_lost 0 +Performance_schema_memory_classes_lost 0 +Performance_schema_metadata_lock_lost 0 Performance_schema_mutex_classes_lost 0 Performance_schema_mutex_instances_lost 0 +Performance_schema_nested_statement_lost 0 +Performance_schema_prepared_statements_lost 0 +Performance_schema_program_lost 0 Performance_schema_rwlock_classes_lost 0 Performance_schema_rwlock_instances_lost 0 Performance_schema_session_connect_attrs_lost 0 @@ -1743,6 +1680,7 @@ Performance_schema_stage_classes_lost 0 Performance_schema_statement_classes_lost 0 Performance_schema_table_handles_lost 0 Performance_schema_table_instances_lost 0 +Performance_schema_table_lock_stat_lost 0 Performance_schema_thread_classes_lost 0 Performance_schema_thread_instances_lost 0 Performance_schema_users_lost 0 |