MySQL锁表快速解决方法

select
    t1.ID, t1.USER, t1.DB, t1.COMMAND, t1.INFO,
    t2.trx_started, t2.trx_state
from information_schema.PROCESSLIST t1
inner join information_schema.INNODB_TRX t2
on t1.id = t2.trx_mysql_thread_id
where DB = 'sakila';

select 
 concat('kill', t1.ID, ';')
from information_schema.PROCESSLIST t1
inner join information_schema.INNODB_TRX t2
on t1.id = t2.trx_mysql_thread_id
where DB = 'sakila';