Debian Codegraph @

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

raw
1 drop table if exists test.marker;
2 create table test.marker(a int);
3 update performance_schema.setup_consumers set enabled='NO';
4 update performance_schema.setup_instruments set enabled='NO';
5 update performance_schema.setup_instruments set enabled='YES'
6 where name like "wait/io/table/%";
7 truncate table performance_schema.events_waits_history_long;
8 flush status;
9 flush tables;
10 drop table if exists test.no_index_tab;
11 drop table if exists test.no_index_tab_1;
12 drop table if exists test.no_index_tab_2;
13 update performance_schema.setup_consumers set enabled='YES';
14 insert into marker set a = 1;
15 create table test.no_index_tab_1
16 ( a varchar(255) not null, b int not null) engine = MyISAM;
17 insert into marker set a = 1;
18 create table test.no_index_tab_2 like test.no_index_tab_1;
19 insert into marker set a = 1;
20 create table test.no_index_tab
21 ( a varchar(255) not null, b int not null) engine = merge
22 union = (test.no_index_tab_1,test.no_index_tab_2) insert_method = first;
23 insert into marker set a = 1;
24 show create table test.no_index_tab_1;
25 Table Create Table
26 no_index_tab_1 CREATE TABLE `no_index_tab_1` (
27 `a` varchar(255) NOT NULL,
28 `b` int NOT NULL
29 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
30 insert into marker set a = 1;
31 show create table test.no_index_tab_2;
32 Table Create Table
33 no_index_tab_2 CREATE TABLE `no_index_tab_2` (
34 `a` varchar(255) NOT NULL,
35 `b` int NOT NULL
36 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
37 insert into marker set a = 1;
38 show create table test.no_index_tab;
39 Table Create Table
40 no_index_tab CREATE TABLE `no_index_tab` (
41 `a` varchar(255) NOT NULL,
42 `b` int NOT NULL
43 ) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci INSERT_METHOD=FIRST UNION=(`no_index_tab_1`,`no_index_tab_2`)
44 insert into marker set a = 1;
45 insert into test.no_index_tab set a = 'foo', b = 1;
46 insert into marker set a = 1;
47 insert into test.no_index_tab set a = 'foo', b = 2;
48 insert into marker set a = 1;
49 insert into test.no_index_tab set a = 'foo', b = 3;
50 insert into marker set a = 1;
51 select * from test.no_index_tab;
52 a b
53 foo 1
54 foo 2
55 foo 3
56 insert into marker set a = 1;
57 update test.no_index_tab set a = 'bar';
58 insert into marker set a = 1;
59 select * from test.no_index_tab limit 2;
60 a b
61 bar 1
62 bar 2
63 insert into marker set a = 1;
64 delete from test.no_index_tab where b = 3;
65 insert into marker set a = 1;
66 select * from test.no_index_tab;
67 a b
68 bar 1
69 bar 2
70 insert into marker set a = 1;
71 optimize table test.no_index_tab;
72 Table Op Msg_type Msg_text
73 test.no_index_tab optimize note The storage engine for the table doesn't support optimize
74 insert into marker set a = 1;
75 select * from test.no_index_tab;
76 a b
77 bar 1
78 bar 2
79 insert into marker set a = 1;
80 truncate table test.no_index_tab;
81 insert into marker set a = 1;
82 drop table test.no_index_tab_1;
83 insert into marker set a = 1;
84 drop table test.no_index_tab_2;
85 insert into marker set a = 1;
86 drop table test.no_index_tab;
87 update performance_schema.setup_consumers set enabled='NO';
88 select event_name,
89 left(source, locate(":", source)) as short_source,
90 object_type, object_schema,
91 if (locate("#sql-", object_name), "#sql-XXXX", object_name)
92 as pretty_name,
93 operation, number_of_bytes
94 from performance_schema.events_waits_history_long
95 where event_name like 'wait/io/table/%'
96 and object_schema in ("test")
97 order by thread_id, event_id;
98 event_name short_source object_type object_schema pretty_name operation number_of_bytes
99 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
100 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
101 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
102 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
103 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
104 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
105 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
106 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab insert 1
107 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
108 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab insert 1
109 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
110 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab insert 1
111 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
112 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 3
113 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
114 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 1
115 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab update 1
116 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 1
117 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab update 1
118 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 1
119 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab update 1
120 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 1
121 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
122 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 2
123 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
124 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 1
125 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 1
126 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 1
127 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab delete 1
128 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 1
129 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
130 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 2
131 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
132 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
133 wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch 2
134 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
135 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
136 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
137 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
138 show global status like 'performance_schema_%_lost';
139 Variable_name Value
140 Performance_schema_accounts_lost 0
141 Performance_schema_cond_classes_lost 0
142 Performance_schema_cond_instances_lost 0
143 Performance_schema_digest_lost 0
144 Performance_schema_file_classes_lost 0
145 Performance_schema_file_handles_lost 0
146 Performance_schema_file_instances_lost 0
147 Performance_schema_hosts_lost 0
148 Performance_schema_index_stat_lost 0
149 Performance_schema_locker_lost 0
150 Performance_schema_memory_classes_lost 0
151 Performance_schema_metadata_lock_lost 0
152 Performance_schema_mutex_classes_lost 0
153 Performance_schema_mutex_instances_lost 0
154 Performance_schema_nested_statement_lost 0
155 Performance_schema_prepared_statements_lost 0
156 Performance_schema_program_lost 0
157 Performance_schema_rwlock_classes_lost 0
158 Performance_schema_rwlock_instances_lost 0
159 Performance_schema_session_connect_attrs_lost 0
160 Performance_schema_socket_classes_lost 0
161 Performance_schema_socket_instances_lost 0
162 Performance_schema_stage_classes_lost 0
163 Performance_schema_statement_classes_lost 0
164 Performance_schema_table_handles_lost 0
165 Performance_schema_table_instances_lost 0
166 Performance_schema_table_lock_stat_lost 0
167 Performance_schema_thread_classes_lost 0
168 Performance_schema_thread_instances_lost 0
169 Performance_schema_users_lost 0
170 truncate performance_schema.events_waits_history_long;
171 flush status;
172 update performance_schema.setup_consumers set enabled='NO';
173 truncate performance_schema.events_waits_history_long;
174 drop table test.marker;
175 flush status;
176 update performance_schema.setup_instruments set enabled='YES';
177 update performance_schema.setup_consumers set enabled='YES';