Mailing List Archive

Author: parker
Date: Sat Aug 13 10:51:28 2005
New Revision: 232512

URL: http://svn.apache.org/viewcvs?rev=232512&view=rev
Log:
Documentation updates

Modified:
spamassassin/trunk/UPGRADE
spamassassin/trunk/lib/Mail/SpamAssassin/BayesStore/MySQL.pm

Modified: spamassassin/trunk/UPGRADE
URL: http://svn.apache.org/viewcvs/spamassassin/trunk/UPGRADE?rev=232512&r1=232511&r2=232512&view=diff
==============================================================================
--- spamassassin/trunk/UPGRADE (original)
+++ spamassassin/trunk/UPGRADE Sat Aug 13 10:51:28 2005
@@ -44,6 +44,32 @@
3.0.x versions will be used instead, where all processes receive an
equal load and no scaling takes place.

+- As of 3.1.0, in addition to the generic BayesSQL support (via
+ Mail::SpamAssassin::BayesStore::SQL) usable by multiple database
+ drivers there is now specific support for MySQL 4.1+ and
+ PostgreSQL. This support is based on non-standard features present
+ in both database servers that allow for various performance boosts.
+
+ If you were using the previous BayesSQL support with MySQL, and
+ already have MySQL 4.1+ installed you can begin using the new module
+ immediately by replacing the bayes_store_module line in your
+ configuration with: Mail::SpamAssassin::BayesStore::MySQL
+
+ We do however recommend that you switch your MySQL tables over to
+ InnoDB for better data integrity and multi user support. You can
+ most often do this via a simple ALTER TABLE command, refer to the
+ MySQL documentation for more information.
+
+ If you were previously using PostgreSQL for your bayes database then
+ we STRONGLY recommend switching to the PostgreSQL specific backend:
+ Mail::SpamAssassin::BayesStore::PgSQL
+ To switch to this backend you should first run sa-learn --backup to
+ make a backup of your existing data and then drop and recreate the
+ database following the instructions in sql/README.bayes. Then you
+ can restore the database with sa-learn --restore. If you have
+ multiple users then you will have to run --backup and --restore for
+ each user to fully restore the database.
+
- See http://wiki.apache.org/spamassassin/UpgradeTo310 for a
supplementary list of upgrade notes. It will be updated with any
upgrade notes not captured in this document.

Modified: spamassassin/trunk/lib/Mail/SpamAssassin/BayesStore/MySQL.pm
URL: http://svn.apache.org/viewcvs/spamassassin/trunk/lib/Mail/SpamAssassin/BayesStore/MySQL.pm?rev=232512&r1=232511&r2=232512&view=diff
==============================================================================
--- spamassassin/trunk/lib/Mail/SpamAssassin/BayesStore/MySQL.pm (original)
+++ spamassassin/trunk/lib/Mail/SpamAssassin/BayesStore/MySQL.pm Sat Aug 13 10:51:28 2005
@@ -28,7 +28,7 @@
possibly corrupt your bayes database data.

In addition, this module will support rollback on error, if you are using
-the InnoDB database type in MySQL. For more information please review
+the InnoDB database table typ in MySQL. For more information please review
the instructions in sql/README.bayes.

=cut