How to reduce size for the file "/var/lib/mysql/snmptt/snmp"

[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

[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.

[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

[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.