Page 1 of 1
How to reduce size for the file "/var/lib/mysql/snmptt/snmp"
Posted: Wed Nov 13, 2019 2:22 am
by arista-nagios
Hello,
As we are observing the large size for the file "/var/lib/mysql/snmptt/snmptt.MYD" around 124 GiB, please help us to instruct how to reduce its size:
[root@Spectraguard snmptt]# du -sh /var/lib/mysql/snmptt/snmptt.MYD
124G /var/lib/mysql/snmptt/snmptt.MYD
Thanks,
Bharat Lalwani
Re: How to reduce size for the file "/var/lib/mysql/snmptt/s
Posted: Wed Nov 13, 2019 10:55 am
by mbellerue
What version of Nagios XI is this? To my knowledge, XI doesn't use an snmptt database. By default it just logs to a log file.
Re: How to reduce size for the file "/var/lib/mysql/snmptt/s
Posted: Mon Nov 18, 2019 7:47 am
by arista-nagios
Hello,
Currently installed version is 5.5.9.
A new Nagios XI update is available.
5.6.8 was released on November 5th, 2019.
Visit
www.nagios.com to obtain the latest update.
Latest Available Version: 5.6.8
Installed Version: 5.5.9
Last Update Check: 2019-11-18 16:00:01
so can we go ahead to remove this file?
Thanks,
Bharat Lalwani
Re: How to reduce size for the file "/var/lib/mysql/snmptt/s
Posted: Mon Nov 18, 2019 11:04 am
by lmiltchev
We do not use that db in Nagios XI. If you installed something else, that uses it, you would need to figure out how to deal with it. Ask your System Administrator to find out what could be using this db. In any case, I would recommend truncating the db, install of deleting the file, just to be on the safe side. If you find out that is is "save" to remote the file, then you can do it, but for the time being, I suggest that you do a bit of a research to find out what's using that db, maybe an old snmp trap interface, etc.