Page 1 of 1

Limit NDO database size

Posted: Sun Mar 02, 2014 10:26 pm
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.

Re: Limit NDO database size

Posted: Mon Mar 03, 2014 1:23 pm
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