Three ways to know when a MySQL slave is about to start lagging

(Baron Schwartz) The trouble with slave lag is that you often can’t see it coming. Especially if the slave’s load is pretty uniform, a slave that’s at 90% of its capacity to keep up with the master can be indistinguishable from one that’s at 5% of its capacity.

Read More - Register for Free Membership