I'm trying to import the categorylinks table. After MySQL finishes the inserts, it reaches the line: ALTER TABLE `categorylinks` ENABLE KEYS By doing a "show full processlist" I can see that MySQL is running this doing "Repair with keycache". From what I've read about this online, it takes 20-30 times longer to build the indexes this way than using "Repair by sorting".
Any ideas how to get around this?
xmldatadumps-l@lists.wikimedia.org