Log entries table is huge!

[BanditBBS]

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

Code: Select all

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?

[lmiltchev]

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

[BanditBBS]

Lock her up!

Thanks