diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_io_aggregate_global_2u_3t.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/table_io_aggregate_global_2u_3t.result | 190 |
1 files changed, 95 insertions, 95 deletions
diff --git a/mysql-test/suite/perfschema/r/table_io_aggregate_global_2u_3t.result b/mysql-test/suite/perfschema/r/table_io_aggregate_global_2u_3t.result index 6df4cad7899..5a261869ba0 100644 --- a/mysql-test/suite/perfschema/r/table_io_aggregate_global_2u_3t.result +++ b/mysql-test/suite/perfschema/r/table_io_aggregate_global_2u_3t.result @@ -211,16 +211,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 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; @@ -273,16 +273,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 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, , ; @@ -341,16 +341,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 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; @@ -444,16 +444,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 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, , ; @@ -517,16 +517,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 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; @@ -632,16 +632,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 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, , ; @@ -710,16 +710,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 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; @@ -837,16 +837,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 @@ -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; @@ -916,16 +916,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 @@ -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; @@ -992,16 +992,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 @@ -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; @@ -1068,16 +1068,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 @@ -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; @@ -1141,16 +1141,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 @@ -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; @@ -1213,16 +1213,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 @@ -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; @@ -1284,16 +1284,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 @@ -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; @@ -1354,16 +1354,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 @@ -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; @@ -1426,16 +1426,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 @@ -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; @@ -1497,16 +1497,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 @@ -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; @@ -1568,16 +1568,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 @@ -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; |