our system is primarily just a relay with Spam/AV scanning.

We clear down the quarantine with the delete all button every day or two using the hidden delete all hack.

from what i have read ibdata1 does not reduce in size in normal operation, so an sql delete does not actualy delete the record in the database entirely. I thought, from reading that dropping and recreating the DB would fix this so did the rebuild-database. It has reduced it but not by much more than 10%

Accessing the spam quarantine even when there is only 100 or so items is very slow, so I guess it is parsing this 4.5GB file to find valid live quarantine items.

I am working on a 6.x platform to replace the current one as I don't think it's going to last long ( been in service 2 years though )

Cheers

Rob

Yup the mail quarantine is there... this might help
http://tracker.clearfoundation.com/view.php?id=242

So how has it got to 4.5GB?

Where is quarantine stored?

Cheers, Rob.

System-mysql is the backend sandboxed version of Mysql for the webconfig. In ClearOS 5.2 it wasn't used to store much unless you used Zarafa to keep your mail there?