path: root/mysql-test/suite/perfschema/r/information_schema.result

select TABLE_SCHEMA, lower(TABLE_NAME), TABLE_CATALOG
from information_schema.tables
where TABLE_SCHEMA='performance_schema'
  order by table_name;
TABLE_SCHEMA	lower(TABLE_NAME)	TABLE_CATALOG
performance_schema	accounts	def
performance_schema	cond_instances	def
performance_schema	events_stages_current	def
performance_schema	events_stages_history	def
performance_schema	events_stages_history_long	def
performance_schema	events_stages_summary_by_account_by_event_name	def
performance_schema	events_stages_summary_by_host_by_event_name	def
performance_schema	events_stages_summary_by_thread_by_event_name	def
performance_schema	events_stages_summary_by_user_by_event_name	def
performance_schema	events_stages_summary_global_by_event_name	def
performance_schema	events_statements_current	def
performance_schema	events_statements_history	def
performance_schema	events_statements_history_long	def
performance_schema	events_statements_summary_by_account_by_event_name	def
performance_schema	events_statements_summary_by_digest	def
performance_schema	events_statements_summary_by_host_by_event_name	def
performance_schema	events_statements_summary_by_program	def
performance_schema	events_statements_summary_by_thread_by_event_name	def
performance_schema	events_statements_summary_by_user_by_event_name	def
performance_schema	events_statements_summary_global_by_event_name	def
performance_schema	events_transactions_current	def
performance_schema	events_transactions_history	def
performance_schema	events_transactions_history_long	def
performance_schema	events_transactions_summary_by_account_by_event_name	def
performance_schema	events_transactions_summary_by_host_by_event_name	def
performance_schema	events_transactions_summary_by_thread_by_event_name	def
performance_schema	events_transactions_summary_by_user_by_event_name	def
performance_schema	events_transactions_summary_global_by_event_name	def
performance_schema	events_waits_current	def
performance_schema	events_waits_history	def
performance_schema	events_waits_history_long	def
performance_schema	events_waits_summary_by_account_by_event_name	def
performance_schema	events_waits_summary_by_host_by_event_name	def
performance_schema	events_waits_summary_by_instance	def
performance_schema	events_waits_summary_by_thread_by_event_name	def
performance_schema	events_waits_summary_by_user_by_event_name	def
performance_schema	events_waits_summary_global_by_event_name	def
performance_schema	file_instances	def
performance_schema	file_summary_by_event_name	def
performance_schema	file_summary_by_instance	def
performance_schema	global_status	def
performance_schema	hosts	def
performance_schema	host_cache	def
performance_schema	memory_summary_by_account_by_event_name	def
performance_schema	memory_summary_by_host_by_event_name	def
performance_schema	memory_summary_by_thread_by_event_name	def
performance_schema	memory_summary_by_user_by_event_name	def
performance_schema	memory_summary_global_by_event_name	def
performance_schema	metadata_locks	def
performance_schema	mutex_instances	def
performance_schema	objects_summary_global_by_type	def
performance_schema	performance_timers	def
performance_schema	prepared_statements_instances	def
performance_schema	replication_applier_configuration	def
performance_schema	replication_applier_status	def
performance_schema	replication_applier_status_by_coordinator	def
performance_schema	replication_applier_status_by_worker	def
performance_schema	replication_connection_configuration	def
performance_schema	rwlock_instances	def
performance_schema	session_account_connect_attrs	def
performance_schema	session_connect_attrs	def
performance_schema	session_status	def
performance_schema	setup_actors	def
performance_schema	setup_consumers	def
performance_schema	setup_instruments	def
performance_schema	setup_objects	def
performance_schema	setup_timers	def
performance_schema	socket_instances	def
performance_schema	socket_summary_by_event_name	def
performance_schema	socket_summary_by_instance	def
performance_schema	status_by_account	def
performance_schema	status_by_host	def
performance_schema	status_by_thread	def
performance_schema	status_by_user	def
performance_schema	table_handles	def
performance_schema	table_io_waits_summary_by_index_usage	def
performance_schema	table_io_waits_summary_by_table	def
performance_schema	table_lock_waits_summary_by_table	def
performance_schema	threads	def
performance_schema	users	def
performance_schema	user_variables_by_thread	def
select lower(TABLE_NAME), TABLE_TYPE, ENGINE
from information_schema.tables
where TABLE_SCHEMA='performance_schema'
  order by table_name;
