You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is 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?
A. The salve has two intermediate relay slaves connected to it.
B. The slave is configured with slave_parallel_workers = 4
C. At most, two schemas are being updates concurrently.
D. THREAD_ID 21 has stopped running.
E. The slave cannot process the relay log fast enough to use all threads.
F. The server needs more cores to use all slave threads.
Answer: B,C
Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?
假设所有工具和使用者都已启用，并且所有线程都已检测。
从给定的输出可以得出哪两个是正确的？
A. The salve has two intermediate relay slaves connected to it.
有两个从站连接到它。
B. The slave is configured with slave_parallel_workers = 4
slave_parallel_workers = 4
C. At most, two schemas are being updates concurrently.
最多有两个模式同时更新。
D. THREAD_ID 21 has stopped running.
D.线程ID 21已停止运行。
E. The slave cannot process the relay log fast enough to use all threads.
从机不能足够快地处理中继日志以使用所有线程。
F. The server needs more cores to use all slave threads.
服务器需要更多的内核来使用所有的从线程。
Answer: B,Chttp://www.cndba.cn/hbhe0316/article/22763

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL