summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r/table_io_aggregate_thread_4u_3t.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_io_aggregate_thread_4u_3t.result')
-rw-r--r--mysql-test/suite/perfschema/r/table_io_aggregate_thread_4u_3t.result314
1 files changed, 157 insertions, 157 deletions
diff --git a/mysql-test/suite/perfschema/r/table_io_aggregate_thread_4u_3t.result b/mysql-test/suite/perfschema/r/table_io_aggregate_thread_4u_3t.result
index 7fed2e31955..f80b6da32cc 100644
--- a/mysql-test/suite/perfschema/r/table_io_aggregate_thread_4u_3t.result
+++ b/mysql-test/suite/perfschema/r/table_io_aggregate_thread_4u_3t.result
@@ -189,7 +189,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 0
username status
user2 not found
@@ -199,28 +199,28 @@ 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 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 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 0
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 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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
@@ -231,7 +231,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;
@@ -241,7 +241,7 @@ TABLE test t2 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 10
TABLE test t3 15
connection con1;
@@ -251,7 +251,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 0
username status
user2 not found
@@ -261,28 +261,28 @@ 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 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 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 0
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 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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
@@ -293,7 +293,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;
@@ -303,7 +303,7 @@ TABLE test t2 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 10
TABLE test t3 15
connect con2, localhost, user2, , ;
@@ -314,7 +314,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 0
username event_name count_star
user2 wait/io/table/sql/handler 0
@@ -325,32 +325,32 @@ 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 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 33
+user1 wait/io/table/sql/handler 34
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 33
+localhost wait/io/table/sql/handler 34
localhost wait/lock/table/sql/handler 0
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 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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
@@ -361,7 +361,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;
@@ -371,7 +371,7 @@ TABLE test t2 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 10
TABLE test t3 15
connection con2;
@@ -417,7 +417,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 0
username event_name count_star
user2 wait/io/table/sql/handler 51
@@ -428,32 +428,32 @@ 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 0
user2 localhost wait/io/table/sql/handler 51
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 84
+localhost wait/io/table/sql/handler 85
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 84
+wait/io/table/sql/handler 85
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 24 14 10 14 4 6 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
@@ -464,7 +464,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 18 11 7 11 2 5 0
+TABLE test t1 19 12 7 12 2 5 0
TABLE test t2 26 16 10 16 4 6 0
TABLE test t3 40 25 15 25 6 9 0
execute dump_waits_table_lock;
@@ -474,7 +474,7 @@ TABLE test t2 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 26
TABLE test t3 40
connect con3, localhost, user3, , ;
@@ -485,7 +485,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 0
username event_name count_star
user2 wait/io/table/sql/handler 51
@@ -497,7 +497,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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -505,7 +505,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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -513,20 +513,20 @@ 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 84
+localhost wait/io/table/sql/handler 85
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 84
+wait/io/table/sql/handler 85
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 24 14 10 14 4 6 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
@@ -537,7 +537,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 18 11 7 11 2 5 0
+TABLE test t1 19 12 7 12 2 5 0
TABLE test t2 26 16 10 16 4 6 0
TABLE test t3 40 25 15 25 6 9 0
execute dump_waits_table_lock;
@@ -547,7 +547,7 @@ TABLE test t2 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 26
TABLE test t3 40
connection con3;
@@ -600,7 +600,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 0
username event_name count_star
user2 wait/io/table/sql/handler 51
@@ -612,7 +612,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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -620,7 +620,7 @@ user3 localhost wait/io/table/sql/handler 70
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -628,20 +628,20 @@ user3 wait/io/table/sql/handler 70
user3 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 154
+localhost wait/io/table/sql/handler 155
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 154
+wait/io/table/sql/handler 155
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 45 27 18 27 6 12 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
@@ -652,7 +652,7 @@ 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 t2 48 30 18 30 6 12 0
TABLE test t3 75 48 27 48 9 18 0
execute dump_waits_table_lock;
@@ -662,7 +662,7 @@ TABLE test t2 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 48
TABLE test t3 75
connect con4, localhost, user4, , ;
@@ -673,7 +673,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 0
username event_name count_star
user2 wait/io/table/sql/handler 51
@@ -686,7 +686,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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -696,7 +696,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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -706,20 +706,20 @@ 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 154
+localhost wait/io/table/sql/handler 155
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 154
+wait/io/table/sql/handler 155
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 45 27 18 27 6 12 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
@@ -730,7 +730,7 @@ 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 t2 48 30 18 30 6 12 0
TABLE test t3 75 48 27 48 9 18 0
execute dump_waits_table_lock;
@@ -740,7 +740,7 @@ TABLE test t2 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 48
TABLE test t3 75
connection con4;
@@ -800,7 +800,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 0
username event_name count_star
user2 wait/io/table/sql/handler 51
@@ -813,7 +813,7 @@ user4 wait/io/table/sql/handler 89
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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -823,7 +823,7 @@ user4 localhost wait/io/table/sql/handler 89
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -833,20 +833,20 @@ user4 wait/io/table/sql/handler 89
user4 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -857,7 +857,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -867,7 +867,7 @@ TABLE test t2 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 76
TABLE test t3 120
connection con1;
@@ -879,7 +879,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 0
username event_name count_star
user2 wait/io/table/sql/handler 51
@@ -892,7 +892,7 @@ user4 wait/io/table/sql/handler 89
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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -902,7 +902,7 @@ user4 localhost wait/io/table/sql/handler 89
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -912,20 +912,20 @@ user4 wait/io/table/sql/handler 89
user4 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -936,7 +936,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -946,7 +946,7 @@ TABLE test t2 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 76
TABLE test t3 120
connection default;
@@ -955,7 +955,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 0
username event_name count_star
user2 wait/io/table/sql/handler 51
@@ -968,7 +968,7 @@ user4 wait/io/table/sql/handler 89
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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -978,7 +978,7 @@ user4 localhost wait/io/table/sql/handler 89
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -988,20 +988,20 @@ user4 wait/io/table/sql/handler 89
user4 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -1012,7 +1012,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -1022,7 +1022,7 @@ TABLE test t2 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 76
TABLE test t3 120
set global read_only=1;
@@ -1031,7 +1031,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 0
username event_name count_star
user2 wait/io/table/sql/handler 51
@@ -1044,7 +1044,7 @@ user4 wait/io/table/sql/handler 89
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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -1054,7 +1054,7 @@ user4 localhost wait/io/table/sql/handler 89
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -1064,20 +1064,20 @@ user4 wait/io/table/sql/handler 89
user4 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -1088,7 +1088,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -1098,7 +1098,7 @@ TABLE test t2 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 76
TABLE test t3 120
disconnect con1;
@@ -1117,7 +1117,7 @@ user4 wait/io/table/sql/handler 89
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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -1127,7 +1127,7 @@ user4 localhost wait/io/table/sql/handler 89
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -1137,20 +1137,20 @@ user4 wait/io/table/sql/handler 89
user4 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -1161,7 +1161,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -1171,7 +1171,7 @@ TABLE test t2 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 76
TABLE test t3 120
disconnect con2;
@@ -1189,7 +1189,7 @@ user4 wait/io/table/sql/handler 89
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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -1199,7 +1199,7 @@ user4 localhost wait/io/table/sql/handler 89
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -1209,20 +1209,20 @@ user4 wait/io/table/sql/handler 89
user4 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -1233,7 +1233,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -1243,7 +1243,7 @@ TABLE test t2 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 76
TABLE test t3 120
disconnect con3;
@@ -1260,7 +1260,7 @@ user4 wait/io/table/sql/handler 89
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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -1270,7 +1270,7 @@ user4 localhost wait/io/table/sql/handler 89
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -1280,20 +1280,20 @@ user4 wait/io/table/sql/handler 89
user4 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -1304,7 +1304,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -1314,7 +1314,7 @@ TABLE test t2 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 76
TABLE test t3 120
disconnect con4;
@@ -1330,7 +1330,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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -1340,7 +1340,7 @@ user4 localhost wait/io/table/sql/handler 89
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -1350,20 +1350,20 @@ user4 wait/io/table/sql/handler 89
user4 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -1374,7 +1374,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -1384,7 +1384,7 @@ TABLE test t2 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 76
TABLE test t3 120
connection default;
@@ -1402,7 +1402,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 0
user2 localhost wait/io/table/sql/handler 51
user2 localhost wait/lock/table/sql/handler 0
@@ -1412,7 +1412,7 @@ user4 localhost wait/io/table/sql/handler 89
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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -1422,20 +1422,20 @@ user4 wait/io/table/sql/handler 89
user4 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -1446,7 +1446,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -1456,7 +1456,7 @@ TABLE test t2 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 76
TABLE test t3 120
truncate performance_schema.events_waits_summary_by_account_by_event_name;
@@ -1483,7 +1483,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 0
user2 wait/io/table/sql/handler 51
user2 wait/lock/table/sql/handler 0
@@ -1493,20 +1493,20 @@ user4 wait/io/table/sql/handler 89
user4 wait/lock/table/sql/handler 0
execute dump_waits_host;
host event_name count_star
-localhost wait/io/table/sql/handler 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -1517,7 +1517,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -1527,7 +1527,7 @@ TABLE test t2 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 76
TABLE test t3 120
truncate performance_schema.events_waits_summary_by_user_by_event_name;
@@ -1564,20 +1564,20 @@ 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 243
+localhost wait/io/table/sql/handler 244
localhost wait/lock/table/sql/handler 0
execute dump_waits_global;
event_name count_star
-wait/io/table/sql/handler 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -1588,7 +1588,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -1598,7 +1598,7 @@ TABLE test t2 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 76
TABLE test t3 120
truncate performance_schema.events_waits_summary_by_host_by_event_name;
@@ -1639,16 +1639,16 @@ 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 243
+wait/io/table/sql/handler 244
wait/lock/table/sql/handler 0
execute dump_waits_history;
event_name count(event_name) object_type object_schema object_name
execute dump_waits_index_io;
object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
-TABLE test t1 NULL 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 t2 NULL 72 44 28 44 8 20 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
@@ -1659,7 +1659,7 @@ 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 t2 76 48 28 48 8 20 0
TABLE test t3 120 78 42 78 12 30 0
execute dump_waits_table_lock;
@@ -1669,7 +1669,7 @@ TABLE test t2 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 76
TABLE test t3 120
truncate performance_schema.events_waits_summary_global_by_event_name;
View Lorry Controller Status