How did you get spamd to log to mysql? Thank you, Tony Bunce, CCNA, Network+ Systems Administration GO Concepts, Inc. www.go-concepts.com www.sitesbygo.com On GO yet? 513-934-2800 1-888-ON-GO-YET ========================== Thank you for choosing GO Concepts as your Internet Services Partner! You truly are what makes us GO! Your input is important to us, so if we have been helpful or if you feel we could have done a better job, please let us know by emailing your praise, complaint, or suggestions to [EMAIL PROTECTED] -----Original Message----- From: Dallas L. Engelken [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 11:11 AM To: [EMAIL PROTECTED] Subject: RE: Limit number of spamd processes
> > On Friday 04 June 2004 15:42, John Fleming might have typed: > > > This is interesting to me. What spamd process time range > are people > > seeing? Mine's about 10-12 sec, Fedora Core 2, >2GHz, 512 > RAM, 40GB > > IDE HDD I am running Bayes. > > 0.1 - 85 seconds. Of 488 records checked, 4 are > 20 seconds > and 26 are > 10 > seconds. > > The rest, I can't tell, as I'm running inside of amavisd-new, > and don't feel > like writing a log parser :p Server is FC1, P4 2.8, 768 RAM, > 7200 RPM drive > I think.. is a dell pc. > FYI, my top 10 processing times... I floor'd them all... So 0 seconds = 0.00-0.99 seconds. This is out of the last 60k emails I've logged. mysql> select count(*) as messages,floor(elapsed) as seconds from email group by floor(elapsed) order by messages desc limit 10; +----------+---------+ | messages | seconds | +----------+---------+ | 13764 | 4 | | 10031 | 5 | | 6484 | 6 | | 4994 | 7 | | 3857 | 8 | | 3688 | 3 | | 3022 | 9 | | 2329 | 10 | | 1640 | 11 | | 1485 | 1 | +----------+---------+ 10 rows in set (1.06 sec) This is a 2.4ghz 512mb 5400rpm 40gig 1u rack..
