mysql mta table crashes often

[kabal]

Hello all,

I have 3 zimbra 4.5 servers, one running mailbox services and two running mta.
Regularly, whenever I run this command:
zmcontrol -s <username>
I get the follwing error:
/opt/zimbra/bin/zmmsgtrace sql execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed

I usually have to run:
logmysql
use zimbra_logger
repair table mta

This resolves it.
My issue is, must be a recurring issue? Is there a way of purging old entire in the mta table to prevent it from crashing so often, or can I specify from that it deletes rows older than a particular age?

Thanx

[uxbod]

Welcome to the forums

Why do you believe it is the amount/age of data that is causing the problem ? I would be more inclined to believe that either MySQL has crashed, or the server has been restarted (whether manually or crash) while MySQL is still running. Have you checked the server for any other issues ?

[kabal]

Thanx for the response.

If the server is shutdown while MySQL is running, would it cause tables to crash?
Also, my for the last few weeks, my admin console has been so slow to come up.
I suspect it's related to java because even the advanced version doesn't open.
Is there any log I can check that can point to why the admin console takes about 10 minutes to come up?

Thanx in anticipation

[uxbod]

Does this vary if you connect to the console from a different machine ? What happens if you open a browser on the actual server and connect to the admin console ? What is the spec of your server ? How much free memory does it have ? What is the load on the server ?

[kabal]

It's slow on all my workstations.
My ldap server has no gui on it.
I have even tried it on linux workstations, still no luck.
Even tried different browsers, only IE seems to open it eventually.
My server has 16GB ram B-)
And load average is not high, enuff RAM to play with.

Are there other logs I can check