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!)<br>
<br><div>Also make sure the quarantine is cleared out correctly if you're using that in mailscanner (again see the tools dir)</div><div><br><div class="gmail_quote">2009/5/5 Simon Jones <span dir="ltr"><<a href="mailto:simonmjones@gmail.com">simonmjones@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">what's the best way to reduce the size of the db, currently i have<br>
over 6 mil records and the search and stuff is slow as a turd :( i<br>
run dbclean.php on a cron but the site of the db, in particular the<br>
maillog table are mahoosive... anyone point me to some docs or have<br>
any tips?<br>
<font color="#888888">--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!<br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Martin Hepworth<br>Oxford, UK<br>
</div>