MySQL表锁

在mysql中的表锁,LOCK TABLE t READ;  用读锁锁表,会阻塞其他事务修改表数据
===================================================================
####Session 1
mysql> select * from t;
+------+------+
| id   | name |
+------+------+
|    1 | WW   |
|    2 | SS   |
|    3 | VV   |
+------+------+
3 rows in set (0.00 sec)

####读锁-锁表t
mysql> LOCK TABLE t READ;

####Session 2,可以读取数据
mysql> select * from t where id=1;
+------+------+
| id   | name |
+------+------+
|    1 | WW   |
+------+------+
1 row in set (0.00 sec)

####Session 2, insert数据被阻塞
mysql> insert into t values(4,'LL');

####Session 1, 解除读锁-锁表t
mysql> UNLOCK table;
Query OK, 0 rows affected (0.00 sec)

在mysql中的表锁,LOCK TABLE t WRITE; 用写锁锁表,会阻塞其他事务读和写
===================================================================
####Session 1
mysql> select * from t;
+------+------+
| id   | name |
+------+------+
|    1 | WW   |
|    2 | SS   |
|    3 | VV   |
+------+------+
3 rows in set (0.00 sec)

####Session 1,写锁-锁表t
mysql> LOCK TABLE t WRITE;

####Session 2,读取数据被阻塞
mysql> select * from t where id=1;

####Session 2, insert数据被阻塞
mysql> insert into t values(4,'LL');

####Session 1, 解除读锁-锁表t
mysql> UNLOCK table;
Query OK, 0 rows affected (0.00 sec)
=================================================================

--待续

请使用浏览器的分享功能分享到微信等