Szerző: Peter Bowyer Dátum: Címzett: exim users Tárgy: Re: [exim] spammers IP ban
On 28/02/06, Henry Amrhein <hamrhein@???> wrote: > On 2/27/06, David Saez Padros <david@???> 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.