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.

my eximstats file is 10 gigs, how do I remove this?

Discussion in 'E-mail Discussions' started by WebHostPro, Feb 27, 2014.

  1. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,597
    Likes Received:
    10
    Trophy Points:
    168
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    My eximstats file is huge, how do flush this out.

    I don't care if the previous data is lost.

    Thanks!
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    35,666
    Likes Received:
    1,138
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can modify the following option in "WHM Home » Server Configuration » Tweak Settings" under the "Stats and Logs" tab:

    "The interval, in days, to retain Exim stats in the database"

    Reducing this value will decrease the amount of data that is stored in the Eximstats database. If you decide to drop the eximstats tables completely, you can generate a new instance of the tables via:

    Code:
    /usr/local/cpanel/bin/updateeximstats
    Thank you.
     
  3. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,597
    Likes Received:
    10
    Trophy Points:
    168
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    Thanks, I have it set to three days.

    It's shocking it can get this big so fast. There is no way to just flush it?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    35,666
    Likes Received:
    1,138
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You would have to delete the eximstats database and regenerate it to remove all of existing data/entries.

    Thank you.
     
  5. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,597
    Likes Received:
    10
    Trophy Points:
    168
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    Great, that's easy. How do you regenerate it? Or can I just wait for it to regenerate on it's own?
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    35,666
    Likes Received:
    1,138
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You can use the command referenced in my earlier response:

    Code:
    /usr/local/cpanel/bin/updateeximstats
    Thank you.
     
Loading...

Share This Page