Page 2 of 2

Re: upgrading nagios-fusion with .OVA vmware image

Posted: Fri Dec 01, 2017 2:03 pm
by dxk9_dtman
I ran the truncate and optimize commands earlier today, neither one purged the 22GB talble size of polled_extras.

Code: Select all

echo "truncate polled_extras" | mysql -ufusion -pfusion -Dfusion
echo "optimize table polled_extras" | mysql -ufusion -pfusion -Dfusion
Attached a screen shot so you can see I don't have that option for the metadata.

Unmanaged growth of that table isn't sustainable. This article mentions Nagios has a developer looking into it, as recently as August of this year
https://webcache.googleusercontent.com/ ... clnk&gl=us

Re: upgrading nagios-fusion with .OVA vmware image

Posted: Fri Dec 01, 2017 3:08 pm
by dwhitfield
I spoke to the developer mentioned in your link. That will be added in Fusion 4.1.

Unfortunately, since those are InnoDB, there's no good way to reclaim the space. If you really don't want to increase your disk space, take a look at https://dba.stackexchange.com/questions ... -databases

Re: upgrading nagios-fusion with .OVA vmware image

Posted: Mon Dec 04, 2017 12:33 pm
by dxk9_dtman
Ok, thanks.

So, for 4.1, we'll plan to go to a new VM image and add that setting.

Re: upgrading nagios-fusion with .OVA vmware image

Posted: Mon Dec 04, 2017 1:04 pm
by npolovenko
@dxk9_dtman, Sounds good. Or you may ssh to the existing VM when the update comes out and run the following command:

Code: Select all

curl https://assets.nagios.com/downloads/nagiosfusion/upgrade.sh | sh
This will upgrade Nagios Fusion without a need to import all settings to the new VM.