Cleaning large eximstats mysql database : Cpanel/WHM
by rajesh[ Edit ] 2012-05-01 19:26:11
If you are using cpanel/WHM you can go to /var/lib/mysql and use "du -sch *" command to find the mysql disk usage of each database accounts.
If the size of your eximstats database is getting large, you will have to do this.
Login as root in to your server using ssh.
Login to mysql
#mysql
#use eximstats
Then from with the query browser run
>delete from sends;
>delete from smtp;
>delete from failures;
>delete from defers;
Now use df to check the free disk space.