Is MySQL Replication out of sync? Waiting for the slave SQL thread to free enough relay log space -


mysql slave server showing waiting slave sql thread free enough relay log space status week because relay logs full.

it happened because sql thread stuck on error. once cleared error, started processing relay logs again , freeing space.

does mean slave out of sync master, after reading through all relay logs?

my reasoning since slave couldn't download relay logs week, data lost.

please clarify me what's going on, can determine whether or not resync servers. re-syncing slave master not favorite option since database huge.

try running select queries on slave, should return data inserted in master. if replication has stopped, new data not in slave.


Comments

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

Does Firefox offer AppleScript support to get URL of windows? -

android - How to install packaged app on Firefox for mobile? -