> Hi, > Hello Peter,
> I've used dspam for a while and love it. I've used the MySQL storage > driver for a while, and have occasionally had problems with the MySQL > server getting too overloaded and being OOM-killed by Linux, so I have a > fairly low connection limit in place on the database. (It's running on a > VPS and I'm not allocated much RAM.) > What version of DSPAM? The newer versions of DSPAM are much more gentile to the MySQL storage backend then they used to be. Have you tried 3.9.0 GIT lately? > Lately, I've installed some new pieces of software which also use the > database, so I've been seeing more and more bursts of spam getting > through as the database connection limit is hit and dspam just passes > messages on without filtering them. > > To fix this, I'm pondering moving from the mysql storage driver to the > hash storage driver. The hash driver is supposed to be more efficient > and I don't feel comfortable raising the connection limit on MySQL. (If > it gets OOM-killed the tables have to be manually recovered.) > The hash driver uses memory mapped files. I don't know if that is better in your case? > My question is, is it possible to migrate the dspam token/signature/etc > databases from the mysql to the hash driver in some way, or would I have > to lose everyone's dspam training? > Short answer: No! It's not possible. Long answer: It's possible to write a migration code but that would take some time. > Also if anyone has any comments on the general advisability of this, I'd > be interested in them. > 1) Stay with MySQL but use DSPAM >= 3.9.0 GIT 2) Switch to TOE training mode (as it is more gentile to the database) 3) Switch to OSB tokenizer (it produces a low amount of tokens while almost as accurate as SBPH. In some cases it's better then SBPH) 4) Reduce MySQLConnectionCache (default is 3) > Thanks, > > Peter > Steve -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Dspam-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspam-user
