Problem in eximstats

[morteza3245]

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]

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]

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.

 

[morteza3245]

Oh, i removed failures table in eximstats
how i can creat again?

i runed drop from phpmyadmin in WHM.

Thanks.

 

[cPanelMichael]

You can generate a new instance of the table via:

/usr/local/cpanel/bin/updateeximstats

Thank you.