2
votes

I want to know if replication from master to slave is affected/stopped when the slave status shows-Waiting for the slave SQL thread to free enough relay log space.

Thanks in advance..!

1

1 Answers

0
votes

The IO thread can't write any more relay log until the SQL thread has processed it so it might be a long running query that is "blocking" replication. You should see it with SHOW PROCESSLIST.

More info over at mysql