summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r/table_aggregate_hist_2u_3t.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_aggregate_hist_2u_3t.result')
-rw-r--r--mysql-test/suite/perfschema/r/table_aggregate_hist_2u_3t.result354
1 files changed, 177 insertions, 177 deletions
diff --git a/mysql-test/suite/perfschema/r/table_aggregate_hist_2u_3t.result b/mysql-test/suite/perfschema/r/table_aggregate_hist_2u_3t.result
index b0ea06f4254..6aa67f54b6a 100644
--- a/mysql-test/suite/perfschema/r/table_aggregate_hist_2u_3t.result
+++ b/mysql-test/suite/perfschema/r/table_aggregate_hist_2u_3t.result
@@ -185,7 +185,7 @@ connection default;
"================== Step 3-A =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
username status
user2 not found
@@ -195,23 +195,23 @@ username status
user4 not found
execute dump_waits_account;
user host event_name count_star
-user1 localhost wait/io/table/sql/handler 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 36
execute dump_waits_user;
user event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 33
+localhost wait/io/table/sql/handler 34
localhost wait/lock/table/sql/handler 36
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 33
+wait/io/table/sql/handler 34
wait/lock/table/sql/handler 36
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 10 TABLE test t2
wait/lock/table/sql/handler 12 TABLE test t2
@@ -219,10 +219,10 @@ 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 t2 NULL 9 5 4 5 2 2 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -233,7 +233,7 @@ 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 t2 10 6 4 6 2 2 0
TABLE test t3 15 9 6 9 3 3 0
execute dump_waits_table_lock;
@@ -243,7 +243,7 @@ TABLE test t2 12 4 8 2 0 0 0 2 0 4
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 22
TABLE test t3 29
connection con1;
@@ -253,7 +253,7 @@ connection default;
"================== Step 3-B =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
username status
user2 not found
@@ -263,23 +263,23 @@ username status
user4 not found
execute dump_waits_account;
user host event_name count_star
-user1 localhost wait/io/table/sql/handler 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 36
execute dump_waits_user;
user event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 33
+localhost wait/io/table/sql/handler 34
localhost wait/lock/table/sql/handler 36
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 33
+wait/io/table/sql/handler 34
wait/lock/table/sql/handler 36
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 10 TABLE test t2
wait/lock/table/sql/handler 12 TABLE test t2
@@ -287,10 +287,10 @@ 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 t2 NULL 9 5 4 5 2 2 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -301,7 +301,7 @@ 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 t2 10 6 4 6 2 2 0
TABLE test t3 15 9 6 9 3 3 0
execute dump_waits_table_lock;
@@ -311,7 +311,7 @@ TABLE test t2 12 4 8 2 0 0 0 2 0 4
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 22
TABLE test t3 29
connect con2, localhost, user2, , ;
@@ -322,7 +322,7 @@ connection default;
"================== Step 4 =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -333,27 +333,27 @@ username status
user4 not found
execute dump_waits_account;
user host event_name count_star
-user1 localhost wait/io/table/sql/handler 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 36
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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
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 33
+localhost wait/io/table/sql/handler 34
localhost wait/lock/table/sql/handler 36
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 33
+wait/io/table/sql/handler 34
wait/lock/table/sql/handler 36
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 10 TABLE test t2
wait/lock/table/sql/handler 12 TABLE test t2
@@ -361,10 +361,10 @@ 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 t2 NULL 9 5 4 5 2 2 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -375,7 +375,7 @@ 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 t2 10 6 4 6 2 2 0
TABLE test t3 15 9 6 9 3 3 0
execute dump_waits_table_lock;
@@ -385,7 +385,7 @@ TABLE test t2 12 4 8 2 0 0 0 2 0 4
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 22
TABLE test t3 29
connection con2;
@@ -431,7 +431,7 @@ connection default;
"================== Step 5 =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -442,27 +442,27 @@ username status
user4 not found
execute dump_waits_account;
user host event_name count_star
-user1 localhost wait/io/table/sql/handler 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 36
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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
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 33
+localhost wait/io/table/sql/handler 34
localhost wait/lock/table/sql/handler 36
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 33
+wait/io/table/sql/handler 34
wait/lock/table/sql/handler 36
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 10 TABLE test t2
wait/lock/table/sql/handler 12 TABLE test t2
@@ -470,10 +470,10 @@ 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 t2 NULL 9 5 4 5 2 2 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -484,7 +484,7 @@ 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 t2 10 6 4 6 2 2 0
TABLE test t3 15 9 6 9 3 3 0
execute dump_waits_table_lock;
@@ -494,7 +494,7 @@ TABLE test t2 12 4 8 2 0 0 0 2 0 4
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 22
TABLE test t3 29
connect con3, localhost, user3, , ;
@@ -505,7 +505,7 @@ connection default;
"================== Step 6 =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -517,7 +517,7 @@ username status
user4 not found
execute dump_waits_account;
user host event_name count_star
-user1 localhost wait/io/table/sql/handler 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 36
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -525,7 +525,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -533,15 +533,15 @@ 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 33
+localhost wait/io/table/sql/handler 34
localhost wait/lock/table/sql/handler 36
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 33
+wait/io/table/sql/handler 34
wait/lock/table/sql/handler 36
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 10 TABLE test t2
wait/lock/table/sql/handler 12 TABLE test t2
@@ -549,10 +549,10 @@ 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 t2 NULL 9 5 4 5 2 2 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -563,7 +563,7 @@ 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 t2 10 6 4 6 2 2 0
TABLE test t3 15 9 6 9 3 3 0
execute dump_waits_table_lock;
@@ -573,7 +573,7 @@ TABLE test t2 12 4 8 2 0 0 0 2 0 4
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 22
TABLE test t3 29
connection con3;
@@ -626,7 +626,7 @@ connection default;
"================== Step 7 =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -638,7 +638,7 @@ username status
user4 not found
execute dump_waits_account;
user host event_name count_star
-user1 localhost wait/io/table/sql/handler 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 36
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -646,7 +646,7 @@ user3 localhost wait/io/table/sql/handler 70
user3 localhost wait/lock/table/sql/handler 36
execute dump_waits_user;
user event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -654,15 +654,15 @@ user3 wait/io/table/sql/handler 70
user3 wait/lock/table/sql/handler 36
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 72
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 72
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 32 TABLE test t2
wait/lock/table/sql/handler 24 TABLE test t2
@@ -670,10 +670,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -684,7 +684,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -694,7 +694,7 @@ TABLE test t2 24 8 16 4 0 0 0 4 0 8
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 56
TABLE test t3 78
connect con4, localhost, user4, , ;
@@ -705,7 +705,7 @@ connection default;
"================== Step 8 =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -718,7 +718,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 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 36
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -728,7 +728,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -738,15 +738,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 72
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 72
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 32 TABLE test t2
wait/lock/table/sql/handler 24 TABLE test t2
@@ -754,10 +754,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -768,7 +768,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -778,7 +778,7 @@ TABLE test t2 24 8 16 4 0 0 0 4 0 8
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 56
TABLE test t3 78
connection con4;
@@ -838,7 +838,7 @@ connection default;
"================== Step 9 =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -851,7 +851,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 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 36
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -861,7 +861,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 36
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -871,15 +871,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 72
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 72
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 32 TABLE test t2
wait/lock/table/sql/handler 24 TABLE test t2
@@ -887,10 +887,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -901,7 +901,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -911,7 +911,7 @@ TABLE test t2 24 8 16 4 0 0 0 4 0 8
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 56
TABLE test t3 78
connection con1;
@@ -923,7 +923,7 @@ connection default;
"================== Step 10 =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -936,7 +936,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 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 48
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -946,7 +946,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -956,15 +956,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 84
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -972,10 +972,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -986,7 +986,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -996,7 +996,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
connection default;
@@ -1005,7 +1005,7 @@ flush tables;
"================== Step 11 =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -1018,7 +1018,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 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 48
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -1028,7 +1028,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -1038,15 +1038,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 84
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -1054,10 +1054,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -1068,7 +1068,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -1078,7 +1078,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
set global read_only=1;
@@ -1087,7 +1087,7 @@ set global read_only=0;
"================== Step 12 =================="
call dump_thread();
username event_name count_star
-user1 wait/io/table/sql/handler 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -1100,7 +1100,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 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 48
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -1110,7 +1110,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -1120,15 +1120,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 84
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -1136,10 +1136,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -1150,7 +1150,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -1160,7 +1160,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
disconnect con1;
@@ -1179,7 +1179,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 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 48
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -1189,7 +1189,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -1199,15 +1199,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 84
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -1215,10 +1215,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -1229,7 +1229,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -1239,7 +1239,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
disconnect con2;
@@ -1257,7 +1257,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 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 48
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -1267,7 +1267,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -1277,15 +1277,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 84
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -1293,10 +1293,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -1307,7 +1307,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -1317,7 +1317,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
disconnect con3;
@@ -1334,7 +1334,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 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 48
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -1344,7 +1344,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -1354,15 +1354,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 84
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -1370,10 +1370,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -1384,7 +1384,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -1394,7 +1394,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
disconnect con4;
@@ -1410,7 +1410,7 @@ username status
user4 not found
execute dump_waits_account;
user host event_name count_star
-user1 localhost wait/io/table/sql/handler 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 48
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -1420,7 +1420,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -1430,15 +1430,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 84
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -1446,10 +1446,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -1460,7 +1460,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -1470,7 +1470,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
connection default;
@@ -1488,7 +1488,7 @@ username status
user4 not found
execute dump_waits_account;
user host event_name count_star
-user1 localhost wait/io/table/sql/handler 33
+user1 localhost wait/io/table/sql/handler 34
user1 localhost wait/lock/table/sql/handler 48
user2 localhost wait/io/table/sql/handler 0
user2 localhost wait/lock/table/sql/handler 0
@@ -1498,7 +1498,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -1508,15 +1508,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 84
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -1524,10 +1524,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -1538,7 +1538,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -1548,7 +1548,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
truncate performance_schema.events_waits_summary_by_account_by_event_name;
@@ -1575,7 +1575,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 33
+user1 wait/io/table/sql/handler 34
user1 wait/lock/table/sql/handler 48
user2 wait/io/table/sql/handler 0
user2 wait/lock/table/sql/handler 0
@@ -1585,15 +1585,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 84
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -1601,10 +1601,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -1615,7 +1615,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -1625,7 +1625,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
truncate performance_schema.events_waits_summary_by_user_by_event_name;
@@ -1662,15 +1662,15 @@ 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 103
+localhost wait/io/table/sql/handler 104
localhost wait/lock/table/sql/handler 84
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -1678,10 +1678,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -1692,7 +1692,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -1702,7 +1702,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
truncate performance_schema.events_waits_summary_by_host_by_event_name;
@@ -1743,11 +1743,11 @@ 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 103
+wait/io/table/sql/handler 104
wait/lock/table/sql/handler 84
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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
@@ -1755,10 +1755,10 @@ 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 t2 NULL 30 18 12 18 4 8 0
TABLE test t2 index_b 0 0 0 0 0 0 0
TABLE test t2 index_cb 0 0 0 0 0 0 0
@@ -1769,7 +1769,7 @@ 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 t2 32 20 12 20 4 8 0
TABLE test t3 50 32 18 32 6 12 0
execute dump_waits_table_lock;
@@ -1779,7 +1779,7 @@ TABLE test t2 28 10 18 4 0 0 1 5 0 9
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 60
TABLE test t3 82
truncate performance_schema.events_waits_summary_global_by_event_name;
@@ -1824,7 +1824,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 32 TABLE test t2
wait/lock/table/sql/handler 28 TABLE test t2
View Lorry Controller Status