Problem in eximstats

morteza3245

• September 25, 2013 17:54

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.

• 

  HostingH

  • September 25, 2013 23:30

  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

  0
• 

  cPanelMichael

  • September 26, 2013 12:32

  Hello :) You can repair the "eximstats" database via a command such as: 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.

  0
• 

  morteza3245

  • September 26, 2013 21:31

  Oh, i removed failures table in eximstats how i can creat again? i runed drop from phpmyadmin in WHM. Thanks.

  0
• 

  cPanelMichael

  • September 27, 2013 13:55

  You can generate a new instance of the table via: /usr/local/cpanel/bin/updateeximstats
  Thank you.

  0

Please sign in to leave a comment.