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_cacheB.Increase the value of table_open_cache_instancesC.Decrease the value of table_open_cache_instancesD.Increase the value of table_open_cacheE.Decrease the value of table_definition_cacheF.Decrease the value of table_open_cache
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
相关考题:
You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following
12、安装MySQL数据库后,系统自动创建的数据库包括______。A.information_schemaB.chooseC.mysqlD.performance_schema