mysql中如何共享读锁

Transaction-A

mysql> lock table myisam_lock read;

Query OK, 0 rows affected (0.00 sec)

mysql> select * from myisam_lock;

9 rows in set (0.00 sec)

mysql> select * from innodb_lock;

ERROR 1100 (HY000): Table 'innodb_lock' was not locked with LOCK TABLES

mysql> update myisam_lock set v='1001' where k='1';

ERROR 1099 (HY000): Table 'myisam_lock' was locked with a READ lock and can't be updated

mysql> unlock tables;

Query OK, 0 rows affected (0.00 sec)