Reputation DB

From: A. Schulze <>
Date: Wed, 01 Oct 2014 09:42:52 +0200


I noticed a little resource problem on my reputation database server.

~10 opendkim instances report the statistics about incoming message to
my database server.
The database has 20 Mio entries in the messages table. These entries
are up to 100 days old
(opendkim-expire has as default 180 days)

opendkim-genstats takes more then 3 hours. during this time the disk
usage grow significant.
I have a separate 30 GB partition mounted as ~mysql/.tmp.
Opendkim-genstats create temporary tables that fill this temp space up
to 80% in my case.
(the space is free again after opendkim-genstats has finished)
That's impressive as the normal database use 'only' 6 GB.

Have other users similar problems?
Received on Wed Oct 01 2014 - 07:43:13 PST

This archive was generated by hypermail 2.3.0 : Wed Oct 01 2014 - 07:54:00 PST