select concat(‘kill ‘,id,’;’) from information_schema.processlist where user=‘root’ and state=‘Waiting for table metadata lock’;
查询被锁的语句组装kill
最新推荐文章于 2024-05-19 18:23:31 发布
select concat(‘kill ‘,id,’;’) from information_schema.processlist where user=‘root’ and state=‘Waiting for table metadata lock’;