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



  • 145 Users Found This Useful

Was this answer helpful?

Related Articles

Failed to start tailwatchd. Unit tailwatchd.service entered failed state.

Failed to start tailwatchd. Unit tailwatchd.service entered failed state.  tailwatchd.service...

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 r_subject:...

FTP Failed: Service check failed to complete Unable to connect to port 21

The service “ftpd” appears to be down. The system failed to connect to this service’s TCP/IP...

connection failed for acme-v01.api.letsencrypt.org: SSL connect attempt failed

 (Hypertext Transfer Protocol) “post” request to...

How to convert InnoDB to MyISAM

Although at times faster, you will find InnoDB a very large headache when it comes to table...