How to clear eximstatus database entries?

This post is about truncating eximstats database. The scenario is considered when the database size increase to large size. This can occur due to high mail queue or spam issues. If your eximstats database has gotten pretty large, chances are you have a spam issue and may want to check your /var/log/exim_mainlog log to see if you have any kind of spam activity going on.

So what is eximstats database?

Eximstats parses the exim log to produce text and graphical data, i.e. number of successful and unsuccessful delivery etc . From WHM we can analyze the email queue by from “Home » Email » Mail Queue Manager“. The eximstats normally analyze the exim mainlog and syslog files to generate a statistical output.

Here I’m explaining the way to remove contents from the database Eximstats.

1. SSH to server as ‘root’ user.

2. Enter to MySQL command prompt.

root@myserver [~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 14851610
Server version: 10.0.20-MariaDB-cll-lve MariaDB Server
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>

3. Use the database eximstat.

MariaDB [(none)]> 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
MariaDB [eximstats]>

4. The DB eximstat mainly contains 4 tables:

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

5. Truncate all tables.

MariaDB [eximstats]> truncate table smtp; 
MariaDB [eximstats]> truncate table sends;
MariaDB [eximstats]> truncate table failures; 
MariaDB [eximstats]> truncate table defers;

6. Quit from MySQL prompt.

MariaDB [eximstats]> quit
Bye

7. Check the DB.

root@sng006 [~]# mysqlcheck -c eximstats
eximstats.defers                                   OK
eximstats.failures                                 OK
eximstats.sends                                    OK
eximstats.smtp

8. Restart Exim daemon.

Do check the exim main log and confirm that everything is normal. That’s all 

If you think this to be difficult, feel free to get our support.