diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_lock_aggregate_hist_4u_2t.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/table_lock_aggregate_hist_4u_2t.result | 490 |
1 files changed, 241 insertions, 249 deletions
diff --git a/mysql-test/suite/perfschema/r/table_lock_aggregate_hist_4u_2t.result b/mysql-test/suite/perfschema/r/table_lock_aggregate_hist_4u_2t.result index 61c649bd2cf..dd63dc6c25a 100644 --- a/mysql-test/suite/perfschema/r/table_lock_aggregate_hist_4u_2t.result +++ b/mysql-test/suite/perfschema/r/table_lock_aggregate_hist_4u_2t.result @@ -1,14 +1,26 @@ +Warnings: +Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. +Warnings: +Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. +Warnings: +Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. +Warnings: +Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. +Warnings: +Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. +Warnings: +Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. update performance_schema.setup_instruments set enabled='NO' where name='wait/io/table/sql/handler'; delete from performance_schema.setup_objects where object_name='t2'; select * from performance_schema.setup_actors order by USER, HOST, ROLE; -HOST USER ROLE -localhost user1 % -localhost user2 % -localhost user3 % -localhost user4 % +HOST USER ROLE ENABLED HISTORY +localhost user1 % YES YES +localhost user2 % YES YES +localhost user3 % YES YES +localhost user4 % YES YES select * from performance_schema.setup_objects order by object_type, object_schema, object_name; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED @@ -22,6 +34,9 @@ events_stages_history_long YES events_statements_current YES events_statements_history YES events_statements_history_long YES +events_transactions_current YES +events_transactions_history YES +events_transactions_history_long YES events_waits_current YES events_waits_history YES events_waits_history_long YES @@ -39,6 +54,85 @@ 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; +<<<<<<< HEAD +======= +show global 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_transactions_history_long_size 1000 +performance_schema_events_transactions_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_digest_length 1024 +performance_schema_max_file_classes 80 +performance_schema_max_file_handles 32768 +performance_schema_max_file_instances 10000 +performance_schema_max_index_stat 5000 +performance_schema_max_memory_classes 320 +performance_schema_max_metadata_locks 10000 +performance_schema_max_mutex_classes 210 +performance_schema_max_mutex_instances 5000 +performance_schema_max_prepared_statements_instances 100 +performance_schema_max_program_instances 5000 +performance_schema_max_rwlock_classes 50 +performance_schema_max_rwlock_instances 5000 +performance_schema_max_socket_classes 10 +performance_schema_max_socket_instances 1000 +performance_schema_max_sql_text_length 1024 +performance_schema_max_stage_classes 150 +performance_schema_max_statement_classes 193 +performance_schema_max_statement_stack 10 +performance_schema_max_table_handles 1000 +performance_schema_max_table_instances 500 +performance_schema_max_table_lock_stat 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 global 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_index_stat_lost 0 +Performance_schema_locker_lost 0 +Performance_schema_memory_classes_lost 0 +Performance_schema_metadata_lock_lost 0 +Performance_schema_mutex_classes_lost 0 +Performance_schema_mutex_instances_lost 0 +Performance_schema_nested_statement_lost 0 +Performance_schema_prepared_statements_lost 0 +Performance_schema_program_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_table_lock_stat_lost 0 +Performance_schema_thread_classes_lost 0 +Performance_schema_thread_instances_lost 0 +Performance_schema_users_lost 0 +>>>>>>> 258e16fa2de... WIP 5.7 P_S "================== Step 1 ==================" call dump_thread(); username status @@ -65,28 +159,20 @@ 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 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 @@ -128,28 +214,20 @@ 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 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 @@ -180,15 +258,74 @@ 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; +select * from test.t1 force index(index_b) where b=5; a b c d -select * from test.t2 where b=5; +select * from test.t2 force index(index_b) where b=5; a b c d -select * from test.t3 where b=5; +select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 1 +<<<<<<< HEAD connection default; "================== Step 3 ==================" +======= +"================== con1 marker ==================" +"================== Step 3-A ==================" +>>>>>>> merge-perfschema-5.7 +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 0 +user1 wait/lock/table/sql/handler 24 +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 24 +execute dump_waits_user; +user event_name count_star +user1 wait/io/table/sql/handler 0 +user1 wait/lock/table/sql/handler 24 +execute dump_waits_host; +host event_name count_star +localhost wait/io/table/sql/handler 0 +localhost wait/lock/table/sql/handler 24 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 0 +wait/lock/table/sql/handler 24 +execute dump_waits_history; +event_name count(event_name) object_type object_schema object_name +wait/lock/table/sql/handler 10 TABLE test t1 +wait/lock/table/sql/handler 14 TABLE test t3 +execute dump_waits_index_io; +object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete +TABLE test t1 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 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 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_low_priority count_write_external +TABLE test t1 10 4 6 2 0 0 0 2 0 3 +TABLE test t3 14 4 10 2 0 0 0 2 0 5 +execute dump_objects_summary; +object_type object_schema object_name count_star +TABLE test t1 10 +TABLE test t2 0 +TABLE test t3 14 +flush tables; +"================== con1 FLUSH ==================" +"================== Step 3-B ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 0 @@ -221,28 +358,20 @@ wait/lock/table/sql/handler 10 TABLE test t1 wait/lock/table/sql/handler 14 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 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 10 4 6 2 0 0 0 2 0 0 3 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 14 4 10 2 0 0 0 2 0 0 5 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 10 4 6 2 0 0 0 2 0 3 +TABLE test t3 14 4 10 2 0 0 0 2 0 5 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 10 @@ -291,28 +420,20 @@ wait/lock/table/sql/handler 10 TABLE test t1 wait/lock/table/sql/handler 14 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 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 10 4 6 2 0 0 0 2 0 0 3 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 14 4 10 2 0 0 0 2 0 0 5 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 10 4 6 2 0 0 0 2 0 3 +TABLE test t3 14 4 10 2 0 0 0 2 0 5 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 10 @@ -349,11 +470,11 @@ 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; +select * from test.t1 force index(index_b) where b=5; a b c d -select * from test.t2 where b=5; +select * from test.t2 force index(index_b) where b=5; a b c d -select * from test.t3 where b=5; +select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 2 205 5 5 1 @@ -396,28 +517,20 @@ wait/lock/table/sql/handler 20 TABLE test t1 wait/lock/table/sql/handler 28 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 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 20 8 12 4 0 0 0 4 0 0 6 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 28 8 20 4 0 0 0 4 0 0 10 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 20 8 12 4 0 0 0 4 0 6 +TABLE test t3 28 8 20 4 0 0 0 4 0 10 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 20 @@ -471,28 +584,20 @@ wait/lock/table/sql/handler 20 TABLE test t1 wait/lock/table/sql/handler 28 TABLE test t3 execute dump_waits_index_io; object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete -TABLE test t1 NULL 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 20 8 12 4 0 0 0 4 0 0 6 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 28 8 20 4 0 0 0 4 0 0 10 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 20 8 12 4 0 0 0 4 0 6 +TABLE test t3 28 8 20 4 0 0 0 4 0 10 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 20 @@ -535,11 +640,11 @@ 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; +select * from test.t1 force index(index_b) where b=5; a b c d -select * from test.t2 where b=5; +select * from test.t2 force index(index_b) where b=5; a b c d -select * from test.t3 where b=5; +select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 3 205 5 5 2 @@ -588,28 +693,20 @@ wait/lock/table/sql/handler 30 TABLE test t1 wait/lock/table/sql/handler 42 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 30 12 18 6 0 0 0 6 0 0 9 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 42 12 30 6 0 0 0 6 0 0 15 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 30 12 18 6 0 0 0 6 0 9 +TABLE test t3 42 12 30 6 0 0 0 6 0 15 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 30 @@ -668,28 +765,20 @@ wait/lock/table/sql/handler 30 TABLE test t1 wait/lock/table/sql/handler 42 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 30 12 18 6 0 0 0 6 0 0 9 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 42 12 30 6 0 0 0 6 0 0 15 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 30 12 18 6 0 0 0 6 0 9 +TABLE test t3 42 12 30 6 0 0 0 6 0 15 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 30 @@ -738,11 +827,11 @@ 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; +select * from test.t1 force index(index_b) where b=5; a b c d -select * from test.t2 where b=5; +select * from test.t2 force index(index_b) where b=5; a b c d -select * from test.t3 where b=5; +select * from test.t3 force index(index_b) where b=5; a b c d 105 5 5 4 205 5 5 3 @@ -797,28 +886,20 @@ wait/lock/table/sql/handler 40 TABLE test t1 wait/lock/table/sql/handler 56 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 40 16 24 8 0 0 0 8 0 0 12 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 56 16 40 8 0 0 0 8 0 0 20 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 40 16 24 8 0 0 0 8 0 12 +TABLE test t3 56 16 40 8 0 0 0 8 0 20 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 40 @@ -878,28 +959,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -956,28 +1029,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -1034,28 +1099,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -1109,28 +1166,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -1183,28 +1232,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -1256,28 +1297,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -1328,28 +1361,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -1402,28 +1427,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -1475,28 +1492,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -1548,28 +1557,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -1621,28 +1622,20 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 44 18 26 8 0 0 1 9 0 0 13 -TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 -TABLE test t3 60 18 42 8 0 0 1 9 0 0 21 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 44 18 26 8 0 0 1 9 0 13 +TABLE test t3 60 18 42 8 0 0 1 9 0 21 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 44 @@ -1694,34 +1687,26 @@ wait/lock/table/sql/handler 44 TABLE test t1 wait/lock/table/sql/handler 60 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 +object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external +TABLE test t1 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 TABLE test t2 0 TABLE test t3 0 -show status like "performance_schema%"; +show global status like "performance_schema%"; Variable_name Value Performance_schema_accounts_lost 0 Performance_schema_cond_classes_lost 0 @@ -1731,9 +1716,15 @@ 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_index_stat_lost 0 Performance_schema_locker_lost 0 +Performance_schema_memory_classes_lost 0 +Performance_schema_metadata_lock_lost 0 Performance_schema_mutex_classes_lost 0 Performance_schema_mutex_instances_lost 0 +Performance_schema_nested_statement_lost 0 +Performance_schema_prepared_statements_lost 0 +Performance_schema_program_lost 0 Performance_schema_rwlock_classes_lost 0 Performance_schema_rwlock_instances_lost 0 Performance_schema_session_connect_attrs_lost 0 @@ -1743,6 +1734,7 @@ 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_table_lock_stat_lost 0 Performance_schema_thread_classes_lost 0 Performance_schema_thread_instances_lost 0 Performance_schema_users_lost 0 |