摘要：MySQL drop空表时处于Waiting for table metadata lock状态，简单粗暴的解决办法，原理性请看官网 1. mysql> select concat("kill ",b.ID,";") as kill_id from information_schema.INNODB 阅读全文