Re: [Dspam-user] dspam database for large installations

2010-08-06 Thread Paul Cockings
On 06/08/10 20:34, Nate Custer wrote: Hello, I am trying to get a dspam working for a very large setup (3 million+ domains) Hey Nate, (out of interest) Have you any thoughts how you will handle the training? Per user or just a group and some scripts to keep the group updated? You say

Re: [Dspam-user] dspam database for large installations

2010-08-06 Thread Stevan Bajić
On Fri, 06 Aug 2010 14:34:06 -0500 Nate Custer ncus...@hostgator.com wrote: Hello, Hello Nate, I am trying to get a dspam working for a very large setup (3 million+ domains) as such am running into some issues with the dspam database, to handle the rate of email filtering needed for

Re: [Dspam-user] dspam database for large installations

2010-08-06 Thread Nate Custer
Paul, (out of interest) Have you any thoughts how you will handle the training? Per user or just a group and some scripts to keep the group updated? My goal is to use a merged group to get a base line of training done, and then offer per-user training on top of that for each email

Re: [Dspam-user] dspam database for large installations

2010-08-06 Thread Stevan Bajić
On Fri, 06 Aug 2010 16:55:00 -0500 Nate Custer ncus...@hostgator.com wrote: Paul, (out of interest) Have you any thoughts how you will handle the training? Per user or just a group and some scripts to keep the group updated? My goal is to use a merged group to get a base line of

Re: [Dspam-user] dspam database for large installations

2010-08-06 Thread Nate Custer
Stevan, I had ignored master-master replication in mysql as it looked like a lot of work. I am currently using a mapping file on each of the servers to split traffic for multiple domains to different spamboxes. If I can get the sql db growth under control and make master-replication work,

Re: [Dspam-user] dspam database for large installations

2010-08-06 Thread Nate Custer
Hello, Thanks for the advice, notrain might be a really good trick. I think I want our users to be able to setup customer training per email address. I work for Hostgator.com, can't say a ton more then that, but we do host a ton of domains. Our last newsletter (blog.hostgator.com) has some

Re: [Dspam-user] dspam database for large installations

2010-08-06 Thread Imposit.com - webmaster
depending on the size of mailboxes you may choose multiple big groups instead of one single. may stavan correct me but my expierence is. if you have many multiple languages in the email traffic and and many different busninesses (like medical, industrial, sales, esales, private mails and so on)

Re: [Dspam-user] dspam database for large installations

2010-08-06 Thread Imposit.com - webmaster
Ok mysql it is,.. it is very interresting - here you can do a lot | | interactive_timeout=10 good to have it low but be aware of sideeffects in other applications | wait_timeout=3600 | connect_timeout=20 | thread_cache_size=128 | key_buffer=64M ## 32MB for every 1GB of RAM you really need

Re: [Dspam-user] dspam database for large installations

2010-08-06 Thread Stevan Bajić
On Sat, 7 Aug 2010 02:53:17 +0200 (CEST) Imposit.com - webmaster webmas...@imposit.com wrote: stevan are you shure about the compiled with intelcompiler`? Yes! Try it yourself. Compile it with PGO enabled and run a bunch of days and then recompile it again. You will see that it is faster then