【MySQL锁表处理】

MySQL锁表处理

#查看是那些表被锁定了

show OPEN TABLES where In_use > 0;

#查看表的状态

show status like ‘user%’;

#查看行级锁

show status like ‘innodb_row_lock%’;

#查看进程id

show processlist;

#使用SQL进行过滤

select * from information_schema.processlist where host like ‘10%’;

#干掉锁表的进程id

kill 278604;