show open tables where in_use>0;
show processlist;
select * from information_schema.innodb_trx;
select * from information_schema.INNODB_LOCKS;
select * from information_schema.INNODB_LOCK_WAITS;
kill trx_mysql_htread_id
show open tables where in_use>0;
show processlist;
select * from information_schema.innodb_trx;
select * from information_schema.INNODB_LOCKS;
select * from information_schema.INNODB_LOCK_WAITS;
kill trx_mysql_htread_id