JedCavins

Member
Jan 2, 2016
20
0
1
usa
cPanel Access Level
Root Administrator
So,

If a client had their setting in /var/cpanel/cpanel.config
Code:
exim_retention_days=90
and they lower it to
Code:
exim_retention_days=10
will this prune the 80 days off or just truncate the database and start over?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,212
363
Hello,

It will show the last 10 days of statistics if you make that change, as opposed to removing all data and starting the statistics from zero. You can also manually import Eximstats data if you ever lose the existing data with a command such as:

Code:
/scripts/import_exim_data /var/log/exim_mainlog*
Thank you.
 

dcusimano

Member
Feb 24, 2008
16
5
53
Toronto, Ontario, Canada
1. How often is the eximstats database pruned automatically? Weekly?
2. Assuming pruning is not done right away if I lower exim_retention_days, and I don't want to wait until the next automatic pruning, how do I manually prune the eximstats database?

For anyone else reading this thead, some background:
- set exim_retention_days in WHM: Server Configuration > Tweak Settings > Find: exim_retention_days. Default 10.
- reports in WHM: Mail Delivery Reports
- eximstats database: /var/cpanel/eximstats_db.sqlite3
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,212
363
1. How often is the eximstats database pruned automatically? Weekly?
It should occur every 24 hours by default as part of the cPanel log processing task (cpanellogd). The log processing frequency is configured in "WHM Home » Server Configuration » Statistics Software Configuration".

2. Assuming pruning is not done right away if I lower exim_retention_days, and I don't want to wait until the next automatic pruning, how do I manually prune the eximstats database?
You can manually run the following command to force a generation of new statistics:

Code:
/scripts/runstatsonce
Thank you.