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