通过SHOW PROCESSLIST;查询到被锁Waiting for table metadata lock
查询当前事务:select * from information_schema.innodb_trx\G
找到进程id(trx_mysql_thread_id),kill 进程id
通过SHOW PROCESSLIST;查询到被锁Waiting for table metadata lock
查询当前事务:select * from information_schema.innodb_trx\G
找到进程id(trx_mysql_thread_id),kill 进程id