mysql import stuck on /*!40000 ALTER TABLE `mytable` ENABLE KEYS */

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!

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *