From: Dave Goodrich [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 4:25 PM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] what appears to be mysql errors inside.... and other
Grimes, David wrote:
> Hello all,
> New user/abuser here...
> 1. Last night, due to a problem with a corporate mail server, my
> server got flooded with ~20k emails. It tried like heck to chew through
> but the poor little machine just wasn't havin' it. My setup is a gentoo
> running vpopmail, qmail, qmail-scanner, spamassassin, -prot, and
> al. with the latest packages as of yesterday. I have two questions 1.
> Outside of better hardware what are some things I should do to the
> config to better equip it for things? Switches, etc...
What do you have now for hardware?
[DG] Athlon 1700 512 60gig ide drive
What version of SA are you running?
[DG] SA is 2.6.3
What extra rules are your running in SA?
[DG] I used the out of the box rule set. Since reading your message I've
removed the RBL and razor checks/usage.
How many messages do you normally handle a day?
[DG] this machine sees ~25k messages a day
I have found that when getting blasted to the extent that it becomes a
hardware issue, turning off SA until you can get the queue cleared helps
quite a bit.
[DG] I eventually did that but for about 4-5 hours my load avg was 400-500
I've got the screen shots to prove it ;) Eventually I blackholed my mx
record which allowed my box to catch up on already delievered mail and then
removed qmail scanner and let everything through un processed.
If you are doing Razor lookups in SA, stop. I've not found Razor to make
a difference in spam caught compared to to the network and system
resources it consumes.
If you are doing RBL lookups in SA, stop. RBL lookups are considerably
faster with qmail and saves you having to process a message that you
later would dump when it gets to SA anyway. Example; I move 40k to 50k
inbound messages a day, 65k+ of those I dropped at the smtp level via
qmail. If I had used RBL lookups in SA I would have over doubled my SA load.
> Number two, this
> message appeared quite often last night. What exactly is it telling me?
It has been my experience,
someone/anyone correct me if I am wrong,
but you A) need to upgrade to 5.4.6 as there were changes to the SQL
code or B) your MySQL connection was timing out.
It seemed to me that those errors went away here when I gave MySQL more
resources. Of course, YMMV, and I could be just a nut ;^)
[DG] thanks for the input! David
> I realize this email is vague and poorly worded so any comments,
> and suggestions to further the discussion would be greatly appreciated.
> @40000000415240cb09be3594 delivery 3013: success:
Get rid of Unwanted Emails...get TLS Spam Blocker!