1Z0-888 Exam Dumps | You are using the Performance Schema to investigate replication on a slave which has a single master.

<< Prev Question Next Question >>

Question 2/49

You are using the Performance Schema to investigate replication on a slave which has a single master.
The option slave-parallel-typeis set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)

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

B. The slave cannot process the relay log fast enough to use all threads.

C. THREAD_ID 21has stopped running.

D. The salve has two intermediate relay slaves connected to it.

E. At most, two schemas are being updates concurrently.

F. The slave is configured with slave_parallel_workers= 4

Question 2/49

LEAVE A REPLY

Download PDF File