help - big queue slow load

[Julian Field]

Try doing this as root:

sa-learn --force-expire

It may take a little while.

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

Jules

-- 
Julian Field MEng CITP CEng
www.MailScanner.info
Buy the MailScanner book at www.MailScanner.info/store

Need help customising MailScanner?
Contact me!
Need help fixing or optimising your systems?
Contact me!
Need help getting you started solving new requirements from your boss?
Contact me!

PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
Follow me at twitter.com/JulesFM and twitter.com/MailScanner


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.