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.
Decrease the value of table_definition_cache.
B.
Increase the value of table_definition_cache.
C.
Decrease the value of table_open_cache.
D.
Increase the value of table_open_cache.
E.
Decrease the value of table_open_cache_instances.
F.
Increase the value of table_open_cache_instances.
答案:F