摘要:

mysql-innodb-mvcc-锁-分析

DDL:

表结构:

drop table if exists numbers;
create table numbers (id int unsigned not null primary key, f1 int not null, f2 int not null) engine=innodb;

定义存储过程:

drop procedure if exists fill_numbers $$
create procedure fill_numbers(in p_max int)
deterministic
begindeclare counter int default 1;truncate table numbers;insert into numbers values (1,1,1);while counter < p_maxdoinsert into numbers (id,f1, f2)select id + counter, counter + f1, id - f2from numbers;select count(*) into counter from numbers;select counter;end while;
end $$
delimiter ;

call fill_numbers(2000000);

场景:

终端一: 执行事务A

start transaction;
update