CPU load on mysql server
Posted: Wed Feb 08, 2012 10:03 am
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...
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...