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]

Reply via email to