MySQL drop empty table in waiting for table metadata lock State, workaround (from Network)

MySQL drop empty table is in waiting for table metadata lock state, simple rough solution, original reason please crossing net

1. mysql> Select Concat ("Kill", b.ID, ";") as kill_id from INFORMATION_SCHEMA. Innodb_trx A,information_schema. Processlist b where a.trx_mysql_thread_id=b.id and a.trx_state= ' RUNNING ' and B.time >=30;

2. Mysql> 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 ';

Either of the two steps above is optional
Mysql> Kill kill_id

This approach is a palliative, but a temporary solution.

MySQL drop empty table in waiting for table metadata lock State, workaround (from Network)