Truncating Eximstats – Eximstat DB growing huge size!!

What’s the use of Eximstat? Eximstat DB growing huge size!!

The Eximstat driver produce text and graphical data by analysing email logs and populates data for the Mail Delivery Reports system. From WHM we can analyse the email queue by from “Home » Email » Mail Queue Manager“. The eximstat normally analyse the exim mainlog and syslog files to generate a statistical output.

Here I’m explaining the way to remove contents from the database Eximstat. If you face any problem to analyse the Mail Queue Manager in your WHM panel, you can go ahead with the same steps or follow this “Empty Mail Delivery Report – WHM“.

1, SSH to server as root.
2, Enter to MySQL command prompt.

# mysql

3, Use the database eximstat.

mysql> use eximstats;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

4, The DB eximstat mainly contains 4 tables:

mysql> show tables;
+---------------------+
| Tables_in_eximstats |
+---------------------+
| defers              |
| failures            |
| sends               |
| smtp                |
+---------------------+
4 rows in set (0.00 sec)

5, Truncate all tables.

truncate table smtp;
truncate table sends;
truncate table failures;
truncate table defers;

6, Quit from MySQL prompt.

mysql> quit
Bye

7, Check the DB.

# mysqlcheck -c eximstats
eximstats.defers                                   OK
eximstats.failures                                 OK
eximstats.sends                                    OK
eximstats.smtp                                     OK

6, Restart MySQL and Exim daemons.

That’s it!!

The SQL TRUNCATE TABLE command is used to delete complete data from an existing table.
That’s it!

1, How to check spamming on server which has Exim as MTA
2, How to restart the service Spamd – cPanel

Post navigation

Arunlal Ashok

Operations Engineer at Endurance International Group. Linux lover. Like to play on Linux console. I started this blog to share and discuss Linux thoughts.

Always happy for an open discussion! Write to arun (@) crybit (dot) com. Check about me for more details. About this blog and our strong members, check The team CryBit.com
I like to travel. My travelogues are published at Trip Mentor

3 thoughts on “Truncating Eximstats – Eximstat DB growing huge size!!

  1. Hi Arunlal,

    i have an issue with exim. Email from a remote domain is rejected by the server. While checking i could see that the remote server IP address is currently included in RBL. So the server reject the mail from that particular domain. I want to whitelist some remote domain in exim. Mean i want to exclude remote domain from RBL check in my server. Can you please write a post how to exclude local and remote domain from RBL check with server. It cloud be more helpful.

  2. Is there any steps to clear manually removing eximstats sqlite file in cpanel, as there is no database named ‘eximstats’

Leave a Reply

Your email address will not be published. Required fields are marked *