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

Database size growing on server


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

du -hs /var/lib/pgsql/data


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


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.