Topic: Reverting to non-SQL Bayes data
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.8
- Linux/BSD distribution name and version: FreeBSD 11.2-RELEASE-p1
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
The other day our iRedMail server crashed, leading to corruption of the sa_bayes database (we have been storing Bayes data using MySQL). I am still investigating the root cause, and I was able to recreate the database, but a friend who runs a much larger email server said his testing showed that SQL performance for Bayes data is actually worse than plain text.
If I want to revert to storing Bayes data without SQL, is it really as simple as commenting out these lines in /usr/local/etc/mail/spamassassin/local.cf and restarting amavisd?
I set up a test machine with a vanilla installation of iRedMail 0.9.8 (no iRedAdmin-Pro). It appears that these are the only deltas from the default install, but just checking. Is it really this simple to go back to no SQL for Bayes data?