drop表提示Waiting for table metadata lock 解决

因为autocommit=0, 在做select之后 没有显示的commit,或者rollback;

解决办法：

      select concat("kill ",trx_mysql_thread_id,";") as kill_id from information_schema.INNODB_TRX where trx_lock_structs=0 and trx_weight=0 and trx_rows_locked=0 and trx_rows_modified=0 and trx_state='RUNNING';