MySQL Database Crashes

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
mguthrie
Posts: 4380
Joined: Mon Jun 14, 2010 10:21 am

Re: MySQL Database Crashes

Post by mguthrie »

Looks like you're correct. From looking at the code of logging.c, all current states are logged anytime there's a rotation. I'm going to dig into this a bit more, but for the time being setting up your own rotation with the logrotate cron might be a better solution for now.
User avatar
gwakem
Posts: 238
Joined: Mon Jan 23, 2012 2:02 pm
Location: Asheville, NC

Re: MySQL Database Crashes

Post by gwakem »

Awesome! Thank you!
--
Griffin Wakem
mguthrie
Posts: 4380
Joined: Mon Jun 14, 2010 10:21 am

Re: MySQL Database Crashes

Post by mguthrie »

So the only real insight I can offer on this would be that /usr/local/nagios/etc/ndomod.cfg allows you to define a bitwise operation as to what gets sent to ndoutils. So if you don't don't mind not having fresh nagios log information in the web interface you can turn off ndoutils logentries with the following option:

Code: Select all

data_processing_options=67108859
I wouldn't try this in production without letting it run on a test box for a while. I tried it on my local benchmark box with 10k checks running on it, and I was hoping it would be a performance increase, but I don't think my test install is large enough to notice much of a difference.
Locked