查出数据库被锁的表，并kill掉

正文

目的是查出数据库被锁的表，并kill掉进程

select * from information_schema.processlist where 
-- info like '%pm_sales_order%' and 
STATE = 'Waiting for table metadata lock' ;
-- and  COMMAND = 'Query' and info like 'SELECT%';
select * from information_schema.processlist where  DB = 'ncp_promotion' 
AND STATE = 'updating'
-- and COMMAND != 'Query';

--  1.查看当前数据库锁表的情况
SELECT * FROM information_schema.INNODB_TRX;
-- 2 .杀掉查询结果中锁表的trx_mysql_thread_id
kill 303677;
kill 303634;
		
show OPEN TABLES where In_use > 0;

show status like '%lock%'

SELECT * FROM information_schema.INNODB_TRX where 
-- trx_query like '%repeat_sale_product_tank_code%'

show OPEN TABLES where In_use > 0; 
show processlist;