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; Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?

Question

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; Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?

Accepted Answer

C. The slave cannot process the relay log fast enough to use all threads. D. The slave is configured with slave_parallel_workers = 4.

Answer

A. At most two schemas are being updated concurrently.

Answer

B. The server needs more cores to use all slave threads.

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…

Question

Exhibit

Options

How the community answered

Community Discussion