Nagios Support Forum

I am not really sure of the frequency. I have reminders now to check the database logs every couple of hours. I rarely check the actual database and when I do, who knows how long it was broken. This last time it has been at least a week, because that's how far back the logs go. I cannot correlate any events to this behavior. I have less than 500 services and 250 hosts. I have, in the past, brought down the entire network that resulted in 200+ notifications at once with no database crashes.

I could go the route of simply running the repair databases script in cron every couple of hours, it's not best practice, but it might alleviate the load? Any harm in running the script too often?

Thanks for the help

ahoward12 wrote:I could go the route of simply running the repair databases script in cron every couple of hours, it's not best practice, but it might alleviate the load? Any harm in running the script too often?

The only harm is that it is going to stop and start mysqld for the time the DB is being repaired. In a large environment it could take a long time, but with the size of your system I would guess it would run pretty quick

Just an update, I haven't changed anything or added the repair script to Cron like previously talked. No issues yet, but it will mess up again sooner or later. If there isnt much anyone else can do. We can close this and I'll assume my fix is going to be adding the script to cron

ahoward12 wrote:Just an update, I haven't changed anything or added the repair script to Cron like previously talked. No issues yet, but it will mess up again sooner or later. If there isnt much anyone else can do. We can close this and I'll assume my fix is going to be adding the script to cron

Will do, let us know if another issue pops up.