Nagios Support Forum

abrist wrote:Files located in the directory: /var/lib/mysql/nagios are tables. You could truncate those tables, or decrease their retention window through Admin --> Performance --> Databases.

I don't see the option in Nagios XI 2012R1.2. Please suggest how to truncate those tables or decrease the retention window.
Also, what could be the impact of either of the tasks.

prateekagr1988 wrote:Please suggest on how to housekeep those, and re-direct to a different file system from /var.

abrist wrote:Well, you would need to move the default location for the database files. Have you considered creating a new mount for /var? Nagios XI systems will make heavy use of /usr and /var.

prateekagr1988 wrote:468.0MB 2014-12-08 nagios /var/spool/mail/nagios

Empty the mail file . . .[/quote]

prateekagr1988 wrote: I don't see the option in Nagios XI 2012R1.2. Please suggest how to truncate those tables or decrease the retention window.

Do you have a list of options on the databases tab of the performance settings page? If so, decrease the days for the table in question.