Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Prune Eximstats

Discussion in 'Database Discussions' started by JedCavins, Jan 22, 2017.

Tags:
  1. JedCavins

    JedCavins Member

    Joined:
    Jan 2, 2016
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,734
    Likes Received:
    1,706
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  3. dcusimano

    dcusimano Member

    Joined:
    Feb 24, 2008
    Messages:
    12
    Likes Received:
    4
    Trophy Points:
    53
    Location:
    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
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,734
    Likes Received:
    1,706
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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".

    You can manually run the following command to force a generation of new statistics:

    Code:
    /scripts/runstatsonce
    Thank you.
     
Loading...

Share This Page