Page 1 of 1

database size is increasing very fast

Posted: Fri Aug 04, 2017 10:47 am
by vinish098
We are monitoring 650 nodes with 6500 services.

This is a very old setup, around more than 3 years.

I observed the "/var" is consuming 444 GB of space.

Under "/var" :-
/var/lib/mysql - 14GB
/var/lib/pgsql - 344GB
/var/tmp - 82GB (213247 files)

It seems completely abnormal behavior. Please help here to clean the disk space.

Thanks..

Re: database size is increasing very fast

Posted: Fri Aug 04, 2017 11:50 am
by dwhitfield
Ignore the title of this article. Scroll down to the part about postgres, and vacuum your postgres: https://support.nagios.com/kb/article/n ... rface.html

Also, can you PM me your Profile? You can download it by going to Admin > System Config > System Profile and click the ***Download Profile*** button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info). This will give us access to many of the logs we would otherwise ask for individually. If security is a concern, you can unzip the profile take out what you like, and then zip it up again. We may end up needing something you remove, but we can ask for that specifically.

After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.