admin管理员组

文章数量:1594721

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,C

https://wwwdba/hbhe0316/article/22763 https://wwwdba/hbhe0316/article/22763 https://wwwdba/hbhe0316/article/22763 https://wwwdba/hbhe0316/article/22763 https://wwwdba/hbhe0316/article/22763 https://wwwdba/hbhe0316/article/22763 https://wwwdba/hbhe0316/article/22763 https://wwwdba/hbhe0316/article/22763 https://wwwdba/hbhe0316/article/22763 https://wwwdba/hbhe0316/article/22763

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

MYSQL

本文标签： mysqlOCP

版权声明：本文标题：Mysql OCP 24题 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://www.elefans.com/dongtai/1728179366a1148254.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。