Sheeri Cabral gave a great presentation on how to monitor MySQL using Nagios. The presentation was from the 2013 Nagios World Conference.