[prev in list] [next in list] [prev in thread] [next in thread] 

List:       exim-users
Subject:    Re: [exim] spammers IP ban
From:       "Peter Bowyer" <peeebeee () gmail ! com>
Date:       2006-02-28 6:34:05
Message-ID: 56152ae90602272234g70c8cd29w () mail ! gmail ! com
[Download RAW message or body]

On 28/02/06, Henry Amrhein <hamrhein@gmail.com> wrote:
> On 2/27/06, David Saez Padros <david@ols.es> wrote:
>
> > we are doing a similar thing, but instead of having  a log parser we
> > directly insert the ip into a mysql database using exim builtin mysql
> > support, then every 5 minutes the mysql databse is dumped into a faster
> > cdb databse which is used by exim.
>
> I'm curious.  Doesn't a few writes to the relational database take
> much longer
> than the time gained by reading from the cdb file? I'm not saying this
> is a bad technique.  I'm just curious if I'm thinking correctly.

That would be my worry, too, along with the (certain) delays and
(possible) erroneous results when the MySQL connection isn't
available. Hence my use of the log-scraping technique to take the
database writes out of the critical path.

Peter

--
Peter Bowyer
Email: peter@bowyer.org
Tel: +44 1296 768003
VoIP: sip:peter@bowyer.org
VoIP: *5048707000@sipbroker.com
FWD: **275*5048707000
VoipTalk: **473*5048707000

-- 
## List details at http://www.exim.org/mailman/listinfo/exim-users 
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/

[prev in list] [next in list] [prev in thread] [next in thread]