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.

Eximstats db growing huge [case 59361]

Discussion in 'E-mail Discussions' started by Lehman, Feb 24, 2012.

  1. Lehman

    Lehman Registered

    Joined:
    Feb 22, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi there!

    I've tried to search the forum to understand this, but the only information I found is from back to 2004.

    My eximstats db is quite huge now (315 MB), but I'm quite noob and I don't know what it stores. Could I empty the tables? I keep a lot of emails in my accounts and I don't want to lose them, but the MySQL process for eximstats is very cpu consuming now.
     
  2. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    526
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brno, Czech Republic
    you can select tables and click empty in phpmyadmin logged in as root. it will work just fine. sorry for the late reply - just had this problem myself.
     
  3. sneader

    sneader Well-Known Member

    Joined:
    Aug 21, 2003
    Messages:
    1,126
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    La Crosse, WI
    cPanel Access Level:
    Root Administrator
    Having a similar problem. This is on an older server where /var is 10GB (used to be plenty big in the 'old days'). Space on /var is precious now, and eximstats takes up nearly 3GB of it. Any strategies out there for minimizing the amount of space that eximstats takes up?

    - Scott
     
  4. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    526
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brno, Czech Republic
    i am running a weekly maintenance where i just empty the eximstats db. not drop it, just empty all tables contents. this does the trick.
     
  5. mtindor

    mtindor Well-Known Member

    Joined:
    Sep 14, 2004
    Messages:
    1,279
    Likes Received:
    36
    Trophy Points:
    48
    Location:
    inside a catfish
    cPanel Access Level:
    Root Administrator
    My strategy for keeping eximstats small is to simply choose a reasonable period to retain the stats. Other than out of boredom, I've never [knowingly] made use of eximstats data. I don't view email sending summarries, relayers, or any of that. Everything I ever want is in the exim logfiles.

    With 11.32, the default is to retain stats for 90 days, which has really wreaked havoc for some with the initial high load during the importing / migration of stats and the default 90 day retention period. I just set my retention period to something much smaller, like 7 days, and the database decreased in size expontentially over the course of the day when I made the change.

    Mike
     
  6. sneader

    sneader Well-Known Member

    Joined:
    Aug 21, 2003
    Messages:
    1,126
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    La Crosse, WI
    cPanel Access Level:
    Root Administrator
    Great idea, Mike! I found the setting in Tweak Settings > Stats and Logs, for anyone else looking for it.

    - Scott
     
  7. mtindor

    mtindor Well-Known Member

    Joined:
    Sep 14, 2004
    Messages:
    1,279
    Likes Received:
    36
    Trophy Points:
    48
    Location:
    inside a catfish
    cPanel Access Level:
    Root Administrator
    Scott,

    I apologize that I failed to say where that setting was found. Of course, you found it with no problem. On one server, my eximstats grew to about 3+ GB in size shortly after i did the 11.32 update. I set retention to 7 days, and then a day later my eximstats database was down to about 460 MB.

    Mike
     
  8. rmackay

    rmackay Well-Known Member

    Joined:
    Nov 26, 2002
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    6
    great info here.. my eximstats DB went to 6GB in no time and caused the server to go nuts. 90 days? seems a bit too high.
     
  9. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    11.32.3.15 changed the default back to 30 days from 90 for new installs. However, it won't change it 30 if you are already running with 90 days in order to avoid data loss.


    Fixed case 59361: Reduce load from mail delivery reports data collection and retention
     
  10. rmackay

    rmackay Well-Known Member

    Joined:
    Nov 26, 2002
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    6
    Nick, was this, combined with some sort of table change, possibly causing mysql high server loads on some cron job?
     
  11. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    The indices and log processing functionality were further optimized. You probably saw it having to rebuild one or two of the indices during the update. We use mysqldiff to only make the needed changes so it shouldn't need to rebuild everything.

    On a side note, if you don't need more then 7 days worth of data, I'd highly recommend setting the retention period to just that ( I would not go any lower to avoid loss of bandwidth data ) .
     
  12. sneader

    sneader Well-Known Member

    Joined:
    Aug 21, 2003
    Messages:
    1,126
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    La Crosse, WI
    cPanel Access Level:
    Root Administrator
    Well, I lowered it from 90 days to 14 days. A few hours later my server went high load. top showed mysql was the culprit, then viewing mysql queries, it was eximstats doing all the deletes to purge out the old stats. Eventually had to just restart MySQL to tame the box. If I were to do it again, I might gracefully lower the days... maybe from 90 to 80 to 70, etc.?

    - Scott
     
  13. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Case 59361 has been resolved in version 11.32.3.15 and later. If you still experience issues, please let us know via http://go.cPanel.net/bugs
     
  14. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Is there a way to run this configuration change through the command line?
     
  15. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Yes, you can modify the following value in /var/cpanel/cpanel.config:

    exim_retention_days

    Thank you.
     
Loading...
Similar Threads - Eximstats growing huge
  1. phild
    Replies:
    3
    Views:
    1,010

Share This Page