<div>what operation do exactly sa-learn --force-expire ?</div>
<div> </div>
<div>thanks<br><br></div>
<div class="gmail_quote">2009/7/29 Julian Field <span dir="ltr">&lt;<a href="mailto:MailScanner@ecs.soton.ac.uk">MailScanner@ecs.soton.ac.uk</a>&gt;</span><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Try doing this as root:<br><br>sa-learn --force-expire<br><br>It may take a little while. 
<div class="im"><br><br>On 28/07/2009 12:13, Marco mangione wrote:<br></div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div class="im">this is the detail of bayes table<br><br>| bayes_seen        | BASE TABLE |   406301568 | MyISAM |<br>| bayes_token       | BASE TABLE |  1028785670 | MyISAM |<br><br><br><br></div>2009/7/28 Marco mangione &lt;<a href="mailto:marco.mangione@gmail.com" target="_blank">marco.mangione@gmail.com</a> &lt;mailto:<a href="mailto:marco.mangione@gmail.com" target="_blank">marco.mangione@gmail.com</a>&gt;&gt; 
<div class="im"><br><br>   seems there are some hang when mailscanner connect to SA db ..<br>   that is bigger than 2GB.... what can i do in this case ?<br><br>   2009/7/28 MailScanner &lt;<a href="mailto:MailScanner@ecs.soton.ac.uk" target="_blank">MailScanner@ecs.soton.ac.uk</a><br>
</div>   &lt;mailto:<a href="mailto:MailScanner@ecs.soton.ac.uk" target="_blank">MailScanner@ecs.soton.ac.uk</a>&gt;&gt; 
<div class="im"><br><br>       If the mail is only being processed very slowly, then unless<br>       you have the parallelism set too *high* (Max Children should<br>       be 5 to start with) then there must be some good reason why it<br>
       is taking a long time. Set &quot;Log Speed = yes&quot; in<br>       MailScanner.conf and restart MailScanner. Then look at your<br>       logs and work out what is taking all the time?<br><br>       When you ran with &quot;--debug --sa-debug&quot;, were there any long<br>
       pauses in the output? There shouldn&#39;t be, once it has started<br>       doing the spam scanning.<br><br>       Also, you can try switching off the spam scanning altogether,<br>       just to double check that is where the problem lies and not in<br>
       your virus scanning. What is &quot;Virus Scanners =&quot; set to in<br>       MailScanner.conf?<br><br>       On Tue, 28 Jul 2009 10:48:42 +0200, Marco mangione<br></div>       &lt;<a href="mailto:marco.mangione@gmail.com" target="_blank">marco.mangione@gmail.com</a> &lt;mailto:<a href="mailto:marco.mangione@gmail.com" target="_blank">marco.mangione@gmail.com</a>&gt;&gt; 
<div class="im"><br>       wrote:<br><br>           DNS are ok. resolution are quick.<br>           can i try to increase parallels postfix or mailscanner<br>           process ?<br>           server have much cpu and ram unused...<br>
<br>           2009/7/27 Julian Field &lt;<a href="mailto:MailScanner@ecs.soton.ac.uk" target="_blank">MailScanner@ecs.soton.ac.uk</a><br></div>           &lt;mailto:<a href="mailto:MailScanner@ecs.soton.ac.uk" target="_blank">MailScanner@ecs.soton.ac.uk</a>&gt;&gt; 
<div class="im"><br><br>               Most likely DNS lookups. Check your DNS is working<br>               properly and you can reach all the blacklists you use<br>               very quickly.<br><br>               Start by doing a &quot;MailScanner --debug --sa-debug&quot; and<br>
               watch for any long pauses.<br><br><br>               On 27/07/2009 11:29, Marco mangione wrote:<br><br>                   Hello,<br><br>                   i have a big queue: 3800mails and very slow load:<br>
                   0.20 seems postfix and mailscanner dont want use<br>                   server resource to speed up ... any idea?<br><br>                   marco<br><br><br>               Jules<br><br>               --                Julian Field MEng CITP CEng<br>
</div>               <a href="http://www.mailscanner.info/" target="_blank">www.MailScanner.info</a> &lt;<a href="http://www.mailscanner.info/" target="_blank">http://www.MailScanner.info</a>&gt; 
<div class="im"><br>               Buy the MailScanner book at <a href="http://www.mailscanner.info/store" target="_blank">www.MailScanner.info/store</a><br></div>               &lt;<a href="http://www.mailscanner.info/store" target="_blank">http://www.MailScanner.info/store</a>&gt; 
<div class="im"><br><br>               Need help customising MailScanner?<br>               Contact me!<br>               Need help fixing or optimising your systems?<br>               Contact me!<br>               Need help getting you started solving new requirements<br>
               from your boss?<br>               Contact me!<br><br>               PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947<br>               1415 B654<br>               Follow me at <a href="http://twitter.com/JulesFM" target="_blank">twitter.com/JulesFM</a><br>
</div>               &lt;<a href="http://twitter.com/JulesFM" target="_blank">http://twitter.com/JulesFM</a>&gt; and<br>               <a href="http://twitter.com/MailScanner" target="_blank">twitter.com/MailScanner</a> &lt;<a href="http://twitter.com/MailScanner" target="_blank">http://twitter.com/MailScanner</a>&gt; 
<div class="im"><br><br><br>               --                This message has been scanned for viruses and<br>               dangerous content by MailScanner, and is<br>               believed to be clean.<br><br>               --                MailScanner mailing list<br>
               <a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a><br></div>               &lt;mailto:<a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a>&gt; 
<div class="im"><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<br>               website!<br><br><br>       --        Jules<br></div>       <a href="mailto:MailScanner@ecs.soton.ac.uk" target="_blank">MailScanner@ecs.soton.ac.uk</a> &lt;mailto:<a href="mailto:MailScanner@ecs.soton.ac.uk" target="_blank">MailScanner@ecs.soton.ac.uk</a>&gt; 
<div class="im"><br><br><br>       --        This message has been scanned for viruses and<br></div>       dangerous content by *MailScanner*<br>       &lt;<a href="http://www.mailscanner.info/" target="_blank">http://www.mailscanner.info/</a>&gt;, and is 
<div class="im"><br>       believed to be clean.<br><br>       -- <br>       MailScanner mailing list<br>       <a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a><br>
</div>       &lt;mailto:<a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a>&gt; 
<div class="im"><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><br><br><br></div></blockquote>
<div>
<div></div>
<div class="h5"><br>Jules<br><br>-- <br>Julian Field MEng CITP CEng<br><a href="http://www.mailscanner.info/" target="_blank">www.MailScanner.info</a><br>Buy the MailScanner book at <a href="http://www.mailscanner.info/store" target="_blank">www.MailScanner.info/store</a><br>
<br>Need help customising MailScanner?<br>Contact me!<br>Need help fixing or optimising your systems?<br>Contact me!<br>Need help getting you started solving new requirements from your boss?<br>Contact me!<br><br>PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654<br>
Follow me at <a href="http://twitter.com/JulesFM" target="_blank">twitter.com/JulesFM</a> and <a href="http://twitter.com/MailScanner" target="_blank">twitter.com/MailScanner</a><br><br><br>-- <br>This message has been scanned for viruses and<br>
dangerous content by MailScanner, and is<br>believed to be clean.<br><br>-- <br>MailScanner mailing list<br><a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">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></div></div></blockquote>
</div><br>