mysql RR隔离级别锁
mysql锁对象 lock_type
LOCK_TABLE 表锁
LOCK_REC 行锁
mysql锁模式lock_mode
LOCK_IS
LOCK_IX
LOCK_S
LOCK_X
LOCK_AUTO_INC
mysql锁类型
LOCK_ORDINARY :lock_mode x/s
LOCK_GAP : lock_mode x locks gap before rec
LOCK_REC_NOT_GAP lock_mode x/s locks rec but not gap
LOCK_INSERT_INTENTION
数据准备
create database testdb;
use testdb;
CREATE TABLE `lock_test` (
`id` int(11) NOT NULL,
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `a` (`a`)
) ENGINE=InnoDB;
insert into lock_test values(0,0,0),(5,5,5),(10,10,10),(15,15,15),(20,20,20),(25,25,25);
select * from lock_test;
