Prune Eximstats

[JedCavins]

So,

If a client had their setting in /var/cpanel/cpanel.config

exim_retention_days=90

and they lower it to

exim_retention_days=10

will this prune the 80 days off or just truncate the database and start over?

 

[cPanelMichael]

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:

/scripts/import_exim_data /var/log/exim_mainlog*

Thank you.

 

[dcusimano]

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]

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:

/scripts/runstatsonce

Thank you.