Re: size of TMD relative to MYD and MYI
Posted by:
Rick James
Date: February 14, 2012 11:43AM
OPTIMIZE rebuilds the table (TMD is the temp copy of MYD).
* If there was lots of empty space, then the TMD will not get to be as big as the MYD.
* If there was little need for the OPTIMIZE, it will get to be as big.
* OPTIMIZE is rebuilding the data, defragmenting any rows that were split; this can involve extra disk seeks.
* OPTIMIZE will rebuild all the indexes -- this _could_ be very time consuming, especially if the indexes are 'random'.
* 0.7/11 is about 6%, but do _not_ expect it to be 6% finished. Random indexes (especially) get slower and slower.
What is the value of key_buffer_size? Normally it should be 20% of available RAM. For this operation, 50% might be better.
Subject
Views
Written By
Posted
5472
February 12, 2012 04:31AM
Re: size of TMD relative to MYD and MYI
3081
February 14, 2012 11:43AM
3068
February 14, 2012 02:44PM
2146
February 15, 2012 11:17PM
1968
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.