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

Account's error_log produces flood of missing modules

 Account's error_log produces flood of missing modules. Ex:   From error_log:     [23-Apr-2018...

Repairing and Optimizing all MySQL and MariaDB Databases on the Server

From time to time you will find repairing and optimizing your databases are necessary. From a...

Error: rpmdb open failed with cPanel

This can occur with older packages sitting on your drive. Try running the following: rm -f...

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