1 Topic by kotso

  • kotso
  • Member
  • Offline
  • Registered: 2011-04-15
  • Posts: 9

Topic: amavisd statistic in iRedAdmin

Hello,

Today I configured amavisd part of iRedAdmin and I faced following problem.

My amavisd database is too big (>5Gb after 10 days)

and iRedAdmin could not load such a big amount smile

So my question is how often you clean up your amavisd db and it there any tool to do ?

Or just delete old records from db? Simple mysql query or there is some tool?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: amavisd statistic in iRedAdmin

Just a cron job with simple SQL command to delete old records.
Reference: http://www.iredmail.org/forum/topic1692 … -mail.html

You can set a day to keep these records in iRedAdmin-Pro-x.y.z/libs/settings.py:

# Automatically remove SQL records of sent/received mails in Amavisd database
# when viewing sent/received mails. Only one time in each login session.
# Default is 90 days. Set to 0 to keep them forever.
AMAVISD_REMOVE_MAILLOG_IN_DAYS = 30

# Automatically remove SQL records of quarantined mails which older than
# specified days when list quarantined mails. Only one time in each login
# session.
# Since quarantined mails may take much disk space, it's better to release
# or remove them as soon as possible.
# Default is 30 days. Set to 0 to keep them forever.
AMAVISD_REMOVE_QUARANTINED_IN_DAYS = 7

Each time you access 'System -> Sent Mails/Received Mails/Quarantined Mails' in iRedAdmin-Pro, it will delete records older than 30 or 7 days automatically.