This support forum board is for questions relating to
Nagios Fusion.
-
dxk9_dtman
- Posts: 12
- Joined: Fri Nov 30, 2012 1:59 pm
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:
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
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
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.