help - big queue slow load

[Marco mangione]

what operation do exactly sa-learn --force-expire ?

thanks

2009/7/29 Julian Field <MailScanner at ecs.soton.ac.uk>

> 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/> <
>> http://www.MailScanner.info <http://www.mailscanner.info/>>
>>                Buy the MailScanner book at www.MailScanner.info/store<http://www.mailscanner.info/store>
>>                <http://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 <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 and 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
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
>
> Before posting, read http://wiki.mailscanner.info/posting
>
> Support MailScanner development - buy the book off the website!
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20090729/bf311c08/attachment-0001.html