Hello I've been running DSPAM 3.80 for some time and recently upgraded to 3.9.0. Of late, with either version, I've had issues with my mail queue, or more accurately DSPAM taking so long to process messages before delivering to maildirs (using qmail). Can anyone see any potential issues with my MySQL config below? The server in question runs mysql-standard-4.1.7-pc-linux-i686 and DSPAM 3.9.0. I've included my dspam.conf file too.
qmail is setup with local delivery concurrency of 45. Thanks Dale ---- dspam config ---- Home /var/lib/dspam StorageDriver /opt/dspam-3.9.0/lib/dspam/libmysql_drv.so TrustedDeliveryAgent "/usr/local/bin/vmail-deliver-dspam %u Maildir" QuarantineAgent "/usr/local/bin/vmail-deliver-dspam %u Maildir/.Spam" OnFail error Trust vmail TrainingMode teft TestConditionalTraining on Feature noise Feature whitelist Feature tb=5 Algorithm graham burton Tokenizer chain PValue bcr Preference "spamAction=quarantine" Preference "signatureLocation=message" # 'message' or 'headers' AllowOverride trainingMode AllowOverride spamAction spamSubject AllowOverride statisticalSedation AllowOverride enableBNR AllowOverride enableWhitelist AllowOverride signatureLocation AllowOverride showFactors AllowOverride optIn optOut AllowOverride whitelistThreshold MySQLServer /tmp/mysql.sock MySQLPort MySQLUser dspam MySQLPass secretpassword MySQLDb dspam MySQLCompress true MySQLConnectionCache 50 MySQLUIDInSignature on Notifications off PurgeSignatures 14 # Stale signatures PurgeNeutral 90 # Tokens with neutralish probabilities PurgeUnused 90 # Unused tokens PurgeHapaxes 30 # Tokens with less than 5 hits (hapaxes) PurgeHits1S 15 # Tokens with only 1 spam hit PurgeHits1I 15 # Tokens with only 1 innocent hit LocalMX 127.0.0.1 SystemLog on UserLog on Opt out TrackSources spam Broken case MaxMessageSize 524288 ServerMode dspam ServerDomainSocketPath "/tmp/dspam.sock" ClientHost /tmp/dspam.sock ProcessorURLContext on ProcessorBias on ---- mysql config ---- [client] port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking #key_buffer = 256M key_buffer = 128M max_allowed_packet = 8192000 table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K query_cache_size = 8M read_rnd_buffer_size = 512K myisam_sort_buffer_size = 64M #skip-networking server-id = 1 innodb_data_home_dir = /usr/local/mysql/data/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data/ innodb_log_arch_dir = /usr/local/mysql/data/ innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout ------------------------------------------------------------------------------ _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
