Debian Codegraph @

mysql-test/suite/perfschema/r/multi_table_io.result

raw
1 drop schema if exists test1;
2 drop table if exists test.t1;
3 create schema test1;
4 create table test.t1 (col1 bigint, col2 varchar(30)) engine = myisam;
5 insert into test.t1 values(1,'One');
6 create table test1.t2 like test.t1;
7 show create table test.t1;
8 Table Create Table
9 t1 CREATE TABLE `t1` (
10 `col1` bigint DEFAULT NULL,
11 `col2` varchar(30) DEFAULT NULL
12 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 show create table test1.t2;
14 Table Create Table
15 t2 CREATE TABLE `t2` (
16 `col1` bigint DEFAULT NULL,
17 `col2` varchar(30) DEFAULT NULL
18 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
19 drop table if exists test.marker;
20 create table test.marker(a int);
21 update performance_schema.setup_consumers set enabled='NO';
22 update performance_schema.setup_instruments set enabled='NO';
23 update performance_schema.setup_instruments set enabled='YES'
24 where name like "wait/io/table/%";
25 truncate table performance_schema.events_waits_history_long;
26 flush status;
27 flush tables;
28 update performance_schema.setup_consumers set enabled = 'YES';
29 insert into test1.t2 select * from test.t1;
30 insert into marker set a = 1;
31 select * from test.t1 natural join test1.t2;
32 col1 col2
33 1 One
34 insert into marker set a = 1;
35 select * from test.t1 where col2 = (select col2 from test1.t2 where test.t1.col1 = test1.t2.col1);
36 col1 col2
37 1 One
38 insert into marker set a = 1;
39 update test.t1 AS a natural join test1.t2 AS b SET a.col2 = 'updated' , b.col2 = 'updated';
40 insert into marker set a = 1;
41 delete from test.t1, test1.t2 using test.t1 inner join test1.t2
42 where test.t1.col1 = test1.t2.col1;
43 update performance_schema.setup_consumers set enabled='NO';
44 select event_name,
45 left(source, locate(":", source)) as short_source,
46 object_type, object_schema,
47 if (locate("#sql-", object_name), "#sql-XXXX", object_name)
48 as pretty_name,
49 operation, number_of_bytes
50 from performance_schema.events_waits_history_long
51 where event_name like 'wait/io/table/%'
52 and object_schema in ('test','test1')
53 order by thread_id, event_id;
54 event_name short_source object_type object_schema pretty_name operation number_of_bytes
55 wait/io/table/sql/handler handler.cc: TABLE test t1 fetch 1
56 wait/io/table/sql/handler handler.cc: TABLE test1 t2 insert 1
57 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
58 wait/io/table/sql/handler handler.cc: TABLE test t1 fetch 1
59 wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch 1
60 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
61 wait/io/table/sql/handler handler.cc: TABLE test t1 fetch 1
62 wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch 1
63 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
64 wait/io/table/sql/handler handler.cc: TABLE test t1 fetch 1
65 wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch 1
66 wait/io/table/sql/handler handler.cc: TABLE test t1 update 1
67 wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch 1
68 wait/io/table/sql/handler handler.cc: TABLE test1 t2 update 1
69 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
70 wait/io/table/sql/handler handler.cc: TABLE test t1 fetch 1
71 wait/io/table/sql/handler handler.cc: TABLE test1 t2 fetch 1
72 wait/io/table/sql/handler handler.cc: TABLE test t1 delete 1
73 wait/io/table/sql/handler handler.cc: TABLE test1 t2 delete 1
74 show global status like 'performance_schema_%_lost';
75 Variable_name Value
76 Performance_schema_accounts_lost 0
77 Performance_schema_cond_classes_lost 0
78 Performance_schema_cond_instances_lost 0
79 Performance_schema_digest_lost 0
80 Performance_schema_file_classes_lost 0
81 Performance_schema_file_handles_lost 0
82 Performance_schema_file_instances_lost 0
83 Performance_schema_hosts_lost 0
84 Performance_schema_index_stat_lost 0
85 Performance_schema_locker_lost 0
86 Performance_schema_memory_classes_lost 0
87 Performance_schema_metadata_lock_lost 0
88 Performance_schema_mutex_classes_lost 0
89 Performance_schema_mutex_instances_lost 0
90 Performance_schema_nested_statement_lost 0
91 Performance_schema_prepared_statements_lost 0
92 Performance_schema_program_lost 0
93 Performance_schema_rwlock_classes_lost 0
94 Performance_schema_rwlock_instances_lost 0
95 Performance_schema_session_connect_attrs_lost 0
96 Performance_schema_socket_classes_lost 0
97 Performance_schema_socket_instances_lost 0
98 Performance_schema_stage_classes_lost 0
99 Performance_schema_statement_classes_lost 0
100 Performance_schema_table_handles_lost 0
101 Performance_schema_table_instances_lost 0
102 Performance_schema_table_lock_stat_lost 0
103 Performance_schema_thread_classes_lost 0
104 Performance_schema_thread_instances_lost 0
105 Performance_schema_users_lost 0
106 truncate performance_schema.events_waits_history_long;
107 flush status;
108 drop table test.t1;
109 drop schema test1;
110 update performance_schema.setup_consumers set enabled='NO';
111 truncate performance_schema.events_waits_history_long;
112 drop table test.marker;
113 flush status;
114 update performance_schema.setup_instruments set enabled='YES';
115 update performance_schema.setup_consumers set enabled='YES';