I am looking for a good all-in-one monitoring tool for a single MySQL server and underlying Linux OS. I need something that gives me a quick graphical view of what is going on right now and that alerts me to issues / potential issues. If it can also give recommendations, even better. I need to be able to see historical data and trends, and preferably have an easy way to see "what changed??" This data should preferably include relevant OS metrics, such as CPU, iops, RAM utilization, etc.
I don't have a DBA, so MySQL administration is just one of 15 different hats I am wearing in our small IT department. I plan to purchase a commercial support contract from Percona or MySQL, but I still need a decent monitoring tool (to be my "virtual DBA", if you will).
Some candidates I have come across are: MonYog, Hyperic HQ, DBTuna & Jet Profiler. I would be interested in knowing about these tools and others from people who have used them in real-world scenarios in detecting & debugging issues, etc.
The platform for the monitoring tool can be either Windows or Linux, it does not matter much.
Input / advice on this would be appreciated.