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

Disable cPanel Brute Force Command Line

To disable the cPanel brute force detection from the command line usee the following:...

Nginx redirecting folder to another host or server

From time to time you may want to proxy out a path to another server or location. To perform a...

FSCK Options and Maintenance

Provided below are some useful commands pertaining to FSCK. Update commands to your environment /...

Failed to start tailwatchd - Unit tailwatchd service entered failed state

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

cPanel Account - PHP Startup: Unable to load dynamic library

PHP Warning:  PHP Startup: Unable to load dynamic library './xsl.so' - ./xsl.so: cannot open...