> > Well, I know there have to be some admins out there who have a lot of
> users
> > and do not use sitewide bayes...... RIGHT? See original email snippet at
> > bottom.
>
> <snip>
>
> > * Other ideas:
> > - increase system memory as much as possible
> > - per-domain Bayes instead of per-user???
>
> This might be our 2nd best choice (unless there is a good
> bayes_expiry_max_db_size solution), but I don't see anything in the manual
> about the syntax of bayes_sql_override_username. The manual mentions
> "grouping", but gives no examples of how I could, for instance, group bayes
> data by domain (my usernames are in the form [EMAIL PROTECTED]).
Just a follow-up to my own brain-lapse:
If you define a custom user scores query like this:
user_scores_sql_custom_query SELECT preference, value FROM
spamassassin_settings WHERE username = _USERNAME_ OR username = '!GLOBAL' OR
username = CONCAT('@', _DOMAIN_) ORDER BY username ASC
Then you can easily decide to use bayes on a per-domain basis for one or more
of your domains (and still have per-user bayes for all other domains). A
sample insert row into the settings table, then, would be:
INSERT INTO spamassassin_settings (username, preference, value) VALUES
('@example.com', 'bayes_sql_override_username', 'example.com');
So everyone in the example.com domain shares all bayes information which is
placed under the username "example.com".
> > - cluster Bayes DB???
>
> This apparently is not an option, since clustered MySQL databases are kept
> entirely in memory. We don't have any 10GB RAM machines sadly :)
>
> From the MySQL manual:
>
> In-memory storage:
>
> All data stored in each data node is kept in memory on the node's host
> computer. For each data node in the cluster, you must have available an
> amount of RAM equal to the size of the database times the number of
> replicas,
> divided by the number of data nodes. Thus, if the database takes up 1
> gigabyte of memory, and you wish to set up the cluster with 4 replicas and
> 8
> data nodes, a minimum of 500 MB memory will be required per node. Note that
> this is in addition to any requirements for the operating system and any
> other applications that might be running on the host.
>
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
