MySQL Forums :: MyISAM :: Repair Will Not Use Filesort


Advanced Search

Repair Will Not Use Filesort
Posted by: James McKelvey ()
Date: May 04, 2010 05:31PM

I searched this forum and tried the advice, but MySQL will NOT repair my table or rebuild indexes without "repair with keycache".

I set myisam_max_sort_file_size to 4T, which is less than the disc space available.

myisam_sort_buffer_size is 1T. max_heap_table_size is 50G, and so is tmp_table_size.

The only errors in the log are complaining about the crashed table.

There are about 700M rows, with a single non-unique index of 6 bytes. Row size is about 88 bytes. The index is disabled. I'm trying to repair the table and then enable indexes.

The host has 32G of RAM. It's 5.1.36 on x86_64.

What do I try next?

Options: ReplyQuote


Subject Views Written By Posted
Repair Will Not Use Filesort 3971 James McKelvey 05/04/2010 05:31PM
Re: Repair Will Not Use Filesort 2307 James McKelvey 05/05/2010 09:59AM
Re: Repair Will Not Use Filesort 2119 Rick James 05/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.