You’re not able to empty the eximstats database via the MySQL command line while the MySQL service is down. I moved away the eximstats database by running the following command:
mv -v /var/lib/mysql/eximstats /home/cptechs/
Your server’s / partition has free space now:
[email protected] ~]cPs# df -h /
Filesystem Size Used Avail Use% Mounted on
/dev/md2 20G 15G 4.4G 77% /
I then restarted the MySQL service and regenerated an empty eximstats database by running the following commands:
The MySQL service is now up and running:
[email protected] ~]cPs# service mysql status
SUCCESS! MySQL running (3493)
[email protected] ~]cPs# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2004
Server version: 5.5.42-cll MySQL Community Server (GPL)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
You may want to consider reducing the amount of days that the eximstats database retains data for at:
WHM » Server Configuration » Tweak Settings » Stats and Logs » The interval, in days, to retain Exim stats in the database