1show variables like "table_definition_cache";
2Variable_name	Value
3table_definition_cache	5000
4show variables like "table_open_cache";
5Variable_name	Value
6table_open_cache	400
7show variables like "max_connections";
8Variable_name	Value
9max_connections	200
10show variables where
11`Variable_name` != "performance_schema_max_statement_classes" and
12`Variable_name` like "performance_schema%";
13Variable_name	Value
14performance_schema	ON
15performance_schema_accounts_size	100
16performance_schema_digests_size	10000
17performance_schema_events_stages_history_long_size	10000
18performance_schema_events_stages_history_size	10
19performance_schema_events_statements_history_long_size	10000
20performance_schema_events_statements_history_size	10
21performance_schema_events_waits_history_long_size	10000
22performance_schema_events_waits_history_size	10
23performance_schema_hosts_size	100
24performance_schema_max_cond_classes	80
25performance_schema_max_cond_instances	10900
26performance_schema_max_digest_length	1024
27performance_schema_max_file_classes	50
28performance_schema_max_file_handles	32768
29performance_schema_max_file_instances	23385
30performance_schema_max_mutex_classes	200
31performance_schema_max_mutex_instances	52200
32performance_schema_max_rwlock_classes	40
33performance_schema_max_rwlock_instances	30800
34performance_schema_max_socket_classes	10
35performance_schema_max_socket_instances	420
36performance_schema_max_stage_classes	150
37performance_schema_max_table_handles	800
38performance_schema_max_table_instances	12500
39performance_schema_max_thread_classes	50
40performance_schema_max_thread_instances	500
41performance_schema_session_connect_attrs_size	512
42performance_schema_setup_actors_size	100
43performance_schema_setup_objects_size	100
44performance_schema_users_size	100
45show status like "%performance_schema%";
46Variable_name	Value
47Performance_schema_accounts_lost	0
48Performance_schema_cond_classes_lost	0
49Performance_schema_cond_instances_lost	0
50Performance_schema_digest_lost	0
51Performance_schema_file_classes_lost	0
52Performance_schema_file_handles_lost	0
53Performance_schema_file_instances_lost	0
54Performance_schema_hosts_lost	0
55Performance_schema_locker_lost	0
56Performance_schema_mutex_classes_lost	0
57Performance_schema_mutex_instances_lost	0
58Performance_schema_rwlock_classes_lost	0
59Performance_schema_rwlock_instances_lost	0
60Performance_schema_session_connect_attrs_lost	0
61Performance_schema_socket_classes_lost	0
62Performance_schema_socket_instances_lost	0
63Performance_schema_stage_classes_lost	0
64Performance_schema_statement_classes_lost	0
65Performance_schema_table_handles_lost	0
66Performance_schema_table_instances_lost	0
67Performance_schema_thread_classes_lost	0
68Performance_schema_thread_instances_lost	0
69Performance_schema_users_lost	0
70