Συντάκτης: Jakob Hirsch Ημερομηνία: Προς: Paulo Andre Υ/ο: exim Αντικείμενο: Re: [exim] exim + greylisting
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...