在表中有大量数据时,修改了表结构或者索引造成表锁死时的解决办法

在数据库命令行中查询

select * from information_schema.processlist where command not in ('Sleep')  and user not in ('mydba','event_scheduler','repl','binlogbak','system user')select * from information_schem