I managed my company's servers and I need to know if load spiked at 3am on the web or mysql server, what processes were active in apache or what queries were going on in mysql at that point in time and maybe any other information that will help me.
I know all of that is in log files all over and its literally a PITA to look it all up and correlate data.
isnt there 1 solution thats been invented.
i know we have pingdom to monitor uptime and responsiveness.
like if it has taken 30 seconds to load a page or an error was given by apache or php or mysql to the browser, i want to know that and what mysql processes were running at the time, the apache full status and maybe top output also.
stuff like that
also would be looking for a SAAS like cloudkick, something i dont have to spend an entire month of work hours setting up when we can pay for something cheaper.