What to do with excessive log file/database file sizes?
Posted: Mon Nov 15, 2021 4:10 am
Hi
We are experiencing that certain logfiles seem to grow quite quickly.... these seem to be the main culprits: (in no particular order)
/var/lib/mysql/xi_auditlog.ibd 159.383.552
nagios_logentries.MYD
nagios_logentries.MYI
nagios_notifications.MYD
/usr/local/nagios/var/nagios.log
you can adjust how long information is to be retained in Performance Settings>Database, which will affect the size of the files I suppose.
But i am a little lost with regards to which parameters that affect these logs? All of these?
Max External Commands Age: Max time in DAYS to keep external commands.
Max Log Entries Age: Max time in DAYS to keep log entries.
Max Notifications Age: Max time in DAYS to keep notifications.
Max State History Age: Max time in DAYS to keep state history information.
And if the files have already grown excessive due to default settings or otherwise, what can be done about it? If I reduce the "Max DAYS" settings, the files will not be pruned/reduced in size.... what can I do?
regards,
HÃ¥kon
We are experiencing that certain logfiles seem to grow quite quickly.... these seem to be the main culprits: (in no particular order)
/var/lib/mysql/xi_auditlog.ibd 159.383.552
nagios_logentries.MYD
nagios_logentries.MYI
nagios_notifications.MYD
/usr/local/nagios/var/nagios.log
you can adjust how long information is to be retained in Performance Settings>Database, which will affect the size of the files I suppose.
But i am a little lost with regards to which parameters that affect these logs? All of these?
Max External Commands Age: Max time in DAYS to keep external commands.
Max Log Entries Age: Max time in DAYS to keep log entries.
Max Notifications Age: Max time in DAYS to keep notifications.
Max State History Age: Max time in DAYS to keep state history information.
And if the files have already grown excessive due to default settings or otherwise, what can be done about it? If I reduce the "Max DAYS" settings, the files will not be pruned/reduced in size.... what can I do?
regards,
HÃ¥kon