Problem: MySQL taking forever to load some large data dumps. Forever or longer. “mysql> show processlist;” shows it wedged at “Repair with keycache” and “Waiting for table metadata lock”. According to a handy Stack Overflow article, this is a known and dreaded condition, which can be addressed by making sure tmp dir has plenty of [...]