Harry,
I think that generally three things are important.
- Monitoring and alerting. I like Nagios.
- Historical trending. I like Cacti. See the memcached templates
included with
http://code.google.com/p/mysql-cacti-templates/
- Performance analysis. I like mk-query-digest from Maatkit.
Cheers,
Baron
--
Baron Schwartz
Percona Inc <
http://www.percona.com/>
Consulting, Training, Support & Services for MySQL