Page 1 of 2
ibdata1 file size increasing in fusion server
Posted: Wed Jul 11, 2018 4:15 am
by amane
Hi,
We are using fusion 4. In the fusion server ibdata1 file size is continuously increasing.
Now the ibdata1 file size is 119309074432 bytes. Could you please tell me how we can reduce the size of this file.
Re: ibdata1 file size increasing in fusion server
Posted: Wed Jul 11, 2018 1:31 pm
by cdienger
Is it 4.0 ? Newer versions should do a better job of keeping the database pruned. I'd suggest upgrading if it's not on 4.1.4 -
https://assets.nagios.com/downloads/nag ... ctions.pdf
You can also try freeing up some space immediately by running:
/usr/local/nagiosfusion/scripts/truncate_polled.php
Re: ibdata1 file size increasing in fusion server
Posted: Mon Jul 16, 2018 8:45 am
by amane
Is it 4.0 ? Newer versions should do a better job of keeping the database pruned. I'd suggest upgrading if it's not on 4.1.4 -
We are using 4.0.1. Need to resolve this issue before upgrade to 4.1.4.
You can also try freeing up some space immediately by running:
/usr/local/nagiosfusion/scripts/truncate_polled.php
We have ran above command but its not reduced the ibdata1 size.
is there any way to reduce the size of this file? is there any issue if we delete this file?
Re: ibdata1 file size increasing in fusion server
Posted: Mon Jul 16, 2018 1:24 pm
by cdienger
Run the following to reclaim space:
cd /usr/local/nagiosfusion/scripts
./truncate_polled.php
echo 'OPTIMIZE TABLE polled_extras;' |mysql -u fusion -pfusion fusion
Re: ibdata1 file size increasing in fusion server
Posted: Tue Jul 17, 2018 9:56 am
by amane
Thanks cdienger,
Do this script need to run with using root account? I have ran this script but not sure if it is working.
[nagios@lxfusnagprd001 scripts]$ ./truncate_polled.php
Re: ibdata1 file size increasing in fusion server
Posted: Tue Jul 17, 2018 11:09 am
by cdienger
I would recommend running it as root. You can run:
echo $?
after running the command. This will show you the result code of the previous command. A 0 means it existed normally.
Re: ibdata1 file size increasing in fusion server
Posted: Fri Jul 20, 2018 7:37 am
by amane
Hi cdienger,
Approx. how much time it will take to complete this script??
Re: ibdata1 file size increasing in fusion server
Posted: Fri Jul 20, 2018 8:28 am
by cdienger
It's hard to say. The truncation should be relatively quick, but the optimization I believe requires making a copy of data remaining in the tables after truncation and would depend on system hardware.
Re: ibdata1 file size increasing in fusion server
Posted: Tue Jul 31, 2018 10:20 am
by amane
We ran this script again and we got the output as well but idata1 file size is not reduced.
[root@lxfusnagprd001 scripts]# ./truncate_polled.php
polled tables truncated!
Re: ibdata1 file size increasing in fusion server
Posted: Tue Jul 31, 2018 1:46 pm
by cdienger
You must run the optimization command as well to reclaim space taken by the database.