db clean

[Martin Hepworth]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20090505/19833297/attachment.html