cPanel server Eximstats disk usage is a most common issue now a days. Most of the cpanel servers without proper setup is facing the issue of disk fill up due to continuous storage of eximstats in the mysql db named eximstats. This happens mainly for small disk vps servers.
Now a days most used control panel in linux is cPanel and most of the server owners buy cpanel due to its simplicity and hence do not hire a server admin to get it properly setup. In such scenario, small sized vps owners will be the most ones who may have faced this issue and may have payed for serveradmins to clear some space.
You can refer our link to cpanel server tweak settings which is a good doc for cpanel tweak settings
We can reduce this by reducing the number of days for which the stats needs to be kept from the WHM >> Tweak settings > Stats and Logs >> The interval, in days, to retain Exim stats in the database (Minimum: 1; Maximum: 365,000)
Set the above to a lesser days like 10 days
Steps to clear cPanel server Eximstats disk usage manually from the mysql command console section
Login to mysql console and execute the below command mentioned. There are mainly 4 tables named sends, smtp,failures and defers. From the name itself it is clear that what type of data is stored in each tables. Mostly after spamming this can get to a large size and if retention days is set to longer the disk can get filled causing further issues with mysql and websites.
mysql> use eximstats
mysql> delete from sends;
mysql> delete from smtp;
mysql> delete from failures;
mysql> delete from defers;
cPanel server Eximstats disk usage can be cleared using the below method as well
mysqladmin drop eximstats
mysqladmin create eximstats
mysql eximstats < /usr/local/cpanel/etc/eximstats_db.sql
To simplify, I am attaching the image results of the above commands. In this If you are manually removing each table, then second set is not needed. If you are having a bit difficulty in managing manual removal of tables, then you can do the second set of steps