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



  • 150 Users Found This Useful

Was this answer helpful?

Related Articles

Remount /tmp with exec permission

Remounting /tmp With Execute Permission   On some cPanel servers, the /tmp partition is...

Error: rpmdb open failed with cPanel

Fixing RPM Database Errors in cPanel   The error "rpmdb open failed" occurs when the RPM...

Whitelisting Multiple IPs with Mod_Security

Whitelisting Multiple IPs in ModSecurity   If ModSecurity is blocking legitimate requests...

How to convert InnoDB to MyISAM

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

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



Save 30% on web hosting - Use coupon code Hosting30