Eximstats db growing huge

If the server have heavy email activity and “The interval, in days, to retain Exim stats in the database” is set to a high value then the eximstats DB size will be very large. First you need to findout if there is any spamming activity going on the server and stop it if any. The MySQL process for huge size eximstats DB will be very CPU consuming, so consider deleting the stats and lowering the value of “The interval, in days, to retain Exim stats in the database” in WHM tweak settings.

Cleaning large eximstats mysql database:

Login to mysql
#mysql

mysql> use eximstats
mysql> delete from sends;
mysql> delete from smtp;
mysql> delete from failures;
mysql> delete from defers;

Advertisements
  1. Thank you so much for this guide.
    I’ve read a couple of cPanel forums regarding this issue but was just to afraid to delete this data thinking it might cause some big problems to our system.

    Is it ok to do this?

    I have also lowered the exim stats database interval in WHM to 20 days to keep the db lower.

    Hoping to hear more from you.

    Thanks again!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: