diff options
author | Sergei Golubchik <sergii@pisem.net> | 2014-05-06 23:20:50 +0200 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2014-05-06 23:20:50 +0200 |
commit | d74414399d8a5a944b47eff95e0796c56c3428a3 (patch) | |
tree | 7daccc9917352d383662de6d3af4b456bb341a50 /mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_3t.result | |
download | mariadb-git-d74414399d8a5a944b47eff95e0796c56c3428a3.tar.gz |
perfschema 5.6.10 initial commit.
10.0 files
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_3t.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_3t.result | 1809 |
1 files changed, 1809 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_3t.result b/mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_3t.result new file mode 100644 index 00000000000..69a2cb891e7 --- /dev/null +++ b/mysql-test/suite/perfschema/r/table_io_aggregate_hist_2u_3t.result @@ -0,0 +1,1809 @@ +update performance_schema.setup_instruments +set enabled='NO' where name='wait/lock/table/sql/handler'; +delete from performance_schema.setup_actors +where user in ('user2', 'user4'); +select * from performance_schema.setup_actors +order by USER, HOST, ROLE; +HOST USER ROLE +localhost user1 % +localhost user3 % +select * from performance_schema.setup_objects +order by object_type, object_schema, object_name; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +TABLE test t1 YES YES +TABLE test t2 YES NO +TABLE test t3 YES NO +select * from performance_schema.setup_consumers; +NAME ENABLED +events_stages_current YES +events_stages_history YES +events_stages_history_long YES +events_statements_current YES +events_statements_history YES +events_statements_history_long YES +events_waits_current YES +events_waits_history YES +events_waits_history_long YES +global_instrumentation YES +thread_instrumentation YES +statements_digest YES +flush tables; +truncate performance_schema.objects_summary_global_by_type; +truncate performance_schema.table_io_waits_summary_by_index_usage; +truncate performance_schema.table_io_waits_summary_by_table; +truncate performance_schema.table_lock_waits_summary_by_table; +truncate performance_schema.events_waits_summary_by_thread_by_event_name; +truncate performance_schema.events_waits_summary_by_account_by_event_name; +truncate performance_schema.events_waits_summary_by_user_by_event_name; +truncate performance_schema.events_waits_summary_by_host_by_event_name; +truncate performance_schema.events_waits_summary_global_by_event_name; +truncate performance_schema.events_waits_history_long; +show variables like "performance_schema%"; +Variable_name Value +performance_schema ON +performance_schema_accounts_size 100 +performance_schema_digests_size 200 +performance_schema_events_stages_history_long_size 1000 +performance_schema_events_stages_history_size 10 +performance_schema_events_statements_history_long_size 1000 +performance_schema_events_statements_history_size 10 +performance_schema_events_waits_history_long_size 10000 +performance_schema_events_waits_history_size 10 +performance_schema_hosts_size 100 +performance_schema_max_cond_classes 80 +performance_schema_max_cond_instances 1000 +performance_schema_max_file_classes 50 +performance_schema_max_file_handles 32768 +performance_schema_max_file_instances 10000 +performance_schema_max_mutex_classes 200 +performance_schema_max_mutex_instances 5000 +performance_schema_max_rwlock_classes 30 +performance_schema_max_rwlock_instances 5000 +performance_schema_max_socket_classes 10 +performance_schema_max_socket_instances 1000 +performance_schema_max_stage_classes 150 +performance_schema_max_statement_classes 167 +performance_schema_max_table_handles 1000 +performance_schema_max_table_instances 500 +performance_schema_max_thread_classes 50 +performance_schema_max_thread_instances 200 +performance_schema_session_connect_attrs_size 2048 +performance_schema_setup_actors_size 100 +performance_schema_setup_objects_size 100 +performance_schema_users_size 100 +show status like "performance_schema%"; +Variable_name Value +Performance_schema_accounts_lost 0 +Performance_schema_cond_classes_lost 0 +Performance_schema_cond_instances_lost 0 +Performance_schema_digest_lost 0 +Performance_schema_file_classes_lost 0 +Performance_schema_file_handles_lost 0 +Performance_schema_file_instances_lost 0 +Performance_schema_hosts_lost 0 +Performance_schema_locker_lost 0 +Performance_schema_mutex_classes_lost 0 +Performance_schema_mutex_instances_lost 0 +Performance_schema_rwlock_classes_lost 0 +Performance_schema_rwlock_instances_lost 0 +Performance_schema_session_connect_attrs_lost 0 +Performance_schema_socket_classes_lost 0 +Performance_schema_socket_instances_lost 0 +Performance_schema_stage_classes_lost 0 +Performance_schema_statement_classes_lost 0 +Performance_schema_table_handles_lost 0 +Performance_schema_table_instances_lost 0 +Performance_schema_thread_classes_lost 0 +Performance_schema_thread_instances_lost 0 +Performance_schema_users_lost 0 +"================== Step 1 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +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 0 +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 0 0 0 0 0 0 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 0 0 0 0 0 0 0 +TABLE test t2 NULL 0 0 0 0 0 0 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 +TABLE test t2 PRIMARY 0 0 0 0 0 0 0 +TABLE test t3 NULL 0 0 0 0 0 0 0 +TABLE test t3 index_b 0 0 0 0 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 0 0 0 0 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 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 0 +TABLE test t2 0 +TABLE test t3 0 +select concat(current_user(), " is connected") as status; +status +user1@localhost is connected +"================== Step 2 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 0 +user1 wait/lock/table/sql/handler 0 +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 0 +user1 localhost wait/lock/table/sql/handler 0 +execute dump_waits_user; +user event_name count_star +user1 wait/io/table/sql/handler 0 +user1 wait/lock/table/sql/handler 0 +execute dump_waits_host; +host event_name count_star +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 0 +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 0 0 0 0 0 0 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 0 0 0 0 0 0 0 +TABLE test t2 NULL 0 0 0 0 0 0 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 +TABLE test t2 PRIMARY 0 0 0 0 0 0 0 +TABLE test t3 NULL 0 0 0 0 0 0 0 +TABLE test t3 index_b 0 0 0 0 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 0 0 0 0 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 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 0 +TABLE test t2 0 +TABLE test t3 0 +insert into test.t1 set a=101, b=1, c=1; +insert into test.t2 set a=102, b=2, c=2; +insert into test.t2 set a=103, b=3, c=3; +insert into test.t3 set a=104, b=4, c=4; +insert into test.t3 set a=105, b=5, c=5; +insert into test.t3 set a=106, b=6, c=6; +select * from test.t1; +a b c d +101 1 1 0 +select * from test.t2; +a b c d +102 2 2 0 +103 3 3 0 +select * from test.t3; +a b c d +104 4 4 0 +105 5 5 0 +106 6 6 0 +update test.t1 set d=d+1; +update test.t2 set d=d+1; +update test.t3 set d=d+1; +update test.t1 set d=d+1 where a=101; +update test.t2 set d=d+1 where a=101; +update test.t3 set d=d+1 where a=101; +select * from test.t1 where b=5; +a b c d +select * from test.t2 where b=5; +a b c d +select * from test.t3 where b=5; +a b c d +105 5 5 1 +"================== con1 marker ==================" +"================== Step 3 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 35 +user1 localhost wait/lock/table/sql/handler 0 +execute dump_waits_user; +user event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +execute dump_waits_host; +host event_name count_star +localhost wait/io/table/sql/handler 35 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 35 +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 6 TABLE test t1 +wait/io/table/sql/handler 12 TABLE test t2 +wait/io/table/sql/handler 17 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 4 2 2 2 1 1 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 t2 NULL 10 6 4 6 2 2 0 +TABLE test t2 index_b 1 1 0 1 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 1 1 0 1 0 0 0 +TABLE test t3 NULL 14 8 6 8 3 3 0 +TABLE test t3 index_b 2 2 0 2 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 1 1 0 1 0 0 0 +execute dump_waits_table_io; +object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete +TABLE test t1 6 3 3 3 1 2 0 +TABLE test t2 12 8 4 8 2 2 0 +TABLE test t3 17 11 6 11 3 3 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 6 +TABLE test t2 12 +TABLE test t3 17 +select concat(current_user(), " is connected") as status; +status +user2@localhost is connected +"================== Step 4 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +username event_name count_star +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 35 +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 35 +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 35 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 35 +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 6 TABLE test t1 +wait/io/table/sql/handler 12 TABLE test t2 +wait/io/table/sql/handler 17 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 4 2 2 2 1 1 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 t2 NULL 10 6 4 6 2 2 0 +TABLE test t2 index_b 1 1 0 1 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 1 1 0 1 0 0 0 +TABLE test t3 NULL 14 8 6 8 3 3 0 +TABLE test t3 index_b 2 2 0 2 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 1 1 0 1 0 0 0 +execute dump_waits_table_io; +object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete +TABLE test t1 6 3 3 3 1 2 0 +TABLE test t2 12 8 4 8 2 2 0 +TABLE test t3 17 11 6 11 3 3 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 6 +TABLE test t2 12 +TABLE test t3 17 +insert into test.t1 set a=201, b=1, c=1; +insert into test.t2 set a=202, b=2, c=2; +insert into test.t2 set a=203, b=3, c=3; +insert into test.t3 set a=204, b=4, c=4; +insert into test.t3 set a=205, b=5, c=5; +insert into test.t3 set a=206, b=6, c=6; +select * from test.t1; +a b c d +101 1 1 2 +201 1 1 0 +select * from test.t2; +a b c d +102 2 2 1 +103 3 3 1 +202 2 2 0 +203 3 3 0 +select * from test.t3; +a b c d +104 4 4 1 +105 5 5 1 +106 6 6 1 +204 4 4 0 +205 5 5 0 +206 6 6 0 +update test.t1 set d=d+1; +update test.t2 set d=d+1; +update test.t3 set d=d+1; +update test.t1 set d=d+1 where a=201; +update test.t2 set d=d+1 where a=201; +update test.t3 set d=d+1 where a=201; +select * from test.t1 where b=5; +a b c d +select * from test.t2 where b=5; +a b c d +select * from test.t3 where b=5; +a b c d +105 5 5 2 +205 5 5 1 +"================== con2 marker ==================" +"================== Step 5 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +username event_name count_star +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 35 +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 35 +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 35 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 35 +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 6 TABLE test t1 +wait/io/table/sql/handler 12 TABLE test t2 +wait/io/table/sql/handler 17 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 4 2 2 2 1 1 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 t2 NULL 10 6 4 6 2 2 0 +TABLE test t2 index_b 1 1 0 1 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 1 1 0 1 0 0 0 +TABLE test t3 NULL 14 8 6 8 3 3 0 +TABLE test t3 index_b 2 2 0 2 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 1 1 0 1 0 0 0 +execute dump_waits_table_io; +object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete +TABLE test t1 6 3 3 3 1 2 0 +TABLE test t2 12 8 4 8 2 2 0 +TABLE test t3 17 11 6 11 3 3 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 6 +TABLE test t2 12 +TABLE test t3 17 +select concat(current_user(), " is connected") as status; +status +user3@localhost is connected +"================== Step 6 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +username event_name count_star +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +username event_name count_star +user3 wait/io/table/sql/handler 0 +user3 wait/lock/table/sql/handler 0 +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +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 35 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 35 +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 6 TABLE test t1 +wait/io/table/sql/handler 12 TABLE test t2 +wait/io/table/sql/handler 17 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 4 2 2 2 1 1 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 t2 NULL 10 6 4 6 2 2 0 +TABLE test t2 index_b 1 1 0 1 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 1 1 0 1 0 0 0 +TABLE test t3 NULL 14 8 6 8 3 3 0 +TABLE test t3 index_b 2 2 0 2 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 1 1 0 1 0 0 0 +execute dump_waits_table_io; +object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete +TABLE test t1 6 3 3 3 1 2 0 +TABLE test t2 12 8 4 8 2 2 0 +TABLE test t3 17 11 6 11 3 3 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 6 +TABLE test t2 12 +TABLE test t3 17 +insert into test.t1 set a=301, b=1, c=1; +insert into test.t2 set a=302, b=2, c=2; +insert into test.t2 set a=303, b=3, c=3; +insert into test.t3 set a=304, b=4, c=4; +insert into test.t3 set a=305, b=5, c=5; +insert into test.t3 set a=306, b=6, c=6; +select * from test.t1; +a b c d +101 1 1 3 +201 1 1 2 +301 1 1 0 +select * from test.t2; +a b c d +102 2 2 2 +103 3 3 2 +202 2 2 1 +203 3 3 1 +302 2 2 0 +303 3 3 0 +select * from test.t3; +a b c d +104 4 4 2 +105 5 5 2 +106 6 6 2 +204 4 4 1 +205 5 5 1 +206 6 6 1 +304 4 4 0 +305 5 5 0 +306 6 6 0 +update test.t1 set d=d+1; +update test.t2 set d=d+1; +update test.t3 set d=d+1; +update test.t1 set d=d+1 where a=301; +update test.t2 set d=d+1 where a=301; +update test.t3 set d=d+1 where a=301; +select * from test.t1 where b=5; +a b c d +select * from test.t2 where b=5; +a b c d +select * from test.t3 where b=5; +a b c d +105 5 5 3 +205 5 5 2 +305 5 5 1 +"================== con3 marker ==================" +"================== Step 7 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +username event_name count_star +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +username event_name count_star +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +execute dump_waits_user; +user event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +execute dump_waits_host; +host event_name count_star +localhost wait/io/table/sql/handler 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +select concat(current_user(), " is connected") as status; +status +user4@localhost is connected +"================== Step 8 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +username event_name count_star +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +username event_name count_star +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +username event_name count_star +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 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +insert into test.t1 set a=401, b=1, c=1; +insert into test.t2 set a=402, b=2, c=2; +insert into test.t2 set a=403, b=3, c=3; +insert into test.t3 set a=404, b=4, c=4; +insert into test.t3 set a=405, b=5, c=5; +insert into test.t3 set a=406, b=6, c=6; +select * from test.t1; +a b c d +101 1 1 4 +201 1 1 3 +301 1 1 2 +401 1 1 0 +select * from test.t2; +a b c d +102 2 2 3 +103 3 3 3 +202 2 2 2 +203 3 3 2 +302 2 2 1 +303 3 3 1 +402 2 2 0 +403 3 3 0 +select * from test.t3; +a b c d +104 4 4 3 +105 5 5 3 +106 6 6 3 +204 4 4 2 +205 5 5 2 +206 6 6 2 +304 4 4 1 +305 5 5 1 +306 6 6 1 +404 4 4 0 +405 5 5 0 +406 6 6 0 +update test.t1 set d=d+1; +update test.t2 set d=d+1; +update test.t3 set d=d+1; +update test.t1 set d=d+1 where a=401; +update test.t2 set d=d+1 where a=401; +update test.t3 set d=d+1 where a=401; +select * from test.t1 where b=5; +a b c d +select * from test.t2 where b=5; +a b c d +select * from test.t3 where b=5; +a b c d +105 5 5 4 +205 5 5 3 +305 5 5 2 +405 5 5 1 +"================== con4 marker ==================" +"================== Step 9 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +username event_name count_star +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +username event_name count_star +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +username event_name count_star +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 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +lock tables test.t1 read, test.t2 read, test.t3 read; +unlock tables; +lock tables test.t1 write, test.t2 write, test.t3 write; +unlock tables; +"================== con1 marker ==================" +"================== Step 10 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +username event_name count_star +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +username event_name count_star +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +username event_name count_star +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 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +flush tables; +"================== flush marker ==================" +"================== Step 11 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +username event_name count_star +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +username event_name count_star +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +username event_name count_star +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 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +set global read_only=1; +set global read_only=0; +"================== global read_only marker ==================" +"================== Step 12 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 35 +user1 wait/lock/table/sql/handler 0 +username event_name count_star +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +username event_name count_star +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +username event_name count_star +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 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +"================== con1 disconnected ==================" +"================== Step 13 ==================" +call dump_thread(); +username status +user1 not found +username event_name count_star +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +username event_name count_star +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +username event_name count_star +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 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +"================== con2 disconnected ==================" +"================== Step 14 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username event_name count_star +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +username event_name count_star +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 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +"================== con3 disconnected ==================" +"================== Step 15 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username event_name count_star +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 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +"================== con4 disconnected ==================" +"================== Step 16 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +truncate performance_schema.events_waits_summary_by_thread_by_event_name; +"================== BY_THREAD truncated ==================" +"================== Step 17 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 35 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 76 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +truncate performance_schema.events_waits_summary_by_account_by_event_name; +"================== BY_ACCOUNT truncated ==================" +"================== Step 18 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 0 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 0 +user3 localhost wait/lock/table/sql/handler 0 +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 35 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 76 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +truncate performance_schema.events_waits_summary_by_user_by_event_name; +"================== BY_USER truncated ==================" +"================== Step 19 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 0 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 0 +user3 localhost wait/lock/table/sql/handler 0 +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 0 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 0 +user3 wait/lock/table/sql/handler 0 +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 111 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +truncate performance_schema.events_waits_summary_by_host_by_event_name; +"================== BY_HOST truncated ==================" +"================== Step 21 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 0 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 0 +user3 localhost wait/lock/table/sql/handler 0 +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 0 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 0 +user3 wait/lock/table/sql/handler 0 +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 0 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 111 +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 16 10 6 10 2 4 0 +TABLE test t1 index_b 1 1 0 1 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 t2 NULL 32 20 12 20 4 8 0 +TABLE test t2 index_b 2 2 0 2 0 0 0 +TABLE test t2 index_cb 0 0 0 0 0 0 0 +TABLE test t2 PRIMARY 2 2 0 2 0 0 0 +TABLE test t3 NULL 46 28 18 28 6 12 0 +TABLE test t3 index_b 6 6 0 6 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 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 t2 36 24 12 24 4 8 0 +TABLE test t3 54 36 18 36 6 12 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 21 +TABLE test t2 36 +TABLE test t3 54 +truncate performance_schema.events_waits_summary_global_by_event_name; +"================== GLOBAL truncated ==================" +"================== Step 21 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/table/sql/handler 0 +user1 localhost wait/lock/table/sql/handler 0 +user2 localhost wait/io/table/sql/handler 0 +user2 localhost wait/lock/table/sql/handler 0 +user3 localhost wait/io/table/sql/handler 0 +user3 localhost wait/lock/table/sql/handler 0 +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 0 +user1 wait/lock/table/sql/handler 0 +user2 wait/io/table/sql/handler 0 +user2 wait/lock/table/sql/handler 0 +user3 wait/io/table/sql/handler 0 +user3 wait/lock/table/sql/handler 0 +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 0 +localhost wait/lock/table/sql/handler 0 +execute dump_waits_global; +event_name count_star +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 36 TABLE test t2 +wait/io/table/sql/handler 54 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 0 0 0 0 0 0 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 0 0 0 0 0 0 0 +TABLE test t2 NULL 0 0 0 0 0 0 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 +TABLE test t2 PRIMARY 0 0 0 0 0 0 0 +TABLE test t3 NULL 0 0 0 0 0 0 0 +TABLE test t3 index_b 0 0 0 0 0 0 0 +TABLE test t3 index_cb 0 0 0 0 0 0 0 +TABLE test t3 PRIMARY 0 0 0 0 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 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 +execute dump_waits_table_lock; +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 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 0 +TABLE test t2 0 +TABLE test t3 0 +show status like "performance_schema%"; +Variable_name Value +Performance_schema_accounts_lost 0 +Performance_schema_cond_classes_lost 0 +Performance_schema_cond_instances_lost 0 +Performance_schema_digest_lost 0 +Performance_schema_file_classes_lost 0 +Performance_schema_file_handles_lost 0 +Performance_schema_file_instances_lost 0 +Performance_schema_hosts_lost 0 +Performance_schema_locker_lost 0 +Performance_schema_mutex_classes_lost 0 +Performance_schema_mutex_instances_lost 0 +Performance_schema_rwlock_classes_lost 0 +Performance_schema_rwlock_instances_lost 0 +Performance_schema_session_connect_attrs_lost 0 +Performance_schema_socket_classes_lost 0 +Performance_schema_socket_instances_lost 0 +Performance_schema_stage_classes_lost 0 +Performance_schema_statement_classes_lost 0 +Performance_schema_table_handles_lost 0 +Performance_schema_table_instances_lost 0 +Performance_schema_thread_classes_lost 0 +Performance_schema_thread_instances_lost 0 +Performance_schema_users_lost 0 |