Marc Perkel wrote: > I've had bayes disabled in SA because it seems to not be able to stay > working in a high volume situation. The MySQL server can't seem to keep > up with it even on very fast computers.
I'm curious where you started seeing performance issues (number of messages, users; hardware platform stats), because it's something I'm keeping in mind for "things to watch out for" locally. Particularly in light of: > Yes MariaDB was better than MySQL but not good enough to keep up. I even > tried putting the database on ram disk and still didn't work. where we switched from MySQL (either ISAM or InnoDB) on disk to ramdisk, and immediately dropped 90%+ of the performance issues we were having. We also found that MySQL replication was such an I/O hog that it was better to single-host the SA Bayes DB, keep reasonable backups, and plan to restore from backup instead of trying for hot or warm failover. -kgd
