Repair Will Not Use Filesort
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?
Subject
Views
Written By
Posted
Repair Will Not Use Filesort
4964
May 04, 2010 05:31PM
2793
May 05, 2010 09:59AM
2615
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.