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 tabl

题目

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

相似考题

1.［A］ celebration ［B］ arrangement［C］ feast ［D］ eve

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

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

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

更多“You are investigating the performance of the server and see the following information: Eve ”相关问题

  • 第1题：

    安装MySQL数据库后，系统自动创建的数据库包括______。

    A．information_schema

    B．choose

    C．mysql

    D．performance_schema


    performance_schema;information_schema;mysql

  • 第2题：

    2、Mysql数据库系统表有哪些？

    A．Information_schema

    B．performance_schema

    C．mysql

    D．sys


    Information_schema;Performance_schema;mysql;test

  • 第3题：

    安装MySQL数据库后，系统自动创建的数据库包括______。

    A．information_schema；

    B．Choose;

    C．Mysql；

    D．performance_schema；


    performance_schema;information_schema;mysql

  • 第4题：

    MySQL自带数据库中， 存储了系统的权限信息。

    A．information_schema

    B．mysql

    C．sakila

    D．performance_schema


    B

  • 第5题：

    mysql中哪个数据库记录了数据库元数据

    A．mysql

    B．information

    C．information_schema

    D．performance_schema


    C解析：表是所有数据库对象的基础。

  • 第6题：

    12、安装MySQL数据库后，系统自动创建的数据库包括______。

    A．information_schema

    B．choose

    C．mysql

    D．performance_schema


    information_schema;mysql;performance_schema

相关内容