Clear cPanel Eximstats DB and Repairing the Eximstats DB

Over the time or due to spammers the eximstats database file may grow to a large size. To clear it run the following commands:


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



To quickly repair the eximstats database run the following: 


service mysql stop
myisamchk -r /var/lib/mysql/eximstats/*.MYI
service mysql start



Share this page:

Was this article useful? Have any suggestions or improvements to the information?

 Print this Article

Also Read

Remount /tmp with exec permission

There are times where you may need to have exec permission available for the /tmp folder. This...

SpamAssassin Command Line Bayesian Learn Command cPanel

Once it is enabled, it is necessary to train spamassassin to learn what is junk mail and what is...

Create CXS Quarantine Directory

The following command may be used to create a quarantine directory for Configserver's CXS: cxs...

E Sysup: Needed system RPMs were not installed: yum-utils

When encountering the following:E Sysup: Needed system RPMs were not installed: yum-utils*****...

central_filter defer (-17): error in filter file: unknown filtering command "r_subject:" near line 22 of filter file

The error "central_filter defer (-17): error in filter file: unknown filtering command...