show OPEN TABLES where In_use > 0; SHOW PROCESSLIST查看数据库中表的状态,是否被锁; kill id //杀掉被锁的表 =================================================== set autocommit=0; select * from t1 where uid='xxxx' for update //在有索引(例如uid)的情况下是行锁,否则是表锁 insert into t1 values(1,'xxxxx'); commit; ===================================================== lock tables t1 write|read; insert into t1 values(2,'xxxxx'); //只有insert unlock tables;