How to decrease the mysql usage caused by eximstats?
Using whm on a Dual XEON 3.0GHz with 2GB RAM. My problem is mysql usage. No user is pushing the sql on the limits according to mytop or mysqladmin processlist. But the user eximstats is always there so probably it is pushing the mysql hard. It is about %35 I want to decrease it. How?
Also when I looked at the eximstats tables inside phpmyadmin all seem optimized but there are over 50K record for each sends and smtp tables. Probably too many records?
Anyway how to decrease the mysql usage according to the data in: