size of TMD relative to MYD and MYI
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
Subject
Views
Written By
Posted
size of TMD relative to MYD and MYI
5478
February 12, 2012 04:31AM
3085
February 14, 2012 11:43AM
3072
February 14, 2012 02:44PM
2150
February 15, 2012 11:17PM
1970
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.