Hello everyone.
We've recently started using Nagios Core on our network to monitor a few, key machines and I had a question as far as tweaking the settings. We have a mysql server that typically runs with a minimal load throughout the day. However, every morning at 1:30, it runs an optimization on the databases that pegs the CPU for about 20 minutes. This is normal and expected every day. When Nagios sees this, naturally, it throws a warning and emails our IT staff.
My question is, how would this best be addressed? Should I setup some kind of recurring downtime for that specific window or should I raise the threshold for the warnings? I'd really like to get a feel for how others handle this before I start downloading addons and such that we don't really need...
CPU load on mysql server
Re: CPU load on mysql server
Changing the timeperiod http://nagios.sourceforge.net/docs/3_0/timeperiods.html that the service runs is probably the best way, you don't really want to raise the threshold for the warnings if it's a legit problem at any other time of the day.