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?
Thanks Paulo -- ## 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/
