RE: shared SQL DB

2005-06-15 Thread Mike Grice
uld run a local MySQL database, replicated from a master. Writes to the master over TCP, reads from local slave over UNIX socket... Mike -- | Mike Grice Broadband Solutions for | Systems Engineer Home & Business @ | PlusNet plc. www.plus.net + - PlusNet - The smarter way to broadband --

Re: The trouble with Bayes

2005-05-06 Thread Mike Grice
t, but doing multiple writes to a database for every mail passing through a system is a real resource glutton (and so I have to have them disabled). Users have problems with the above method because they don't like extra stuff in their message (if the DSPAM-ID is at the

Re: rulesemporium.com outage again?????

2005-05-03 Thread Mike Grice
ould be providers out there that could mirror the site without worrying too much? Cheers Mike -- | Mike Grice Broadband Solutions for | Systems Engineer Home & Business @ | PlusNet plc. www.plus.net + - PlusNet - The smarter way to broadband --

Re: SA + SQL + per-user prefs

2005-05-03 Thread Mike Grice
On Mon, 2005-05-02 at 10:49 -0500, Michael Parker wrote: > On Mon, May 02, 2005 at 04:33:28PM +0100, Mike Grice wrote: > > > > Nope, but think of how it would scale. The design above is bad because > > there is no unique data in there, so the table will get slow. A bette

Re: SA + SQL + per-user prefs

2005-05-02 Thread Mike Grice
pref4 1 bob 1 0 0 1 I'm looking into integrating user prefs this quarter where I work, and I do have some concerns on how it will scale (e.g., with mysql replication you need to send writes to a different machine from reads if you need to have seperate database

Re: Rule of thumb for max children?

2005-04-25 Thread Mike Grice
On Mon, 2005-04-25 at 11:58 +0100, Mike Grice wrote: > Hi there, > > I'm running SA 3.0.2 via spamc/spamd on an Exim mail server, but I'm > finding I quickly run out of memory and the machine collapses into a > burning heap as soon as it touches swap. > > Is th

Rule of thumb for max children?

2005-04-25 Thread Mike Grice
Hi there, I'm running SA 3.0.2 via spamc/spamd on an Exim mail server, but I'm finding I quickly run out of memory and the machine collapses into a burning heap as soon as it touches swap. Is there a rule of thumb of how many SA daemons to prefork to the amount of RAM? The boxes currently have

Re: Interesting RBL problem

2005-04-21 Thread Mike Grice
On Thu, 2005-04-21 at 10:19 -0500, Stuart Johnston wrote: > Mike Grice wrote: > > On Thu, 2005-04-21 at 04:37 -0700, Jeff Chan wrote: > > > > This I know (I'm a sysadmin ;-)), what I'm getting at is why would SA > > time it out? The system should use the h

Re: Interesting RBL problem

2005-04-21 Thread Mike Grice
On Thu, 2005-04-21 at 05:16 -0700, Jeff Chan wrote: > On Thursday, April 21, 2005, 5:12:37 AM, Mike Grice wrote: > > why would SA > > time it out? The system should use the hostfile in preference to DNS > > (e.g., in nsswitch.conf), but for some bizarre reason this lookup

Re: Interesting RBL problem

2005-04-21 Thread Mike Grice
On Thu, 2005-04-21 at 04:37 -0700, Jeff Chan wrote: > On Thursday, April 21, 2005, 4:26:46 AM, Mike Grice wrote: > > On Thu, 2005-04-21 at 03:55 -0700, Jeff Chan wrote: > >> On Thursday, April 21, 2005, 3:46:35 AM, Mike Grice wrote: > > >> >>From /etc/hosts:

Re: Interesting RBL problem

2005-04-21 Thread Mike Grice
On Thu, 2005-04-21 at 03:55 -0700, Jeff Chan wrote: > On Thursday, April 21, 2005, 3:46:35 AM, Mike Grice wrote: > > On Thu, 2005-04-21 at 03:01 -0700, Jeff Chan wrote: > > >> Did you remember to forward the queries for your local zones to > >> the rbldnsd server

Re: Interesting RBL problem

2005-04-21 Thread Mike Grice
On Thu, 2005-04-21 at 03:01 -0700, Jeff Chan wrote: > On Thursday, April 21, 2005, 2:40:49 AM, Mike Grice wrote: > > I then began to mirror the RBLs that we use (and SURBLS) to speed things > > up, but for some reason I'm now getting an RBL timeout. The way I did > > t

Interesting RBL problem

2005-04-21 Thread Mike Grice
Hi there, I'm trialling SA for use in our customer spamfiltering. I'm concerned about it's speed (due to the amount of mail we handle), so I ran in debug mode. As I suspected, the greatest delay is when the app has to callout to the net, e.g., RBL lookups and the like. I then began to mirror