lower(TABLE_NAME)	TABLE_TYPE	ENGINE
accounts	BASE TABLE	PERFORMANCE_SCHEMA
cond_instances	BASE TABLE	PERFORMANCE_SCHEMA
events_stages_current	BASE TABLE	PERFORMANCE_SCHEMA
events_stages_history	BASE TABLE	PERFORMANCE_SCHEMA
events_stages_history_long	BASE TABLE	PERFORMANCE_SCHEMA
events_stages_summary_by_account_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_stages_summary_by_host_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_stages_summary_by_thread_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_stages_summary_by_user_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_stages_summary_global_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_statements_current	BASE TABLE	PERFORMANCE_SCHEMA
events_statements_history	BASE TABLE	PERFORMANCE_SCHEMA
events_statements_history_long	BASE TABLE	PERFORMANCE_SCHEMA
events_statements_summary_by_account_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_statements_summary_by_digest	BASE TABLE	PERFORMANCE_SCHEMA
events_statements_summary_by_host_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_statements_summary_by_program	BASE TABLE	PERFORMANCE_SCHEMA
events_statements_summary_by_thread_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_statements_summary_by_user_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_statements_summary_global_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_transactions_current	BASE TABLE	PERFORMANCE_SCHEMA
events_transactions_history	BASE TABLE	PERFORMANCE_SCHEMA
events_transactions_history_long	BASE TABLE	PERFORMANCE_SCHEMA
events_transactions_summary_by_account_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_transactions_summary_by_host_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_transactions_summary_by_thread_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_transactions_summary_by_user_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_transactions_summary_global_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_waits_current	BASE TABLE	PERFORMANCE_SCHEMA
events_waits_history	BASE TABLE	PERFORMANCE_SCHEMA
events_waits_history_long	BASE TABLE	PERFORMANCE_SCHEMA
events_waits_summary_by_account_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_waits_summary_by_host_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_waits_summary_by_instance	BASE TABLE	PERFORMANCE_SCHEMA
events_waits_summary_by_thread_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_waits_summary_by_user_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
events_waits_summary_global_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
file_instances	BASE TABLE	PERFORMANCE_SCHEMA
file_summary_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
file_summary_by_instance	BASE TABLE	PERFORMANCE_SCHEMA
global_status	BASE TABLE	PERFORMANCE_SCHEMA
hosts	BASE TABLE	PERFORMANCE_SCHEMA
host_cache	BASE TABLE	PERFORMANCE_SCHEMA
memory_summary_by_account_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
memory_summary_by_host_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
memory_summary_by_thread_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
memory_summary_by_user_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
memory_summary_global_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
metadata_locks	BASE TABLE	PERFORMANCE_SCHEMA
mutex_instances	BASE TABLE	PERFORMANCE_SCHEMA
objects_summary_global_by_type	BASE TABLE	PERFORMANCE_SCHEMA
performance_timers	BASE TABLE	PERFORMANCE_SCHEMA
prepared_statements_instances	BASE TABLE	PERFORMANCE_SCHEMA
replication_applier_configuration	BASE TABLE	PERFORMANCE_SCHEMA
replication_applier_status	BASE TABLE	PERFORMANCE_SCHEMA
replication_applier_status_by_coordinator	BASE TABLE	PERFORMANCE_SCHEMA
replication_applier_status_by_worker	BASE TABLE	PERFORMANCE_SCHEMA
replication_connection_configuration	BASE TABLE	PERFORMANCE_SCHEMA
rwlock_instances	BASE TABLE	PERFORMANCE_SCHEMA
session_account_connect_attrs	BASE TABLE	PERFORMANCE_SCHEMA
session_connect_attrs	BASE TABLE	PERFORMANCE_SCHEMA
session_status	BASE TABLE	PERFORMANCE_SCHEMA
setup_actors	BASE TABLE	PERFORMANCE_SCHEMA
setup_consumers	BASE TABLE	PERFORMANCE_SCHEMA
setup_instruments	BASE TABLE	PERFORMANCE_SCHEMA
setup_objects	BASE TABLE	PERFORMANCE_SCHEMA
setup_timers	BASE TABLE	PERFORMANCE_SCHEMA
socket_instances	BASE TABLE	PERFORMANCE_SCHEMA
socket_summary_by_event_name	BASE TABLE	PERFORMANCE_SCHEMA
socket_summary_by_instance	BASE TABLE	PERFORMANCE_SCHEMA
status_by_account	BASE TABLE	PERFORMANCE_SCHEMA
status_by_host	BASE TABLE	PERFORMANCE_SCHEMA
status_by_thread	BASE TABLE	PERFORMANCE_SCHEMA
status_by_user	BASE TABLE	PERFORMANCE_SCHEMA
table_handles	BASE TABLE	PERFORMANCE_SCHEMA
table_io_waits_summary_by_index_usage	BASE TABLE	PERFORMANCE_SCHEMA
table_io_waits_summary_by_table	BASE TABLE	PERFORMANCE_SCHEMA
table_lock_waits_summary_by_table	BASE TABLE	PERFORMANCE_SCHEMA
threads	BASE TABLE	PERFORMANCE_SCHEMA
users	BASE TABLE	PERFORMANCE_SCHEMA
user_variables_by_thread	BASE TABLE	PERFORMANCE_SCHEMA
select lower(TABLE_NAME), VERSION, ROW_FORMAT
from information_schema.tables
where TABLE_SCHEMA='performance_schema'
  order by table_name;
lower(TABLE_NAME)	VERSION	ROW_FORMAT
accounts	10	Fixed
cond_instances	10	Dynamic
events_stages_current	10	Dynamic
events_stages_history	10	Dynamic
events_stages_history_long	10	Dynamic
events_stages_summary_by_account_by_event_name	10	Dynamic
events_stages_summary_by_host_by_event_name	10	Dynamic
events_stages_summary_by_thread_by_event_name	10	Dynamic
events_stages_summary_by_user_by_event_name	10	Dynamic
events_stages_summary_global_by_event_name	10	Dynamic
events_statements_current	10	Dynamic
events_statements_history	10	Dynamic
events_statements_history_long	10	Dynamic
events_statements_summary_by_account_by_event_name	10	Dynamic
events_statements_summary_by_digest	10	Dynamic
events_statements_summary_by_host_by_event_name	10	Dynamic
events_statements_summary_by_program	10	Dynamic
events_statements_summary_by_thread_by_event_name	10	Dynamic
events_statements_summary_by_user_by_event_name	10	Dynamic
events_statements_summary_global_by_event_name	10	Dynamic
events_transactions_current	10	Dynamic
events_transactions_history	10	Dynamic
events_transactions_history_long	10	Dynamic
events_transactions_summary_by_account_by_event_name	10	Dynamic
events_transactions_summary_by_host_by_event_name	10	Dynamic
events_transactions_summary_by_thread_by_event_name	10	Dynamic
events_transactions_summary_by_user_by_event_name	10	Dynamic
events_transactions_summary_global_by_event_name	10	Dynamic
events_waits_current	10	Dynamic
events_waits_history	10	Dynamic
events_waits_history_long	10	Dynamic
events_waits_summary_by_account_by_event_name	10	Dynamic
events_waits_summary_by_host_by_event_name	10	Dynamic
events_waits_summary_by_instance	10	Dynamic
events_waits_summary_by_thread_by_event_name	10	Dynamic
events_waits_summary_by_user_by_event_name	10	Dynamic
events_waits_summary_global_by_event_name	10	Dynamic
file_instances	10	Dynamic
file_summary_by_event_name	10	Dynamic
file_summary_by_instance	10	Dynamic
global_status	10	Dynamic
hosts	10	Fixed
host_cache	10	Dynamic
memory_summary_by_account_by_event_name	10	Dynamic
memory_summary_by_host_by_event_name	10	Dynamic
memory_summary_by_thread_by_event_name	10	Dynamic
memory_summary_by_user_by_event_name	10	Dynamic
memory_summary_global_by_event_name	10	Dynamic
metadata_locks	10	Dynamic
mutex_instances	10	Dynamic
objects_summary_global_by_type	10	Dynamic
performance_timers	10	Fixed
prepared_statements_instances	10	Dynamic
replication_applier_configuration	10	Dynamic
replication_applier_status	10	Dynamic
replication_applier_status_by_coordinator	10	Dynamic
replication_applier_status_by_worker	10	Dynamic
replication_connection_configuration	10	Dynamic
rwlock_instances	10	Dynamic
session_account_connect_attrs	10	Dynamic
session_connect_attrs	10	Dynamic
session_status	10	Dynamic
setup_actors	10	Fixed
setup_consumers	10	Dynamic
setup_instruments	10	Dynamic
setup_objects	10	Dynamic
setup_timers	10	Dynamic
socket_instances	10	Dynamic
socket_summary_by_event_name	10	Dynamic
socket_summary_by_instance	10	Dynamic
status_by_account	10	Dynamic
status_by_host	10	Dynamic
status_by_thread	10	Dynamic
status_by_user	10	Dynamic
table_handles	10	Dynamic
table_io_waits_summary_by_index_usage	10	Dynamic
table_io_waits_summary_by_table	10	Dynamic
table_lock_waits_summary_by_table	10	Dynamic
threads	10	Dynamic
users	10	Fixed
user_variables_by_thread	10	Dynamic
select lower(TABLE_NAME), AVG_ROW_LENGTH
from information_schema.tables
where TABLE_SCHEMA='performance_schema' and
lower(TABLE_NAME) not regexp '^variables|variables$|^status|session_status|global_status'
  order by table_name;
