Which action should be taken to remove the performance bottleneck described here?

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?

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.



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Rajareddy

Rajareddy

I think D,F

Rajareddy

Rajareddy

Answer should be B and D