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