diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_3t.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_3t.result | 338 |
1 files changed, 172 insertions, 166 deletions
diff --git a/mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_3t.result b/mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_3t.result index d2ee0bd6c5e..9d98d1f84d1 100644 --- a/mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_3t.result +++ b/mysql-test/suite/perfschema/r/table_lock_aggregate_thread_4u_3t.result @@ -4,11 +4,11 @@ update performance_schema.setup_consumers set enabled='NO' where name like 'event%'; 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 @@ -23,6 +23,9 @@ events_stages_history_long NO events_statements_current NO events_statements_history NO events_statements_history_long NO +events_transactions_current NO +events_transactions_history NO +events_transactions_history_long NO events_waits_current NO events_waits_history NO events_waits_history_long NO @@ -66,15 +69,12 @@ 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 @@ -84,10 +84,10 @@ 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 t2 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 @@ -129,15 +129,12 @@ 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 @@ -147,10 +144,10 @@ 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 t2 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 0 @@ -181,15 +178,15 @@ 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 connection default; -"================== Step 3 ==================" +"================== Step 3-A ==================" call dump_thread(); username event_name count_star user1 wait/io/table/sql/handler 0 @@ -220,15 +217,12 @@ 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 @@ -238,10 +232,69 @@ 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 12 4 8 2 0 0 0 2 0 0 4 -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 t2 12 4 8 2 0 0 0 2 0 4 +TABLE test t3 14 4 10 2 0 0 0 2 0 5 +execute dump_objects_summary; +object_type object_schema object_name count_star +TABLE test t1 10 +TABLE test t2 12 +TABLE test t3 14 +connection con1; +flush tables; +"================== con1 FLUSH ==================" +connection default; +"================== Step 3-B ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/table/sql/handler 0 +user1 wait/lock/table/sql/handler 36 +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 36 +execute dump_waits_user; +user event_name count_star +user1 wait/io/table/sql/handler 0 +user1 wait/lock/table/sql/handler 36 +execute dump_waits_host; +host event_name count_star +localhost wait/io/table/sql/handler 0 +localhost wait/lock/table/sql/handler 36 +execute dump_waits_global; +event_name count_star +wait/io/table/sql/handler 0 +wait/lock/table/sql/handler 36 +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 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 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 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_low_priority count_write_external +TABLE test t1 10 4 6 2 0 0 0 2 0 3 +TABLE test t2 12 4 8 2 0 0 0 2 0 4 +TABLE test t3 14 4 10 2 0 0 0 2 0 5 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 10 @@ -288,15 +341,12 @@ 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 @@ -306,10 +356,10 @@ 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 12 4 8 2 0 0 0 2 0 0 4 -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 t2 12 4 8 2 0 0 0 2 0 4 +TABLE test t3 14 4 10 2 0 0 0 2 0 5 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 10 @@ -346,11 +396,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 @@ -391,15 +441,12 @@ 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 @@ -409,10 +456,10 @@ 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 24 8 16 4 0 0 0 4 0 0 8 -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 t2 24 8 16 4 0 0 0 4 0 8 +TABLE test t3 28 8 20 4 0 0 0 4 0 10 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 20 @@ -464,15 +511,12 @@ 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 @@ -482,10 +526,10 @@ 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 24 8 16 4 0 0 0 4 0 0 8 -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 t2 24 8 16 4 0 0 0 4 0 8 +TABLE test t3 28 8 20 4 0 0 0 4 0 10 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 20 @@ -528,11 +572,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 @@ -579,15 +623,12 @@ 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 @@ -597,10 +638,10 @@ 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 36 12 24 6 0 0 0 6 0 0 12 -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 t2 36 12 24 6 0 0 0 6 0 12 +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 @@ -657,15 +698,12 @@ 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 @@ -675,10 +713,10 @@ 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 36 12 24 6 0 0 0 6 0 0 12 -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 t2 36 12 24 6 0 0 0 6 0 12 +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 @@ -727,11 +765,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 @@ -784,15 +822,12 @@ 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 @@ -802,10 +837,10 @@ 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 48 16 32 8 0 0 0 8 0 0 16 -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 t2 48 16 32 8 0 0 0 8 0 16 +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 @@ -863,15 +898,12 @@ 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 @@ -881,10 +913,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -939,15 +971,12 @@ 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 @@ -957,10 +986,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -1015,15 +1044,12 @@ 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 @@ -1033,10 +1059,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -1088,15 +1114,12 @@ 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 @@ -1106,10 +1129,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -1160,15 +1183,12 @@ 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 @@ -1178,10 +1198,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -1231,15 +1251,12 @@ 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 @@ -1249,10 +1266,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -1301,15 +1318,12 @@ 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 @@ -1319,10 +1333,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -1373,15 +1387,12 @@ 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 @@ -1391,10 +1402,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -1444,15 +1455,12 @@ 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 @@ -1462,10 +1470,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -1515,15 +1523,12 @@ 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 @@ -1533,10 +1538,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -1586,15 +1591,12 @@ 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 @@ -1604,10 +1606,10 @@ 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 52 18 34 8 0 0 1 9 0 0 17 -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 t2 52 18 34 8 0 0 1 9 0 17 +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 @@ -1657,15 +1659,12 @@ 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 @@ -1675,16 +1674,16 @@ 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 t2 0 0 0 0 0 0 0 0 0 0 +TABLE test t3 0 0 0 0 0 0 0 0 0 0 execute dump_objects_summary; object_type object_schema object_name count_star TABLE test t1 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 @@ -1694,9 +1693,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 @@ -1706,6 +1711,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 |