[policyd-users] cleanup performance optimization

2008-03-17 Thread Roland Rosenfeld
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.)

Re: [policyd-users] cleanup performance optimization

2008-03-17 Thread Tobias Kreidl
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