You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.http://www.cndba.cn/hbhe0316/article/22741

mysql> SHOW SLAVE STATUS/ G

…http://www.cndba.cn/hbhe0316/article/22741

Slave_IO_Running: Yes

Slave_SQL_Running: Nohttp://www.cndba.cn/hbhe0316/article/22741http://www.cndba.cn/hbhe0316/article/22741

What are two reasons that you may stop the SQL thread on the slave while keeping the I/ O thread running?

A. to allow the remaining events to be processed on the slave while not receiving new events from the masterhttp://www.cndba.cn/hbhe0316/article/22741http://www.cndba.cn/hbhe0316/article/22741

B. to allow a backup to be created under reduced loadhttp://www.cndba.cn/hbhe0316/article/22741

C. to allow for point-in-time recovery on the slavehttp://www.cndba.cn/hbhe0316/article/22741

D. to prevent schema changes from propagating to the slave before they are validated

E. to prevent any transaction experiencing a deadlock

Answer:BC

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

MYSQL