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.

Problem in eximstats

Discussion in 'Workarounds and Optimization' started by morteza3245, Sep 25, 2013.

  1. morteza3245

    morteza3245 Well-Known Member

    Joined:
    Sep 16, 2013
    Messages:
    104
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello
    i see in eximstats database, this table failures have 1GB Size.

    i can drop That? or have not problem?

    Note: i see this line at log : 130926 3:41:36 [ERROR] MySQL thread id 5369015, OS thread handle 0x7f6d7cfae700, query id 961728564 localhost root Checking table
    CHECK TABLE `failures`

    Please help me about this table.

    Thanks.
     
    #1 morteza3245, Sep 25, 2013
    Last edited: Sep 25, 2013
  2. HostingH

    HostingH Well-Known Member

    Joined:
    Jan 13, 2008
    Messages:
    73
    Likes Received:
    3
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hi,

    Yes, you can clear it or repair it.

    to clear it use following steps

    Go to mysql

    mysql

    use eximstats

    Then from with the query browser run

    delete from sends;
    delete from smtp;
    delete from failures;
    delete from defers;

    \q

    Now check disk space
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,745
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can repair the "eximstats" database via a command such as:

    Code:
    mysqlcheck --repair eximstats
    After that, I recommend modifying the following option under the "Stats and Logs" tab in "WHM Home » Server Configuration » Tweak Settings":

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

    You can reduce the number of days if you find there is too much disk space usage being utilized by Eximstats.

    Thank you.
     
  4. morteza3245

    morteza3245 Well-Known Member

    Joined:
    Sep 16, 2013
    Messages:
    104
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Oh, i removed failures table in eximstats
    how i can creat again?

    i runed drop from phpmyadmin in WHM.

    Thanks.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,745
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page