lower(TABLE_NAME)	AVG_ROW_LENGTH
accounts	0
cond_instances	0
events_stages_current	0
events_stages_history	0
events_stages_history_long	0
events_stages_summary_by_account_by_event_name	0
events_stages_summary_by_host_by_event_name	0
events_stages_summary_by_thread_by_event_name	0
events_stages_summary_by_user_by_event_name	0
events_stages_summary_global_by_event_name	0
events_statements_current	0
events_statements_history	0
events_statements_history_long	0
events_statements_summary_by_account_by_event_name	0
events_statements_summary_by_digest	0
events_statements_summary_by_host_by_event_name	0
events_statements_summary_by_program	0
events_statements_summary_by_thread_by_event_name	0
events_statements_summary_by_user_by_event_name	0
events_statements_summary_global_by_event_name	0
events_transactions_current	0
events_transactions_history	0
events_transactions_history_long	0
events_transactions_summary_by_account_by_event_name	0
events_transactions_summary_by_host_by_event_name	0
events_transactions_summary_by_thread_by_event_name	0
events_transactions_summary_by_user_by_event_name	0
events_transactions_summary_global_by_event_name	0
events_waits_current	0
events_waits_history	0
events_waits_history_long	0
events_waits_summary_by_account_by_event_name	0
events_waits_summary_by_host_by_event_name	0
events_waits_summary_by_instance	0
events_waits_summary_by_thread_by_event_name	0
events_waits_summary_by_user_by_event_name	0
events_waits_summary_global_by_event_name	0
file_instances	0
file_summary_by_event_name	0
file_summary_by_instance	0
hosts	0
host_cache	0
memory_summary_by_account_by_event_name	0
memory_summary_by_host_by_event_name	0
memory_summary_by_thread_by_event_name	0
memory_summary_by_user_by_event_name	0
memory_summary_global_by_event_name	0
metadata_locks	0
mutex_instances	0
objects_summary_global_by_type	0
performance_timers	0
prepared_statements_instances	0
replication_applier_configuration	0
replication_applier_status	0
replication_applier_status_by_coordinator	0
replication_applier_status_by_worker	0
replication_connection_configuration	0
rwlock_instances	0
session_account_connect_attrs	0
session_connect_attrs	0
setup_actors	0
setup_consumers	0
setup_instruments	0
setup_objects	0
setup_timers	0
socket_instances	0
socket_summary_by_event_name	0
socket_summary_by_instance	0
table_handles	0
table_io_waits_summary_by_index_usage	0
table_io_waits_summary_by_table	0
table_lock_waits_summary_by_table	0
threads	0
users	0
user_variables_by_thread	0
select lower(TABLE_NAME), TABLE_ROWS, AVG_ROW_LENGTH
from information_schema.tables
where TABLE_SCHEMA='performance_schema' and
lower(TABLE_NAME) regexp '^variables|variables$|^status|session_status|global_status'
  order by table_name;
lower(TABLE_NAME)	TABLE_ROWS	AVG_ROW_LENGTH
global_status	table_rows	avg_row_len
session_status	table_rows	avg_row_len
status_by_account	table_rows	avg_row_len
status_by_host	table_rows	avg_row_len
status_by_thread	table_rows	avg_row_len
status_by_user	table_rows	avg_row_len
select lower(TABLE_NAME), DATA_LENGTH, MAX_DATA_LENGTH
from information_schema.tables
where TABLE_SCHEMA='performance_schema'
  order by table_name;
lower(TABLE_NAME)	DATA_LENGTH	MAX_DATA_LENGTH
accounts	0	0
cond_instances	0	0
events_stages_current	0	0
events_stages_history	0	0
events_stages_history_long	0	0
events_stages_summary_by_account_by_event_name	0	0
events_stages_summary_by_host_by_event_name	0	0
events_stages_summary_by_thread_by_event_name	0	0
events_stages_summary_by_user_by_event_name	0	0
events_stages_summary_global_by_event_name	0	0
events_statements_current	0	0
events_statements_history	0	0
events_statements_history_long	0	0
events_statements_summary_by_account_by_event_name	0	0
events_statements_summary_by_digest	0	0
events_statements_summary_by_host_by_event_name	0	0
events_statements_summary_by_program	0	0
events_statements_summary_by_thread_by_event_name	0	0
events_statements_summary_by_user_by_event_name	0	0
events_statements_summary_global_by_event_name	0	0
events_transactions_current	0	0
events_transactions_history	0	0
events_transactions_history_long	0	0
events_transactions_summary_by_account_by_event_name	0	0
events_transactions_summary_by_host_by_event_name	0	0
events_transactions_summary_by_thread_by_event_name	0	0
events_transactions_summary_by_user_by_event_name	0	0
events_transactions_summary_global_by_event_name	0	0
events_waits_current	0	0
events_waits_history	0	0
events_waits_history_long	0	0
events_waits_summary_by_account_by_event_name	0	0
events_waits_summary_by_host_by_event_name	0	0
events_waits_summary_by_instance	0	0
events_waits_summary_by_thread_by_event_name	0	0
events_waits_summary_by_user_by_event_name	0	0
events_waits_summary_global_by_event_name	0	0
file_instances	0	0
file_summary_by_event_name	0	0
file_summary_by_instance	0	0
global_status	0	0
hosts	0	0
host_cache	0	0
memory_summary_by_account_by_event_name	0	0
memory_summary_by_host_by_event_name	0	0
memory_summary_by_thread_by_event_name	0	0
memory_summary_by_user_by_event_name	0	0
memory_summary_global_by_event_name	0	0
metadata_locks	0	0
mutex_instances	0	0
objects_summary_global_by_type	0	0
performance_timers	0	0
prepared_statements_instances	0	0
replication_applier_configuration	0	0
replication_applier_status	0	0
replication_applier_status_by_coordinator	0	0
replication_applier_status_by_worker	0	0
replication_connection_configuration	0	0
rwlock_instances	0	0
session_account_connect_attrs	0	0
session_connect_attrs	0	0
session_status	0	0
setup_actors	0	0
setup_consumers	0	0
setup_instruments	0	0
setup_objects	0	0
setup_timers	0	0
socket_instances	0	0
socket_summary_by_event_name	0	0
socket_summary_by_instance	0	0
status_by_account	0	0
status_by_host	0	0
status_by_thread	0	0
status_by_user	0	0
table_handles	0	0
table_io_waits_summary_by_index_usage	0	0
table_io_waits_summary_by_table	0	0
table_lock_waits_summary_by_table	0	0
threads	0	0
users	0	0
user_variables_by_thread	0	0
select lower(TABLE_NAME), INDEX_LENGTH, DATA_FREE, AUTO_INCREMENT
from information_schema.tables
where TABLE_SCHEMA='performance_schema'
  order by table_name;
