morteza3245

Well-Known Member
Sep 16, 2013
163
1
68
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.
 
Last edited:

HostingH

Well-Known Member
Jan 13, 2008
125
17
68
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
You can generate a new instance of the table via:

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