Author: Paulo Andre Date: To: exim-users Subject: Re: [exim] exim + greylisting
Jakob Hirsch wrote: > Quoting Paulo Andre:
>
>
>> Hi Renaud, I was using this system for quiet sometime and found that as
>> the database got bigger, then exim would use all connections to the
>> database, break other solutions. I tried increasing max connections and
>>
>
> The reason for that is obviously the blatant lack of indexes (making
> full table scans necessary). Using overly complicated queries (making
> mysql use temporary files) makes it even worse.
> This is no problem with a small database, so cleaning up old entries
> will hide the deficiencies of the poor design.
>
> Renaud, your cleaning solution deletes all entries older than 4 hours,
> which makes valid hosts going through greylisting again and again...
>
> Jakob, although this is OT for this list, what would be the better
solution? For one I could delete all entries until yesterday, this would
allow for the 4 hours LIFETIME, where else would it be best to create
indexes?