lower(TABLE_NAME)	INDEX_LENGTH	DATA_FREE	AUTO_INCREMENT
accounts	0	0	NULL
cond_instances	0	0	NULL
events_stages_current	0	0	NULL
events_stages_history	0	0	NULL
events_stages_history_long	0	0	NULL
events_stages_summary_by_account_by_event_name	0	0	NULL
events_stages_summary_by_host_by_event_name	0	0	NULL
events_stages_summary_by_thread_by_event_name	0	0	NULL
events_stages_summary_by_user_by_event_name	0	0	NULL
events_stages_summary_global_by_event_name	0	0	NULL
events_statements_current	0	0	NULL
events_statements_history	0	0	NULL
events_statements_history_long	0	0	NULL
events_statements_summary_by_account_by_event_name	0	0	NULL
events_statements_summary_by_digest	0	0	NULL
events_statements_summary_by_host_by_event_name	0	0	NULL
events_statements_summary_by_program	0	0	NULL
events_statements_summary_by_thread_by_event_name	0	0	NULL
events_statements_summary_by_user_by_event_name	0	0	NULL
events_statements_summary_global_by_event_name	0	0	NULL
events_transactions_current	0	0	NULL
events_transactions_history	0	0	NULL
events_transactions_history_long	0	0	NULL
events_transactions_summary_by_account_by_event_name	0	0	NULL
events_transactions_summary_by_host_by_event_name	0	0	NULL
events_transactions_summary_by_thread_by_event_name	0	0	NULL
events_transactions_summary_by_user_by_event_name	0	0	NULL
events_transactions_summary_global_by_event_name	0	0	NULL
events_waits_current	0	0	NULL
events_waits_history	0	0	NULL
events_waits_history_long	0	0	NULL
events_waits_summary_by_account_by_event_name	0	0	NULL
events_waits_summary_by_host_by_event_name	0	0	NULL
events_waits_summary_by_instance	0	0	NULL
events_waits_summary_by_thread_by_event_name	0	0	NULL
events_waits_summary_by_user_by_event_name	0	0	NULL
events_waits_summary_global_by_event_name	0	0	NULL
file_instances	0	0	NULL
file_summary_by_event_name	0	0	NULL
file_summary_by_instance	0	0	NULL
global_status	0	0	NULL
hosts	0	0	NULL
host_cache	0	0	NULL
memory_summary_by_account_by_event_name	0	0	NULL
memory_summary_by_host_by_event_name	0	0	NULL
memory_summary_by_thread_by_event_name	0	0	NULL
memory_summary_by_user_by_event_name	0	0	NULL
memory_summary_global_by_event_name	0	0	NULL
metadata_locks	0	0	NULL
mutex_instances	0	0	NULL
objects_summary_global_by_type	0	0	NULL
performance_timers	0	0	NULL
prepared_statements_instances	0	0	NULL
replication_applier_configuration	0	0	NULL
replication_applier_status	0	0	NULL
replication_applier_status_by_coordinator	0	0	NULL
replication_applier_status_by_worker	0	0	NULL
replication_connection_configuration	0	0	NULL
rwlock_instances	0	0	NULL
session_account_connect_attrs	0	0	NULL
session_connect_attrs	0	0	NULL
session_status	0	0	NULL
setup_actors	0	0	NULL
setup_consumers	0	0	NULL
setup_instruments	0	0	NULL
setup_objects	0	0	NULL
setup_timers	0	0	NULL
socket_instances	0	0	NULL
socket_summary_by_event_name	0	0	NULL
socket_summary_by_instance	0	0	NULL
status_by_account	0	0	NULL
status_by_host	0	0	NULL
status_by_thread	0	0	NULL
status_by_user	0	0	NULL
table_handles	0	0	NULL
table_io_waits_summary_by_index_usage	0	0	NULL
table_io_waits_summary_by_table	0	0	NULL
table_lock_waits_summary_by_table	0	0	NULL
threads	0	0	NULL
users	0	0	NULL
user_variables_by_thread	0	0	NULL
select lower(TABLE_NAME), CREATE_TIME, UPDATE_TIME, CHECK_TIME
from information_schema.tables
where TABLE_SCHEMA='performance_schema'
  order by table_name;
