MySQL Forums
Forum List  »  InnoDB

Re: Tearing my hair out... MyISAM or InnoDB?
Posted by: Kevin Bartz
Date: August 15, 2005 07:49PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Tearing my hair out... MyISAM or InnoDB?
2028
August 15, 2005 07:49PM


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.