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

    MySQL 5.6 Database Administrator-063-Which two facts can be concluded from the given output?

    royalwzy发表于 2015-09-03 03:10:03
    love 0
    You are using the performance Schema to investigate replication on a slave: Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime FROM performance_schema.events_waits_summary_by_thread_by_event_name INNER JOIN performance_schema,threads USING (THREAD_ID) WHERE threads .NAME LIKE ‘thread/sql/slave\-%’ GROUP BY THREAD_ID, threads.NAME; 7 Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output? A. At most two schemas are being updated concurrently. B. The server needs more cores to use all slave threads. C. The slave cannot process the relay log fast enough to use all threads. D. The slave is configured with slave_parallel_workers = 4. 答案:CD


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