lower(TABLE_NAME)	CREATE_TIME	UPDATE_TIME	CHECK_TIME
accounts	NULL	NULL	NULL
cond_instances	NULL	NULL	NULL
events_stages_current	NULL	NULL	NULL
events_stages_history	NULL	NULL	NULL
events_stages_history_long	NULL	NULL	NULL
events_stages_summary_by_account_by_event_name	NULL	NULL	NULL
events_stages_summary_by_host_by_event_name	NULL	NULL	NULL
events_stages_summary_by_thread_by_event_name	NULL	NULL	NULL
events_stages_summary_by_user_by_event_name	NULL	NULL	NULL
events_stages_summary_global_by_event_name	NULL	NULL	NULL
events_statements_current	NULL	NULL	NULL
events_statements_history	NULL	NULL	NULL
events_statements_history_long	NULL	NULL	NULL
events_statements_summary_by_account_by_event_name	NULL	NULL	NULL
events_statements_summary_by_digest	NULL	NULL	NULL
events_statements_summary_by_host_by_event_name	NULL	NULL	NULL
events_statements_summary_by_program	NULL	NULL	NULL
events_statements_summary_by_thread_by_event_name	NULL	NULL	NULL
events_statements_summary_by_user_by_event_name	NULL	NULL	NULL
events_statements_summary_global_by_event_name	NULL	NULL	NULL
events_transactions_current	NULL	NULL	NULL
events_transactions_history	NULL	NULL	NULL
events_transactions_history_long	NULL	NULL	NULL
events_transactions_summary_by_account_by_event_name	NULL	NULL	NULL
events_transactions_summary_by_host_by_event_name	NULL	NULL	NULL
events_transactions_summary_by_thread_by_event_name	NULL	NULL	NULL
events_transactions_summary_by_user_by_event_name	NULL	NULL	NULL
events_transactions_summary_global_by_event_name	NULL	NULL	NULL
events_waits_current	NULL	NULL	NULL
events_waits_history	NULL	NULL	NULL
events_waits_history_long	NULL	NULL	NULL
events_waits_summary_by_account_by_event_name	NULL	NULL	NULL
events_waits_summary_by_host_by_event_name	NULL	NULL	NULL
events_waits_summary_by_instance	NULL	NULL	NULL
events_waits_summary_by_thread_by_event_name	NULL	NULL	NULL
events_waits_summary_by_user_by_event_name	NULL	NULL	NULL
events_waits_summary_global_by_event_name	NULL	NULL	NULL
file_instances	NULL	NULL	NULL
file_summary_by_event_name	NULL	NULL	NULL
file_summary_by_instance	NULL	NULL	NULL
global_status	NULL	NULL	NULL
hosts	NULL	NULL	NULL
host_cache	NULL	NULL	NULL
memory_summary_by_account_by_event_name	NULL	NULL	NULL
memory_summary_by_host_by_event_name	NULL	NULL	NULL
memory_summary_by_thread_by_event_name	NULL	NULL	NULL
memory_summary_by_user_by_event_name	NULL	NULL	NULL
memory_summary_global_by_event_name	NULL	NULL	NULL
metadata_locks	NULL	NULL	NULL
mutex_instances	NULL	NULL	NULL
objects_summary_global_by_type	NULL	NULL	NULL
performance_timers	NULL	NULL	NULL
prepared_statements_instances	NULL	NULL	NULL
replication_applier_configuration	NULL	NULL	NULL
replication_applier_status	NULL	NULL	NULL
replication_applier_status_by_coordinator	NULL	NULL	NULL
replication_applier_status_by_worker	NULL	NULL	NULL
replication_connection_configuration	NULL	NULL	NULL
rwlock_instances	NULL	NULL	NULL
session_account_connect_attrs	NULL	NULL	NULL
session_connect_attrs	NULL	NULL	NULL
session_status	NULL	NULL	NULL
setup_actors	NULL	NULL	NULL
setup_consumers	NULL	NULL	NULL
setup_instruments	NULL	NULL	NULL
setup_objects	NULL	NULL	NULL
setup_timers	NULL	NULL	NULL
socket_instances	NULL	NULL	NULL
socket_summary_by_event_name	NULL	NULL	NULL
socket_summary_by_instance	NULL	NULL	NULL
status_by_account	NULL	NULL	NULL
status_by_host	NULL	NULL	NULL
status_by_thread	NULL	NULL	NULL
status_by_user	NULL	NULL	NULL
table_handles	NULL	NULL	NULL
table_io_waits_summary_by_index_usage	NULL	NULL	NULL
table_io_waits_summary_by_table	NULL	NULL	NULL
table_lock_waits_summary_by_table	NULL	NULL	NULL
threads	NULL	NULL	NULL
users	NULL	NULL	NULL
user_variables_by_thread	NULL	NULL	NULL
select lower(TABLE_NAME), TABLE_COLLATION, CHECKSUM
from information_schema.tables
where TABLE_SCHEMA='performance_schema'
  order by table_name;
