Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
Shopping Questions are considered Off-Topic here on ServerFault. Please see the Help section or Here for more info. If you are interested in having a way to ask these types of questions head over to the IT Shopping Questions Beta and post your question as a possible question for the beta and follow the proposal. –  TheCleaner Sep 4 '13 at 18:46
add comment

closed as off-topic by Magellan, Nathan C, mdpc, Falcon Momot, TheCleaner Sep 4 '13 at 18:46

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they tend to become obsolete quickly. Instead, describe your situation and the specific problem you're trying to solve." – Magellan, Nathan C, mdpc, Falcon Momot, TheCleaner
If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers

up vote 1 down vote accepted

Have you tried Splunk? It's able to correlate data from many sources and I personally find that their whole "log-querying/correlation paradigm" is 1,000s miles ahead of what you usually find in the log management space.

share|improve this answer
    
tried splunk, a bit overwhelmed by its options –  Andre Jay Marcelo-Tanner Jun 13 '12 at 18:07
add comment

I only have experience with Zabbix which I've found to have a good balance between ease of use and features. Installation is pretty easy assuming you are familiar with building from source and there is the usual learning curve to configuration it is also pretty easy to select monitoring templates to get you a large amount of monitoring data very quickly. It is also relatively easy to add custom monitoring data if needed.

I assume you have checked out the Monitoring tag for various similar discussions.

share|improve this answer
    
yes checked the monitoring tag, not much there. I definitely want something that can scour my logs for me. –  Andre Jay Marcelo-Tanner Feb 20 '11 at 23:47
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.