使用mysql表经常锁死解决办 2020/09/25 | mysql | 评论(0) | 阅读(27) SHOW PROCESSLIST查看数据库中表的状态,是否被锁; kill id //杀掉被锁的表 =================================================== set autocommit=0; select * from t1 where uid='xxxx' for update //在有索引(例如uid)的情况下是行锁,否则是表锁 insert into t1 values(1,...