ibdata1 file size increasing in fusion server

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

[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

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

[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

[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

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

[amane]

Hi cdienger,

Approx. how much time it will take to complete this script??

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

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

[cdienger]

You must run the optimization command as well to reclaim space taken by the database.