lower(TABLE_NAME)	TABLE_COLLATION	CHECKSUM
accounts	utf8mb3_general_ci	NULL
cond_instances	utf8mb3_general_ci	NULL
events_stages_current	utf8mb3_general_ci	NULL
events_stages_history	utf8mb3_general_ci	NULL
events_stages_history_long	utf8mb3_general_ci	NULL
events_stages_summary_by_account_by_event_name	utf8mb3_general_ci	NULL
events_stages_summary_by_host_by_event_name	utf8mb3_general_ci	NULL
events_stages_summary_by_thread_by_event_name	utf8mb3_general_ci	NULL
events_stages_summary_by_user_by_event_name	utf8mb3_general_ci	NULL
events_stages_summary_global_by_event_name	utf8mb3_general_ci	NULL
events_statements_current	utf8mb3_general_ci	NULL
events_statements_history	utf8mb3_general_ci	NULL
events_statements_history_long	utf8mb3_general_ci	NULL
events_statements_summary_by_account_by_event_name	utf8mb3_general_ci	NULL
events_statements_summary_by_digest	utf8mb3_general_ci	NULL
events_statements_summary_by_host_by_event_name	utf8mb3_general_ci	NULL
events_statements_summary_by_program	utf8mb3_general_ci	NULL
events_statements_summary_by_thread_by_event_name	utf8mb3_general_ci	NULL
events_statements_summary_by_user_by_event_name	utf8mb3_general_ci	NULL
events_statements_summary_global_by_event_name	utf8mb3_general_ci	NULL
events_transactions_current	utf8mb3_general_ci	NULL
events_transactions_history	utf8mb3_general_ci	NULL
events_transactions_history_long	utf8mb3_general_ci	NULL
events_transactions_summary_by_account_by_event_name	utf8mb3_general_ci	NULL
events_transactions_summary_by_host_by_event_name	utf8mb3_general_ci	NULL
events_transactions_summary_by_thread_by_event_name	utf8mb3_general_ci	NULL
events_transactions_summary_by_user_by_event_name	utf8mb3_general_ci	NULL
events_transactions_summary_global_by_event_name	utf8mb3_general_ci	NULL
events_waits_current	utf8mb3_general_ci	NULL
events_waits_history	utf8mb3_general_ci	NULL
events_waits_history_long	utf8mb3_general_ci	NULL
events_waits_summary_by_account_by_event_name	utf8mb3_general_ci	NULL
events_waits_summary_by_host_by_event_name	utf8mb3_general_ci	NULL
events_waits_summary_by_instance	utf8mb3_general_ci	NULL
events_waits_summary_by_thread_by_event_name	utf8mb3_general_ci	NULL
events_waits_summary_by_user_by_event_name	utf8mb3_general_ci	NULL
events_waits_summary_global_by_event_name	utf8mb3_general_ci	NULL
file_instances	utf8mb3_general_ci	NULL
file_summary_by_event_name	utf8mb3_general_ci	NULL
file_summary_by_instance	utf8mb3_general_ci	NULL
global_status	utf8mb3_general_ci	NULL
hosts	utf8mb3_general_ci	NULL
host_cache	utf8mb3_general_ci	NULL
memory_summary_by_account_by_event_name	utf8mb3_general_ci	NULL
memory_summary_by_host_by_event_name	utf8mb3_general_ci	NULL
memory_summary_by_thread_by_event_name	utf8mb3_general_ci	NULL
memory_summary_by_user_by_event_name	utf8mb3_general_ci	NULL
memory_summary_global_by_event_name	utf8mb3_general_ci	NULL
metadata_locks	utf8mb3_general_ci	NULL
mutex_instances	utf8mb3_general_ci	NULL
objects_summary_global_by_type	utf8mb3_general_ci	NULL
performance_timers	utf8mb3_general_ci	NULL
prepared_statements_instances	utf8mb3_general_ci	NULL
replication_applier_configuration	utf8mb3_general_ci	NULL
replication_applier_status	utf8mb3_general_ci	NULL
replication_applier_status_by_coordinator	utf8mb3_general_ci	NULL
replication_applier_status_by_worker	utf8mb3_general_ci	NULL
replication_connection_configuration	utf8mb3_general_ci	NULL
rwlock_instances	utf8mb3_general_ci	NULL
session_account_connect_attrs	utf8mb3_bin	NULL
session_connect_attrs	utf8mb3_bin	NULL
session_status	utf8mb3_general_ci	NULL
setup_actors	utf8mb3_general_ci	NULL
setup_consumers	utf8mb3_general_ci	NULL
setup_instruments	utf8mb3_general_ci	NULL
setup_objects	utf8mb3_general_ci	NULL
setup_timers	utf8mb3_general_ci	NULL
socket_instances	utf8mb3_general_ci	NULL
socket_summary_by_event_name	utf8mb3_general_ci	NULL
socket_summary_by_instance	utf8mb3_general_ci	NULL
status_by_account	utf8mb3_general_ci	NULL
status_by_host	utf8mb3_general_ci	NULL
status_by_thread	utf8mb3_general_ci	NULL
status_by_user	utf8mb3_general_ci	NULL
table_handles	utf8mb3_general_ci	NULL
table_io_waits_summary_by_index_usage	utf8mb3_general_ci	NULL
table_io_waits_summary_by_table	utf8mb3_general_ci	NULL
table_lock_waits_summary_by_table	utf8mb3_general_ci	NULL
threads	utf8mb3_general_ci	NULL
users	utf8mb3_general_ci	NULL
user_variables_by_thread	utf8mb3_general_ci	NULL
select lower(TABLE_NAME), CREATE_OPTIONS
from information_schema.tables
where TABLE_SCHEMA='performance_schema'
  order by table_name;
