From: Joey L Date: June 4 2012 12:35pm Subject: i am running mysqlrepair on 80G myisam table. List-Archive: http://lists.mysql.com/mysql/227580 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 i am running mysqlrepair on 80G myisam table. It is taking forever to repair - i am getting a lot of "Waiting for table" messeges when i execute "show full processlist" 613 | p_040912 | localhost | p_040912 | Query | 24 | Waiting for table | SELECT `oldurl`, `newurl Can anyone help for this ? is there anything i can tweak in the my.cnf file that avoids this issue - it is taking forever !!! thanks