Is there any way to force a "Repair by sort" rather than a (way to slow) "Repair with keycache" when doing an "ALTER TABLE t ENABLE KEYS"?
The table in question is 6GB large and contains 100M rows. I have set myisam_sort_buffer_size=512MB myisam_max_sort_file_size=10000MB myisam_max_extra_sort_file_size=0 bulk_insert_buffer_size=64MB but this doesn't help. I am running somewhat low on diskspace with only a few gigabytes free, could this have any influence here? Any other ideas? -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]