You are investigating the performance of the server and see the following information:
Events_waits_summary_global_by_event_name in the performance schema shows that the
wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The
table_open_cache_overflows status variable is 0. Which action should be taken to remove
the performance bottleneck described here?
A.
Increase the value of table_definition_cache.
B.
Increase the value of table_open_cache_instances.
C.
Decrease the value of table_open_cache_instances.
D.
Increase the value of table_open_cache.
E.
Decrease the value of table_definition_cache.
F.
Decrease the value of table_open_cache.
D
B
d
D
http://planet.mysql.com/entry/?id=34237
I think D,F
Answer should be B and D