锁

表级

# 创建表级读写锁
LOCK TABLES T1 READ, T2 WRITE;
# 解锁
UNLOCK TABLES;
# 手动查看当前被锁的表并KILL
SHOW OPEN TABLES where In_use > 0
SHOW PROCESSLIST
KILL ${ID}

行级

# 共享锁
SELECT * FROM T1 LOCK IN SHARE MODE;
# 独占锁
SELECT * FROM T1 FOR UPDATE;