Debian Codegraph @

mysql-test/suite/perfschema/r/start_server_nothing.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 0
109 performance_schema_digests_size 0
110 performance_schema_events_stages_history_long_size 0
111 performance_schema_events_stages_history_size 0
112 performance_schema_events_statements_history_long_size 0
113 performance_schema_events_statements_history_size 0
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 0
117 performance_schema_events_waits_history_size 0
118 performance_schema_hosts_size 0
119 performance_schema_max_cond_classes 0
120 performance_schema_max_cond_instances 0
121 performance_schema_max_digest_length 1024
122 performance_schema_max_file_classes 0
123 performance_schema_max_file_handles 0
124 performance_schema_max_file_instances 0
125 performance_schema_max_index_stat 0
126 performance_schema_max_memory_classes 0
127 performance_schema_max_metadata_locks 0
128 performance_schema_max_mutex_classes 0
129 performance_schema_max_mutex_instances 0
130 performance_schema_max_prepared_statements_instances 100
131 performance_schema_max_program_instances 0
132 performance_schema_max_rwlock_classes 0
133 performance_schema_max_rwlock_instances 0
134 performance_schema_max_socket_classes 0
135 performance_schema_max_socket_instances 0
136 performance_schema_max_sql_text_length 1024
137 performance_schema_max_stage_classes 0
138 performance_schema_max_statement_classes 0
139 performance_schema_max_statement_stack 1
140 performance_schema_max_table_handles 0
141 performance_schema_max_table_instances 0
142 performance_schema_max_table_lock_stat 0
143 performance_schema_max_thread_classes 0
144 performance_schema_max_thread_instances 0
145 performance_schema_session_connect_attrs_size 0
146 performance_schema_setup_actors_size 0
147 performance_schema_setup_objects_size 0
148 performance_schema_users_size 0
149 show engine PERFORMANCE_SCHEMA status;
150 show global status like "performance_schema%";
151 show global variables like "performance_schema%";
152 Variable_name Value
153 performance_schema ON
154 performance_schema_accounts_size 0
155 performance_schema_digests_size 0
156 performance_schema_events_stages_history_long_size 0
157 performance_schema_events_stages_history_size 0
158 performance_schema_events_statements_history_long_size 0
159 performance_schema_events_statements_history_size 0
160 performance_schema_events_transactions_history_long_size 1000
161 performance_schema_events_transactions_history_size 10
162 performance_schema_events_waits_history_long_size 0
163 performance_schema_events_waits_history_size 0
164 performance_schema_hosts_size 0
165 performance_schema_max_cond_classes 0
166 performance_schema_max_cond_instances 0
167 performance_schema_max_digest_length 1024
168 performance_schema_max_file_classes 0
169 performance_schema_max_file_handles 0
170 performance_schema_max_file_instances 0
171 performance_schema_max_index_stat 0
172 performance_schema_max_memory_classes 0
173 performance_schema_max_metadata_locks 0
174 performance_schema_max_mutex_classes 0
175 performance_schema_max_mutex_instances 0
176 performance_schema_max_prepared_statements_instances 100
177 performance_schema_max_program_instances 0
178 performance_schema_max_rwlock_classes 0
179 performance_schema_max_rwlock_instances 0
180 performance_schema_max_socket_classes 0
181 performance_schema_max_socket_instances 0
182 performance_schema_max_sql_text_length 1024
183 performance_schema_max_stage_classes 0
184 performance_schema_max_statement_classes 0
185 performance_schema_max_statement_stack 1
186 performance_schema_max_table_handles 0
187 performance_schema_max_table_instances 0
188 performance_schema_max_table_lock_stat 0
189 performance_schema_max_thread_classes 0
190 performance_schema_max_thread_instances 0
191 performance_schema_session_connect_attrs_size 0
192 performance_schema_setup_actors_size 0
193 performance_schema_setup_objects_size 0
194 performance_schema_users_size 0
195 select * from performance_schema.setup_instruments
196 order by name;
197 NAME ENABLED TIMED
198 idle YES YES
199 memory/performance_schema/accounts YES NO
200 memory/performance_schema/cond_class YES NO
201 memory/performance_schema/cond_instances YES NO
202 memory/performance_schema/events_stages_history YES NO
203 memory/performance_schema/events_stages_history_long YES NO
204 memory/performance_schema/events_stages_summary_by_account_by_event_name YES NO
205 memory/performance_schema/events_stages_summary_by_host_by_event_name YES NO
206 memory/performance_schema/events_stages_summary_by_thread_by_event_name YES NO
207 memory/performance_schema/events_stages_summary_by_user_by_event_name YES NO
208 memory/performance_schema/events_stages_summary_global_by_event_name YES NO
209 memory/performance_schema/events_statements_current YES NO
210 memory/performance_schema/events_statements_current.sqltext YES NO
211 memory/performance_schema/events_statements_current.tokens YES NO
212 memory/performance_schema/events_statements_history YES NO
213 memory/performance_schema/events_statements_history.sqltext YES NO
214 memory/performance_schema/events_statements_history.tokens YES NO
215 memory/performance_schema/events_statements_history_long YES NO
216 memory/performance_schema/events_statements_history_long.sqltext YES NO
217 memory/performance_schema/events_statements_history_long.tokens YES NO
218 memory/performance_schema/events_statements_summary_by_account_by_event_name YES NO
219 memory/performance_schema/events_statements_summary_by_digest YES NO
220 memory/performance_schema/events_statements_summary_by_digest.tokens YES NO
221 memory/performance_schema/events_statements_summary_by_host_by_event_name YES NO
222 memory/performance_schema/events_statements_summary_by_program YES NO
223 memory/performance_schema/events_statements_summary_by_thread_by_event_name YES NO
224 memory/performance_schema/events_statements_summary_by_user_by_event_name YES NO
225 memory/performance_schema/events_statements_summary_global_by_event_name YES NO
226 memory/performance_schema/events_transactions_history YES NO
227 memory/performance_schema/events_transactions_history_long YES NO
228 memory/performance_schema/events_transactions_summary_by_account_by_event_name YES NO
229 memory/performance_schema/events_transactions_summary_by_host_by_event_name YES NO
230 memory/performance_schema/events_transactions_summary_by_thread_by_event_name YES NO
231 memory/performance_schema/events_transactions_summary_by_user_by_event_name YES NO
232 memory/performance_schema/events_waits_history YES NO
233 memory/performance_schema/events_waits_history_long YES NO
234 memory/performance_schema/events_waits_summary_by_account_by_event_name YES NO
235 memory/performance_schema/events_waits_summary_by_host_by_event_name YES NO
236 memory/performance_schema/events_waits_summary_by_thread_by_event_name YES NO
237 memory/performance_schema/events_waits_summary_by_user_by_event_name YES NO
238 memory/performance_schema/file_class YES NO
239 memory/performance_schema/file_handle YES NO
240 memory/performance_schema/file_instances YES NO
241 memory/performance_schema/hosts YES NO
242 memory/performance_schema/memory_class YES NO
243 memory/performance_schema/memory_summary_by_account_by_event_name YES NO
244 memory/performance_schema/memory_summary_by_host_by_event_name YES NO
245 memory/performance_schema/memory_summary_by_thread_by_event_name YES NO
246 memory/performance_schema/memory_summary_by_user_by_event_name YES NO
247 memory/performance_schema/memory_summary_global_by_event_name YES NO
248 memory/performance_schema/metadata_locks YES NO
249 memory/performance_schema/mutex_class YES NO
250 memory/performance_schema/mutex_instances YES NO
251 memory/performance_schema/prepared_statements_instances YES NO
252 memory/performance_schema/rwlock_class YES NO
253 memory/performance_schema/rwlock_instances YES NO
254 memory/performance_schema/scalable_buffer YES NO
255 memory/performance_schema/session_connect_attrs YES NO
256 memory/performance_schema/setup_actors YES NO
257 memory/performance_schema/setup_objects YES NO
258 memory/performance_schema/socket_class YES NO
259 memory/performance_schema/socket_instances YES NO
260 memory/performance_schema/stage_class YES NO
261 memory/performance_schema/statement_class YES NO
262 memory/performance_schema/table_handles YES NO
263 memory/performance_schema/table_io_waits_summary_by_index_usage YES NO
264 memory/performance_schema/table_lock_waits_summary_by_table YES NO
265 memory/performance_schema/table_shares YES NO
266 memory/performance_schema/threads YES NO
267 memory/performance_schema/thread_class YES NO
268 memory/performance_schema/users YES NO
269 transaction YES YES
270 wait/io/table/sql/handler YES YES
271 wait/lock/metadata/sql/mdl YES YES
272 wait/lock/table/sql/handler YES YES
273 select TIMER_NAME from performance_schema.performance_timers;
274 TIMER_NAME
275 CYCLE
276 NANOSECOND
277 MICROSECOND
278 MILLISECOND
279 TICK
280 select * from performance_schema.setup_consumers;
281 NAME ENABLED
282 events_stages_current YES
283 events_stages_history YES
284 events_stages_history_long YES
285 events_statements_current YES
286 events_statements_history YES
287 events_statements_history_long YES
288 events_transactions_current YES
289 events_transactions_history YES
290 events_transactions_history_long YES
291 events_waits_current YES
292 events_waits_history YES
293 events_waits_history_long YES
294 global_instrumentation YES
295 thread_instrumentation YES
296 statements_digest YES
297 select NAME from performance_schema.setup_timers;
298 NAME
299 idle
300 wait
301 stage
302 statement
303 transaction
304 Warnings:
305 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
306 select * from performance_schema.accounts;
307 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
308 select * from performance_schema.cond_instances;
309 NAME OBJECT_INSTANCE_BEGIN
310 select * from performance_schema.events_stages_current;
311 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT WORK_COMPLETED WORK_ESTIMATED NESTING_EVENT_ID NESTING_EVENT_TYPE
312 select * from performance_schema.events_stages_history;
313 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT WORK_COMPLETED WORK_ESTIMATED NESTING_EVENT_ID NESTING_EVENT_TYPE
314 select * from performance_schema.events_stages_history_long;
315 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT WORK_COMPLETED WORK_ESTIMATED NESTING_EVENT_ID NESTING_EVENT_TYPE
316 select * from performance_schema.events_stages_summary_by_account_by_event_name;
317 USER HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
318 select * from performance_schema.events_stages_summary_by_host_by_event_name;
319 HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
320 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
321 THREAD_ID EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
322 select * from performance_schema.events_stages_summary_by_user_by_event_name;
323 USER EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
324 select * from performance_schema.events_stages_summary_global_by_event_name;
325 EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
326 select * from performance_schema.events_statements_current;
327 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT LOCK_TIME SQL_TEXT DIGEST DIGEST_TEXT CURRENT_SCHEMA OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN MYSQL_ERRNO RETURNED_SQLSTATE MESSAGE_TEXT ERRORS WARNINGS ROWS_AFFECTED ROWS_SENT ROWS_EXAMINED CREATED_TMP_DISK_TABLES CREATED_TMP_TABLES SELECT_FULL_JOIN SELECT_FULL_RANGE_JOIN SELECT_RANGE SELECT_RANGE_CHECK SELECT_SCAN SORT_MERGE_PASSES SORT_RANGE SORT_ROWS SORT_SCAN NO_INDEX_USED NO_GOOD_INDEX_USED NESTING_EVENT_ID NESTING_EVENT_TYPE NESTING_EVENT_LEVEL
328 select * from performance_schema.events_statements_history;
329 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT LOCK_TIME SQL_TEXT DIGEST DIGEST_TEXT CURRENT_SCHEMA OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN MYSQL_ERRNO RETURNED_SQLSTATE MESSAGE_TEXT ERRORS WARNINGS ROWS_AFFECTED ROWS_SENT ROWS_EXAMINED CREATED_TMP_DISK_TABLES CREATED_TMP_TABLES SELECT_FULL_JOIN SELECT_FULL_RANGE_JOIN SELECT_RANGE SELECT_RANGE_CHECK SELECT_SCAN SORT_MERGE_PASSES SORT_RANGE SORT_ROWS SORT_SCAN NO_INDEX_USED NO_GOOD_INDEX_USED NESTING_EVENT_ID NESTING_EVENT_TYPE NESTING_EVENT_LEVEL
330 select * from performance_schema.events_statements_history_long;
331 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT LOCK_TIME SQL_TEXT DIGEST DIGEST_TEXT CURRENT_SCHEMA OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN MYSQL_ERRNO RETURNED_SQLSTATE MESSAGE_TEXT ERRORS WARNINGS ROWS_AFFECTED ROWS_SENT ROWS_EXAMINED CREATED_TMP_DISK_TABLES CREATED_TMP_TABLES SELECT_FULL_JOIN SELECT_FULL_RANGE_JOIN SELECT_RANGE SELECT_RANGE_CHECK SELECT_SCAN SORT_MERGE_PASSES SORT_RANGE SORT_ROWS SORT_SCAN NO_INDEX_USED NO_GOOD_INDEX_USED NESTING_EVENT_ID NESTING_EVENT_TYPE NESTING_EVENT_LEVEL
332 select * from performance_schema.events_statements_summary_by_account_by_event_name;
333 USER HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED
334 select * from performance_schema.events_statements_summary_by_host_by_event_name;
335 HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED
336 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
337 THREAD_ID EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED
338 select * from performance_schema.events_statements_summary_by_user_by_event_name;
339 USER EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED
340 select * from performance_schema.events_statements_summary_global_by_event_name;
341 EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED
342 select * from performance_schema.events_waits_current;
343 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT SPINS OBJECT_SCHEMA OBJECT_NAME INDEX_NAME OBJECT_TYPE OBJECT_INSTANCE_BEGIN NESTING_EVENT_ID NESTING_EVENT_TYPE OPERATION NUMBER_OF_BYTES FLAGS
344 select * from performance_schema.events_waits_history;
345 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT SPINS OBJECT_SCHEMA OBJECT_NAME INDEX_NAME OBJECT_TYPE OBJECT_INSTANCE_BEGIN NESTING_EVENT_ID NESTING_EVENT_TYPE OPERATION NUMBER_OF_BYTES FLAGS
346 select * from performance_schema.events_waits_history_long;
347 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT SPINS OBJECT_SCHEMA OBJECT_NAME INDEX_NAME OBJECT_TYPE OBJECT_INSTANCE_BEGIN NESTING_EVENT_ID NESTING_EVENT_TYPE OPERATION NUMBER_OF_BYTES FLAGS
348 select * from performance_schema.events_waits_summary_by_account_by_event_name;
349 USER HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
350 select * from performance_schema.events_waits_summary_by_host_by_event_name;
351 HOST EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
352 select * from performance_schema.events_waits_summary_by_instance;
353 EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
354 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
355 THREAD_ID EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
356 select * from performance_schema.events_waits_summary_by_user_by_event_name;
357 USER EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
358 select * from performance_schema.events_waits_summary_global_by_event_name;
359 EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
360 wait/io/table/sql/handler 0 0 0 0 0
361 wait/lock/table/sql/handler 0 0 0 0 0
362 idle 0 0 0 0 0
363 wait/lock/metadata/sql/mdl 0 0 0 0 0
364 select * from performance_schema.file_instances;
365 FILE_NAME EVENT_NAME OPEN_COUNT
366 select * from performance_schema.file_summary_by_event_name;
367 EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
368 select * from performance_schema.file_summary_by_instance;
369 FILE_NAME EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
370 select * from performance_schema.hosts;
371 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
372 select * from performance_schema.metadata_locks;
373 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN LOCK_TYPE LOCK_DURATION LOCK_STATUS SOURCE OWNER_THREAD_ID OWNER_EVENT_ID
374 select * from performance_schema.mutex_instances;
375 NAME OBJECT_INSTANCE_BEGIN LOCKED_BY_THREAD_ID
376 select * from performance_schema.objects_summary_global_by_type;
377 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
378 select * from performance_schema.rwlock_instances;
379 NAME OBJECT_INSTANCE_BEGIN WRITE_LOCKED_BY_THREAD_ID READ_LOCKED_BY_COUNT
380 select * from performance_schema.session_account_connect_attrs;
381 PROCESSLIST_ID ATTR_NAME ATTR_VALUE ORDINAL_POSITION
382 select * from performance_schema.session_connect_attrs;
383 PROCESSLIST_ID ATTR_NAME ATTR_VALUE ORDINAL_POSITION
384 select * from performance_schema.setup_actors;
385 HOST USER ROLE ENABLED HISTORY
386 select * from performance_schema.setup_objects;
387 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
388 select * from performance_schema.socket_instances;
389 EVENT_NAME OBJECT_INSTANCE_BEGIN THREAD_ID SOCKET_ID IP PORT STATE
390 select * from performance_schema.socket_summary_by_event_name;
391 EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
392 select * from performance_schema.socket_summary_by_instance;
393 EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
394 select * from performance_schema.table_handles;
395 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN OWNER_THREAD_ID OWNER_EVENT_ID INTERNAL_LOCK EXTERNAL_LOCK
396 select * from performance_schema.threads;
397 THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE THREAD_OS_ID
398 select * from performance_schema.users;
399 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS