MySQL Forums
Forum List  »  MyISAM

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

Written By
Repair Will Not Use Filesort
May 04, 2010 05:31PM
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.