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 TABLE_SCHEMA lower(TABLE_NAME) TABLE_CATALOG
5 performance_schema accounts def
6 performance_schema binary_log_transaction_compression_stats def
7 performance_schema cond_instances def
8 performance_schema data_lock_waits def
9 performance_schema data_locks def
10 performance_schema error_log def
11 performance_schema events_errors_summary_by_account_by_error def
12 performance_schema events_errors_summary_by_host_by_error def
13 performance_schema events_errors_summary_by_thread_by_error def
14 performance_schema events_errors_summary_by_user_by_error def
15 performance_schema events_errors_summary_global_by_error def
16 performance_schema events_stages_current def
17 performance_schema events_stages_history def
18 performance_schema events_stages_history_long def
19 performance_schema events_stages_summary_by_account_by_event_name def
20 performance_schema events_stages_summary_by_host_by_event_name def
21 performance_schema events_stages_summary_by_thread_by_event_name def
22 performance_schema events_stages_summary_by_user_by_event_name def
23 performance_schema events_stages_summary_global_by_event_name def
24 performance_schema events_statements_current def
25 performance_schema events_statements_histogram_by_digest def
26 performance_schema events_statements_histogram_global def
27 performance_schema events_statements_history def
28 performance_schema events_statements_history_long def
29 performance_schema events_statements_summary_by_account_by_event_name def
30 performance_schema events_statements_summary_by_digest def
31 performance_schema events_statements_summary_by_host_by_event_name def
32 performance_schema events_statements_summary_by_program def
33 performance_schema events_statements_summary_by_thread_by_event_name def
34 performance_schema events_statements_summary_by_user_by_event_name def
35 performance_schema events_statements_summary_global_by_event_name def
36 performance_schema events_transactions_current def
37 performance_schema events_transactions_history def
38 performance_schema events_transactions_history_long def
39 performance_schema events_transactions_summary_by_account_by_event_name def
40 performance_schema events_transactions_summary_by_host_by_event_name def
41 performance_schema events_transactions_summary_by_thread_by_event_name def
42 performance_schema events_transactions_summary_by_user_by_event_name def
43 performance_schema events_transactions_summary_global_by_event_name def
44 performance_schema events_waits_current def
45 performance_schema events_waits_history def
46 performance_schema events_waits_history_long def
47 performance_schema events_waits_summary_by_account_by_event_name def
48 performance_schema events_waits_summary_by_host_by_event_name def
49 performance_schema events_waits_summary_by_instance def
50 performance_schema events_waits_summary_by_thread_by_event_name def
51 performance_schema events_waits_summary_by_user_by_event_name def
52 performance_schema events_waits_summary_global_by_event_name def
53 performance_schema file_instances def
54 performance_schema file_summary_by_event_name def
55 performance_schema file_summary_by_instance def
56 performance_schema global_status def
57 performance_schema global_variables def
58 performance_schema host_cache def
59 performance_schema hosts def
60 performance_schema innodb_redo_log_files def
61 performance_schema keyring_component_status def
62 performance_schema keyring_keys def
63 performance_schema log_status def
64 performance_schema memory_summary_by_account_by_event_name def
65 performance_schema memory_summary_by_host_by_event_name def
66 performance_schema memory_summary_by_thread_by_event_name def
67 performance_schema memory_summary_by_user_by_event_name def
68 performance_schema memory_summary_global_by_event_name def
69 performance_schema metadata_locks def
70 performance_schema mutex_instances def
71 performance_schema objects_summary_global_by_type def
72 performance_schema performance_timers def
73 performance_schema persisted_variables def
74 performance_schema prepared_statements_instances def
75 performance_schema processlist def
76 performance_schema replication_applier_configuration def
77 performance_schema replication_applier_filters def
78 performance_schema replication_applier_global_filters def
79 performance_schema replication_applier_status def
80 performance_schema replication_applier_status_by_coordinator def
81 performance_schema replication_applier_status_by_worker def
82 performance_schema replication_asynchronous_connection_failover def
83 performance_schema replication_asynchronous_connection_failover_managed def
84 performance_schema replication_connection_configuration def
85 performance_schema replication_connection_status def
86 performance_schema replication_group_member_stats def
87 performance_schema replication_group_members def
88 performance_schema rwlock_instances def
89 performance_schema session_account_connect_attrs def
90 performance_schema session_connect_attrs def
91 performance_schema session_status def
92 performance_schema session_variables def
93 performance_schema setup_actors def
94 performance_schema setup_consumers def
95 performance_schema setup_instruments def
96 performance_schema setup_objects def
97 performance_schema setup_threads def
98 performance_schema socket_instances def
99 performance_schema socket_summary_by_event_name def
100 performance_schema socket_summary_by_instance def
101 performance_schema status_by_account def
102 performance_schema status_by_host def
103 performance_schema status_by_thread def
104 performance_schema status_by_user def
105 performance_schema table_handles def
106 performance_schema table_io_waits_summary_by_index_usage def
107 performance_schema table_io_waits_summary_by_table def
108 performance_schema table_lock_waits_summary_by_table def
109 performance_schema threads def
110 performance_schema tls_channel_status def
111 performance_schema user_defined_functions def
112 performance_schema user_variables_by_thread def
113 performance_schema users def
114 performance_schema variables_by_thread def
115 performance_schema variables_info def
116 select lower(TABLE_NAME), TABLE_TYPE, ENGINE
117 from information_schema.tables
118 where TABLE_SCHEMA='performance_schema';
119 lower(TABLE_NAME) TABLE_TYPE ENGINE
120 accounts BASE TABLE PERFORMANCE_SCHEMA
121 binary_log_transaction_compression_stats BASE TABLE PERFORMANCE_SCHEMA
122 cond_instances BASE TABLE PERFORMANCE_SCHEMA
123 data_lock_waits BASE TABLE PERFORMANCE_SCHEMA
124 data_locks BASE TABLE PERFORMANCE_SCHEMA
125 error_log BASE TABLE PERFORMANCE_SCHEMA
126 events_errors_summary_by_account_by_error BASE TABLE PERFORMANCE_SCHEMA
127 events_errors_summary_by_host_by_error BASE TABLE PERFORMANCE_SCHEMA
128 events_errors_summary_by_thread_by_error BASE TABLE PERFORMANCE_SCHEMA
129 events_errors_summary_by_user_by_error BASE TABLE PERFORMANCE_SCHEMA
130 events_errors_summary_global_by_error BASE TABLE PERFORMANCE_SCHEMA
131 events_stages_current BASE TABLE PERFORMANCE_SCHEMA
132 events_stages_history BASE TABLE PERFORMANCE_SCHEMA
133 events_stages_history_long BASE TABLE PERFORMANCE_SCHEMA
134 events_stages_summary_by_account_by_event_name BASE TABLE PERFORMANCE_SCHEMA
135 events_stages_summary_by_host_by_event_name BASE TABLE PERFORMANCE_SCHEMA
136 events_stages_summary_by_thread_by_event_name BASE TABLE PERFORMANCE_SCHEMA
137 events_stages_summary_by_user_by_event_name BASE TABLE PERFORMANCE_SCHEMA
138 events_stages_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
139 events_statements_current BASE TABLE PERFORMANCE_SCHEMA
140 events_statements_histogram_by_digest BASE TABLE PERFORMANCE_SCHEMA
141 events_statements_histogram_global BASE TABLE PERFORMANCE_SCHEMA
142 events_statements_history BASE TABLE PERFORMANCE_SCHEMA
143 events_statements_history_long BASE TABLE PERFORMANCE_SCHEMA
144 events_statements_summary_by_account_by_event_name BASE TABLE PERFORMANCE_SCHEMA
145 events_statements_summary_by_digest BASE TABLE PERFORMANCE_SCHEMA
146 events_statements_summary_by_host_by_event_name BASE TABLE PERFORMANCE_SCHEMA
147 events_statements_summary_by_program BASE TABLE PERFORMANCE_SCHEMA
148 events_statements_summary_by_thread_by_event_name BASE TABLE PERFORMANCE_SCHEMA
149 events_statements_summary_by_user_by_event_name BASE TABLE PERFORMANCE_SCHEMA
150 events_statements_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
151 events_transactions_current BASE TABLE PERFORMANCE_SCHEMA
152 events_transactions_history BASE TABLE PERFORMANCE_SCHEMA
153 events_transactions_history_long BASE TABLE PERFORMANCE_SCHEMA
154 events_transactions_summary_by_account_by_event_name BASE TABLE PERFORMANCE_SCHEMA
155 events_transactions_summary_by_host_by_event_name BASE TABLE PERFORMANCE_SCHEMA
156 events_transactions_summary_by_thread_by_event_name BASE TABLE PERFORMANCE_SCHEMA
157 events_transactions_summary_by_user_by_event_name BASE TABLE PERFORMANCE_SCHEMA
158 events_transactions_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
159 events_waits_current BASE TABLE PERFORMANCE_SCHEMA
160 events_waits_history BASE TABLE PERFORMANCE_SCHEMA
161 events_waits_history_long BASE TABLE PERFORMANCE_SCHEMA
162 events_waits_summary_by_account_by_event_name BASE TABLE PERFORMANCE_SCHEMA
163 events_waits_summary_by_host_by_event_name BASE TABLE PERFORMANCE_SCHEMA
164 events_waits_summary_by_instance BASE TABLE PERFORMANCE_SCHEMA
165 events_waits_summary_by_thread_by_event_name BASE TABLE PERFORMANCE_SCHEMA
166 events_waits_summary_by_user_by_event_name BASE TABLE PERFORMANCE_SCHEMA
167 events_waits_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
168 file_instances BASE TABLE PERFORMANCE_SCHEMA
169 file_summary_by_event_name BASE TABLE PERFORMANCE_SCHEMA
170 file_summary_by_instance BASE TABLE PERFORMANCE_SCHEMA
171 global_status BASE TABLE PERFORMANCE_SCHEMA
172 global_variables BASE TABLE PERFORMANCE_SCHEMA
173 host_cache BASE TABLE PERFORMANCE_SCHEMA
174 hosts BASE TABLE PERFORMANCE_SCHEMA
175 innodb_redo_log_files BASE TABLE PERFORMANCE_SCHEMA
176 keyring_component_status BASE TABLE PERFORMANCE_SCHEMA
177 keyring_keys BASE TABLE PERFORMANCE_SCHEMA
178 log_status BASE TABLE PERFORMANCE_SCHEMA
179 memory_summary_by_account_by_event_name BASE TABLE PERFORMANCE_SCHEMA
180 memory_summary_by_host_by_event_name BASE TABLE PERFORMANCE_SCHEMA
181 memory_summary_by_thread_by_event_name BASE TABLE PERFORMANCE_SCHEMA
182 memory_summary_by_user_by_event_name BASE TABLE PERFORMANCE_SCHEMA
183 memory_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
184 metadata_locks BASE TABLE PERFORMANCE_SCHEMA
185 mutex_instances BASE TABLE PERFORMANCE_SCHEMA
186 objects_summary_global_by_type BASE TABLE PERFORMANCE_SCHEMA
187 performance_timers BASE TABLE PERFORMANCE_SCHEMA
188 persisted_variables BASE TABLE PERFORMANCE_SCHEMA
189 prepared_statements_instances BASE TABLE PERFORMANCE_SCHEMA
190 processlist BASE TABLE PERFORMANCE_SCHEMA
191 replication_applier_configuration BASE TABLE PERFORMANCE_SCHEMA
192 replication_applier_filters BASE TABLE PERFORMANCE_SCHEMA
193 replication_applier_global_filters BASE TABLE PERFORMANCE_SCHEMA
194 replication_applier_status BASE TABLE PERFORMANCE_SCHEMA
195 replication_applier_status_by_coordinator BASE TABLE PERFORMANCE_SCHEMA
196 replication_applier_status_by_worker BASE TABLE PERFORMANCE_SCHEMA
197 replication_asynchronous_connection_failover BASE TABLE PERFORMANCE_SCHEMA
198 replication_asynchronous_connection_failover_managed BASE TABLE PERFORMANCE_SCHEMA
199 replication_connection_configuration BASE TABLE PERFORMANCE_SCHEMA
200 replication_connection_status BASE TABLE PERFORMANCE_SCHEMA
201 replication_group_member_stats BASE TABLE PERFORMANCE_SCHEMA
202 replication_group_members BASE TABLE PERFORMANCE_SCHEMA
203 rwlock_instances BASE TABLE PERFORMANCE_SCHEMA
204 session_account_connect_attrs BASE TABLE PERFORMANCE_SCHEMA
205 session_connect_attrs BASE TABLE PERFORMANCE_SCHEMA
206 session_status BASE TABLE PERFORMANCE_SCHEMA
207 session_variables BASE TABLE PERFORMANCE_SCHEMA
208 setup_actors BASE TABLE PERFORMANCE_SCHEMA
209 setup_consumers BASE TABLE PERFORMANCE_SCHEMA
210 setup_instruments BASE TABLE PERFORMANCE_SCHEMA
211 setup_objects BASE TABLE PERFORMANCE_SCHEMA
212 setup_threads BASE TABLE PERFORMANCE_SCHEMA
213 socket_instances BASE TABLE PERFORMANCE_SCHEMA
214 socket_summary_by_event_name BASE TABLE PERFORMANCE_SCHEMA
215 socket_summary_by_instance BASE TABLE PERFORMANCE_SCHEMA
216 status_by_account BASE TABLE PERFORMANCE_SCHEMA
217 status_by_host BASE TABLE PERFORMANCE_SCHEMA
218 status_by_thread BASE TABLE PERFORMANCE_SCHEMA
219 status_by_user BASE TABLE PERFORMANCE_SCHEMA
220 table_handles BASE TABLE PERFORMANCE_SCHEMA
221 table_io_waits_summary_by_index_usage BASE TABLE PERFORMANCE_SCHEMA
222 table_io_waits_summary_by_table BASE TABLE PERFORMANCE_SCHEMA
223 table_lock_waits_summary_by_table BASE TABLE PERFORMANCE_SCHEMA
224 threads BASE TABLE PERFORMANCE_SCHEMA
225 tls_channel_status BASE TABLE PERFORMANCE_SCHEMA
226 user_defined_functions BASE TABLE PERFORMANCE_SCHEMA
227 user_variables_by_thread BASE TABLE PERFORMANCE_SCHEMA
228 users BASE TABLE PERFORMANCE_SCHEMA
229 variables_by_thread BASE TABLE PERFORMANCE_SCHEMA
230 variables_info BASE TABLE PERFORMANCE_SCHEMA
231 select lower(TABLE_NAME), VERSION, ROW_FORMAT
232 from information_schema.tables
233 where TABLE_SCHEMA='performance_schema';
234 lower(TABLE_NAME) VERSION ROW_FORMAT
235 accounts 10 Fixed
236 binary_log_transaction_compression_stats 10 Dynamic
237 cond_instances 10 Dynamic
238 data_lock_waits 10 Dynamic
239 data_locks 10 Dynamic
240 error_log 10 Dynamic
241 events_errors_summary_by_account_by_error 10 Dynamic
242 events_errors_summary_by_host_by_error 10 Dynamic
243 events_errors_summary_by_thread_by_error 10 Dynamic
244 events_errors_summary_by_user_by_error 10 Dynamic
245 events_errors_summary_global_by_error 10 Dynamic
246 events_stages_current 10 Dynamic
247 events_stages_history 10 Dynamic
248 events_stages_history_long 10 Dynamic
249 events_stages_summary_by_account_by_event_name 10 Dynamic
250 events_stages_summary_by_host_by_event_name 10 Dynamic
251 events_stages_summary_by_thread_by_event_name 10 Dynamic
252 events_stages_summary_by_user_by_event_name 10 Dynamic
253 events_stages_summary_global_by_event_name 10 Dynamic
254 events_statements_current 10 Dynamic
255 events_statements_histogram_by_digest 10 Dynamic
256 events_statements_histogram_global 10 Fixed
257 events_statements_history 10 Dynamic
258 events_statements_history_long 10 Dynamic
259 events_statements_summary_by_account_by_event_name 10 Dynamic
260 events_statements_summary_by_digest 10 Dynamic
261 events_statements_summary_by_host_by_event_name 10 Dynamic
262 events_statements_summary_by_program 10 Dynamic
263 events_statements_summary_by_thread_by_event_name 10 Dynamic
264 events_statements_summary_by_user_by_event_name 10 Dynamic
265 events_statements_summary_global_by_event_name 10 Dynamic
266 events_transactions_current 10 Dynamic
267 events_transactions_history 10 Dynamic
268 events_transactions_history_long 10 Dynamic
269 events_transactions_summary_by_account_by_event_name 10 Dynamic
270 events_transactions_summary_by_host_by_event_name 10 Dynamic
271 events_transactions_summary_by_thread_by_event_name 10 Dynamic
272 events_transactions_summary_by_user_by_event_name 10 Dynamic
273 events_transactions_summary_global_by_event_name 10 Dynamic
274 events_waits_current 10 Dynamic
275 events_waits_history 10 Dynamic
276 events_waits_history_long 10 Dynamic
277 events_waits_summary_by_account_by_event_name 10 Dynamic
278 events_waits_summary_by_host_by_event_name 10 Dynamic
279 events_waits_summary_by_instance 10 Dynamic
280 events_waits_summary_by_thread_by_event_name 10 Dynamic
281 events_waits_summary_by_user_by_event_name 10 Dynamic
282 events_waits_summary_global_by_event_name 10 Dynamic
283 file_instances 10 Dynamic
284 file_summary_by_event_name 10 Dynamic
285 file_summary_by_instance 10 Dynamic
286 global_status 10 Dynamic
287 global_variables 10 Dynamic
288 host_cache 10 Dynamic
289 hosts 10 Fixed
290 innodb_redo_log_files 10 Dynamic
291 keyring_component_status 10 Dynamic
292 keyring_keys 10 Dynamic
293 log_status 10 Dynamic
294 memory_summary_by_account_by_event_name 10 Dynamic
295 memory_summary_by_host_by_event_name 10 Dynamic
296 memory_summary_by_thread_by_event_name 10 Dynamic
297 memory_summary_by_user_by_event_name 10 Dynamic
298 memory_summary_global_by_event_name 10 Dynamic
299 metadata_locks 10 Dynamic
300 mutex_instances 10 Dynamic
301 objects_summary_global_by_type 10 Dynamic
302 performance_timers 10 Fixed
303 persisted_variables 10 Dynamic
304 prepared_statements_instances 10 Dynamic
305 processlist 10 Dynamic
306 replication_applier_configuration 10 Dynamic
307 replication_applier_filters 10 Dynamic
308 replication_applier_global_filters 10 Dynamic
309 replication_applier_status 10 Fixed
310 replication_applier_status_by_coordinator 10 Dynamic
311 replication_applier_status_by_worker 10 Dynamic
312 replication_asynchronous_connection_failover 10 Fixed
313 replication_asynchronous_connection_failover_managed 10 Dynamic
314 replication_connection_configuration 10 Dynamic
315 replication_connection_status 10 Dynamic
316 replication_group_member_stats 10 Dynamic
317 replication_group_members 10 Fixed
318 rwlock_instances 10 Dynamic
319 session_account_connect_attrs 10 Dynamic
320 session_connect_attrs 10 Dynamic
321 session_status 10 Dynamic
322 session_variables 10 Dynamic
323 setup_actors 10 Fixed
324 setup_consumers 10 Dynamic
325 setup_instruments 10 Dynamic
326 setup_objects 10 Dynamic
327 setup_threads 10 Dynamic
328 socket_instances 10 Dynamic
329 socket_summary_by_event_name 10 Dynamic
330 socket_summary_by_instance 10 Dynamic
331 status_by_account 10 Dynamic
332 status_by_host 10 Dynamic
333 status_by_thread 10 Dynamic
334 status_by_user 10 Dynamic
335 table_handles 10 Dynamic
336 table_io_waits_summary_by_index_usage 10 Dynamic
337 table_io_waits_summary_by_table 10 Dynamic
338 table_lock_waits_summary_by_table 10 Dynamic
339 threads 10 Dynamic
340 tls_channel_status 10 Dynamic
341 user_defined_functions 10 Dynamic
342 user_variables_by_thread 10 Dynamic
343 users 10 Fixed
344 variables_by_thread 10 Dynamic
345 variables_info 10 Dynamic
346 select lower(TABLE_NAME), AVG_ROW_LENGTH
347 from information_schema.tables
348 where TABLE_SCHEMA='performance_schema' and
349 lower(TABLE_NAME) not regexp '^variables|variables$|^status|session_status|global_status';
350 lower(TABLE_NAME) AVG_ROW_LENGTH
351 accounts 0
352 binary_log_transaction_compression_stats 0
353 cond_instances 0
354 data_lock_waits 0
355 data_locks 0
356 error_log 0
357 events_errors_summary_by_account_by_error 0
358 events_errors_summary_by_host_by_error 0
359 events_errors_summary_by_thread_by_error 0
360 events_errors_summary_by_user_by_error 0
361 events_errors_summary_global_by_error 0
362 events_stages_current 0
363 events_stages_history 0
364 events_stages_history_long 0
365 events_stages_summary_by_account_by_event_name 0
366 events_stages_summary_by_host_by_event_name 0
367 events_stages_summary_by_thread_by_event_name 0
368 events_stages_summary_by_user_by_event_name 0
369 events_stages_summary_global_by_event_name 0
370 events_statements_current 0
371 events_statements_histogram_by_digest 0
372 events_statements_histogram_global 0
373 events_statements_history 0
374 events_statements_history_long 0
375 events_statements_summary_by_account_by_event_name 0
376 events_statements_summary_by_digest 0
377 events_statements_summary_by_host_by_event_name 0
378 events_statements_summary_by_program 0
379 events_statements_summary_by_thread_by_event_name 0
380 events_statements_summary_by_user_by_event_name 0
381 events_statements_summary_global_by_event_name 0
382 events_transactions_current 0
383 events_transactions_history 0
384 events_transactions_history_long 0
385 events_transactions_summary_by_account_by_event_name 0
386 events_transactions_summary_by_host_by_event_name 0
387 events_transactions_summary_by_thread_by_event_name 0
388 events_transactions_summary_by_user_by_event_name 0
389 events_transactions_summary_global_by_event_name 0
390 events_waits_current 0
391 events_waits_history 0
392 events_waits_history_long 0
393 events_waits_summary_by_account_by_event_name 0
394 events_waits_summary_by_host_by_event_name 0
395 events_waits_summary_by_instance 0
396 events_waits_summary_by_thread_by_event_name 0
397 events_waits_summary_by_user_by_event_name 0
398 events_waits_summary_global_by_event_name 0
399 file_instances 0
400 file_summary_by_event_name 0
401 file_summary_by_instance 0
402 host_cache 0
403 hosts 0
404 innodb_redo_log_files 0
405 keyring_component_status 0
406 keyring_keys 0
407 log_status 0
408 memory_summary_by_account_by_event_name 0
409 memory_summary_by_host_by_event_name 0
410 memory_summary_by_thread_by_event_name 0
411 memory_summary_by_user_by_event_name 0
412 memory_summary_global_by_event_name 0
413 metadata_locks 0
414 mutex_instances 0
415 objects_summary_global_by_type 0
416 performance_timers 0
417 prepared_statements_instances 0
418 processlist 0
419 replication_applier_configuration 0
420 replication_applier_filters 0
421 replication_applier_global_filters 0
422 replication_applier_status 0
423 replication_applier_status_by_coordinator 0
424 replication_applier_status_by_worker 0
425 replication_asynchronous_connection_failover 0
426 replication_asynchronous_connection_failover_managed 0
427 replication_connection_configuration 0
428 replication_connection_status 0
429 replication_group_member_stats 0
430 replication_group_members 0
431 rwlock_instances 0
432 session_account_connect_attrs 0
433 session_connect_attrs 0
434 setup_actors 0
435 setup_consumers 0
436 setup_instruments 0
437 setup_objects 0
438 setup_threads 0
439 socket_instances 0
440 socket_summary_by_event_name 0
441 socket_summary_by_instance 0
442 table_handles 0
443 table_io_waits_summary_by_index_usage 0
444 table_io_waits_summary_by_table 0
445 table_lock_waits_summary_by_table 0
446 threads 0
447 tls_channel_status 0
448 user_defined_functions 0
449 user_variables_by_thread 0
450 users 0
451 select lower(TABLE_NAME), TABLE_ROWS, AVG_ROW_LENGTH
452 from information_schema.tables
453 where TABLE_SCHEMA='performance_schema' and
454 lower(TABLE_NAME) regexp '^variables|variables$|^status|session_status|global_status';
455 lower(TABLE_NAME) TABLE_ROWS AVG_ROW_LENGTH
456 global_status table_rows avg_row_len
457 global_variables table_rows avg_row_len
458 persisted_variables table_rows avg_row_len
459 session_status table_rows avg_row_len
460 session_variables table_rows avg_row_len
461 status_by_account table_rows avg_row_len
462 status_by_host table_rows avg_row_len
463 status_by_thread table_rows avg_row_len
464 status_by_user table_rows avg_row_len
465 variables_by_thread table_rows avg_row_len
466 variables_info table_rows avg_row_len
467 select lower(TABLE_NAME), DATA_LENGTH, MAX_DATA_LENGTH
468 from information_schema.tables
469 where TABLE_SCHEMA='performance_schema';
470 lower(TABLE_NAME) DATA_LENGTH MAX_DATA_LENGTH
471 accounts 0 0
472 binary_log_transaction_compression_stats 0 0
473 cond_instances 0 0
474 data_lock_waits 0 0
475 data_locks 0 0
476 error_log 0 0
477 events_errors_summary_by_account_by_error 0 0
478 events_errors_summary_by_host_by_error 0 0
479 events_errors_summary_by_thread_by_error 0 0
480 events_errors_summary_by_user_by_error 0 0
481 events_errors_summary_global_by_error 0 0
482 events_stages_current 0 0
483 events_stages_history 0 0
484 events_stages_history_long 0 0
485 events_stages_summary_by_account_by_event_name 0 0
486 events_stages_summary_by_host_by_event_name 0 0
487 events_stages_summary_by_thread_by_event_name 0 0
488 events_stages_summary_by_user_by_event_name 0 0
489 events_stages_summary_global_by_event_name 0 0
490 events_statements_current 0 0
491 events_statements_histogram_by_digest 0 0
492 events_statements_histogram_global 0 0
493 events_statements_history 0 0
494 events_statements_history_long 0 0
495 events_statements_summary_by_account_by_event_name 0 0
496 events_statements_summary_by_digest 0 0
497 events_statements_summary_by_host_by_event_name 0 0
498 events_statements_summary_by_program 0 0
499 events_statements_summary_by_thread_by_event_name 0 0
500 events_statements_summary_by_user_by_event_name 0 0
501 events_statements_summary_global_by_event_name 0 0
502 events_transactions_current 0 0
503 events_transactions_history 0 0
504 events_transactions_history_long 0 0
505 events_transactions_summary_by_account_by_event_name 0 0
506 events_transactions_summary_by_host_by_event_name 0 0
507 events_transactions_summary_by_thread_by_event_name 0 0
508 events_transactions_summary_by_user_by_event_name 0 0
509 events_transactions_summary_global_by_event_name 0 0
510 events_waits_current 0 0
511 events_waits_history 0 0
512 events_waits_history_long 0 0
513 events_waits_summary_by_account_by_event_name 0 0
514 events_waits_summary_by_host_by_event_name 0 0
515 events_waits_summary_by_instance 0 0
516 events_waits_summary_by_thread_by_event_name 0 0
517 events_waits_summary_by_user_by_event_name 0 0
518 events_waits_summary_global_by_event_name 0 0
519 file_instances 0 0
520 file_summary_by_event_name 0 0
521 file_summary_by_instance 0 0
522 global_status 0 0
523 global_variables 0 0
524 host_cache 0 0
525 hosts 0 0
526 innodb_redo_log_files 0 0
527 keyring_component_status 0 0
528 keyring_keys 0 0
529 log_status 0 0
530 memory_summary_by_account_by_event_name 0 0
531 memory_summary_by_host_by_event_name 0 0
532 memory_summary_by_thread_by_event_name 0 0
533 memory_summary_by_user_by_event_name 0 0
534 memory_summary_global_by_event_name 0 0
535 metadata_locks 0 0
536 mutex_instances 0 0
537 objects_summary_global_by_type 0 0
538 performance_timers 0 0
539 persisted_variables 0 0
540 prepared_statements_instances 0 0
541 processlist 0 0
542 replication_applier_configuration 0 0
543 replication_applier_filters 0 0
544 replication_applier_global_filters 0 0
545 replication_applier_status 0 0
546 replication_applier_status_by_coordinator 0 0
547 replication_applier_status_by_worker 0 0
548 replication_asynchronous_connection_failover 0 0
549 replication_asynchronous_connection_failover_managed 0 0
550 replication_connection_configuration 0 0
551 replication_connection_status 0 0
552 replication_group_member_stats 0 0
553 replication_group_members 0 0
554 rwlock_instances 0 0
555 session_account_connect_attrs 0 0
556 session_connect_attrs 0 0
557 session_status 0 0
558 session_variables 0 0
559 setup_actors 0 0
560 setup_consumers 0 0
561 setup_instruments 0 0
562 setup_objects 0 0
563 setup_threads 0 0
564 socket_instances 0 0
565 socket_summary_by_event_name 0 0
566 socket_summary_by_instance 0 0
567 status_by_account 0 0
568 status_by_host 0 0
569 status_by_thread 0 0
570 status_by_user 0 0
571 table_handles 0 0
572 table_io_waits_summary_by_index_usage 0 0
573 table_io_waits_summary_by_table 0 0
574 table_lock_waits_summary_by_table 0 0
575 threads 0 0
576 tls_channel_status 0 0
577 user_defined_functions 0 0
578 user_variables_by_thread 0 0
579 users 0 0
580 variables_by_thread 0 0
581 variables_info 0 0
582 select lower(TABLE_NAME), INDEX_LENGTH, DATA_FREE, AUTO_INCREMENT
583 from information_schema.tables
584 where TABLE_SCHEMA='performance_schema';
585 lower(TABLE_NAME) INDEX_LENGTH DATA_FREE AUTO_INCREMENT
586 accounts 0 0 NULL
587 binary_log_transaction_compression_stats 0 0 NULL
588 cond_instances 0 0 NULL
589 data_lock_waits 0 0 NULL
590 data_locks 0 0 NULL
591 error_log 0 0 NULL
592 events_errors_summary_by_account_by_error 0 0 NULL
593 events_errors_summary_by_host_by_error 0 0 NULL
594 events_errors_summary_by_thread_by_error 0 0 NULL
595 events_errors_summary_by_user_by_error 0 0 NULL
596 events_errors_summary_global_by_error 0 0 NULL
597 events_stages_current 0 0 NULL
598 events_stages_history 0 0 NULL
599 events_stages_history_long 0 0 NULL
600 events_stages_summary_by_account_by_event_name 0 0 NULL
601 events_stages_summary_by_host_by_event_name 0 0 NULL
602 events_stages_summary_by_thread_by_event_name 0 0 NULL
603 events_stages_summary_by_user_by_event_name 0 0 NULL
604 events_stages_summary_global_by_event_name 0 0 NULL
605 events_statements_current 0 0 NULL
606 events_statements_histogram_by_digest 0 0 NULL
607 events_statements_histogram_global 0 0 NULL
608 events_statements_history 0 0 NULL
609 events_statements_history_long 0 0 NULL
610 events_statements_summary_by_account_by_event_name 0 0 NULL
611 events_statements_summary_by_digest 0 0 NULL
612 events_statements_summary_by_host_by_event_name 0 0 NULL
613 events_statements_summary_by_program 0 0 NULL
614 events_statements_summary_by_thread_by_event_name 0 0 NULL
615 events_statements_summary_by_user_by_event_name 0 0 NULL
616 events_statements_summary_global_by_event_name 0 0 NULL
617 events_transactions_current 0 0 NULL
618 events_transactions_history 0 0 NULL
619 events_transactions_history_long 0 0 NULL
620 events_transactions_summary_by_account_by_event_name 0 0 NULL
621 events_transactions_summary_by_host_by_event_name 0 0 NULL
622 events_transactions_summary_by_thread_by_event_name 0 0 NULL
623 events_transactions_summary_by_user_by_event_name 0 0 NULL
624 events_transactions_summary_global_by_event_name 0 0 NULL
625 events_waits_current 0 0 NULL
626 events_waits_history 0 0 NULL
627 events_waits_history_long 0 0 NULL
628 events_waits_summary_by_account_by_event_name 0 0 NULL
629 events_waits_summary_by_host_by_event_name 0 0 NULL
630 events_waits_summary_by_instance 0 0 NULL
631 events_waits_summary_by_thread_by_event_name 0 0 NULL
632 events_waits_summary_by_user_by_event_name 0 0 NULL
633 events_waits_summary_global_by_event_name 0 0 NULL
634 file_instances 0 0 NULL
635 file_summary_by_event_name 0 0 NULL
636 file_summary_by_instance 0 0 NULL
637 global_status 0 0 NULL
638 global_variables 0 0 NULL
639 host_cache 0 0 NULL
640 hosts 0 0 NULL
641 innodb_redo_log_files 0 0 NULL
642 keyring_component_status 0 0 NULL
643 keyring_keys 0 0 NULL
644 log_status 0 0 NULL
645 memory_summary_by_account_by_event_name 0 0 NULL
646 memory_summary_by_host_by_event_name 0 0 NULL
647 memory_summary_by_thread_by_event_name 0 0 NULL
648 memory_summary_by_user_by_event_name 0 0 NULL
649 memory_summary_global_by_event_name 0 0 NULL
650 metadata_locks 0 0 NULL
651 mutex_instances 0 0 NULL
652 objects_summary_global_by_type 0 0 NULL
653 performance_timers 0 0 NULL
654 persisted_variables 0 0 NULL
655 prepared_statements_instances 0 0 NULL
656 processlist 0 0 NULL
657 replication_applier_configuration 0 0 NULL
658 replication_applier_filters 0 0 NULL
659 replication_applier_global_filters 0 0 NULL
660 replication_applier_status 0 0 NULL
661 replication_applier_status_by_coordinator 0 0 NULL
662 replication_applier_status_by_worker 0 0 NULL
663 replication_asynchronous_connection_failover 0 0 NULL
664 replication_asynchronous_connection_failover_managed 0 0 NULL
665 replication_connection_configuration 0 0 NULL
666 replication_connection_status 0 0 NULL
667 replication_group_member_stats 0 0 NULL
668 replication_group_members 0 0 NULL
669 rwlock_instances 0 0 NULL
670 session_account_connect_attrs 0 0 NULL
671 session_connect_attrs 0 0 NULL
672 session_status 0 0 NULL
673 session_variables 0 0 NULL
674 setup_actors 0 0 NULL
675 setup_consumers 0 0 NULL
676 setup_instruments 0 0 NULL
677 setup_objects 0 0 NULL
678 setup_threads 0 0 NULL
679 socket_instances 0 0 NULL
680 socket_summary_by_event_name 0 0 NULL
681 socket_summary_by_instance 0 0 NULL
682 status_by_account 0 0 NULL
683 status_by_host 0 0 NULL
684 status_by_thread 0 0 NULL
685 status_by_user 0 0 NULL
686 table_handles 0 0 NULL
687 table_io_waits_summary_by_index_usage 0 0 NULL
688 table_io_waits_summary_by_table 0 0 NULL
689 table_lock_waits_summary_by_table 0 0 NULL
690 threads 0 0 NULL
691 tls_channel_status 0 0 NULL
692 user_defined_functions 0 0 NULL
693 user_variables_by_thread 0 0 NULL
694 users 0 0 NULL
695 variables_by_thread 0 0 NULL
696 variables_info 0 0 NULL
697 select lower(TABLE_NAME), CREATE_TIME, UPDATE_TIME, CHECK_TIME
698 from information_schema.tables
699 where TABLE_SCHEMA='performance_schema';
700 lower(TABLE_NAME) CREATE_TIME UPDATE_TIME CHECK_TIME
701 accounts NULL NULL NULL
702 binary_log_transaction_compression_stats NULL NULL NULL
703 cond_instances NULL NULL NULL
704 data_lock_waits NULL NULL NULL
705 data_locks NULL NULL NULL
706 error_log NULL NULL NULL
707 events_errors_summary_by_account_by_error NULL NULL NULL
708 events_errors_summary_by_host_by_error NULL NULL NULL
709 events_errors_summary_by_thread_by_error NULL NULL NULL
710 events_errors_summary_by_user_by_error NULL NULL NULL
711 events_errors_summary_global_by_error NULL NULL NULL
712 events_stages_current NULL NULL NULL
713 events_stages_history NULL NULL NULL
714 events_stages_history_long NULL NULL NULL
715 events_stages_summary_by_account_by_event_name NULL NULL NULL
716 events_stages_summary_by_host_by_event_name NULL NULL NULL
717 events_stages_summary_by_thread_by_event_name NULL NULL NULL
718 events_stages_summary_by_user_by_event_name NULL NULL NULL
719 events_stages_summary_global_by_event_name NULL NULL NULL
720 events_statements_current NULL NULL NULL
721 events_statements_histogram_by_digest NULL NULL NULL
722 events_statements_histogram_global NULL NULL NULL
723 events_statements_history NULL NULL NULL
724 events_statements_history_long NULL NULL NULL
725 events_statements_summary_by_account_by_event_name NULL NULL NULL
726 events_statements_summary_by_digest NULL NULL NULL
727 events_statements_summary_by_host_by_event_name NULL NULL NULL
728 events_statements_summary_by_program NULL NULL NULL
729 events_statements_summary_by_thread_by_event_name NULL NULL NULL
730 events_statements_summary_by_user_by_event_name NULL NULL NULL
731 events_statements_summary_global_by_event_name NULL NULL NULL
732 events_transactions_current NULL NULL NULL
733 events_transactions_history NULL NULL NULL
734 events_transactions_history_long NULL NULL NULL
735 events_transactions_summary_by_account_by_event_name NULL NULL NULL
736 events_transactions_summary_by_host_by_event_name NULL NULL NULL
737 events_transactions_summary_by_thread_by_event_name NULL NULL NULL
738 events_transactions_summary_by_user_by_event_name NULL NULL NULL
739 events_transactions_summary_global_by_event_name NULL NULL NULL
740 events_waits_current NULL NULL NULL
741 events_waits_history NULL NULL NULL
742 events_waits_history_long NULL NULL NULL
743 events_waits_summary_by_account_by_event_name NULL NULL NULL
744 events_waits_summary_by_host_by_event_name NULL NULL NULL
745 events_waits_summary_by_instance NULL NULL NULL
746 events_waits_summary_by_thread_by_event_name NULL NULL NULL
747 events_waits_summary_by_user_by_event_name NULL NULL NULL
748 events_waits_summary_global_by_event_name NULL NULL NULL
749 file_instances NULL NULL NULL
750 file_summary_by_event_name NULL NULL NULL
751 file_summary_by_instance NULL NULL NULL
752 global_status NULL NULL NULL
753 global_variables NULL NULL NULL
754 host_cache NULL NULL NULL
755 hosts NULL NULL NULL
756 innodb_redo_log_files NULL NULL NULL
757 keyring_component_status NULL NULL NULL
758 keyring_keys NULL NULL NULL
759 log_status NULL NULL NULL
760 memory_summary_by_account_by_event_name NULL NULL NULL
761 memory_summary_by_host_by_event_name NULL NULL NULL
762 memory_summary_by_thread_by_event_name NULL NULL NULL
763 memory_summary_by_user_by_event_name NULL NULL NULL
764 memory_summary_global_by_event_name NULL NULL NULL
765 metadata_locks NULL NULL NULL
766 mutex_instances NULL NULL NULL
767 objects_summary_global_by_type NULL NULL NULL
768 performance_timers NULL NULL NULL
769 persisted_variables NULL NULL NULL
770 prepared_statements_instances NULL NULL NULL
771 processlist NULL NULL NULL
772 replication_applier_configuration NULL NULL NULL
773 replication_applier_filters NULL NULL NULL
774 replication_applier_global_filters NULL NULL NULL
775 replication_applier_status NULL NULL NULL
776 replication_applier_status_by_coordinator NULL NULL NULL
777 replication_applier_status_by_worker NULL NULL NULL
778 replication_asynchronous_connection_failover NULL NULL NULL
779 replication_asynchronous_connection_failover_managed NULL NULL NULL
780 replication_connection_configuration NULL NULL NULL
781 replication_connection_status NULL NULL NULL
782 replication_group_member_stats NULL NULL NULL
783 replication_group_members NULL NULL NULL
784 rwlock_instances NULL NULL NULL
785 session_account_connect_attrs NULL NULL NULL
786 session_connect_attrs NULL NULL NULL
787 session_status NULL NULL NULL
788 session_variables NULL NULL NULL
789 setup_actors NULL NULL NULL
790 setup_consumers NULL NULL NULL
791 setup_instruments NULL NULL NULL
792 setup_objects NULL NULL NULL
793 setup_threads NULL NULL NULL
794 socket_instances NULL NULL NULL
795 socket_summary_by_event_name NULL NULL NULL
796 socket_summary_by_instance NULL NULL NULL
797 status_by_account NULL NULL NULL
798 status_by_host NULL NULL NULL
799 status_by_thread NULL NULL NULL
800 status_by_user NULL NULL NULL
801 table_handles NULL NULL NULL
802 table_io_waits_summary_by_index_usage NULL NULL NULL
803 table_io_waits_summary_by_table NULL NULL NULL
804 table_lock_waits_summary_by_table NULL NULL NULL
805 threads NULL NULL NULL
806 tls_channel_status NULL NULL NULL
807 user_defined_functions NULL NULL NULL
808 user_variables_by_thread NULL NULL NULL
809 users NULL NULL NULL
810 variables_by_thread NULL NULL NULL
811 variables_info NULL NULL NULL
812 select lower(TABLE_NAME), TABLE_COLLATION, CHECKSUM
813 from information_schema.tables
814 where TABLE_SCHEMA='performance_schema';
815 lower(TABLE_NAME) TABLE_COLLATION CHECKSUM
816 accounts utf8mb4_0900_ai_ci NULL
817 binary_log_transaction_compression_stats utf8mb4_0900_ai_ci NULL
818 cond_instances utf8mb4_0900_ai_ci NULL
819 data_lock_waits utf8mb4_0900_ai_ci NULL
820 data_locks utf8mb4_0900_ai_ci NULL
821 error_log utf8mb4_0900_ai_ci NULL
822 events_errors_summary_by_account_by_error utf8mb4_0900_ai_ci NULL
823 events_errors_summary_by_host_by_error utf8mb4_0900_ai_ci NULL
824 events_errors_summary_by_thread_by_error utf8mb4_0900_ai_ci NULL
825 events_errors_summary_by_user_by_error utf8mb4_0900_ai_ci NULL
826 events_errors_summary_global_by_error utf8mb4_0900_ai_ci NULL
827 events_stages_current utf8mb4_0900_ai_ci NULL
828 events_stages_history utf8mb4_0900_ai_ci NULL
829 events_stages_history_long utf8mb4_0900_ai_ci NULL
830 events_stages_summary_by_account_by_event_name utf8mb4_0900_ai_ci NULL
831 events_stages_summary_by_host_by_event_name utf8mb4_0900_ai_ci NULL
832 events_stages_summary_by_thread_by_event_name utf8mb4_0900_ai_ci NULL
833 events_stages_summary_by_user_by_event_name utf8mb4_0900_ai_ci NULL
834 events_stages_summary_global_by_event_name utf8mb4_0900_ai_ci NULL
835 events_statements_current utf8mb4_0900_ai_ci NULL
836 events_statements_histogram_by_digest utf8mb4_0900_ai_ci NULL
837 events_statements_histogram_global utf8mb4_0900_ai_ci NULL
838 events_statements_history utf8mb4_0900_ai_ci NULL
839 events_statements_history_long utf8mb4_0900_ai_ci NULL
840 events_statements_summary_by_account_by_event_name utf8mb4_0900_ai_ci NULL
841 events_statements_summary_by_digest utf8mb4_0900_ai_ci NULL
842 events_statements_summary_by_host_by_event_name utf8mb4_0900_ai_ci NULL
843 events_statements_summary_by_program utf8mb4_0900_ai_ci NULL
844 events_statements_summary_by_thread_by_event_name utf8mb4_0900_ai_ci NULL
845 events_statements_summary_by_user_by_event_name utf8mb4_0900_ai_ci NULL
846 events_statements_summary_global_by_event_name utf8mb4_0900_ai_ci NULL
847 events_transactions_current utf8mb4_0900_ai_ci NULL
848 events_transactions_history utf8mb4_0900_ai_ci NULL
849 events_transactions_history_long utf8mb4_0900_ai_ci NULL
850 events_transactions_summary_by_account_by_event_name utf8mb4_0900_ai_ci NULL
851 events_transactions_summary_by_host_by_event_name utf8mb4_0900_ai_ci NULL
852 events_transactions_summary_by_thread_by_event_name utf8mb4_0900_ai_ci NULL
853 events_transactions_summary_by_user_by_event_name utf8mb4_0900_ai_ci NULL
854 events_transactions_summary_global_by_event_name utf8mb4_0900_ai_ci NULL
855 events_waits_current utf8mb4_0900_ai_ci NULL
856 events_waits_history utf8mb4_0900_ai_ci NULL
857 events_waits_history_long utf8mb4_0900_ai_ci NULL
858 events_waits_summary_by_account_by_event_name utf8mb4_0900_ai_ci NULL
859 events_waits_summary_by_host_by_event_name utf8mb4_0900_ai_ci NULL
860 events_waits_summary_by_instance utf8mb4_0900_ai_ci NULL
861 events_waits_summary_by_thread_by_event_name utf8mb4_0900_ai_ci NULL
862 events_waits_summary_by_user_by_event_name utf8mb4_0900_ai_ci NULL
863 events_waits_summary_global_by_event_name utf8mb4_0900_ai_ci NULL
864 file_instances utf8mb4_0900_ai_ci NULL
865 file_summary_by_event_name utf8mb4_0900_ai_ci NULL
866 file_summary_by_instance utf8mb4_0900_ai_ci NULL
867 global_status utf8mb4_0900_ai_ci NULL
868 global_variables utf8mb4_0900_ai_ci NULL
869 host_cache utf8mb4_0900_ai_ci NULL
870 hosts utf8mb4_0900_ai_ci NULL
871 innodb_redo_log_files utf8mb4_0900_ai_ci NULL
872 keyring_component_status utf8mb4_0900_ai_ci NULL
873 keyring_keys utf8mb4_bin NULL
874 log_status utf8mb4_0900_ai_ci NULL
875 memory_summary_by_account_by_event_name utf8mb4_0900_ai_ci NULL
876 memory_summary_by_host_by_event_name utf8mb4_0900_ai_ci NULL
877 memory_summary_by_thread_by_event_name utf8mb4_0900_ai_ci NULL
878 memory_summary_by_user_by_event_name utf8mb4_0900_ai_ci NULL
879 memory_summary_global_by_event_name utf8mb4_0900_ai_ci NULL
880 metadata_locks utf8mb4_0900_ai_ci NULL
881 mutex_instances utf8mb4_0900_ai_ci NULL
882 objects_summary_global_by_type utf8mb4_0900_ai_ci NULL
883 performance_timers utf8mb4_0900_ai_ci NULL
884 persisted_variables utf8mb4_0900_ai_ci NULL
885 prepared_statements_instances utf8mb4_0900_ai_ci NULL
886 processlist utf8mb4_0900_ai_ci NULL
887 replication_applier_configuration utf8mb4_0900_ai_ci NULL
888 replication_applier_filters utf8mb4_0900_ai_ci NULL
889 replication_applier_global_filters utf8mb4_0900_ai_ci NULL
890 replication_applier_status utf8mb4_0900_ai_ci NULL
891 replication_applier_status_by_coordinator utf8mb4_0900_ai_ci NULL
892 replication_applier_status_by_worker utf8mb4_0900_ai_ci NULL
893 replication_asynchronous_connection_failover utf8mb4_0900_ai_ci NULL
894 replication_asynchronous_connection_failover_managed utf8mb4_0900_ai_ci NULL
895 replication_connection_configuration utf8mb4_0900_ai_ci NULL
896 replication_connection_status utf8mb4_0900_ai_ci NULL
897 replication_group_member_stats utf8mb4_0900_ai_ci NULL
898 replication_group_members utf8mb4_0900_ai_ci NULL
899 rwlock_instances utf8mb4_0900_ai_ci NULL
900 session_account_connect_attrs utf8mb4_bin NULL
901 session_connect_attrs utf8mb4_bin NULL
902 session_status utf8mb4_0900_ai_ci NULL
903 session_variables utf8mb4_0900_ai_ci NULL
904 setup_actors utf8mb4_0900_ai_ci NULL
905 setup_consumers utf8mb4_0900_ai_ci NULL
906 setup_instruments utf8mb4_0900_ai_ci NULL
907 setup_objects utf8mb4_0900_ai_ci NULL
908 setup_threads utf8mb4_0900_ai_ci NULL
909 socket_instances utf8mb4_0900_ai_ci NULL
910 socket_summary_by_event_name utf8mb4_0900_ai_ci NULL
911 socket_summary_by_instance utf8mb4_0900_ai_ci NULL
912 status_by_account utf8mb4_0900_ai_ci NULL
913 status_by_host utf8mb4_0900_ai_ci NULL
914 status_by_thread utf8mb4_0900_ai_ci NULL
915 status_by_user utf8mb4_0900_ai_ci NULL
916 table_handles utf8mb4_0900_ai_ci NULL
917 table_io_waits_summary_by_index_usage utf8mb4_0900_ai_ci NULL
918 table_io_waits_summary_by_table utf8mb4_0900_ai_ci NULL
919 table_lock_waits_summary_by_table utf8mb4_0900_ai_ci NULL
920 threads utf8mb4_0900_ai_ci NULL
921 tls_channel_status utf8mb4_0900_ai_ci NULL
922 user_defined_functions utf8mb4_0900_ai_ci NULL
923 user_variables_by_thread utf8mb4_0900_ai_ci NULL
924 users utf8mb4_0900_ai_ci NULL
925 variables_by_thread utf8mb4_0900_ai_ci NULL
926 variables_info utf8mb4_0900_ai_ci NULL
927 select lower(TABLE_NAME), CREATE_OPTIONS
928 from information_schema.tables
929 where TABLE_SCHEMA='performance_schema';
930 lower(TABLE_NAME) CREATE_OPTIONS
931 accounts
932 binary_log_transaction_compression_stats
933 cond_instances
934 data_lock_waits
935 data_locks
936 error_log
937 events_errors_summary_by_account_by_error
938 events_errors_summary_by_host_by_error
939 events_errors_summary_by_thread_by_error
940 events_errors_summary_by_user_by_error
941 events_errors_summary_global_by_error
942 events_stages_current
943 events_stages_history
944 events_stages_history_long
945 events_stages_summary_by_account_by_event_name
946 events_stages_summary_by_host_by_event_name
947 events_stages_summary_by_thread_by_event_name
948 events_stages_summary_by_user_by_event_name
949 events_stages_summary_global_by_event_name
950 events_statements_current
951 events_statements_histogram_by_digest
952 events_statements_histogram_global
953 events_statements_history
954 events_statements_history_long
955 events_statements_summary_by_account_by_event_name
956 events_statements_summary_by_digest
957 events_statements_summary_by_host_by_event_name
958 events_statements_summary_by_program
959 events_statements_summary_by_thread_by_event_name
960 events_statements_summary_by_user_by_event_name
961 events_statements_summary_global_by_event_name
962 events_transactions_current
963 events_transactions_history
964 events_transactions_history_long
965 events_transactions_summary_by_account_by_event_name
966 events_transactions_summary_by_host_by_event_name
967 events_transactions_summary_by_thread_by_event_name
968 events_transactions_summary_by_user_by_event_name
969 events_transactions_summary_global_by_event_name
970 events_waits_current
971 events_waits_history
972 events_waits_history_long
973 events_waits_summary_by_account_by_event_name
974 events_waits_summary_by_host_by_event_name
975 events_waits_summary_by_instance
976 events_waits_summary_by_thread_by_event_name
977 events_waits_summary_by_user_by_event_name
978 events_waits_summary_global_by_event_name
979 file_instances
980 file_summary_by_event_name
981 file_summary_by_instance
982 global_status
983 global_variables
984 host_cache
985 hosts
986 innodb_redo_log_files
987 keyring_component_status
988 keyring_keys
989 log_status
990 memory_summary_by_account_by_event_name
991 memory_summary_by_host_by_event_name
992 memory_summary_by_thread_by_event_name
993 memory_summary_by_user_by_event_name
994 memory_summary_global_by_event_name
995 metadata_locks
996 mutex_instances
997 objects_summary_global_by_type
998 performance_timers
999 persisted_variables
1000 prepared_statements_instances
1001 processlist
1002 replication_applier_configuration
1003 replication_applier_filters
1004 replication_applier_global_filters
1005 replication_applier_status
1006 replication_applier_status_by_coordinator
1007 replication_applier_status_by_worker
1008 replication_asynchronous_connection_failover
1009 replication_asynchronous_connection_failover_managed
1010 replication_connection_configuration
1011 replication_connection_status
1012 replication_group_member_stats
1013 replication_group_members
1014 rwlock_instances
1015 session_account_connect_attrs
1016 session_connect_attrs
1017 session_status
1018 session_variables
1019 setup_actors
1020 setup_consumers
1021 setup_instruments
1022 setup_objects
1023 setup_threads
1024 socket_instances
1025 socket_summary_by_event_name
1026 socket_summary_by_instance
1027 status_by_account
1028 status_by_host
1029 status_by_thread
1030 status_by_user
1031 table_handles
1032 table_io_waits_summary_by_index_usage
1033 table_io_waits_summary_by_table
1034 table_lock_waits_summary_by_table
1035 threads
1036 tls_channel_status
1037 user_defined_functions
1038 user_variables_by_thread
1039 users
1040 variables_by_thread
1041 variables_info
1042 select lower(TABLE_NAME), TABLE_COMMENT
1043 from information_schema.tables
1044 where TABLE_SCHEMA='performance_schema';
1045 lower(TABLE_NAME) TABLE_COMMENT
1046 accounts
1047 binary_log_transaction_compression_stats
1048 cond_instances
1049 data_lock_waits
1050 data_locks
1051 error_log
1052 events_errors_summary_by_account_by_error
1053 events_errors_summary_by_host_by_error
1054 events_errors_summary_by_thread_by_error
1055 events_errors_summary_by_user_by_error
1056 events_errors_summary_global_by_error
1057 events_stages_current
1058 events_stages_history
1059 events_stages_history_long
1060 events_stages_summary_by_account_by_event_name
1061 events_stages_summary_by_host_by_event_name
1062 events_stages_summary_by_thread_by_event_name
1063 events_stages_summary_by_user_by_event_name
1064 events_stages_summary_global_by_event_name
1065 events_statements_current
1066 events_statements_histogram_by_digest
1067 events_statements_histogram_global
1068 events_statements_history
1069 events_statements_history_long
1070 events_statements_summary_by_account_by_event_name
1071 events_statements_summary_by_digest
1072 events_statements_summary_by_host_by_event_name
1073 events_statements_summary_by_program
1074 events_statements_summary_by_thread_by_event_name
1075 events_statements_summary_by_user_by_event_name
1076 events_statements_summary_global_by_event_name
1077 events_transactions_current
1078 events_transactions_history
1079 events_transactions_history_long
1080 events_transactions_summary_by_account_by_event_name
1081 events_transactions_summary_by_host_by_event_name
1082 events_transactions_summary_by_thread_by_event_name
1083 events_transactions_summary_by_user_by_event_name
1084 events_transactions_summary_global_by_event_name
1085 events_waits_current
1086 events_waits_history
1087 events_waits_history_long
1088 events_waits_summary_by_account_by_event_name
1089 events_waits_summary_by_host_by_event_name
1090 events_waits_summary_by_instance
1091 events_waits_summary_by_thread_by_event_name
1092 events_waits_summary_by_user_by_event_name
1093 events_waits_summary_global_by_event_name
1094 file_instances
1095 file_summary_by_event_name
1096 file_summary_by_instance
1097 global_status
1098 global_variables
1099 host_cache
1100 hosts
1101 innodb_redo_log_files
1102 keyring_component_status
1103 keyring_keys
1104 log_status
1105 memory_summary_by_account_by_event_name
1106 memory_summary_by_host_by_event_name
1107 memory_summary_by_thread_by_event_name
1108 memory_summary_by_user_by_event_name
1109 memory_summary_global_by_event_name
1110 metadata_locks
1111 mutex_instances
1112 objects_summary_global_by_type
1113 performance_timers
1114 persisted_variables
1115 prepared_statements_instances
1116 processlist
1117 replication_applier_configuration
1118 replication_applier_filters
1119 replication_applier_global_filters
1120 replication_applier_status
1121 replication_applier_status_by_coordinator
1122 replication_applier_status_by_worker
1123 replication_asynchronous_connection_failover
1124 replication_asynchronous_connection_failover_managed
1125 replication_connection_configuration
1126 replication_connection_status
1127 replication_group_member_stats
1128 replication_group_members
1129 rwlock_instances
1130 session_account_connect_attrs
1131 session_connect_attrs
1132 session_status
1133 session_variables
1134 setup_actors
1135 setup_consumers
1136 setup_instruments
1137 setup_objects
1138 setup_threads
1139 socket_instances
1140 socket_summary_by_event_name
1141 socket_summary_by_instance
1142 status_by_account
1143 status_by_host
1144 status_by_thread
1145 status_by_user
1146 table_handles
1147 table_io_waits_summary_by_index_usage
1148 table_io_waits_summary_by_table
1149 table_lock_waits_summary_by_table
1150 threads
1151 tls_channel_status
1152 user_defined_functions
1153 user_variables_by_thread
1154 users
1155 variables_by_thread
1156 variables_info