I was importing a mysql database and it was taking forever.
> show processlist showed Info for the query that was running over an hour:
/*!40000 ALTER TABLE `mytable` ENABLE KEYS */
This post clued me in to the fact that, since the “State” was “Repair with Keycache”, the temporary tables are filling up the whole 60GB partition I’d set for this DB.
Whenever you get “Repair With Keycache” as a status, you have no free space to do file sorting
Starting over with a bigger partition and hopefully this will do it!