mysql锁单表竟然锁了全库
窗口1
17:52:28 mysql>lock table sbtest1 read ;
Query OK, 0 rows affected (0.00 sec)
17:52:44 mysql>
17:52:45 mysql>
17:52:45 mysql>select max(id) from sbtest2;
ERROR 1100 (HY000): Table ‘sbtest2’ was not locked with LOCK TABLES
窗口2新创建一个会话可以解决这个问题
新创建一个会话
17:54:10 mysql>use test;
Database changed
17:54:13 mysql>select max(id) from sbtest2;
±--------+
| max(id) |
±--------+
| 8147678 |
±--------+
1 row in set (0.01 sec)
17:54:13 mysql>select max(id) from sbtest2;
±--------+
| max(id) |
±--------+
| 8147678 |
±--------+
1 row in set (0.01 sec)
17:54:40 mysql>delete from sbtest2 where id=8147678;
Query OK, 1 row affected (0.01 sec)