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


相关考题:

[A] celebration [B] arrangement[C] feast [D] eve

If you had been have yesterday,you______(see)his father.

()you()Jane last month? B: No, I(). A、*/saw/didn’tB、Did/see/didn’tC、Did/saw/didn’tD、id/see/did

You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following

安装MySQL数据库后,系统自动创建的数据库包括______。A.information_schemaB.chooseC.mysqlD.performance_schema

MySQL自带数据库中, 存储了系统的权限信息。A.information_schemaB.mysqlC.sakilaD.performance_schema

2、Mysql数据库系统表有哪些?A.Information_schemaB.performance_schemaC.mysqlD.sys

mysql中哪个数据库记录了数据库元数据A.mysqlB.informationC.information_schemaD.performance_schema

安装MySQL数据库后,系统自动创建的数据库包括______。A.information_schema;B.Choose;C.Mysql;D.performance_schema;

12、安装MySQL数据库后,系统自动创建的数据库包括______。A.information_schemaB.chooseC.mysqlD.performance_schema