eximstats - optimize eximstats mysql database
Written by anil on Tuesday, June 19th, 2007 in exim, mysql, Linux, cPanel/WHM.
This will remove unwanted datas from eximstats database.
Run this is as root.
mysql eximstats
use eximstats
OPTIMIZE TABLE sends;
OPTIMIZE TABLE smtp;
You can automate this by setting a cronjob,
0 0 */5 * * echo “OPTIMIZE TABLE eximstats.sends, eximstats.smtp;” | mysql
Thanks