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, that would be a serious improvement in my overall design. Are you using NFS for the /var/dspam data as well?
I am currently doing TOE traning for all users, but I am seeing some updates when I stress test (I think that may be the before 25k messages filtered barrier being hit). Right now no training should be happening as the users don't know about dspam and should not be training. The my.cnf is not very interesting (but is attached below). The dspam.conf is mostly full of the IgnoreHeader rules you provided earlier. To make it a bit more readable I filtered those out. As far as the OS, am running a stock CentOS 5.4 64 bit, with the stock compiler options: [r...@vps2 mysql]# gcc -v Using built-in specs. Target: x86_64-redhat-linux Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --enable-checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-libgcj-multifile --enable-languages=c,c++,objc,obj-c++,java,fortran,ada --enable-java-awt=gtk --disable-dssi --enable-plugin --with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre --with-cpu=generic --host=x86_64-redhat-linux Thread model: posix gcc version 4.1.2 20080704 (Red Hat 4.1.2-48) Nate -------------------------------------------------------------------------------------------------- dspam.conf: [r...@vps2 mysql]# cat /usr/local/etc/dspam.conf | grep -v IgnoreHeader | grep -v "#" | uniq Home /var/dspam StorageDriver /usr/local/lib/dspam/libmysql_drv.so DeliveryHost 127.0.0.1 DeliveryPort 10026 DeliveryIdent localhost DeliveryProto SMTP OnFail error Trust root Trust dspam Trust apache Trust mail Trust mailnull Trust smmsp Trust daemon TrainingMode toe TestConditionalTraining on Feature whitelist Algorithm graham burton Tokenizer osb PValue bcr WebStats on ImprobabilityDrive on AllowOverride enableWhitelist MySQLServer /var/lib/mysql/mysql.sock MySQLPort 3306 MySQLUser dspam MySQLPass HIDDEN MySQLDb dspam MySQLCompress true MySQLReconnect true MySQLConnectionCache 8 MySQLUIDInSignature off HashRecMax 98317 HashAutoExtend on HashMaxExtents 0 HashExtentSize 49157 HashPctIncrease 10 HashMaxSeek 10 HashConnectionCache 10 Notifications off PurgeNeutral 90 LocalMX 127.0.0.1 SystemLog on UserLog on Opt out ParseToHeaders on ChangeModeOnParse on ChangeUserOnParse full ServerHost 127.0.0.1 ServerPort 24 ServerQueueSize 64 ServerPID /var/run/dspam.pid ServerMode auto ServerPass.Relay1 "HIDDEN" ServerParameters "--deliver=innocent -d %u" ServerIdent "vps2.wehatetrees.org" ServerDomainSocketPath "/tmp/dspam.sock" ClientHost /tmp/dspam.sock ClientIdent "HIDDEN" ProcessorURLContext on ProcessorBias on StripRcptDomain off [r...@vps2 mysql]# cat /etc/my.cnf [mysqld] tmpdir=/tmp open_files_limit=33628 old_passwords=1 datadir=/var/lib/mysql skip-locking safe-show-database tmp_table_size = 256M max_heap_table_size = 256M query_cache_limit=32M query_cache_size=96MB ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=25 max_connections=150 collation_server=utf8_unicode_ci character_set_server=utf8 delayed_insert_timeout=40 interactive_timeout=10 wait_timeout=3600 connect_timeout=20 thread_cache_size=128 key_buffer=64M ## 32MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=16M table_cache=8196 record_buffer=1M sort_buffer_size=2M ## 1MB for every 1GB of RAM read_buffer_size=2M ## 1MB for every 1GB of RAM read_rnd_buffer_size=2M ## 1MB for every 1GB of RAM thread_concurrency=8 ## Number of CPUs x 2 myisam_sort_buffer_size=32M server-id=1 pbxt-record-cache-size=1G pbxt-index-cache-size=1G [mysql.server] user=mysql [safe_mysqld] open_files_limit=33628 err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
