SM <[EMAIL PROTECTED]> writes: [...] >>Now I use MyISAM strorage backend, because I just created Bayesian >>database using Spamassassin sql/bayes_mysql.sql file :) > > The recommendations in the sql/bayes_mysql.sql file are for the > average setup. It doesn't cover MySQL optimization techniques as that > a MySQL specific issue. > > You can change the engine from MyISAM to InnoDB (see ALTER TABLE). > That should improve performance for INSERTs. With the amount of mail > your server handles, you either have to improve MySQL performance, > switch to more powerful hardware or disable Bayes. If you disable > Bayes, the punctuation spam would still be caught in your setup as it > scored over 19 points.
Hello again! :) I'm working on conversion of storage engine from MyISAM to InnoDB. My hardware seems to be good enough. It's Sun Fire x4100 M2 server with 2 x Dual-Core AMD Opteron 2220 SE CPUs and 8GB RAM on the board and it's bored with its job ;) I think I rather need faster disks. My best regards, Pawel
