-----Original Message-----
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
questions
Grimes, David wrote:
<snip>
config to better equip it for things? Switches, etc...
What do you have now for hardware?
[DG] Athlon 1700 512 60gig ide drive
Should be plenty with a stock qmail-vpopmail-mysql-SA. Not sure how much qmail-scanner requires as far as resources. Perl can get hungry. I've processed twice as much on a Sparc 20 with dual 125mhz and 512 ram. I didn't run qmail-scanner and a AV solution though......
<sidenote>
The fellow who could convert one of the many perl qmailqueue replacements to C, would likely be carried about town on the shoulders of a grateful crowd.
</sidenote>
What version of SA are you running? [DG] SA is 2.6.3
They should have the problems sorted out with SA 3.0.0 now, seems most of the traffic I have seen is people not thoroughly reading the docs before upgrading. The upgrade will also give you SURBL, which will help more than anything else I have tried.
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.
Did you add your RBLs into qmail-smtpd? (adding rblsmtpd to your run file)
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.
Painfull I know, but sometimes it is the only way ;^)
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 ;^)
DAve [DG] thanks for the input! David
Your welcome.
DAve
I realize this email is vague and poorly worded so any comments,
questions,
and suggestions to further the discussion would be greatly appreciated.
<snip>
-- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
