MySQL:Waiting for table metadata lock

http://www.chriscalender.com/troubleshooting-waiting-for-table-metadata-lock-errors-for-both-myisam-and-innodb-tables/
http://www.chriscalender.com/tag/waiting-for-table-metadata-lock/

#show (full) processlist;
會有出現"Waiting for table metadata lock"的Process
找出停留最久的把他kill
#kill [porcess id];

建議把
wait_timeout 和 interactive_timeout秒數調低一點
ex: 60秒

#show ENGINE INNODB STATUS;