Debian Codegraph @

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

raw
1 select TABLE_SCHEMA, lower(TABLE_NAME), TABLE_CATALOG
2 from information_schema.tables
3 where TABLE_SCHEMA='performance_schema'
4 order by table_name;
5 TABLE_SCHEMA lower(TABLE_NAME) TABLE_CATALOG
6 performance_schema accounts def
7 performance_schema cond_instances def
8 performance_schema events_stages_current def
9 performance_schema events_stages_history def
10 performance_schema events_stages_history_long def
11 performance_schema events_stages_summary_by_account_by_event_name def
12 performance_schema events_stages_summary_by_host_by_event_name def
13 performance_schema events_stages_summary_by_thread_by_event_name def
14 performance_schema events_stages_summary_by_user_by_event_name def
15 performance_schema events_stages_summary_global_by_event_name def
16 performance_schema events_statements_current def
17 performance_schema events_statements_history def
18 performance_schema events_statements_history_long def
19 performance_schema events_statements_summary_by_account_by_event_name def
20 performance_schema events_statements_summary_by_digest def
21 performance_schema events_statements_summary_by_host_by_event_name def
22 performance_schema events_statements_summary_by_program def
23 performance_schema events_statements_summary_by_thread_by_event_name def
24 performance_schema events_statements_summary_by_user_by_event_name def
25 performance_schema events_statements_summary_global_by_event_name def
26 performance_schema events_transactions_current def
27 performance_schema events_transactions_history def
28 performance_schema events_transactions_history_long def
29 performance_schema events_transactions_summary_by_account_by_event_name def
30 performance_schema events_transactions_summary_by_host_by_event_name def
31 performance_schema events_transactions_summary_by_thread_by_event_name def
32 performance_schema events_transactions_summary_by_user_by_event_name def
33 performance_schema events_transactions_summary_global_by_event_name def
34 performance_schema events_waits_current def
35 performance_schema events_waits_history def
36 performance_schema events_waits_history_long def
37 performance_schema events_waits_summary_by_account_by_event_name def
38 performance_schema events_waits_summary_by_host_by_event_name def
39 performance_schema events_waits_summary_by_instance def
40 performance_schema events_waits_summary_by_thread_by_event_name def
41 performance_schema events_waits_summary_by_user_by_event_name def
42 performance_schema events_waits_summary_global_by_event_name def
43 performance_schema file_instances def
44 performance_schema file_summary_by_event_name def
45 performance_schema file_summary_by_instance def
46 performance_schema global_status def
47 performance_schema hosts def
48 performance_schema host_cache def
49 performance_schema memory_summary_by_account_by_event_name def
50 performance_schema memory_summary_by_host_by_event_name def
51 performance_schema memory_summary_by_thread_by_event_name def
52 performance_schema memory_summary_by_user_by_event_name def
53 performance_schema memory_summary_global_by_event_name def
54 performance_schema metadata_locks def
55 performance_schema mutex_instances def
56 performance_schema objects_summary_global_by_type def
57 performance_schema performance_timers def
58 performance_schema prepared_statements_instances def
59 performance_schema replication_applier_configuration def
60 performance_schema replication_applier_status def
61 performance_schema replication_applier_status_by_coordinator def
62 performance_schema replication_applier_status_by_worker def
63 performance_schema replication_connection_configuration def
64 performance_schema rwlock_instances def
65 performance_schema session_account_connect_attrs def
66 performance_schema session_connect_attrs def
67 performance_schema session_status def
68 performance_schema setup_actors def
69 performance_schema setup_consumers def
70 performance_schema setup_instruments def
71 performance_schema setup_objects def
72 performance_schema setup_timers def
73 performance_schema socket_instances def
74 performance_schema socket_summary_by_event_name def
75 performance_schema socket_summary_by_instance def
76 performance_schema status_by_account def
77 performance_schema status_by_host def
78 performance_schema status_by_thread def
79 performance_schema status_by_user def
80 performance_schema table_handles def
81 performance_schema table_io_waits_summary_by_index_usage def
82 performance_schema table_io_waits_summary_by_table def
83 performance_schema table_lock_waits_summary_by_table def
84 performance_schema threads def
85 performance_schema users def
86 performance_schema user_variables_by_thread def
87 select lower(TABLE_NAME), TABLE_TYPE, ENGINE
88 from information_schema.tables
89 where TABLE_SCHEMA='performance_schema'
90 order by table_name;
91 lower(TABLE_NAME) TABLE_TYPE ENGINE
92 accounts BASE TABLE PERFORMANCE_SCHEMA
93 cond_instances BASE TABLE PERFORMANCE_SCHEMA
94 events_stages_current BASE TABLE PERFORMANCE_SCHEMA
95 events_stages_history BASE TABLE PERFORMANCE_SCHEMA
96 events_stages_history_long BASE TABLE PERFORMANCE_SCHEMA
97 events_stages_summary_by_account_by_event_name BASE TABLE PERFORMANCE_SCHEMA
98 events_stages_summary_by_host_by_event_name BASE TABLE PERFORMANCE_SCHEMA
99 events_stages_summary_by_thread_by_event_name BASE TABLE PERFORMANCE_SCHEMA
100 events_stages_summary_by_user_by_event_name BASE TABLE PERFORMANCE_SCHEMA
101 events_stages_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
102 events_statements_current BASE TABLE PERFORMANCE_SCHEMA
103 events_statements_history BASE TABLE PERFORMANCE_SCHEMA
104 events_statements_history_long BASE TABLE PERFORMANCE_SCHEMA
105 events_statements_summary_by_account_by_event_name BASE TABLE PERFORMANCE_SCHEMA
106 events_statements_summary_by_digest BASE TABLE PERFORMANCE_SCHEMA
107 events_statements_summary_by_host_by_event_name BASE TABLE PERFORMANCE_SCHEMA
108 events_statements_summary_by_program BASE TABLE PERFORMANCE_SCHEMA
109 events_statements_summary_by_thread_by_event_name BASE TABLE PERFORMANCE_SCHEMA
110 events_statements_summary_by_user_by_event_name BASE TABLE PERFORMANCE_SCHEMA
111 events_statements_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
112 events_transactions_current BASE TABLE PERFORMANCE_SCHEMA
113 events_transactions_history BASE TABLE PERFORMANCE_SCHEMA
114 events_transactions_history_long BASE TABLE PERFORMANCE_SCHEMA
115 events_transactions_summary_by_account_by_event_name BASE TABLE PERFORMANCE_SCHEMA
116 events_transactions_summary_by_host_by_event_name BASE TABLE PERFORMANCE_SCHEMA
117 events_transactions_summary_by_thread_by_event_name BASE TABLE PERFORMANCE_SCHEMA
118 events_transactions_summary_by_user_by_event_name BASE TABLE PERFORMANCE_SCHEMA
119 events_transactions_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
120 events_waits_current BASE TABLE PERFORMANCE_SCHEMA
121 events_waits_history BASE TABLE PERFORMANCE_SCHEMA
122 events_waits_history_long BASE TABLE PERFORMANCE_SCHEMA
123 events_waits_summary_by_account_by_event_name BASE TABLE PERFORMANCE_SCHEMA
124 events_waits_summary_by_host_by_event_name BASE TABLE PERFORMANCE_SCHEMA
125 events_waits_summary_by_instance BASE TABLE PERFORMANCE_SCHEMA
126 events_waits_summary_by_thread_by_event_name BASE TABLE PERFORMANCE_SCHEMA
127 events_waits_summary_by_user_by_event_name BASE TABLE PERFORMANCE_SCHEMA
128 events_waits_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
129 file_instances BASE TABLE PERFORMANCE_SCHEMA
130 file_summary_by_event_name BASE TABLE PERFORMANCE_SCHEMA
131 file_summary_by_instance BASE TABLE PERFORMANCE_SCHEMA
132 global_status BASE TABLE PERFORMANCE_SCHEMA
133 hosts BASE TABLE PERFORMANCE_SCHEMA
134 host_cache BASE TABLE PERFORMANCE_SCHEMA
135 memory_summary_by_account_by_event_name BASE TABLE PERFORMANCE_SCHEMA
136 memory_summary_by_host_by_event_name BASE TABLE PERFORMANCE_SCHEMA
137 memory_summary_by_thread_by_event_name BASE TABLE PERFORMANCE_SCHEMA
138 memory_summary_by_user_by_event_name BASE TABLE PERFORMANCE_SCHEMA
139 memory_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
140 metadata_locks BASE TABLE PERFORMANCE_SCHEMA
141 mutex_instances BASE TABLE PERFORMANCE_SCHEMA
142 objects_summary_global_by_type BASE TABLE PERFORMANCE_SCHEMA
143 performance_timers BASE TABLE PERFORMANCE_SCHEMA
144 prepared_statements_instances BASE TABLE PERFORMANCE_SCHEMA
145 replication_applier_configuration BASE TABLE PERFORMANCE_SCHEMA
146 replication_applier_status BASE TABLE PERFORMANCE_SCHEMA
147 replication_applier_status_by_coordinator BASE TABLE PERFORMANCE_SCHEMA
148 replication_applier_status_by_worker BASE TABLE PERFORMANCE_SCHEMA
149 replication_connection_configuration BASE TABLE PERFORMANCE_SCHEMA
150 rwlock_instances BASE TABLE PERFORMANCE_SCHEMA
151 session_account_connect_attrs BASE TABLE PERFORMANCE_SCHEMA
152 session_connect_attrs BASE TABLE PERFORMANCE_SCHEMA
153 session_status BASE TABLE PERFORMANCE_SCHEMA
154 setup_actors BASE TABLE PERFORMANCE_SCHEMA
155 setup_consumers BASE TABLE PERFORMANCE_SCHEMA
156 setup_instruments BASE TABLE PERFORMANCE_SCHEMA
157 setup_objects BASE TABLE PERFORMANCE_SCHEMA
158 setup_timers BASE TABLE PERFORMANCE_SCHEMA
159 socket_instances BASE TABLE PERFORMANCE_SCHEMA
160 socket_summary_by_event_name BASE TABLE PERFORMANCE_SCHEMA
161 socket_summary_by_instance BASE TABLE PERFORMANCE_SCHEMA
162 status_by_account BASE TABLE PERFORMANCE_SCHEMA
163 status_by_host BASE TABLE PERFORMANCE_SCHEMA
164 status_by_thread BASE TABLE PERFORMANCE_SCHEMA
165 status_by_user BASE TABLE PERFORMANCE_SCHEMA
166 table_handles BASE TABLE PERFORMANCE_SCHEMA
167 table_io_waits_summary_by_index_usage BASE TABLE PERFORMANCE_SCHEMA
168 table_io_waits_summary_by_table BASE TABLE PERFORMANCE_SCHEMA
169 table_lock_waits_summary_by_table BASE TABLE PERFORMANCE_SCHEMA
170 threads BASE TABLE PERFORMANCE_SCHEMA
171 users BASE TABLE PERFORMANCE_SCHEMA
172 user_variables_by_thread BASE TABLE PERFORMANCE_SCHEMA
173 select lower(TABLE_NAME), VERSION, ROW_FORMAT
174 from information_schema.tables
175 where TABLE_SCHEMA='performance_schema'
176 order by table_name;
177 lower(TABLE_NAME) VERSION ROW_FORMAT
178 accounts 10 Fixed
179 cond_instances 10 Dynamic
180 events_stages_current 10 Dynamic
181 events_stages_history 10 Dynamic
182 events_stages_history_long 10 Dynamic
183 events_stages_summary_by_account_by_event_name 10 Dynamic
184 events_stages_summary_by_host_by_event_name 10 Dynamic
185 events_stages_summary_by_thread_by_event_name 10 Dynamic
186 events_stages_summary_by_user_by_event_name 10 Dynamic
187 events_stages_summary_global_by_event_name 10 Dynamic
188 events_statements_current 10 Dynamic
189 events_statements_history 10 Dynamic
190 events_statements_history_long 10 Dynamic
191 events_statements_summary_by_account_by_event_name 10 Dynamic
192 events_statements_summary_by_digest 10 Dynamic
193 events_statements_summary_by_host_by_event_name 10 Dynamic
194 events_statements_summary_by_program 10 Dynamic
195 events_statements_summary_by_thread_by_event_name 10 Dynamic
196 events_statements_summary_by_user_by_event_name 10 Dynamic
197 events_statements_summary_global_by_event_name 10 Dynamic
198 events_transactions_current 10 Dynamic
199 events_transactions_history 10 Dynamic
200 events_transactions_history_long 10 Dynamic
201 events_transactions_summary_by_account_by_event_name 10 Dynamic
202 events_transactions_summary_by_host_by_event_name 10 Dynamic
203 events_transactions_summary_by_thread_by_event_name 10 Dynamic
204 events_transactions_summary_by_user_by_event_name 10 Dynamic
205 events_transactions_summary_global_by_event_name 10 Dynamic
206 events_waits_current 10 Dynamic
207 events_waits_history 10 Dynamic
208 events_waits_history_long 10 Dynamic
209 events_waits_summary_by_account_by_event_name 10 Dynamic
210 events_waits_summary_by_host_by_event_name 10 Dynamic
211 events_waits_summary_by_instance 10 Dynamic
212 events_waits_summary_by_thread_by_event_name 10 Dynamic
213 events_waits_summary_by_user_by_event_name 10 Dynamic
214 events_waits_summary_global_by_event_name 10 Dynamic
215 file_instances 10 Dynamic
216 file_summary_by_event_name 10 Dynamic
217 file_summary_by_instance 10 Dynamic
218 global_status 10 Dynamic
219 hosts 10 Fixed
220 host_cache 10 Dynamic
221 memory_summary_by_account_by_event_name 10 Dynamic
222 memory_summary_by_host_by_event_name 10 Dynamic
223 memory_summary_by_thread_by_event_name 10 Dynamic
224 memory_summary_by_user_by_event_name 10 Dynamic
225 memory_summary_global_by_event_name 10 Dynamic
226 metadata_locks 10 Dynamic
227 mutex_instances 10 Dynamic
228 objects_summary_global_by_type 10 Dynamic
229 performance_timers 10 Fixed
230 prepared_statements_instances 10 Dynamic
231 replication_applier_configuration 10 Dynamic
232 replication_applier_status 10 Dynamic
233 replication_applier_status_by_coordinator 10 Dynamic
234 replication_applier_status_by_worker 10 Dynamic
235 replication_connection_configuration 10 Dynamic
236 rwlock_instances 10 Dynamic
237 session_account_connect_attrs 10 Dynamic
238 session_connect_attrs 10 Dynamic
239 session_status 10 Dynamic
240 setup_actors 10 Fixed
241 setup_consumers 10 Dynamic
242 setup_instruments 10 Dynamic
243 setup_objects 10 Dynamic
244 setup_timers 10 Dynamic
245 socket_instances 10 Dynamic
246 socket_summary_by_event_name 10 Dynamic
247 socket_summary_by_instance 10 Dynamic
248 status_by_account 10 Dynamic
249 status_by_host 10 Dynamic
250 status_by_thread 10 Dynamic
251 status_by_user 10 Dynamic
252 table_handles 10 Dynamic
253 table_io_waits_summary_by_index_usage 10 Dynamic
254 table_io_waits_summary_by_table 10 Dynamic
255 table_lock_waits_summary_by_table 10 Dynamic
256 threads 10 Dynamic
257 users 10 Fixed
258 user_variables_by_thread 10 Dynamic
259 select lower(TABLE_NAME), AVG_ROW_LENGTH
260 from information_schema.tables
261 where TABLE_SCHEMA='performance_schema' and
262 lower(TABLE_NAME) not regexp '^variables|variables$|^status|session_status|global_status'
263 order by table_name;
264 lower(TABLE_NAME) AVG_ROW_LENGTH
265 accounts 0
266 cond_instances 0
267 events_stages_current 0
268 events_stages_history 0
269 events_stages_history_long 0
270 events_stages_summary_by_account_by_event_name 0
271 events_stages_summary_by_host_by_event_name 0
272 events_stages_summary_by_thread_by_event_name 0
273 events_stages_summary_by_user_by_event_name 0
274 events_stages_summary_global_by_event_name 0
275 events_statements_current 0
276 events_statements_history 0
277 events_statements_history_long 0
278 events_statements_summary_by_account_by_event_name 0
279 events_statements_summary_by_digest 0
280 events_statements_summary_by_host_by_event_name 0
281 events_statements_summary_by_program 0
282 events_statements_summary_by_thread_by_event_name 0
283 events_statements_summary_by_user_by_event_name 0
284 events_statements_summary_global_by_event_name 0
285 events_transactions_current 0
286 events_transactions_history 0
287 events_transactions_history_long 0
288 events_transactions_summary_by_account_by_event_name 0
289 events_transactions_summary_by_host_by_event_name 0
290 events_transactions_summary_by_thread_by_event_name 0
291 events_transactions_summary_by_user_by_event_name 0
292 events_transactions_summary_global_by_event_name 0
293 events_waits_current 0
294 events_waits_history 0
295 events_waits_history_long 0
296 events_waits_summary_by_account_by_event_name 0
297 events_waits_summary_by_host_by_event_name 0
298 events_waits_summary_by_instance 0
299 events_waits_summary_by_thread_by_event_name 0
300 events_waits_summary_by_user_by_event_name 0
301 events_waits_summary_global_by_event_name 0
302 file_instances 0
303 file_summary_by_event_name 0
304 file_summary_by_instance 0
305 hosts 0
306 host_cache 0
307 memory_summary_by_account_by_event_name 0
308 memory_summary_by_host_by_event_name 0
309 memory_summary_by_thread_by_event_name 0
310 memory_summary_by_user_by_event_name 0
311 memory_summary_global_by_event_name 0
312 metadata_locks 0
313 mutex_instances 0
314 objects_summary_global_by_type 0
315 performance_timers 0
316 prepared_statements_instances 0
317 replication_applier_configuration 0
318 replication_applier_status 0
319 replication_applier_status_by_coordinator 0
320 replication_applier_status_by_worker 0
321 replication_connection_configuration 0
322 rwlock_instances 0
323 session_account_connect_attrs 0
324 session_connect_attrs 0
325 setup_actors 0
326 setup_consumers 0
327 setup_instruments 0
328 setup_objects 0
329 setup_timers 0
330 socket_instances 0
331 socket_summary_by_event_name 0
332 socket_summary_by_instance 0
333 table_handles 0
334 table_io_waits_summary_by_index_usage 0
335 table_io_waits_summary_by_table 0
336 table_lock_waits_summary_by_table 0
337 threads 0
338 users 0
339 user_variables_by_thread 0
340 select lower(TABLE_NAME), TABLE_ROWS, AVG_ROW_LENGTH
341 from information_schema.tables
342 where TABLE_SCHEMA='performance_schema' and
343 lower(TABLE_NAME) regexp '^variables|variables$|^status|session_status|global_status'
344 order by table_name;
345 lower(TABLE_NAME) TABLE_ROWS AVG_ROW_LENGTH
346 global_status table_rows avg_row_len
347 session_status table_rows avg_row_len
348 status_by_account table_rows avg_row_len
349 status_by_host table_rows avg_row_len
350 status_by_thread table_rows avg_row_len
351 status_by_user table_rows avg_row_len
352 select lower(TABLE_NAME), DATA_LENGTH, MAX_DATA_LENGTH
353 from information_schema.tables
354 where TABLE_SCHEMA='performance_schema'
355 order by table_name;
356 lower(TABLE_NAME) DATA_LENGTH MAX_DATA_LENGTH
357 accounts 0 0
358 cond_instances 0 0
359 events_stages_current 0 0
360 events_stages_history 0 0
361 events_stages_history_long 0 0
362 events_stages_summary_by_account_by_event_name 0 0
363 events_stages_summary_by_host_by_event_name 0 0
364 events_stages_summary_by_thread_by_event_name 0 0
365 events_stages_summary_by_user_by_event_name 0 0
366 events_stages_summary_global_by_event_name 0 0
367 events_statements_current 0 0
368 events_statements_history 0 0
369 events_statements_history_long 0 0
370 events_statements_summary_by_account_by_event_name 0 0
371 events_statements_summary_by_digest 0 0
372 events_statements_summary_by_host_by_event_name 0 0
373 events_statements_summary_by_program 0 0
374 events_statements_summary_by_thread_by_event_name 0 0
375 events_statements_summary_by_user_by_event_name 0 0
376 events_statements_summary_global_by_event_name 0 0
377 events_transactions_current 0 0
378 events_transactions_history 0 0
379 events_transactions_history_long 0 0
380 events_transactions_summary_by_account_by_event_name 0 0
381 events_transactions_summary_by_host_by_event_name 0 0
382 events_transactions_summary_by_thread_by_event_name 0 0
383 events_transactions_summary_by_user_by_event_name 0 0
384 events_transactions_summary_global_by_event_name 0 0
385 events_waits_current 0 0
386 events_waits_history 0 0
387 events_waits_history_long 0 0
388 events_waits_summary_by_account_by_event_name 0 0
389 events_waits_summary_by_host_by_event_name 0 0
390 events_waits_summary_by_instance 0 0
391 events_waits_summary_by_thread_by_event_name 0 0
392 events_waits_summary_by_user_by_event_name 0 0
393 events_waits_summary_global_by_event_name 0 0
394 file_instances 0 0
395 file_summary_by_event_name 0 0
396 file_summary_by_instance 0 0
397 global_status 0 0
398 hosts 0 0
399 host_cache 0 0
400 memory_summary_by_account_by_event_name 0 0
401 memory_summary_by_host_by_event_name 0 0
402 memory_summary_by_thread_by_event_name 0 0
403 memory_summary_by_user_by_event_name 0 0
404 memory_summary_global_by_event_name 0 0
405 metadata_locks 0 0
406 mutex_instances 0 0
407 objects_summary_global_by_type 0 0
408 performance_timers 0 0
409 prepared_statements_instances 0 0
410 replication_applier_configuration 0 0
411 replication_applier_status 0 0
412 replication_applier_status_by_coordinator 0 0
413 replication_applier_status_by_worker 0 0
414 replication_connection_configuration 0 0
415 rwlock_instances 0 0
416 session_account_connect_attrs 0 0
417 session_connect_attrs 0 0
418 session_status 0 0
419 setup_actors 0 0
420 setup_consumers 0 0
421 setup_instruments 0 0
422 setup_objects 0 0
423 setup_timers 0 0
424 socket_instances 0 0
425 socket_summary_by_event_name 0 0
426 socket_summary_by_instance 0 0
427 status_by_account 0 0
428 status_by_host 0 0
429 status_by_thread 0 0
430 status_by_user 0 0
431 table_handles 0 0
432 table_io_waits_summary_by_index_usage 0 0
433 table_io_waits_summary_by_table 0 0
434 table_lock_waits_summary_by_table 0 0
435 threads 0 0
436 users 0 0
437 user_variables_by_thread 0 0
438 select lower(TABLE_NAME), INDEX_LENGTH, DATA_FREE, AUTO_INCREMENT
439 from information_schema.tables
440 where TABLE_SCHEMA='performance_schema'
441 order by table_name;
442 lower(TABLE_NAME) INDEX_LENGTH DATA_FREE AUTO_INCREMENT
443 accounts 0 0 NULL
444 cond_instances 0 0 NULL
445 events_stages_current 0 0 NULL
446 events_stages_history 0 0 NULL
447 events_stages_history_long 0 0 NULL
448 events_stages_summary_by_account_by_event_name 0 0 NULL
449 events_stages_summary_by_host_by_event_name 0 0 NULL
450 events_stages_summary_by_thread_by_event_name 0 0 NULL
451 events_stages_summary_by_user_by_event_name 0 0 NULL
452 events_stages_summary_global_by_event_name 0 0 NULL
453 events_statements_current 0 0 NULL
454 events_statements_history 0 0 NULL
455 events_statements_history_long 0 0 NULL
456 events_statements_summary_by_account_by_event_name 0 0 NULL
457 events_statements_summary_by_digest 0 0 NULL
458 events_statements_summary_by_host_by_event_name 0 0 NULL
459 events_statements_summary_by_program 0 0 NULL
460 events_statements_summary_by_thread_by_event_name 0 0 NULL
461 events_statements_summary_by_user_by_event_name 0 0 NULL
462 events_statements_summary_global_by_event_name 0 0 NULL
463 events_transactions_current 0 0 NULL
464 events_transactions_history 0 0 NULL
465 events_transactions_history_long 0 0 NULL
466 events_transactions_summary_by_account_by_event_name 0 0 NULL
467 events_transactions_summary_by_host_by_event_name 0 0 NULL
468 events_transactions_summary_by_thread_by_event_name 0 0 NULL
469 events_transactions_summary_by_user_by_event_name 0 0 NULL
470 events_transactions_summary_global_by_event_name 0 0 NULL
471 events_waits_current 0 0 NULL
472 events_waits_history 0 0 NULL
473 events_waits_history_long 0 0 NULL
474 events_waits_summary_by_account_by_event_name 0 0 NULL
475 events_waits_summary_by_host_by_event_name 0 0 NULL
476 events_waits_summary_by_instance 0 0 NULL
477 events_waits_summary_by_thread_by_event_name 0 0 NULL
478 events_waits_summary_by_user_by_event_name 0 0 NULL
479 events_waits_summary_global_by_event_name 0 0 NULL
480 file_instances 0 0 NULL
481 file_summary_by_event_name 0 0 NULL
482 file_summary_by_instance 0 0 NULL
483 global_status 0 0 NULL
484 hosts 0 0 NULL
485 host_cache 0 0 NULL
486 memory_summary_by_account_by_event_name 0 0 NULL
487 memory_summary_by_host_by_event_name 0 0 NULL
488 memory_summary_by_thread_by_event_name 0 0 NULL
489 memory_summary_by_user_by_event_name 0 0 NULL
490 memory_summary_global_by_event_name 0 0 NULL
491 metadata_locks 0 0 NULL
492 mutex_instances 0 0 NULL
493 objects_summary_global_by_type 0 0 NULL
494 performance_timers 0 0 NULL
495 prepared_statements_instances 0 0 NULL
496 replication_applier_configuration 0 0 NULL
497 replication_applier_status 0 0 NULL
498 replication_applier_status_by_coordinator 0 0 NULL
499 replication_applier_status_by_worker 0 0 NULL
500 replication_connection_configuration 0 0 NULL
501 rwlock_instances 0 0 NULL
502 session_account_connect_attrs 0 0 NULL
503 session_connect_attrs 0 0 NULL
504 session_status 0 0 NULL
505 setup_actors 0 0 NULL
506 setup_consumers 0 0 NULL
507 setup_instruments 0 0 NULL
508 setup_objects 0 0 NULL
509 setup_timers 0 0 NULL
510 socket_instances 0 0 NULL
511 socket_summary_by_event_name 0 0 NULL
512 socket_summary_by_instance 0 0 NULL
513 status_by_account 0 0 NULL
514 status_by_host 0 0 NULL
515 status_by_thread 0 0 NULL
516 status_by_user 0 0 NULL
517 table_handles 0 0 NULL
518 table_io_waits_summary_by_index_usage 0 0 NULL
519 table_io_waits_summary_by_table 0 0 NULL
520 table_lock_waits_summary_by_table 0 0 NULL
521 threads 0 0 NULL
522 users 0 0 NULL
523 user_variables_by_thread 0 0 NULL
524 select lower(TABLE_NAME), CREATE_TIME, UPDATE_TIME, CHECK_TIME
525 from information_schema.tables
526 where TABLE_SCHEMA='performance_schema'
527 order by table_name;
528 lower(TABLE_NAME) CREATE_TIME UPDATE_TIME CHECK_TIME
529 accounts NULL NULL NULL
530 cond_instances NULL NULL NULL
531 events_stages_current NULL NULL NULL
532 events_stages_history NULL NULL NULL
533 events_stages_history_long NULL NULL NULL
534 events_stages_summary_by_account_by_event_name NULL NULL NULL
535 events_stages_summary_by_host_by_event_name NULL NULL NULL
536 events_stages_summary_by_thread_by_event_name NULL NULL NULL
537 events_stages_summary_by_user_by_event_name NULL NULL NULL
538 events_stages_summary_global_by_event_name NULL NULL NULL
539 events_statements_current NULL NULL NULL
540 events_statements_history NULL NULL NULL
541 events_statements_history_long NULL NULL NULL
542 events_statements_summary_by_account_by_event_name NULL NULL NULL
543 events_statements_summary_by_digest NULL NULL NULL
544 events_statements_summary_by_host_by_event_name NULL NULL NULL
545 events_statements_summary_by_program NULL NULL NULL
546 events_statements_summary_by_thread_by_event_name NULL NULL NULL
547 events_statements_summary_by_user_by_event_name NULL NULL NULL
548 events_statements_summary_global_by_event_name NULL NULL NULL
549 events_transactions_current NULL NULL NULL
550 events_transactions_history NULL NULL NULL
551 events_transactions_history_long NULL NULL NULL
552 events_transactions_summary_by_account_by_event_name NULL NULL NULL
553 events_transactions_summary_by_host_by_event_name NULL NULL NULL
554 events_transactions_summary_by_thread_by_event_name NULL NULL NULL
555 events_transactions_summary_by_user_by_event_name NULL NULL NULL
556 events_transactions_summary_global_by_event_name NULL NULL NULL
557 events_waits_current NULL NULL NULL
558 events_waits_history NULL NULL NULL
559 events_waits_history_long NULL NULL NULL
560 events_waits_summary_by_account_by_event_name NULL NULL NULL
561 events_waits_summary_by_host_by_event_name NULL NULL NULL
562 events_waits_summary_by_instance NULL NULL NULL
563 events_waits_summary_by_thread_by_event_name NULL NULL NULL
564 events_waits_summary_by_user_by_event_name NULL NULL NULL
565 events_waits_summary_global_by_event_name NULL NULL NULL
566 file_instances NULL NULL NULL
567 file_summary_by_event_name NULL NULL NULL
568 file_summary_by_instance NULL NULL NULL
569 global_status NULL NULL NULL
570 hosts NULL NULL NULL
571 host_cache NULL NULL NULL
572 memory_summary_by_account_by_event_name NULL NULL NULL
573 memory_summary_by_host_by_event_name NULL NULL NULL
574 memory_summary_by_thread_by_event_name NULL NULL NULL
575 memory_summary_by_user_by_event_name NULL NULL NULL
576 memory_summary_global_by_event_name NULL NULL NULL
577 metadata_locks NULL NULL NULL
578 mutex_instances NULL NULL NULL
579 objects_summary_global_by_type NULL NULL NULL
580 performance_timers NULL NULL NULL
581 prepared_statements_instances NULL NULL NULL
582 replication_applier_configuration NULL NULL NULL
583 replication_applier_status NULL NULL NULL
584 replication_applier_status_by_coordinator NULL NULL NULL
585 replication_applier_status_by_worker NULL NULL NULL
586 replication_connection_configuration NULL NULL NULL
587 rwlock_instances NULL NULL NULL
588 session_account_connect_attrs NULL NULL NULL
589 session_connect_attrs NULL NULL NULL
590 session_status NULL NULL NULL
591 setup_actors NULL NULL NULL
592 setup_consumers NULL NULL NULL
593 setup_instruments NULL NULL NULL
594 setup_objects NULL NULL NULL
595 setup_timers NULL NULL NULL
596 socket_instances NULL NULL NULL
597 socket_summary_by_event_name NULL NULL NULL
598 socket_summary_by_instance NULL NULL NULL
599 status_by_account NULL NULL NULL
600 status_by_host NULL NULL NULL
601 status_by_thread NULL NULL NULL
602 status_by_user NULL NULL NULL
603 table_handles NULL NULL NULL
604 table_io_waits_summary_by_index_usage NULL NULL NULL
605 table_io_waits_summary_by_table NULL NULL NULL
606 table_lock_waits_summary_by_table NULL NULL NULL
607 threads NULL NULL NULL
608 users NULL NULL NULL
609 user_variables_by_thread NULL NULL NULL
610 select lower(TABLE_NAME), TABLE_COLLATION, CHECKSUM
611 from information_schema.tables
612 where TABLE_SCHEMA='performance_schema'
613 order by table_name;
614 lower(TABLE_NAME) TABLE_COLLATION CHECKSUM
615 accounts utf8mb3_general_ci NULL
616 cond_instances utf8mb3_general_ci NULL
617 events_stages_current utf8mb3_general_ci NULL
618 events_stages_history utf8mb3_general_ci NULL
619 events_stages_history_long utf8mb3_general_ci NULL
620 events_stages_summary_by_account_by_event_name utf8mb3_general_ci NULL
621 events_stages_summary_by_host_by_event_name utf8mb3_general_ci NULL
622 events_stages_summary_by_thread_by_event_name utf8mb3_general_ci NULL
623 events_stages_summary_by_user_by_event_name utf8mb3_general_ci NULL
624 events_stages_summary_global_by_event_name utf8mb3_general_ci NULL
625 events_statements_current utf8mb3_general_ci NULL
626 events_statements_history utf8mb3_general_ci NULL
627 events_statements_history_long utf8mb3_general_ci NULL
628 events_statements_summary_by_account_by_event_name utf8mb3_general_ci NULL
629 events_statements_summary_by_digest utf8mb3_general_ci NULL
630 events_statements_summary_by_host_by_event_name utf8mb3_general_ci NULL
631 events_statements_summary_by_program utf8mb3_general_ci NULL
632 events_statements_summary_by_thread_by_event_name utf8mb3_general_ci NULL
633 events_statements_summary_by_user_by_event_name utf8mb3_general_ci NULL
634 events_statements_summary_global_by_event_name utf8mb3_general_ci NULL
635 events_transactions_current utf8mb3_general_ci NULL
636 events_transactions_history utf8mb3_general_ci NULL
637 events_transactions_history_long utf8mb3_general_ci NULL
638 events_transactions_summary_by_account_by_event_name utf8mb3_general_ci NULL
639 events_transactions_summary_by_host_by_event_name utf8mb3_general_ci NULL
640 events_transactions_summary_by_thread_by_event_name utf8mb3_general_ci NULL
641 events_transactions_summary_by_user_by_event_name utf8mb3_general_ci NULL
642 events_transactions_summary_global_by_event_name utf8mb3_general_ci NULL
643 events_waits_current utf8mb3_general_ci NULL
644 events_waits_history utf8mb3_general_ci NULL
645 events_waits_history_long utf8mb3_general_ci NULL
646 events_waits_summary_by_account_by_event_name utf8mb3_general_ci NULL
647 events_waits_summary_by_host_by_event_name utf8mb3_general_ci NULL
648 events_waits_summary_by_instance utf8mb3_general_ci NULL
649 events_waits_summary_by_thread_by_event_name utf8mb3_general_ci NULL
650 events_waits_summary_by_user_by_event_name utf8mb3_general_ci NULL
651 events_waits_summary_global_by_event_name utf8mb3_general_ci NULL
652 file_instances utf8mb3_general_ci NULL
653 file_summary_by_event_name utf8mb3_general_ci NULL
654 file_summary_by_instance utf8mb3_general_ci NULL
655 global_status utf8mb3_general_ci NULL
656 hosts utf8mb3_general_ci NULL
657 host_cache utf8mb3_general_ci NULL
658 memory_summary_by_account_by_event_name utf8mb3_general_ci NULL
659 memory_summary_by_host_by_event_name utf8mb3_general_ci NULL
660 memory_summary_by_thread_by_event_name utf8mb3_general_ci NULL
661 memory_summary_by_user_by_event_name utf8mb3_general_ci NULL
662 memory_summary_global_by_event_name utf8mb3_general_ci NULL
663 metadata_locks utf8mb3_general_ci NULL
664 mutex_instances utf8mb3_general_ci NULL
665 objects_summary_global_by_type utf8mb3_general_ci NULL
666 performance_timers utf8mb3_general_ci NULL
667 prepared_statements_instances utf8mb3_general_ci NULL
668 replication_applier_configuration utf8mb3_general_ci NULL
669 replication_applier_status utf8mb3_general_ci NULL
670 replication_applier_status_by_coordinator utf8mb3_general_ci NULL
671 replication_applier_status_by_worker utf8mb3_general_ci NULL
672 replication_connection_configuration utf8mb3_general_ci NULL
673 rwlock_instances utf8mb3_general_ci NULL
674 session_account_connect_attrs utf8mb3_bin NULL
675 session_connect_attrs utf8mb3_bin NULL
676 session_status utf8mb3_general_ci NULL
677 setup_actors utf8mb3_general_ci NULL
678 setup_consumers utf8mb3_general_ci NULL
679 setup_instruments utf8mb3_general_ci NULL
680 setup_objects utf8mb3_general_ci NULL
681 setup_timers utf8mb3_general_ci NULL
682 socket_instances utf8mb3_general_ci NULL
683 socket_summary_by_event_name utf8mb3_general_ci NULL
684 socket_summary_by_instance utf8mb3_general_ci NULL
685 status_by_account utf8mb3_general_ci NULL
686 status_by_host utf8mb3_general_ci NULL
687 status_by_thread utf8mb3_general_ci NULL
688 status_by_user utf8mb3_general_ci NULL
689 table_handles utf8mb3_general_ci NULL
690 table_io_waits_summary_by_index_usage utf8mb3_general_ci NULL
691 table_io_waits_summary_by_table utf8mb3_general_ci NULL
692 table_lock_waits_summary_by_table utf8mb3_general_ci NULL
693 threads utf8mb3_general_ci NULL
694 users utf8mb3_general_ci NULL
695 user_variables_by_thread utf8mb3_general_ci NULL
696 select lower(TABLE_NAME), CREATE_OPTIONS
697 from information_schema.tables
698 where TABLE_SCHEMA='performance_schema'
699 order by table_name;
700 lower(TABLE_NAME) CREATE_OPTIONS
701 accounts
702 cond_instances
703 events_stages_current
704 events_stages_history
705 events_stages_history_long
706 events_stages_summary_by_account_by_event_name
707 events_stages_summary_by_host_by_event_name
708 events_stages_summary_by_thread_by_event_name
709 events_stages_summary_by_user_by_event_name
710 events_stages_summary_global_by_event_name
711 events_statements_current
712 events_statements_history
713 events_statements_history_long
714 events_statements_summary_by_account_by_event_name
715 events_statements_summary_by_digest
716 events_statements_summary_by_host_by_event_name
717 events_statements_summary_by_program
718 events_statements_summary_by_thread_by_event_name
719 events_statements_summary_by_user_by_event_name
720 events_statements_summary_global_by_event_name
721 events_transactions_current
722 events_transactions_history
723 events_transactions_history_long
724 events_transactions_summary_by_account_by_event_name
725 events_transactions_summary_by_host_by_event_name
726 events_transactions_summary_by_thread_by_event_name
727 events_transactions_summary_by_user_by_event_name
728 events_transactions_summary_global_by_event_name
729 events_waits_current
730 events_waits_history
731 events_waits_history_long
732 events_waits_summary_by_account_by_event_name
733 events_waits_summary_by_host_by_event_name
734 events_waits_summary_by_instance
735 events_waits_summary_by_thread_by_event_name
736 events_waits_summary_by_user_by_event_name
737 events_waits_summary_global_by_event_name
738 file_instances
739 file_summary_by_event_name
740 file_summary_by_instance
741 global_status
742 hosts
743 host_cache
744 memory_summary_by_account_by_event_name
745 memory_summary_by_host_by_event_name
746 memory_summary_by_thread_by_event_name
747 memory_summary_by_user_by_event_name
748 memory_summary_global_by_event_name
749 metadata_locks
750 mutex_instances
751 objects_summary_global_by_type
752 performance_timers
753 prepared_statements_instances
754 replication_applier_configuration
755 replication_applier_status
756 replication_applier_status_by_coordinator
757 replication_applier_status_by_worker
758 replication_connection_configuration
759 rwlock_instances
760 session_account_connect_attrs
761 session_connect_attrs
762 session_status
763 setup_actors
764 setup_consumers
765 setup_instruments
766 setup_objects
767 setup_timers
768 socket_instances
769 socket_summary_by_event_name
770 socket_summary_by_instance
771 status_by_account
772 status_by_host
773 status_by_thread
774 status_by_user
775 table_handles
776 table_io_waits_summary_by_index_usage
777 table_io_waits_summary_by_table
778 table_lock_waits_summary_by_table
779 threads
780 users
781 user_variables_by_thread
782 select lower(TABLE_NAME), TABLE_COMMENT
783 from information_schema.tables
784 where TABLE_SCHEMA='performance_schema'
785 order by table_name;
786 lower(TABLE_NAME) TABLE_COMMENT
787 accounts
788 cond_instances
789 events_stages_current
790 events_stages_history
791 events_stages_history_long
792 events_stages_summary_by_account_by_event_name
793 events_stages_summary_by_host_by_event_name
794 events_stages_summary_by_thread_by_event_name
795 events_stages_summary_by_user_by_event_name
796 events_stages_summary_global_by_event_name
797 events_statements_current
798 events_statements_history
799 events_statements_history_long
800 events_statements_summary_by_account_by_event_name
801 events_statements_summary_by_digest
802 events_statements_summary_by_host_by_event_name
803 events_statements_summary_by_program
804 events_statements_summary_by_thread_by_event_name
805 events_statements_summary_by_user_by_event_name
806 events_statements_summary_global_by_event_name
807 events_transactions_current
808 events_transactions_history
809 events_transactions_history_long
810 events_transactions_summary_by_account_by_event_name
811 events_transactions_summary_by_host_by_event_name
812 events_transactions_summary_by_thread_by_event_name
813 events_transactions_summary_by_user_by_event_name
814 events_transactions_summary_global_by_event_name
815 events_waits_current
816 events_waits_history
817 events_waits_history_long
818 events_waits_summary_by_account_by_event_name
819 events_waits_summary_by_host_by_event_name
820 events_waits_summary_by_instance
821 events_waits_summary_by_thread_by_event_name
822 events_waits_summary_by_user_by_event_name
823 events_waits_summary_global_by_event_name
824 file_instances
825 file_summary_by_event_name
826 file_summary_by_instance
827 global_status
828 hosts
829 host_cache
830 memory_summary_by_account_by_event_name
831 memory_summary_by_host_by_event_name
832 memory_summary_by_thread_by_event_name
833 memory_summary_by_user_by_event_name
834 memory_summary_global_by_event_name
835 metadata_locks
836 mutex_instances
837 objects_summary_global_by_type
838 performance_timers
839 prepared_statements_instances
840 replication_applier_configuration
841 replication_applier_status
842 replication_applier_status_by_coordinator
843 replication_applier_status_by_worker
844 replication_connection_configuration
845 rwlock_instances
846 session_account_connect_attrs
847 session_connect_attrs
848 session_status
849 setup_actors
850 setup_consumers
851 setup_instruments
852 setup_objects
853 setup_timers
854 socket_instances
855 socket_summary_by_event_name
856 socket_summary_by_instance
857 status_by_account
858 status_by_host
859 status_by_thread
860 status_by_user
861 table_handles
862 table_io_waits_summary_by_index_usage
863 table_io_waits_summary_by_table
864 table_lock_waits_summary_by_table
865 threads
866 users
867 user_variables_by_thread