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/
