show variables like "table_definition_cache";
Variable_name	Value
table_definition_cache	5000
show variables like "table_open_cache";
Variable_name	Value
table_open_cache	400
show variables like "max_connections";
Variable_name	Value
max_connections	200
show variables like "%performance_schema%";
Variable_name	Value
performance_schema	ON
performance_schema_accounts_size	100
performance_schema_digests_size	10000
performance_schema_events_stages_history_long_size	10000
performance_schema_events_stages_history_size	10
performance_schema_events_statements_history_long_size	10000
performance_schema_events_statements_history_size	10
performance_schema_events_waits_history_long_size	10000
performance_schema_events_waits_history_size	10
performance_schema_hosts_size	100
performance_schema_max_cond_classes	80
performance_schema_max_cond_instances	10900
performance_schema_max_file_classes	50
performance_schema_max_file_handles	32768
performance_schema_max_file_instances	23385
performance_schema_max_mutex_classes	200
performance_schema_max_mutex_instances	52200
performance_schema_max_rwlock_classes	30
performance_schema_max_rwlock_instances	30800
performance_schema_max_socket_classes	10
performance_schema_max_socket_instances	420
performance_schema_max_stage_classes	150
performance_schema_max_statement_classes	167
performance_schema_max_table_handles	800
performance_schema_max_table_instances	12500
performance_schema_max_thread_classes	50
performance_schema_max_thread_instances	500
performance_schema_session_connect_attrs_size	512
performance_schema_setup_actors_size	100
performance_schema_setup_objects_size	100
performance_schema_users_size	100
show status like "%performance_schema%";
Variable_name	Value
Performance_schema_accounts_lost	0
Performance_schema_cond_classes_lost	0
Performance_schema_cond_instances_lost	0
Performance_schema_digest_lost	0
Performance_schema_file_classes_lost	0
Performance_schema_file_handles_lost	0
Performance_schema_file_instances_lost	0
Performance_schema_hosts_lost	0
Performance_schema_locker_lost	0
Performance_schema_mutex_classes_lost	0
Performance_schema_mutex_instances_lost	0
Performance_schema_rwlock_classes_lost	0
Performance_schema_rwlock_instances_lost	0
Performance_schema_session_connect_attrs_lost	0
Performance_schema_socket_classes_lost	0
Performance_schema_socket_instances_lost	0
Performance_schema_stage_classes_lost	0
Performance_schema_statement_classes_lost	0
Performance_schema_table_handles_lost	0
Performance_schema_table_instances_lost	0
Performance_schema_thread_classes_lost	0
Performance_schema_thread_instances_lost	0
Performance_schema_users_lost	0
show engine performance_schema status;
Type	Name	Status
performance_schema	events_waits_current.row_size	184
performance_schema	events_waits_current.row_count	3000
performance_schema	events_waits_history.row_size	184
performance_schema	events_waits_history.row_count	5000
performance_schema	events_waits_history.memory	920000
performance_schema	events_waits_history_long.row_size	184
performance_schema	events_waits_history_long.row_count	10000
performance_schema	events_waits_history_long.memory	1840000
performance_schema	(pfs_mutex_class).row_size	256
performance_schema	(pfs_mutex_class).row_count	200
performance_schema	(pfs_mutex_class).memory	51200
performance_schema	(pfs_rwlock_class).row_size	320
performance_schema	(pfs_rwlock_class).row_count	30
performance_schema	(pfs_rwlock_class).memory	9600
performance_schema	(pfs_cond_class).row_size	256
performance_schema	(pfs_cond_class).row_count	80
performance_schema	(pfs_cond_class).memory	20480
performance_schema	(pfs_thread_class).row_size	192
performance_schema	(pfs_thread_class).row_count	50
performance_schema	(pfs_thread_class).memory	9600
performance_schema	(pfs_file_class).row_size	320
performance_schema	(pfs_file_class).row_count	50
performance_schema	(pfs_file_class).memory	16000
performance_schema	mutex_instances.row_size	128
performance_schema	mutex_instances.row_count	52200
performance_schema	mutex_instances.memory	6681600
performance_schema	rwlock_instances.row_size	192
performance_schema	rwlock_instances.row_count	30800
performance_schema	rwlock_instances.memory	5913600
performance_schema	cond_instances.row_size	128
performance_schema	cond_instances.row_count	10900
performance_schema	cond_instances.memory	1395200
performance_schema	threads.row_size	1856
performance_schema	threads.row_count	500
performance_schema	threads.memory	928000
performance_schema	file_instances.row_size	704
performance_schema	file_instances.row_count	23385
performance_schema	file_instances.memory	16463040
performance_schema	(pfs_file_handle).row_size	8
performance_schema	(pfs_file_handle).row_count	32768
performance_schema	(pfs_file_handle).memory	262144
performance_schema	events_waits_summary_by_thread_by_event_name.row_size	32
performance_schema	events_waits_summary_by_thread_by_event_name.row_count	186500
performance_schema	events_waits_summary_by_thread_by_event_name.memory	5968000
performance_schema	(pfs_table_share).row_size	22208
performance_schema	(pfs_table_share).row_count	12500
performance_schema	(pfs_table_share).memory	277600000
performance_schema	(pfs_table).row_size	9280
performance_schema	(pfs_table).row_count	800
performance_schema	(pfs_table).memory	7424000
performance_schema	setup_actors.row_size	256
performance_schema	setup_actors.row_count	100
performance_schema	setup_actors.memory	25600
performance_schema	setup_objects.row_size	448
performance_schema	setup_objects.row_count	100
performance_schema	setup_objects.memory	44800
performance_schema	(pfs_account).row_size	256
performance_schema	(pfs_account).row_count	100
performance_schema	(pfs_account).memory	25600
performance_schema	events_waits_summary_by_account_by_event_name.row_size	32
performance_schema	events_waits_summary_by_account_by_event_name.row_count	37300
performance_schema	events_waits_summary_by_account_by_event_name.memory	1193600
performance_schema	events_waits_summary_by_user_by_event_name.row_size	32
performance_schema	events_waits_summary_by_user_by_event_name.row_count	37300
performance_schema	events_waits_summary_by_user_by_event_name.memory	1193600
performance_schema	events_waits_summary_by_host_by_event_name.row_size	32
performance_schema	events_waits_summary_by_host_by_event_name.row_count	37300
performance_schema	events_waits_summary_by_host_by_event_name.memory	1193600
performance_schema	(pfs_user).row_size	128
performance_schema	(pfs_user).row_count	100
performance_schema	(pfs_user).memory	12800
performance_schema	(pfs_host).row_size	128
performance_schema	(pfs_host).row_count	100
performance_schema	(pfs_host).memory	12800
performance_schema	(pfs_stage_class).row_size	192
performance_schema	(pfs_stage_class).row_count	150
performance_schema	(pfs_stage_class).memory	28800
performance_schema	events_stages_history.row_size	88
performance_schema	events_stages_history.row_count	5000
performance_schema	events_stages_history.memory	440000
performance_schema	events_stages_history_long.row_size	88
performance_schema	events_stages_history_long.row_count	10000
performance_schema	events_stages_history_long.memory	880000
performance_schema	events_stages_summary_by_thread_by_event_name.row_size	32
performance_schema	events_stages_summary_by_thread_by_event_name.row_count	75000
performance_schema	events_stages_summary_by_thread_by_event_name.memory	2400000
performance_schema	events_stages_summary_global_by_event_name.row_size	32
performance_schema	events_stages_summary_global_by_event_name.row_count	150
performance_schema	events_stages_summary_global_by_event_name.memory	4800
performance_schema	events_stages_summary_by_account_by_event_name.row_size	32
performance_schema	events_stages_summary_by_account_by_event_name.row_count	15000
performance_schema	events_stages_summary_by_account_by_event_name.memory	480000
performance_schema	events_stages_summary_by_user_by_event_name.row_size	32
performance_schema	events_stages_summary_by_user_by_event_name.row_count	15000
performance_schema	events_stages_summary_by_user_by_event_name.memory	480000
performance_schema	events_stages_summary_by_host_by_event_name.row_size	32
performance_schema	events_stages_summary_by_host_by_event_name.row_count	15000
performance_schema	events_stages_summary_by_host_by_event_name.memory	480000
performance_schema	(pfs_statement_class).row_size	192
performance_schema	(pfs_statement_class).row_count	167
performance_schema	(pfs_statement_class).memory	32064
performance_schema	events_statements_history.row_size	3024
performance_schema	events_statements_history.row_count	5000
performance_schema	events_statements_history.memory	15120000
performance_schema	events_statements_history_long.row_size	3024
performance_schema	events_statements_history_long.row_count	10000
performance_schema	events_statements_history_long.memory	30240000
performance_schema	events_statements_summary_by_thread_by_event_name.row_size	184
performance_schema	events_statements_summary_by_thread_by_event_name.row_count	83500
performance_schema	events_statements_summary_by_thread_by_event_name.memory	15364000
performance_schema	events_statements_summary_global_by_event_name.row_size	184
performance_schema	events_statements_summary_global_by_event_name.row_count	167
performance_schema	events_statements_summary_global_by_event_name.memory	30728
performance_schema	events_statements_summary_by_account_by_event_name.row_size	184
performance_schema	events_statements_summary_by_account_by_event_name.row_count	16700
performance_schema	events_statements_summary_by_account_by_event_name.memory	3072800
performance_schema	events_statements_summary_by_user_by_event_name.row_size	184
performance_schema	events_statements_summary_by_user_by_event_name.row_count	16700
performance_schema	events_statements_summary_by_user_by_event_name.memory	3072800
performance_schema	events_statements_summary_by_host_by_event_name.row_size	184
performance_schema	events_statements_summary_by_host_by_event_name.row_count	16700
performance_schema	events_statements_summary_by_host_by_event_name.memory	3072800
performance_schema	events_statements_current.row_size	3024
performance_schema	events_statements_current.row_count	500
performance_schema	events_statements_current.memory	1512000
performance_schema	(pfs_socket_class).row_size	320
performance_schema	(pfs_socket_class).row_count	10
performance_schema	(pfs_socket_class).memory	3200
performance_schema	socket_instances.row_size	320
performance_schema	socket_instances.row_count	420
performance_schema	socket_instances.memory	134400
performance_schema	events_statements_summary_by_digest.row_size	1472
performance_schema	events_statements_summary_by_digest.row_count	10000
performance_schema	events_statements_summary_by_digest.memory	14720000
performance_schema	session_connect_attrs.row_size	500
performance_schema	session_connect_attrs.row_count	512
performance_schema	session_connect_attrs.memory	256000
performance_schema	(account_hash).count	2
performance_schema	(account_hash).size	100
performance_schema	(digest_hash).count	0
performance_schema	(digest_hash).size	10000
performance_schema	(filename_hash).count	0
performance_schema	(filename_hash).size	23385
performance_schema	(host_hash).count	2
performance_schema	(host_hash).size	100
performance_schema	(setup_actor_hash).count	1
performance_schema	(setup_actor_hash).size	100
performance_schema	(setup_object_hash).count	4
performance_schema	(setup_object_hash).size	100
performance_schema	(table_share_hash).count	82
performance_schema	(table_share_hash).size	12500
performance_schema	(user_hash).count	2
performance_schema	(user_hash).size	100
performance_schema	host_cache.size	336
performance_schema	performance_schema.memory	421029256