Re: Reputation DB

From: Benny Pedersen <me_at_junc.eu>
Date: Wed, 01 Oct 2014 12:45:40 +0200

On October 1, 2014 9:42:52 AM "A. Schulze" <sca_at_andreasschulze.de> wrote:

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

Wild

> I have a separate 30 GB partition mounted as ~mysql/.tmp.

Why diskbased ?, limithed ram on the server ?

> Opendkim-genstats create temporary tables that fill this temp space up
> to 80% in my case.

What is the output from mysqltuner ?

> (the space is free again after opendkim-genstats has finished)

Imho this sql server needs more ram

> That's impressive as the normal database use 'only' 6 GB.

Big size for mysql

> Have other users similar problems?

Not yet here, still low usage here
Received on Wed Oct 01 2014 - 10:46:01 PST

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