Nagios Support Forum

G 'Day Nagios XI Support,

Since I am running an heavily loaded Nagios XI instance (50,000+ objects) I purposely do not execute the my db maintenance cronjob below every 5 minutes. It typically takes 10-12 minutes to fully execute. I run it ever 4 hours as the below crontab entry shows. Unfortunately the Database Maintenance Status turns Red after 2 hours and then goes Green once the job completes and stays Green for 2 hours and then turns Red again for 2 hours.

0 */4 * * * nagios /usr/bin/php -q /usr/local/nagiosxi/cron/dbmaint.php >> /usr/local/nagiosxi/var/dbmaint.log 2>&1


So my question is: Is there a way that I can modify the timer associated with the Database Maintenance Status under the System Component Status widget?

Seems like being able to control should be based on the setting for the crontab entry but obviously it is not.

I know I am probably reaching here but I thought I would ask...

And as always thanks for your help,
Danny

There is no way to adjust that, however, may I suggest a different setup.

Change the cron back to run every 5 minutes.

Then, go to Admin -> Performance Settings -> Database Tab
Under each section set the "Optimize Interval:" to 240

Well that works too. It did resolve the DB Maintenance Status Red Alarm...

Will watch the performance but looks okay for now...thanks for the alternative approach.

Thanks,
Danny

onegative wrote:Well that works too. It did resolve the DB Maintenance Status Red Alarm...

Will watch the performance but looks okay for now...thanks for the alternative approach.

Thanks,
Danny

Great!

Let us know if we can be of further assistance.

Locking thread