Hi!
I'm fighting against performance problems with cleanup on our setup
(2 Postfix machines, 3.5M rejects/day, 300k accepts/day each machine,
MySQL server 4 GB RAM, 6M entries in triplet table).
The old database server with less RAM and a small MySQL configuration
(small key_buffer_size etc.) we
Hello, Roland:
You didn't mention what your retention times were for the triplets, etc.
You might try cutting the expiration limits down to be no more than
about twice the limit value (so, say, 4 hours and 2 hours). We get over
1 M messages a day and even though my DBs grow to as much as 50 MB
Roland Rosenfeld wrote:
> Hi!
>
> I'm fighting against performance problems with cleanup on our setup
> (2 Postfix machines, 3.5M rejects/day, 300k accepts/day each machine,
> MySQL server 4 GB RAM, 6M entries in triplet table).
>
> The old database server with less RAM and a small MySQL configura
On Mon, 17 Mar 2008, Tobias Kreidl wrote:
> You didn't mention what your retention times were for the triplets,
> etc.
AUTO_WHITELIST_EXPIRE=14d
TRIPLET_TIME=3s
TRIPLET_AUTH_TIMEOUT = 14d
TRIPLET_UNAUTH_TIMEOUT = 1d
Whitelist expire didn't reach the limit (since we had to completely
clean the da
One other thing: Mail gateways do a lot of nslookup operations, so make
sure you run "nscd" (name service cache daemon) and adjust it so it
caches more than the default number of hosts. So for example, the one
section in /etc/nscd.conf dealing with host names might contain
something like this:
Nigel Kukard wrote:
>>
>> btw i'm just a "user" and i'm afraid i will not contribute anything to
>> the community
>>
>
> Testing is contributing, and as you've already found a bug ... you've
> already contributed ;)
>
> Latest commit fixes the daemonization btw.
>
>
>>> 1. I'll commit a
zen wrote:
> Nigel Kukard wrote:
>
>>>
>>> btw i'm just a "user" and i'm afraid i will not contribute anything to
>>> the community
>>>
>>>
>> Testing is contributing, and as you've already found a bug ... you've
>> already contributed ;)
>>
>> Latest commit fixes the daemonizati