select trx_state, trx_started, trx_mysql_thread_id, trx_query from information_schema.innodb_trx; 查询出阻塞的线程,kill即可