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/
