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



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

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

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

Remount /tmp with exec permission

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

Whitelisting Multiple IPs with Mod_Security

The following can be added to the main modsecurity.conf or a whitelist file such as one...

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