Re: Tearing my hair out... MyISAM or InnoDB?
Hi Kim Seong! Thanks for your reply. When the index gets done building with MyISAM, the MYI file usually hits about 10G, with the MYD about 3G.
Problem is, it takes forever for it to build the MYI; ls'ing in the datamart, the MYI seems to get built piece by piece, the later pieces built ever more slowly. Why is this?
I set my key_buffer to 48G, but MySQL trims it to 4G; is there some other parameter I can increase to make the loads and index build faster?
Thanks for your help.
Kevin
Subject
Views
Written By
Posted
3500
August 15, 2005 03:45PM
1971
August 15, 2005 03:49PM
2066
August 15, 2005 07:31PM
Re: Tearing my hair out... MyISAM or InnoDB?
2028
August 15, 2005 07:49PM
1852
August 16, 2005 03:32AM
1962
August 16, 2005 11:13AM
2590
August 23, 2005 11:00PM
2016
August 24, 2005 07:36PM
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.