MySQL Forums
Forum List  »  MyISAM

Re: Repair Will Not Use Filesort
Posted by: Rick James
Date: May 08, 2010 12:54AM

Thanks for the observation.

What was key_buffer_size? Bigger than the 4GB needed for the index?

You should probably never have max_heap_table_size bigger than RAM. And not bigger than RAM after subtracting other things, like caches.

Options: ReplyQuote


Subject
Views
Written By
Posted
4958
May 04, 2010 05:31PM
Re: Repair Will Not Use Filesort
2613
May 08, 2010 12:54AM


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.