Jump to: navigation, search
MithiWiki Home > ConnectXf Home > ConnectXf Administration > Configuration > Database size growing on server
Troubleshooting Icon.png
Troubleshooting
Product ConnectXf
Version All
Applies to Administrators
Level Advanced



Database size growing on server

Problem

Database size is large. It should not be above @4GB. Check the folder size using following command:

du -hs /var/lib/pgsql/data

Cause

The database size is large because of spam report data. The agent to rotate the table is set to 30 days, so it has grown large.


  mcs_rotate_report_database%MCS rotate REPORT database%on%0 0 * * *%1%2%1%/mithi/mcs/modules/mithi-bl/admin/bl/bin/agent_rotate_report_database.sh%30

Solution

Change the agent to delete data after every 7 days instead of every 30 days.

 /mithi/mcs/bin/modifyagent.sh mcs_rotate_report_database -restartagents t -agent_params 7

NOTE The spam report data will be available only for the 7 days.