Huge files in /var.

[prateekagr1988]

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.

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

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.

468.0MB 2014-12-08 nagios /var/spool/mail/nagios

Empty the mail file . . .[/quote]

[abrist]

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.