IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    MySQL 5.6 Database Administrator-069-Which action should be taken to remove the performance bottleneck described here?

    royalwzy发表于 2015-09-03 03:18:36
    love 0
    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


沪ICP备19023445号-2号
友情链接