MySQL Forums
Forum List  »  MyISAM

size of TMD relative to MYD and MYI
Posted by: athiq rahman
Date: February 12, 2012 04:31AM

I am running an optimization on table now for over 9 hours. The size of the TMD is 700 mb when the MYD is 11G and MYI is 6.7G.

I am trying to get an understanding of how much longer this will take. Does the TMD file size come near the MYD file size? If that is the cases we could be talking over a week for this to be optimized.

If I cancel the process, will the table get corrupt?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
size of TMD relative to MYD and MYI
5711
February 12, 2012 04:31AM
3254
February 14, 2012 11:43AM
3198
February 14, 2012 02:44PM
2258
February 15, 2012 11:17PM
2086
February 16, 2012 06:52AM


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.