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.)
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