Limit NDO database size

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Ravil
Posts: 43
Joined: Thu Feb 20, 2014 9:30 pm

Limit NDO database size

Post by Ravil »

sreinhardt wrote:Generally, unless there is a crash causing failure, snmptt will continue to process even if data it expects is not available, so this is somewhat expected. Especially considering the trap still forwarded to the core interface, I think this is just overly verbose output from snmptt.
I have another one question. I installed nagios 3.5.1, ndoutils 1.5.2 and nagvis-1.7.10. Now information from Nagios save in Data Base mysql.
How mysql database is limited in terms of? It will be filled until it fills the entire disk? I need to limit the number of records in the database to the old entries are overwritten, and the new saved.
Last edited by Ravil on Mon Mar 03, 2014 8:06 pm, edited 2 times in total.
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: Limit NDO database size

Post by lmiltchev »

You can set how long you would like to keep the data in various mysql tables easily in Nagios XI. In Nagios Core, you will need to keep an eye on the tables that tend to "grow" the most, for example "nagios_logentries" and "nagios_notifications", and truncate them if necessary.

http://dev.mysql.com/doc/refman/5.0/en/ ... table.html
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked