Thanks Mark,

> amavisd-new on the other hand uses persistent connection to SQL on its 
> own SQL lookups and logging/quarantining to SQL, one connection per 
> child process.
> 

How I have to do to migrate amavisd-new versus SQL database? Are there
effective improvements?

> You should ask on the SA list. How many child processess are you 
> running?
> Perhaps it's just that your SQL tables need to be OPTIMIZEd, or are 
> missing good indexes. I see MySQL server using only a small fraction 
> of the CPU and I/O on a system where
> amavisd+SA is running.

set-variable    = max_connection=200

rocsca 

> -----Messaggio originale-----
> Da: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] Per conto 
> di Mark Martinec
> Inviato: giovedì 22 giugno 2006 3.06
> A: [email protected]
> Oggetto: Re: [AMaViS-user] SpamAssassin and SQL
> 
> rocsca,
> 
> > I set up amavisd-new so that spamassassin keeps information 
> collected 
> > by bayesian algorithm in a MySQL db.
> > I don't understand how this works exactly.
> > But I suppose that when spamassassin scans a mail message than:
> > - it establishes a connection with the MySQL server
> > - it queries or updates the database
> > - it close connection.
> > as many time it needs for a single messages.
> 
> Not more than once for one message.
> 
> > So I get that mysql server works a lot with spamassassin and it 
> > consumes all CPU resources about all time.
> 
> I haven't heard of it being a problem so far.
> Using SQL for Bayes is usually a great relief from previous 
> use of bdb.
> 
> > There is a why for optmizing the resources (e.g.: saving 
> the number of 
> > established connections, using persistent connection - like 
> PHP permit 
> > to do..)?
> 
> I don't think there exists a mechanism by which spamassassin 
> could use a persistent connection to SQL for Bayes/AWL across 
> several message.
> 
> Perhaps some SQL proxy could be used, don't know if that is feasible.
> 
> amavisd-new on the other hand uses persistent connection to 
> SQL on its own SQL lookups and logging/quarantining to SQL, 
> one connection per child process.
> 
> > PS: Can someone point me where I can I could read this information 
> > about the architecture of spamassassin so that I can improve the 
> > performance as I need?
> 
> You should ask on the SA list. How many child processess are 
> you running?
> Perhaps it's just that your SQL tables need to be OPTIMIZEd, 
> or are missing good indexes. I see MySQL server using only a 
> small fraction of the CPU and I/O on a system where 
> amavisd+SA is running.
> 
>   Mark
> 
> All the advantages of Linux Managed Hosting--Without the Cost 
> and Risk!
> Fully trained technicians. The highest number of Red Hat 
> certifications in the hosting industry. Fanatical Support. 
> Click to learn more
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&;
> dat=121642
> _______________________________________________
> AMaViS-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/amavis-user
> AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
> AMaViS-HowTos:http://www.amavis.org/howto/
> 


All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/

Reply via email to