Take the 2-minute tour ×  We use pingdom and a few internal
heartbeat mechanisms on our product.  We would like to add a
'are our slaves running and in good shape' check.  What fields
in SHOW SLAVE STATUS indicate that the slave where SHOW SLAVE
STATUS was executed on is not (or is) replicating correctly?
The 2 we are currently testing are:  Slave_IO_Running (must
equal Yes)  Slave_SQL_Running (must equal Yes)
Seconds_Behind_Master (must be integer, and less then 10 seconds
behind master)  Any others we should be testing?  Thanks again!
share|improve this question  1 Answer 1  up vote 2 down vote
accepted   You may want to monitor Relay_Log_Space. It
represents the some total of relay logs the Slave has to
process. When should you worry about it?  Give this scenario
• Slave_IO_Running is Yes   • Slave_SQL_Running is No  This
indicates that that the IO Thread is still downloading entries
from its Master's binary logs. The longer you take to address
the SQL error, the more the Relay_Log_Space will pile up