1

Topic: avamvisd mysql table too big...

==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
====

Hi, I realize that amavisd db is too big...
It's possible to empty quarantine table at least?
And how?

Thanks, this is the DB dimensions:

[root@mail ~]# du -hs /var/lib/mysql/amavisd/*
4,0K    /var/lib/mysql/amavisd/db.opt
12K    /var/lib/mysql/amavisd/maddr.frm
137M    /var/lib/mysql/amavisd/maddr.ibd
12K    /var/lib/mysql/amavisd/mailaddr.frm
0    /var/lib/mysql/amavisd/mailaddr.MYD
4,0K    /var/lib/mysql/amavisd/mailaddr.MYI
12K    /var/lib/mysql/amavisd/msgrcpt.frm
421M    /var/lib/mysql/amavisd/msgrcpt.ibd
16K    /var/lib/mysql/amavisd/msgs.frm
985M    /var/lib/mysql/amavisd/msgs.ibd
16K    /var/lib/mysql/amavisd/policy.frm
0    /var/lib/mysql/amavisd/policy.MYD
4,0K    /var/lib/mysql/amavisd/policy.MYI
12K    /var/lib/mysql/amavisd/quarantine.frm
6,7G    /var/lib/mysql/amavisd/quarantine.ibd
12K    /var/lib/mysql/amavisd/users.frm
0    /var/lib/mysql/amavisd/users.MYD
4,0K    /var/lib/mysql/amavisd/users.MYI
12K    /var/lib/mysql/amavisd/wblist.frm
0    /var/lib/mysql/amavisd/wblist.MYD
4,0K    /var/lib/mysql/amavisd/wblist.MYI

----

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

2

Re: avamvisd mysql table too big...

You can clean up amavisd database with script shipped in iRedAdmin (both open source edition and Pro edition): tools/cleanup_amavisd_db.py.

It's recommended to run this script manually first, then add a daily cron job to execute it.

Note: please use the latest release of iRedAdmin, this script shipped in old release will cause performance issue if you have too many records in amavisd database.

3

Re: avamvisd mysql table too big...

ZhangHuangbin wrote:

You can clean up amavisd database with script shipped in iRedAdmin (both open source edition and Pro edition): tools/cleanup_amavisd_db.py.

It's recommended to run this script manually first, then add a daily cron job to execute it.

Note: please use the latest release of iRedAdmin, this script shipped in old release will cause performance issue if you have too many records in amavisd database.

Tnx Zhang, where I can find the updated version of this script?
Or in another words, where I can download free latest version of iredadmin?

4

Re: avamvisd mysql table too big...

http://iredmail.org/yum/misc/

5

Re: avamvisd mysql table too big...

This directory contains the latest stable release of iRedAdmin (open source  edition).

Here's its source code repository:
https://bitbucket.org/zhb/iredadmin-ose/commits

6

Re: avamvisd mysql table too big...

ZhangHuangbin wrote:

This directory contains the latest stable release of iRedAdmin (open source  edition).

Here's its source code repository:
https://bitbucket.org/zhb/iredadmin-ose/commits

Hi,

I try the script, but the server become unresponsive and queue become too big.

Can I truncate just the quarantine table?

Thanks...

7

Re: avamvisd mysql table too big...

posa68 wrote:

Can I truncate just the quarantine table?

Yes.