upgrading nagios-fusion with .OVA vmware image

This support forum board is for questions relating to Nagios Fusion.
dxk9_dtman
Posts: 12
Joined: Fri Nov 30, 2012 1:59 pm

Re: upgrading nagios-fusion with .OVA vmware image

Post 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
You do not have the required permissions to view the files attached to this post.
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: upgrading nagios-fusion with .OVA vmware image

Post 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
dxk9_dtman
Posts: 12
Joined: Fri Nov 30, 2012 1:59 pm

Re: upgrading nagios-fusion with .OVA vmware image

Post by dxk9_dtman »

Ok, thanks.

So, for 4.1, we'll plan to go to a new VM image and add that setting.
npolovenko
Support Tech
Posts: 3457
Joined: Mon May 15, 2017 5:00 pm

Re: upgrading nagios-fusion with .OVA vmware image

Post 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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked