summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r/table_io_aggregate_hist_4u_2t.result
diff options
context:
space:
mode:
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.result354
1 files changed, 177 insertions, 177 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 a19d3798e8b..e8b5fdaba5b 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
@@ -178,7 +178,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 0
username status
user2 not found
@@ -188,37 +188,37 @@ 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 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 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 0
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 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 9 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 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 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 t1 9
TABLE test t2 0
TABLE test t3 15
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 0
username status
user2 not found
@@ -246,37 +246,37 @@ 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 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 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 0
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 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 9 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 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
@@ -284,7 +284,7 @@ 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 t1 9
TABLE test t2 0
TABLE test t3 15
connect con2, localhost, user2, , ;
@@ -295,7 +295,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 0
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -306,41 +306,41 @@ 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 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 23
+user1 wait/io/table/sql/handler 24
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 23
+localhost wait/io/table/sql/handler 24
localhost wait/lock/table/sql/handler 0
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 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 9 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 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
@@ -348,7 +348,7 @@ 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 t1 9
TABLE test t2 0
TABLE test t3 15
connection con2;
@@ -394,7 +394,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 0
username event_name count_star
user2 wait/io/table/sql/handler 35
@@ -405,41 +405,41 @@ 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 0
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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
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 58
+localhost wait/io/table/sql/handler 59
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 58
+wait/io/table/sql/handler 59
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 18 TABLE test t1
+wait/io/table/sql/handler 19 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 14 9 5 9 2 3 0
+TABLE test t1 NULL 17 11 6 11 2 4 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 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 18 11 7 11 2 5 0
+TABLE test t1 19 12 7 12 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_low_priority count_write_external
@@ -447,7 +447,7 @@ 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 18
+TABLE test t1 19
TABLE test t2 0
TABLE test t3 40
connect con3, localhost, user3, , ;
@@ -458,7 +458,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 0
username event_name count_star
user2 wait/io/table/sql/handler 35
@@ -470,7 +470,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 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -478,7 +478,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 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -486,29 +486,29 @@ 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 58
+localhost wait/io/table/sql/handler 59
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 58
+wait/io/table/sql/handler 59
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 18 TABLE test t1
+wait/io/table/sql/handler 19 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 14 9 5 9 2 3 0
+TABLE test t1 NULL 17 11 6 11 2 4 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 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 18 11 7 11 2 5 0
+TABLE test t1 19 12 7 12 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_low_priority count_write_external
@@ -516,7 +516,7 @@ 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 18
+TABLE test t1 19
TABLE test t2 0
TABLE test t3 40
connection con3;
@@ -569,7 +569,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 0
username event_name count_star
user2 wait/io/table/sql/handler 35
@@ -581,7 +581,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 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -589,7 +589,7 @@ 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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -597,29 +597,29 @@ 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 106
+localhost wait/io/table/sql/handler 107
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 106
+wait/io/table/sql/handler 107
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 31 TABLE test t1
+wait/io/table/sql/handler 32 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 25 16 9 16 3 6 0
+TABLE test t1 NULL 28 18 10 18 3 7 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 t1 PRIMARY 4 2 2 2 0 2 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 31 19 12 19 3 9 0
+TABLE test t1 32 20 12 20 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_low_priority count_write_external
@@ -627,7 +627,7 @@ 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 31
+TABLE test t1 32
TABLE test t2 0
TABLE test t3 75
connect con4, localhost, user4, , ;
@@ -638,7 +638,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 0
username event_name count_star
user2 wait/io/table/sql/handler 35
@@ -651,7 +651,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 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -661,7 +661,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 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -671,29 +671,29 @@ 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 106
+localhost wait/io/table/sql/handler 107
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 106
+wait/io/table/sql/handler 107
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 31 TABLE test t1
+wait/io/table/sql/handler 32 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 25 16 9 16 3 6 0
+TABLE test t1 NULL 28 18 10 18 3 7 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 t1 PRIMARY 4 2 2 2 0 2 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 31 19 12 19 3 9 0
+TABLE test t1 32 20 12 20 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_low_priority count_write_external
@@ -701,7 +701,7 @@ 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 31
+TABLE test t1 32
TABLE test t2 0
TABLE test t3 75
connection con4;
@@ -761,7 +761,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 0
username event_name count_star
user2 wait/io/table/sql/handler 35
@@ -774,7 +774,7 @@ 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 23
+user1 localhost wait/io/table/sql/handler 24
user1 localhost wait/lock/table/sql/handler 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -784,7 +784,7 @@ 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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -794,29 +794,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -824,7 +824,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
connection con1;
@@ -836,7 +836,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 0
username event_name count_star
user2 wait/io/table/sql/handler 35
@@ -849,7 +849,7 @@ 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 23
+user1 localhost wait/io/table/sql/handler 24
user1 localhost wait/lock/table/sql/handler 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -859,7 +859,7 @@ 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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -869,29 +869,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -899,7 +899,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
connection default;
@@ -908,7 +908,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 0
username event_name count_star
user2 wait/io/table/sql/handler 35
@@ -921,7 +921,7 @@ 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 23
+user1 localhost wait/io/table/sql/handler 24
user1 localhost wait/lock/table/sql/handler 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -931,7 +931,7 @@ 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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -941,29 +941,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -971,7 +971,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
set global read_only=1;
@@ -980,7 +980,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 0
username event_name count_star
user2 wait/io/table/sql/handler 35
@@ -993,7 +993,7 @@ 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 23
+user1 localhost wait/io/table/sql/handler 24
user1 localhost wait/lock/table/sql/handler 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -1003,7 +1003,7 @@ 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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -1013,29 +1013,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -1043,7 +1043,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
disconnect con1;
@@ -1062,7 +1062,7 @@ 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 23
+user1 localhost wait/io/table/sql/handler 24
user1 localhost wait/lock/table/sql/handler 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -1072,7 +1072,7 @@ 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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -1082,29 +1082,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -1112,7 +1112,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
disconnect con2;
@@ -1130,7 +1130,7 @@ 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 23
+user1 localhost wait/io/table/sql/handler 24
user1 localhost wait/lock/table/sql/handler 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -1140,7 +1140,7 @@ 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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -1150,29 +1150,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -1180,7 +1180,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
disconnect con3;
@@ -1197,7 +1197,7 @@ 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 23
+user1 localhost wait/io/table/sql/handler 24
user1 localhost wait/lock/table/sql/handler 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -1207,7 +1207,7 @@ 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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -1217,29 +1217,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -1247,7 +1247,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
disconnect con4;
@@ -1263,7 +1263,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 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -1273,7 +1273,7 @@ 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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -1283,29 +1283,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -1313,7 +1313,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
connection default;
@@ -1331,7 +1331,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 0
user2 localhost wait/io/table/sql/handler 35
user2 localhost wait/lock/table/sql/handler 0
@@ -1341,7 +1341,7 @@ 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 23
+user1 wait/io/table/sql/handler 24
user1 wait/lock/table/sql/handler 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -1351,29 +1351,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -1381,7 +1381,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
truncate performance_schema.events_waits_summary_by_account_by_event_name;
@@ -1408,7 +1408,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 0
user2 wait/io/table/sql/handler 35
user2 wait/lock/table/sql/handler 0
@@ -1418,29 +1418,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -1448,7 +1448,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
truncate performance_schema.events_waits_summary_by_user_by_event_name;
@@ -1485,29 +1485,29 @@ 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 167
+localhost wait/io/table/sql/handler 168
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -1515,7 +1515,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
truncate performance_schema.events_waits_summary_by_host_by_event_name;
@@ -1556,25 +1556,25 @@ 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 167
+wait/io/table/sql/handler 168
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 47 TABLE test t1
+wait/io/table/sql/handler 48 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 39 25 14 25 4 10 0
+TABLE test t1 NULL 42 27 15 27 4 11 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 t1 PRIMARY 6 3 3 3 0 3 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 47 29 18 29 4 14 0
+TABLE test t1 48 30 18 30 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_low_priority count_write_external
@@ -1582,7 +1582,7 @@ 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 47
+TABLE test t1 48
TABLE test t2 0
TABLE test t3 120
truncate performance_schema.events_waits_summary_global_by_event_name;
@@ -1627,7 +1627,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 47 TABLE test t1
+wait/io/table/sql/handler 48 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
View Lorry Controller Status