> But myisam_sort_buffer is, AFAIK, only used during "Repair by sort" > (in PROCESSLIST), not "Repair with keycache." What did yours say > during the 21 hours? It may change from sort to keycache after awhile > -- something to do with the size of the indexes or something. Not > exactly sure about the criteria.
Yes, it is indeed using "Repair with keycache". This change of strategy would explain why indexing the complete data set takes 40x longer than indexing a 20% subset. I'll try further increasing myisam_sort_buffer_size to 512MB. Also found two further options that may be relevant, myisam_max_sort_file_size and myisam_repair_threads, which I will increase to 10GB and 2, respectively. > No idea about InnoDB, but I would guess that it'd be slower? Does > DISBALE/ENABLE KEYS even do anything with InnoDB, or just MyISAM? Hmm. I just checked, and it seems it doesn't do anything. (For InnoDB tables, the query plan still shows type=ref rather than type=ALL after DISABLE KEYS.) -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
