Nagios Support Forum

Posted: **Fri Aug 08, 2014 9:58 am**

I'm running out of disk space and I sort of found out why:

817.5M  nagios_logentries.MYI
1.5G    nagios_externalcommands.MYD
1.8G    nagios_logentries.TMD
3.6G    nagios_logentries.MYD

Look how large those 4 MySQL files are. Any way to make those smaller? I went to pefromance settings yesterday and set Max Log Entries from 90 to 60, but that made no change in the filesize. Should that have? Do I need to run the repair script?

Posted: **Fri Aug 08, 2014 11:14 am**

You will need to truncate these tables then run the repair on the database. Example:

Code: Select all

mysql -u ndoutils -pn@gweb nagios -e 'TRUNCATE TABLE nagios_logentries'

Note: You will lose the historical data that was stored in these tables.

For more info, read the following document:

http://assets.nagios.com/downloads/nagi ... tabase.pdf

Posted: **Fri Aug 08, 2014 11:22 am**

Lock her up!

Thanks

Nagios Support Forum

Log entries table is huge!

Log entries table is huge!

Re: Log entries table is huge!

Re: Log entries table is huge!