Debian Codegraph @

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

raw
1 show databases;
2 Database
3 information_schema
4 mtr
5 mysql
6 performance_schema
7 sys
8 test
9 select count(*) from performance_schema.performance_timers;
10 count(*)
11 5
12 select count(*) from performance_schema.setup_consumers;
13 count(*)
14 16
15 select count(*) > 4 from performance_schema.setup_instruments;
16 count(*) > 4
17 1
18 select * from performance_schema.accounts;
19 select * from performance_schema.cond_instances;
20 select * from performance_schema.events_stages_current;
21 select * from performance_schema.events_stages_history;
22 select * from performance_schema.events_stages_history_long;
23 select * from performance_schema.events_stages_summary_by_account_by_event_name;
24 select * from performance_schema.events_stages_summary_by_host_by_event_name;
25 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
26 select * from performance_schema.events_stages_summary_by_user_by_event_name;
27 select * from performance_schema.events_stages_summary_global_by_event_name;
28 select * from performance_schema.events_statements_current;
29 select * from performance_schema.events_statements_histogram_by_digest;
30 select * from performance_schema.events_statements_histogram_global;
31 select * from performance_schema.events_statements_history;
32 select * from performance_schema.events_statements_history_long;
33 select * from performance_schema.events_statements_summary_by_account_by_event_name;
34 select * from performance_schema.events_statements_summary_by_digest;
35 select * from performance_schema.events_statements_summary_by_host_by_event_name;
36 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
37 select * from performance_schema.events_statements_summary_by_user_by_event_name;
38 select * from performance_schema.events_statements_summary_global_by_event_name;
39 select * from performance_schema.events_transactions_current;
40 select * from performance_schema.events_transactions_history;
41 select * from performance_schema.events_transactions_history_long;
42 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
43 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
44 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
45 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
46 select * from performance_schema.events_transactions_summary_global_by_event_name;
47 select * from performance_schema.events_waits_current;
48 select * from performance_schema.events_waits_history;
49 select * from performance_schema.events_waits_history_long;
50 select * from performance_schema.events_waits_summary_by_account_by_event_name;
51 select * from performance_schema.events_waits_summary_by_host_by_event_name;
52 select * from performance_schema.events_waits_summary_by_instance;
53 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
54 select * from performance_schema.events_waits_summary_by_user_by_event_name;
55 select * from performance_schema.events_waits_summary_global_by_event_name;
56 select * from performance_schema.memory_summary_by_account_by_event_name;
57 select * from performance_schema.memory_summary_by_host_by_event_name;
58 select * from performance_schema.memory_summary_by_thread_by_event_name;
59 select * from performance_schema.memory_summary_by_user_by_event_name;
60 select * from performance_schema.memory_summary_global_by_event_name;
61 select * from performance_schema.events_errors_summary_by_account_by_error;
62 select * from performance_schema.events_errors_summary_by_host_by_error;
63 select * from performance_schema.events_errors_summary_by_thread_by_error;
64 select * from performance_schema.events_errors_summary_by_user_by_error;
65 select * from performance_schema.events_errors_summary_global_by_error;
66 select * from performance_schema.file_instances;
67 select * from performance_schema.file_summary_by_event_name;
68 select * from performance_schema.file_summary_by_instance;
69 select * from performance_schema.host_cache;
70 select * from performance_schema.hosts;
71 select * from performance_schema.memory_summary_by_account_by_event_name;
72 select * from performance_schema.memory_summary_by_host_by_event_name;
73 select * from performance_schema.memory_summary_by_thread_by_event_name;
74 select * from performance_schema.memory_summary_by_user_by_event_name;
75 select * from performance_schema.memory_summary_global_by_event_name;
76 select * from performance_schema.metadata_locks;
77 select * from performance_schema.mutex_instances;
78 select * from performance_schema.objects_summary_global_by_type;
79 select * from performance_schema.performance_timers;
80 select * from performance_schema.rwlock_instances;
81 select * from performance_schema.data_locks;
82 select * from performance_schema.data_lock_waits;
83 select * from performance_schema.session_account_connect_attrs;
84 select * from performance_schema.session_connect_attrs;
85 select * from performance_schema.setup_actors;
86 select * from performance_schema.setup_consumers;
87 select * from performance_schema.setup_instruments;
88 select * from performance_schema.setup_objects;
89 select * from performance_schema.setup_threads;
90 select * from performance_schema.socket_instances;
91 select * from performance_schema.socket_summary_by_instance;
92 select * from performance_schema.socket_summary_by_event_name;
93 select * from performance_schema.table_handles;
94 select * from performance_schema.table_io_waits_summary_by_index_usage;
95 select * from performance_schema.table_io_waits_summary_by_table;
96 select * from performance_schema.table_lock_waits_summary_by_table;
97 select * from performance_schema.threads;
98 select * from performance_schema.users;
99 select * from performance_schema.replication_connection_configuration;
100 select * from performance_schema.replication_connection_status;
101 select * from performance_schema.replication_applier_configuration;
102 select * from performance_schema.replication_applier_status;
103 select * from performance_schema.replication_applier_status_by_coordinator;
104 select * from performance_schema.replication_applier_status_by_worker;
105 select * from performance_schema.global_status;
106 select * from performance_schema.status_by_thread;
107 select * from performance_schema.status_by_user;
108 select * from performance_schema.status_by_host;
109 select * from performance_schema.status_by_account;
110 select * from performance_schema.session_status;
111 select * from performance_schema.global_variables;
112 select * from performance_schema.variables_by_thread;
113 select * from performance_schema.session_variables;
114 show engine PERFORMANCE_SCHEMA status;
115 show global status like "performance_schema%";
116 drop table if exists db1.t1;
117 drop database if exists db1;
118 create database db1;
119 create table db1.t1 (a int, b char(10) default 'default',
120 unique key uidx(a));
121 insert into db1.t1 values('1', 'abc');
122 insert into db1.t1 values('2', 'abc');
123 select * from db1.t1 where a='1';
124 a b
125 1 abc
126 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
127 from performance_schema.table_io_waits_summary_by_table
128 where OBJECT_SCHEMA='db1'
129 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
130 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
131 3 TABLE db1 t1
132 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
133 from performance_schema.table_io_waits_summary_by_index_usage
134 where OBJECT_SCHEMA='db1'
135 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
136 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
137 2 TABLE db1 t1 NULL
138 1 TABLE db1 t1 (index 0)
139 flush tables;
140 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
141 from performance_schema.table_io_waits_summary_by_table
142 where OBJECT_SCHEMA='db1'
143 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
144 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
145 0 TABLE db1 t1
146 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
147 from performance_schema.table_io_waits_summary_by_index_usage
148 where OBJECT_SCHEMA='db1'
149 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
150 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
151 select variable_value > 0 from performance_schema.global_status
152 where variable_name like 'PERFORMANCE_SCHEMA_INDEX_STAT_LOST';
153 variable_value > 0
154 1
155 FLUSH STATUS;
156 select variable_value from performance_schema.global_status
157 where variable_name like 'PERFORMANCE_SCHEMA_INDEX_STAT_LOST';
158 variable_value
159 0
160 create table db1.t2 (a int, b char(10) default 'default',
161 unique key uidx(a));
162 insert into db1.t1 values('3', 'abc');
163 insert into db1.t1 values('4', 'abc');
164 select * from db1.t1 where a='1';
165 a b
166 1 abc
167 insert into db1.t2 values('1', 'abc');
168 insert into db1.t2 values('2', 'abc');
169 select * from db1.t2 where a='1';
170 a b
171 1 abc
172 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
173 from performance_schema.table_io_waits_summary_by_table
174 where OBJECT_SCHEMA='db1'
175 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
176 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
177 3 TABLE db1 t1
178 3 TABLE db1 t2
179 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
180 from performance_schema.table_io_waits_summary_by_index_usage
181 where OBJECT_SCHEMA='db1'
182 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
183 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
184 2 TABLE db1 t1 NULL
185 1 TABLE db1 t1 (index 0)
186 2 TABLE db1 t2 NULL
187 1 TABLE db1 t2 (index 0)
188 flush tables;
189 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
190 from performance_schema.table_io_waits_summary_by_table
191 where OBJECT_SCHEMA='db1'
192 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
193 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
194 0 TABLE db1 t1
195 0 TABLE db1 t2
196 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
197 from performance_schema.table_io_waits_summary_by_index_usage
198 where OBJECT_SCHEMA='db1'
199 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
200 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
201 select variable_value > 0 from performance_schema.global_status
202 where variable_name like 'PERFORMANCE_SCHEMA_INDEX_STAT_LOST';
203 variable_value > 0
204 1
205 FLUSH STATUS;
206 update performance_schema.setup_objects set ENABLED='NO' where OBJECT_TYPE='TABLE';
207 insert into db1.t1 values('5', 'abc');
208 insert into db1.t1 values('6', 'abc');
209 select * from db1.t1 where a='1';
210 a b
211 1 abc
212 insert into db1.t2 values('3', 'abc');
213 insert into db1.t2 values('4', 'abc');
214 select * from db1.t2 where a='1';
215 a b
216 1 abc
217 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
218 from performance_schema.table_io_waits_summary_by_table
219 where OBJECT_SCHEMA='db1'
220 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
221 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
222 0 TABLE db1 t1
223 0 TABLE db1 t2
224 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
225 from performance_schema.table_io_waits_summary_by_index_usage
226 where OBJECT_SCHEMA='db1'
227 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
228 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
229 flush tables;
230 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
231 from performance_schema.table_io_waits_summary_by_table
232 where OBJECT_SCHEMA='db1'
233 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
234 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
235 0 TABLE db1 t1
236 0 TABLE db1 t2
237 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
238 from performance_schema.table_io_waits_summary_by_index_usage
239 where OBJECT_SCHEMA='db1'
240 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
241 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
242 select variable_value from performance_schema.global_status
243 where variable_name like 'PERFORMANCE_SCHEMA_INDEX_STAT_LOST';
244 variable_value
245 0
246 drop database db1;
247 update performance_schema.setup_objects set ENABLED='YES'
248 where OBJECT_TYPE='TABLE' and OBJECT_SCHEMA="%";