EVOLUTION-MANAGER

Edit File: multi_table_io.result

drop schema if exists test1; drop table if exists test.t1; create schema test1; create table test.t1 (col1 bigint, col2 varchar(30)) engine = myisam; insert into test.t1 values(1,'One'); create table test1.t2 like test.t1; show create table test.t1; Table Create Table t1 CREATE TABLE `t1` ( `col1` bigint(20) DEFAULT NULL, `col2` varchar(30) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 show create table test1.t2; Table Create Table t2 CREATE TABLE `t2` ( `col1` bigint(20) DEFAULT NULL, `col2` varchar(30) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table if exists test.marker; create table test.marker(a int); update performance_schema.setup_consumers set enabled='NO'; update performance_schema.setup_instruments set enabled='NO'; update performance_schema.setup_instruments set enabled='YES' where name like "wait/io/table/%"; truncate table performance_schema.events_waits_history_long; flush status; flush tables; update performance_schema.setup_consumers set enabled = 'YES'; insert into test1.t2 select * from test.t1; insert into marker set a = 1; select * from test.t1 natural join test1.t2; col1 col2 1 One insert into marker set a = 1; select * from test.t1 where col2 = (select col2 from test1.t2 where test.t1.col1 = test1.t2.col1); col1 col2 1 One insert into marker set a = 1; update test.t1 AS a natural join test1.t2 AS b SET a.col2 = 'updated' , b.col2 = 'updated'; insert into marker set a = 1; delete from test.t1, test1.t2 using test.t1 inner join test1.t2 where test.t1.col1 = test1.t2.col1; update performance_schema.setup_consumers set enabled='NO'; select event_name, left(source, locate(":", source)) as short_source, object_type, object_schema, if (locate("#sql-", object_name), "#sql-XXXX", object_name) as pretty_name, operation, number_of_bytes from performance_schema.events_waits_history_long where event_name like 'wait/io/table/%' and object_schema in ('test','test1') order by thread_id, event_id; event_name short_source object_type object_schema pretty_name operation number_of_bytes wait/io/table/sql/handler handler.cc: TABLE test t1 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test1 t2 insert NULL wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL wait/io/table/sql/handler handler.cc: TABLE test t1 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL wait/io/table/sql/handler handler.cc: TABLE test t1 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL wait/io/table/sql/handler handler.cc: TABLE test t1 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test t1 update NULL wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test1 t2 update NULL wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL wait/io/table/sql/handler handler.cc: TABLE test t1 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test t1 delete NULL wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch NULL wait/io/table/sql/handler handler.cc: TABLE test1 t2 delete NULL show status where Variable_name like 'performance_schema_%' and Variable_name not like 'performance_schema_%_classes_lost'; Variable_name Value Performance_schema_accounts_lost 0 Performance_schema_cond_instances_lost 0 Performance_schema_digest_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_instances_lost 0 Performance_schema_rwlock_instances_lost 0 Performance_schema_session_connect_attrs_lost 0 Performance_schema_socket_instances_lost 0 Performance_schema_table_handles_lost 0 Performance_schema_table_instances_lost 0 Performance_schema_thread_instances_lost 0 Performance_schema_users_lost 0 truncate performance_schema.events_waits_history_long; flush status; drop table test.t1; drop schema test1; update performance_schema.setup_consumers set enabled='NO'; truncate performance_schema.events_waits_history_long; drop table test.marker; flush status; update performance_schema.setup_instruments set enabled='YES'; update performance_schema.setup_consumers set enabled='YES';