db clean

Simon Jones simonmjones at gmail.com
Tue May 5 17:35:46 IST 2009

2009/5/5 Martin Hepworth <maxsec at gmail.com>:
> more of a mailwatch question, but make sure the db_clean.php is running with
> the appropriate number of days - you may wish to reduce the default of 60
> days down a little (and make sure the require line at the start of the
> script points to the correct place to start with!)
> Also make sure the quarantine is cleared out correctly if you're using that
> in mailscanner (again see the tools dir)
> 2009/5/5 Simon Jones <simonmjones at gmail.com>
>> what's the best way to reduce the size of the db, currently i have
>> over 6 mil records and the search and stuff is slow as a turd :(  i
>> run dbclean.php on a cron but the site of the db, in particular the
>> maillog table are mahoosive...  anyone point me to some docs or have
>> any tips?
>> --
>> MailScanner mailing list
>> mailscanner at lists.mailscanner.info
>> http://lists.mailscanner.info/mailman/listinfo/mailscanner
>> Before posting, read http://wiki.mailscanner.info/posting
>> Support MailScanner development - buy the book off the website!
> --
> Martin Hepworth
> Oxford, UK
thanks Martin, apologies for wrong list posting.

i have days to keep set at 15 and i run a seperate db server so
there's no quatantine_maint to run as it doesn't process mail and it
seems to point to the correct functions.php location.

More information about the MailScanner mailing list