摘要: select * from information_schema.INNODB_lock_waits;select * from information_schema.INNODB_locks;SHOW PROCESSLIST //查看数据库中表的状态,是否被锁;kill id //杀掉被锁的表... 阅读全文
posted @ 2015-04-28 17:13 xunux 阅读(167) 评论(0) 推荐(0) 编辑