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?
Show replies by date