Re: Table repair dilema
Sorry, but I can't say. I have little experience with performance questions.
The time required for a repair of a 4GB table should mainly depend on the number and complexity of the indexes. Of course the hardware of the machine and the configuration of the caches matter too. However, I'm not so familiar with all the cache options and how they play together.
If you used the REPAIR TABLE command, you won't get much information, how far the process is now. If you had used myisamchk with a couple of -v options, you would see at least some progress information. 24h sounds very much. But I won't be surprised if it is still working OK.
Regards,
Ingo
Subject
Views
Written By
Posted
3632
November 03, 2005 11:48AM
2036
November 04, 2005 04:17AM
2032
November 04, 2005 11:54AM
Re: Table repair dilema
3750
November 07, 2005 04:27AM
1951
November 07, 2005 10:29AM
2175
November 08, 2005 03:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.