diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_aggregate_hist_2u_2t.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/table_aggregate_hist_2u_2t.result | 354 |
1 files changed, 177 insertions, 177 deletions
diff --git a/mysql-test/suite/perfschema/r/table_aggregate_hist_2u_2t.result b/mysql-test/suite/perfschema/r/table_aggregate_hist_2u_2t.result index 52ece6d289d..b1b8707988c 100644 --- a/mysql-test/suite/perfschema/r/table_aggregate_hist_2u_2t.result +++ b/mysql-test/suite/perfschema/r/table_aggregate_hist_2u_2t.result @@ -176,7 +176,7 @@ connection default; "================== Step 3-A ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 username status user2 not found @@ -186,39 +186,39 @@ 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/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 24 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 23 +localhost wait/io/table/sql/handler 24 localhost wait/lock/table/sql/handler 24 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 23 +wait/io/table/sql/handler 24 wait/lock/table/sql/handler 24 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 9 TABLE test t1 wait/lock/table/sql/handler 10 TABLE test t1 wait/io/table/sql/handler 15 TABLE test t3 wait/lock/table/sql/handler 14 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 NULL 9 6 3 6 1 2 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 t1 PRIMARY 0 0 0 0 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 t1 9 6 3 6 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 @@ -226,7 +226,7 @@ TABLE test t1 10 4 6 2 0 0 0 2 0 3 TABLE test t3 14 4 10 2 0 0 0 2 0 5 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 18 +TABLE test t1 19 TABLE test t2 0 TABLE test t3 29 connection con1; @@ -236,7 +236,7 @@ connection default; "================== Step 3-B ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 username status user2 not found @@ -246,39 +246,39 @@ 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/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 24 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 23 +localhost wait/io/table/sql/handler 24 localhost wait/lock/table/sql/handler 24 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 23 +wait/io/table/sql/handler 24 wait/lock/table/sql/handler 24 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 9 TABLE test t1 wait/lock/table/sql/handler 10 TABLE test t1 wait/io/table/sql/handler 15 TABLE test t3 wait/lock/table/sql/handler 14 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 NULL 9 6 3 6 1 2 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 t1 PRIMARY 0 0 0 0 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 t1 9 6 3 6 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 @@ -286,7 +286,7 @@ TABLE test t1 10 4 6 2 0 0 0 2 0 3 TABLE test t3 14 4 10 2 0 0 0 2 0 5 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 18 +TABLE test t1 19 TABLE test t2 0 TABLE test t3 29 connect con2, localhost, user2, , ; @@ -297,7 +297,7 @@ connection default; "================== Step 4 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 username event_name count_star user2 wait/io/table/sql/handler 0 @@ -308,43 +308,43 @@ 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/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 24 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 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 23 +localhost wait/io/table/sql/handler 24 localhost wait/lock/table/sql/handler 24 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 23 +wait/io/table/sql/handler 24 wait/lock/table/sql/handler 24 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 9 TABLE test t1 wait/lock/table/sql/handler 10 TABLE test t1 wait/io/table/sql/handler 15 TABLE test t3 wait/lock/table/sql/handler 14 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 NULL 9 6 3 6 1 2 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 t1 PRIMARY 0 0 0 0 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 t1 9 6 3 6 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 @@ -352,7 +352,7 @@ TABLE test t1 10 4 6 2 0 0 0 2 0 3 TABLE test t3 14 4 10 2 0 0 0 2 0 5 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 18 +TABLE test t1 19 TABLE test t2 0 TABLE test t3 29 connection con2; @@ -398,7 +398,7 @@ connection default; "================== Step 5 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 username event_name count_star user2 wait/io/table/sql/handler 0 @@ -409,43 +409,43 @@ 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/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 24 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 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 23 +localhost wait/io/table/sql/handler 24 localhost wait/lock/table/sql/handler 24 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 23 +wait/io/table/sql/handler 24 wait/lock/table/sql/handler 24 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 9 TABLE test t1 wait/lock/table/sql/handler 10 TABLE test t1 wait/io/table/sql/handler 15 TABLE test t3 wait/lock/table/sql/handler 14 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 NULL 9 6 3 6 1 2 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 t1 PRIMARY 0 0 0 0 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 t1 9 6 3 6 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 @@ -453,7 +453,7 @@ TABLE test t1 10 4 6 2 0 0 0 2 0 3 TABLE test t3 14 4 10 2 0 0 0 2 0 5 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 18 +TABLE test t1 19 TABLE test t2 0 TABLE test t3 29 connect con3, localhost, user3, , ; @@ -464,7 +464,7 @@ connection default; "================== Step 6 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 username event_name count_star user2 wait/io/table/sql/handler 0 @@ -476,7 +476,7 @@ 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/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 24 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -484,7 +484,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -492,31 +492,31 @@ 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 23 +localhost wait/io/table/sql/handler 24 localhost wait/lock/table/sql/handler 24 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 23 +wait/io/table/sql/handler 24 wait/lock/table/sql/handler 24 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 9 TABLE test t1 wait/lock/table/sql/handler 10 TABLE test t1 wait/io/table/sql/handler 15 TABLE test t3 wait/lock/table/sql/handler 14 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 NULL 9 6 3 6 1 2 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 t1 PRIMARY 0 0 0 0 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 t1 9 6 3 6 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 @@ -524,7 +524,7 @@ TABLE test t1 10 4 6 2 0 0 0 2 0 3 TABLE test t3 14 4 10 2 0 0 0 2 0 5 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 18 +TABLE test t1 19 TABLE test t2 0 TABLE test t3 29 connection con3; @@ -577,7 +577,7 @@ connection default; "================== Step 7 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 username event_name count_star user2 wait/io/table/sql/handler 0 @@ -589,7 +589,7 @@ 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/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 24 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -597,7 +597,7 @@ user3 localhost wait/io/table/sql/handler 48 user3 localhost wait/lock/table/sql/handler 24 execute dump_waits_user; user event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -605,31 +605,31 @@ user3 wait/io/table/sql/handler 48 user3 wait/lock/table/sql/handler 24 execute dump_waits_host; host event_name count_star -localhost wait/io/table/sql/handler 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 48 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 48 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 20 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 28 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -637,7 +637,7 @@ TABLE test t1 20 8 12 4 0 0 0 4 0 6 TABLE test t3 28 8 20 4 0 0 0 4 0 10 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 41 +TABLE test t1 42 TABLE test t2 0 TABLE test t3 78 connect con4, localhost, user4, , ; @@ -648,7 +648,7 @@ connection default; "================== Step 8 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 username event_name count_star user2 wait/io/table/sql/handler 0 @@ -661,7 +661,7 @@ 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 23 +user1 localhost wait/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 24 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -671,7 +671,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -681,31 +681,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 48 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 48 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 20 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 28 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -713,7 +713,7 @@ TABLE test t1 20 8 12 4 0 0 0 4 0 6 TABLE test t3 28 8 20 4 0 0 0 4 0 10 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 41 +TABLE test t1 42 TABLE test t2 0 TABLE test t3 78 connection con4; @@ -773,7 +773,7 @@ connection default; "================== Step 9 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 username event_name count_star user2 wait/io/table/sql/handler 0 @@ -786,7 +786,7 @@ 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 23 +user1 localhost wait/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 24 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -796,7 +796,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 24 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -806,31 +806,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 48 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 48 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 20 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 28 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -838,7 +838,7 @@ TABLE test t1 20 8 12 4 0 0 0 4 0 6 TABLE test t3 28 8 20 4 0 0 0 4 0 10 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 41 +TABLE test t1 42 TABLE test t2 0 TABLE test t3 78 connection con1; @@ -850,7 +850,7 @@ connection default; "================== Step 10 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 username event_name count_star user2 wait/io/table/sql/handler 0 @@ -863,7 +863,7 @@ 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 23 +user1 localhost wait/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 32 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -873,7 +873,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -883,31 +883,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 56 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -915,7 +915,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 connection default; @@ -924,7 +924,7 @@ flush tables; "================== Step 11 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 username event_name count_star user2 wait/io/table/sql/handler 0 @@ -937,7 +937,7 @@ 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 23 +user1 localhost wait/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 32 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -947,7 +947,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -957,31 +957,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 56 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -989,7 +989,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 set global read_only=1; @@ -998,7 +998,7 @@ set global read_only=0; "================== Step 12 ==================" call dump_thread(); username event_name count_star -user1 wait/io/table/sql/handler 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 username event_name count_star user2 wait/io/table/sql/handler 0 @@ -1011,7 +1011,7 @@ 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 23 +user1 localhost wait/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 32 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -1021,7 +1021,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -1031,31 +1031,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 56 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -1063,7 +1063,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 disconnect con1; @@ -1082,7 +1082,7 @@ 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 23 +user1 localhost wait/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 32 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -1092,7 +1092,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -1102,31 +1102,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 56 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -1134,7 +1134,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 disconnect con2; @@ -1152,7 +1152,7 @@ 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 23 +user1 localhost wait/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 32 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -1162,7 +1162,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -1172,31 +1172,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 56 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -1204,7 +1204,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 disconnect con3; @@ -1221,7 +1221,7 @@ 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 23 +user1 localhost wait/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 32 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -1231,7 +1231,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -1241,31 +1241,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 56 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -1273,7 +1273,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 disconnect con4; @@ -1289,7 +1289,7 @@ 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/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 32 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -1299,7 +1299,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -1309,31 +1309,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 56 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -1341,7 +1341,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 connection default; @@ -1359,7 +1359,7 @@ 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/io/table/sql/handler 24 user1 localhost wait/lock/table/sql/handler 32 user2 localhost wait/io/table/sql/handler 0 user2 localhost wait/lock/table/sql/handler 0 @@ -1369,7 +1369,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -1379,31 +1379,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 56 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -1411,7 +1411,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 truncate performance_schema.events_waits_summary_by_account_by_event_name; @@ -1438,7 +1438,7 @@ 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 23 +user1 wait/io/table/sql/handler 24 user1 wait/lock/table/sql/handler 32 user2 wait/io/table/sql/handler 0 user2 wait/lock/table/sql/handler 0 @@ -1448,31 +1448,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 56 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -1480,7 +1480,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 truncate performance_schema.events_waits_summary_by_user_by_event_name; @@ -1517,31 +1517,31 @@ 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 71 +localhost wait/io/table/sql/handler 72 localhost wait/lock/table/sql/handler 56 execute dump_waits_global; event_name count_star -wait/io/table/sql/handler 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -1549,7 +1549,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 truncate performance_schema.events_waits_summary_by_host_by_event_name; @@ -1590,27 +1590,27 @@ 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 71 +wait/io/table/sql/handler 72 wait/lock/table/sql/handler 56 execute dump_waits_history; event_name count(event_name) object_type object_schema object_name -wait/io/table/sql/handler 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 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 17 11 6 11 2 4 0 +TABLE test t1 NULL 20 13 7 13 2 5 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 t1 PRIMARY 2 1 1 1 0 1 0 TABLE test t3 NULL 44 26 18 26 6 12 0 TABLE test t3 index_b 4 4 0 4 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 21 13 8 13 2 6 0 +TABLE test t1 22 14 8 14 2 6 0 TABLE test t3 50 32 18 32 6 12 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 @@ -1618,7 +1618,7 @@ TABLE test t1 24 10 14 4 0 0 1 5 0 7 TABLE test t3 32 10 22 4 0 0 1 5 0 11 execute dump_objects_summary; object_type object_schema object_name count_star -TABLE test t1 45 +TABLE test t1 46 TABLE test t2 0 TABLE test t3 82 truncate performance_schema.events_waits_summary_global_by_event_name; @@ -1663,7 +1663,7 @@ 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 21 TABLE test t1 +wait/io/table/sql/handler 22 TABLE test t1 wait/lock/table/sql/handler 24 TABLE test t1 wait/io/table/sql/handler 50 TABLE test t3 wait/lock/table/sql/handler 32 TABLE test t3 |