how to monitor the health of mysql databases

run this from cron (or incorporate in a monitoring app like nefu):

$ mysqlcheck -uroot -ppassword -A -e -1 -s | egrep -v '^mysql\..*log$|locks with log tables'