lower(TABLE_NAME)	CREATE_OPTIONS
accounts	
cond_instances	
events_stages_current	
events_stages_history	
events_stages_history_long	
events_stages_summary_by_account_by_event_name	
events_stages_summary_by_host_by_event_name	
events_stages_summary_by_thread_by_event_name	
events_stages_summary_by_user_by_event_name	
events_stages_summary_global_by_event_name	
events_statements_current	
events_statements_history	
events_statements_history_long	
events_statements_summary_by_account_by_event_name	
events_statements_summary_by_digest	
events_statements_summary_by_host_by_event_name	
events_statements_summary_by_program	
events_statements_summary_by_thread_by_event_name	
events_statements_summary_by_user_by_event_name	
events_statements_summary_global_by_event_name	
events_transactions_current	
events_transactions_history	
events_transactions_history_long	
events_transactions_summary_by_account_by_event_name	
events_transactions_summary_by_host_by_event_name	
events_transactions_summary_by_thread_by_event_name	
events_transactions_summary_by_user_by_event_name	
events_transactions_summary_global_by_event_name	
events_waits_current	
events_waits_history	
events_waits_history_long	
events_waits_summary_by_account_by_event_name	
events_waits_summary_by_host_by_event_name	
events_waits_summary_by_instance	
events_waits_summary_by_thread_by_event_name	
events_waits_summary_by_user_by_event_name	
events_waits_summary_global_by_event_name	
file_instances	
file_summary_by_event_name	
file_summary_by_instance	
global_status	
hosts	
host_cache	
memory_summary_by_account_by_event_name	
memory_summary_by_host_by_event_name	
memory_summary_by_thread_by_event_name	
memory_summary_by_user_by_event_name	
memory_summary_global_by_event_name	
metadata_locks	
mutex_instances	
objects_summary_global_by_type	
performance_timers	
prepared_statements_instances	
replication_applier_configuration	
replication_applier_status	
replication_applier_status_by_coordinator	
replication_applier_status_by_worker	
replication_connection_configuration	
rwlock_instances	
session_account_connect_attrs	
session_connect_attrs	
session_status	
setup_actors	
setup_consumers	
setup_instruments	
setup_objects	
setup_timers	
socket_instances	
socket_summary_by_event_name	
socket_summary_by_instance	
status_by_account	
status_by_host	
status_by_thread	
status_by_user	
table_handles	
table_io_waits_summary_by_index_usage	
table_io_waits_summary_by_table	
table_lock_waits_summary_by_table	
threads	
users	
user_variables_by_thread	
select lower(TABLE_NAME), TABLE_COMMENT
from information_schema.tables
where TABLE_SCHEMA='performance_schema'
  order by table_name;
lower(TABLE_NAME)	TABLE_COMMENT
accounts	
cond_instances	
events_stages_current	
events_stages_history	
events_stages_history_long	
events_stages_summary_by_account_by_event_name	
events_stages_summary_by_host_by_event_name	
events_stages_summary_by_thread_by_event_name	
events_stages_summary_by_user_by_event_name	
events_stages_summary_global_by_event_name	
events_statements_current	
events_statements_history	
events_statements_history_long	
events_statements_summary_by_account_by_event_name	
events_statements_summary_by_digest	
events_statements_summary_by_host_by_event_name	
events_statements_summary_by_program	
events_statements_summary_by_thread_by_event_name	
events_statements_summary_by_user_by_event_name	
events_statements_summary_global_by_event_name	
events_transactions_current	
events_transactions_history	
events_transactions_history_long	
events_transactions_summary_by_account_by_event_name	
events_transactions_summary_by_host_by_event_name	
events_transactions_summary_by_thread_by_event_name	
events_transactions_summary_by_user_by_event_name	
events_transactions_summary_global_by_event_name	
events_waits_current	
events_waits_history	
events_waits_history_long	
events_waits_summary_by_account_by_event_name	
events_waits_summary_by_host_by_event_name	
events_waits_summary_by_instance	
events_waits_summary_by_thread_by_event_name	
events_waits_summary_by_user_by_event_name	
events_waits_summary_global_by_event_name	
file_instances	
file_summary_by_event_name	
file_summary_by_instance	
global_status	
hosts	
host_cache	
memory_summary_by_account_by_event_name	
memory_summary_by_host_by_event_name	
memory_summary_by_thread_by_event_name	
memory_summary_by_user_by_event_name	
memory_summary_global_by_event_name	
metadata_locks	
mutex_instances	
objects_summary_global_by_type	
performance_timers	
prepared_statements_instances	
replication_applier_configuration	
replication_applier_status	
replication_applier_status_by_coordinator	
replication_applier_status_by_worker	
replication_connection_configuration	
rwlock_instances	
session_account_connect_attrs	
session_connect_attrs	
session_status	
setup_actors	
setup_consumers	
setup_instruments	
setup_objects	
setup_timers	
socket_instances	
socket_summary_by_event_name	
socket_summary_by_instance	
status_by_account	
status_by_host	
status_by_thread	
status_by_user	
table_handles	
table_io_waits_summary_by_index_usage	
table_io_waits_summary_by_table	
table_lock_waits_summary_by_table	
threads	
users	
user_variables_by_thread