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 15
15 select count(*) > 4 from performance_schema.setup_instruments;
16 count(*) > 4
17 1
18 select count(*) from performance_schema.setup_timers;
19 count(*)
20 5
21 Warnings:
22 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
23 select * from performance_schema.accounts;
24 select * from performance_schema.cond_instances;
25 select * from performance_schema.events_stages_current;
26 select * from performance_schema.events_stages_history;
27 select * from performance_schema.events_stages_history_long;
28 select * from performance_schema.events_stages_summary_by_account_by_event_name;
29 select * from performance_schema.events_stages_summary_by_host_by_event_name;
30 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
31 select * from performance_schema.events_stages_summary_by_user_by_event_name;
32 select * from performance_schema.events_stages_summary_global_by_event_name;
33 select * from performance_schema.events_statements_current;
34 select * from performance_schema.events_statements_history;
35 select * from performance_schema.events_statements_history_long;
36 select * from performance_schema.events_statements_summary_by_account_by_event_name;
37 select * from performance_schema.events_statements_summary_by_digest;
38 select * from performance_schema.events_statements_summary_by_host_by_event_name;
39 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
40 select * from performance_schema.events_statements_summary_by_user_by_event_name;
41 select * from performance_schema.events_statements_summary_global_by_event_name;
42 select * from performance_schema.events_transactions_current;
43 select * from performance_schema.events_transactions_history;
44 select * from performance_schema.events_transactions_history_long;
45 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
46 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
47 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
48 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
49 select * from performance_schema.events_transactions_summary_global_by_event_name;
50 select * from performance_schema.events_waits_current;
51 select * from performance_schema.events_waits_history;
52 select * from performance_schema.events_waits_history_long;
53 select * from performance_schema.events_waits_summary_by_account_by_event_name;
54 select * from performance_schema.events_waits_summary_by_host_by_event_name;
55 select * from performance_schema.events_waits_summary_by_instance;
56 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
57 select * from performance_schema.events_waits_summary_by_user_by_event_name;
58 select * from performance_schema.events_waits_summary_global_by_event_name;
59 select * from performance_schema.memory_summary_by_account_by_event_name;
60 select * from performance_schema.memory_summary_by_host_by_event_name;
61 select * from performance_schema.memory_summary_by_thread_by_event_name;
62 select * from performance_schema.memory_summary_by_user_by_event_name;
63 select * from performance_schema.memory_summary_global_by_event_name;
64 select * from performance_schema.file_instances;
65 select * from performance_schema.file_summary_by_event_name;
66 select * from performance_schema.file_summary_by_instance;
67 select * from performance_schema.host_cache;
68 select * from performance_schema.hosts;
69 select * from performance_schema.memory_summary_by_account_by_event_name;
70 select * from performance_schema.memory_summary_by_host_by_event_name;
71 select * from performance_schema.memory_summary_by_thread_by_event_name;
72 select * from performance_schema.memory_summary_by_user_by_event_name;
73 select * from performance_schema.memory_summary_global_by_event_name;
74 select * from performance_schema.metadata_locks;
75 select * from performance_schema.mutex_instances;
76 select * from performance_schema.objects_summary_global_by_type;
77 select * from performance_schema.performance_timers;
78 select * from performance_schema.rwlock_instances;
79 select * from performance_schema.session_account_connect_attrs;
80 select * from performance_schema.session_connect_attrs;
81 select * from performance_schema.setup_actors;
82 select * from performance_schema.setup_consumers;
83 select * from performance_schema.setup_instruments;
84 select * from performance_schema.setup_objects;
85 select * from performance_schema.setup_timers;
86 select * from performance_schema.socket_instances;
87 select * from performance_schema.socket_summary_by_instance;
88 select * from performance_schema.socket_summary_by_event_name;
89 select * from performance_schema.table_handles;
90 select * from performance_schema.table_io_waits_summary_by_index_usage;
91 select * from performance_schema.table_io_waits_summary_by_table;
92 select * from performance_schema.table_lock_waits_summary_by_table;
93 select * from performance_schema.threads;
94 select * from performance_schema.users;
95 select * from performance_schema.replication_connection_configuration;
96 select * from performance_schema.replication_applier_configuration;
97 select * from performance_schema.replication_applier_status;
98 select * from performance_schema.replication_applier_status_by_coordinator;
99 select * from performance_schema.global_status;
100 select * from performance_schema.status_by_thread;
101 select * from performance_schema.status_by_user;
102 select * from performance_schema.status_by_host;
103 select * from performance_schema.status_by_account;
104 select * from performance_schema.session_status;
105 show global variables like "performance_schema%";
106 Variable_name Value
107 performance_schema ON
108 performance_schema_accounts_size 100
109 performance_schema_digests_size 200
110 performance_schema_events_stages_history_long_size 1000
111 performance_schema_events_stages_history_size 10
112 performance_schema_events_statements_history_long_size 1000
113 performance_schema_events_statements_history_size 10
114 performance_schema_events_transactions_history_long_size 1000
115 performance_schema_events_transactions_history_size 10
116 performance_schema_events_waits_history_long_size 10000
117 performance_schema_events_waits_history_size 10
118 performance_schema_hosts_size 100
119 performance_schema_max_cond_classes 90
120 performance_schema_max_cond_instances 1500
121 performance_schema_max_digest_length 1024
122 performance_schema_max_file_classes 80
123 performance_schema_max_file_handles 32768
124 performance_schema_max_file_instances 10000
125 performance_schema_max_index_stat 34
126 performance_schema_max_memory_classes 320
127 performance_schema_max_metadata_locks 10000
128 performance_schema_max_mutex_classes 210
129 performance_schema_max_mutex_instances 5000
130 performance_schema_max_prepared_statements_instances 100
131 performance_schema_max_program_instances 5000
132 performance_schema_max_rwlock_classes 50
133 performance_schema_max_rwlock_instances 5000
134 performance_schema_max_socket_classes 10
135 performance_schema_max_socket_instances 1000
136 performance_schema_max_sql_text_length 1024
137 performance_schema_max_stage_classes 160
138 performance_schema_max_statement_classes 223
139 performance_schema_max_statement_stack 10
140 performance_schema_max_table_handles 1000
141 performance_schema_max_table_instances 500
142 performance_schema_max_table_lock_stat 500
143 performance_schema_max_thread_classes 50
144 performance_schema_max_thread_instances 400
145 performance_schema_session_connect_attrs_size 2048
146 performance_schema_setup_actors_size 100
147 performance_schema_setup_objects_size 100
148 performance_schema_users_size 100
149 show engine PERFORMANCE_SCHEMA status;
150 show global status like "performance_schema%";
151 drop table if exists db1.t1;
152 drop database if exists db1;
153 create database db1;
154 create table db1.t1 (a int, b char(10) default 'default',
155 unique key uidx(a));
156 insert into db1.t1 values('1', 'abc');
157 insert into db1.t1 values('2', 'abc');
158 select * from db1.t1 where a='1';
159 a b
160 1 abc
161 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
162 from performance_schema.table_io_waits_summary_by_table
163 where OBJECT_SCHEMA='db1'
164 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
165 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
166 3 TABLE db1 t1
167 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
168 from performance_schema.table_io_waits_summary_by_index_usage
169 where OBJECT_SCHEMA='db1'
170 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
171 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
172 2 TABLE db1 t1 NULL
173 1 TABLE db1 t1 uidx
174 flush tables;
175 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
176 from performance_schema.table_io_waits_summary_by_table
177 where OBJECT_SCHEMA='db1'
178 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
179 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
180 1 TABLE db1 t1
181 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
182 from performance_schema.table_io_waits_summary_by_index_usage
183 where OBJECT_SCHEMA='db1'
184 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
185 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
186 1 TABLE db1 t1 uidx
187 select variable_value > 0 from information_schema.global_status
188 where variable_name like 'PERFORMANCE_SCHEMA_INDEX_STAT_LOST';
189 variable_value > 0
190 1
191 FLUSH GLOBAL STATUS;
192 select variable_value from information_schema.global_status
193 where variable_name like 'PERFORMANCE_SCHEMA_INDEX_STAT_LOST';
194 variable_value
195 0
196 create table db1.t2 (a int, b char(10) default 'default',
197 unique key uidx(a));
198 insert into db1.t1 values('3', 'abc');
199 insert into db1.t1 values('4', 'abc');
200 select * from db1.t1 where a='1';
201 a b
202 1 abc
203 insert into db1.t2 values('1', 'abc');
204 insert into db1.t2 values('2', 'abc');
205 select * from db1.t2 where a='1';
206 a b
207 1 abc
208 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
209 from performance_schema.table_io_waits_summary_by_table
210 where OBJECT_SCHEMA='db1'
211 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
212 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
213 4 TABLE db1 t1
214 3 TABLE db1 t2
215 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
216 from performance_schema.table_io_waits_summary_by_index_usage
217 where OBJECT_SCHEMA='db1'
218 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
219 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
220 2 TABLE db1 t1 NULL
221 2 TABLE db1 t1 uidx
222 2 TABLE db1 t2 NULL
223 1 TABLE db1 t2 (index 0)
224 flush tables;
225 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
226 from performance_schema.table_io_waits_summary_by_table
227 where OBJECT_SCHEMA='db1'
228 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
229 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
230 2 TABLE db1 t1
231 0 TABLE db1 t2
232 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
233 from performance_schema.table_io_waits_summary_by_index_usage
234 where OBJECT_SCHEMA='db1'
235 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
236 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
237 2 TABLE db1 t1 uidx
238 select variable_value > 0 from information_schema.global_status
239 where variable_name like 'PERFORMANCE_SCHEMA_INDEX_STAT_LOST';
240 variable_value > 0
241 1
242 FLUSH GLOBAL STATUS;
243 update performance_schema.setup_objects set ENABLED='NO' where OBJECT_TYPE='TABLE';
244 insert into db1.t1 values('5', 'abc');
245 insert into db1.t1 values('6', 'abc');
246 select * from db1.t1 where a='1';
247 a b
248 1 abc
249 insert into db1.t2 values('3', 'abc');
250 insert into db1.t2 values('4', 'abc');
251 select * from db1.t2 where a='1';
252 a b
253 1 abc
254 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
255 from performance_schema.table_io_waits_summary_by_table
256 where OBJECT_SCHEMA='db1'
257 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
258 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
259 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
260 from performance_schema.table_io_waits_summary_by_index_usage
261 where OBJECT_SCHEMA='db1'
262 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
263 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
264 flush tables;
265 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
266 from performance_schema.table_io_waits_summary_by_table
267 where OBJECT_SCHEMA='db1'
268 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
269 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
270 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME
271 from performance_schema.table_io_waits_summary_by_index_usage
272 where OBJECT_SCHEMA='db1'
273 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME;
274 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME
275 select variable_value from information_schema.global_status
276 where variable_name like 'PERFORMANCE_SCHEMA_INDEX_STAT_LOST';
277 variable_value
278 0
279 drop database db1;
280 update performance_schema.setup_objects set ENABLED='YES'
281 where OBJECT_TYPE='TABLE' and OBJECT_SCHEMA="%";