📄 innodb_concurrent.result
字号:
select * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc20 2 ddddddddddddddddddddddddddddddddddddddddddd30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee40 2 fffffffffffffffffffffffffffffffffffffffffff50 1 ggggggggggggggggggggggggggggggggggggggggggg60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkdrop table t1;create table t1(eta int(11) not null, tipo int(11), c varchar(255)) type=innodb;Warnings:Warning 1287 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' insteadinsert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");select get_lock("hello",10);get_lock("hello",10)1begin; select * from t1 where tipo=2 FOR UPDATE;begin;select release_lock("hello");release_lock("hello")1update t1 set tipo=11+get_lock("hello",10)*0 where tipo=22;ERROR HY000: Lock wait timeout exceeded; try restarting transactionselect * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc20 2 ddddddddddddddddddddddddddddddddddddddddddd30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee40 2 fffffffffffffffffffffffffffffffffffffffffff50 1 ggggggggggggggggggggggggggggggggggggggggggg60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkketa tipo c20 2 ddddddddddddddddddddddddddddddddddddddddddd40 2 fffffffffffffffffffffffffffffffffffffffffff60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhselect * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc20 2 ddddddddddddddddddddddddddddddddddddddddddd30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee40 2 fffffffffffffffffffffffffffffffffffffffffff50 1 ggggggggggggggggggggggggggggggggggggggggggg60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk commit;commit;select * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc20 2 ddddddddddddddddddddddddddddddddddddddddddd30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee40 2 fffffffffffffffffffffffffffffffffffffffffff50 1 ggggggggggggggggggggggggggggggggggggggggggg60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkselect * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc20 2 ddddddddddddddddddddddddddddddddddddddddddd30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee40 2 fffffffffffffffffffffffffffffffffffffffffff50 1 ggggggggggggggggggggggggggggggggggggggggggg60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkdrop table t1;create table t1(eta int(11) not null, tipo int(11), c varchar(255)) type=innodb;Warnings:Warning 1287 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' insteadinsert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");select get_lock("hello",10);get_lock("hello",10)1begin; select * from t1 where tipo=2 FOR UPDATE;begin;select release_lock("hello");release_lock("hello")1select * from t1 where tipo=1 FOR UPDATE;ERROR HY000: Lock wait timeout exceeded; try restarting transactioneta tipo c20 2 ddddddddddddddddddddddddddddddddddddddddddd40 2 fffffffffffffffffffffffffffffffffffffffffff60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhselect * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc20 2 ddddddddddddddddddddddddddddddddddddddddddd30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee40 2 fffffffffffffffffffffffffffffffffffffffffff50 1 ggggggggggggggggggggggggggggggggggggggggggg60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk commit;commit;select * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc20 2 ddddddddddddddddddddddddddddddddddddddddddd30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee40 2 fffffffffffffffffffffffffffffffffffffffffff50 1 ggggggggggggggggggggggggggggggggggggggggggg60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkselect * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc20 2 ddddddddddddddddddddddddddddddddddddddddddd30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee40 2 fffffffffffffffffffffffffffffffffffffffffff50 1 ggggggggggggggggggggggggggggggggggggggggggg60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkdrop table t1;create table t1(eta int(11) not null, tipo int(11), c varchar(255)) type=innodb;Warnings:Warning 1287 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' insteadinsert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");select get_lock("hello",10);get_lock("hello",10)1begin; delete from t1 where tipo=2;begin;select release_lock("hello");release_lock("hello")1update t1 set tipo=1+get_lock("hello",10)*0 where tipo=2;ERROR HY000: Lock wait timeout exceeded; try restarting transactionselect * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc20 2 ddddddddddddddddddddddddddddddddddddddddddd30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee40 2 fffffffffffffffffffffffffffffffffffffffffff50 1 ggggggggggggggggggggggggggggggggggggggggggg60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkselect * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee50 1 ggggggggggggggggggggggggggggggggggggggggggg70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk commit;commit;select * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee50 1 ggggggggggggggggggggggggggggggggggggggggggg70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkselect * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee50 1 ggggggggggggggggggggggggggggggggggggggggggg70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkdrop table t1;create table t1(eta int(11) not null, tipo int(11), c varchar(255)) type=innodb;Warnings:Warning 1287 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' insteadinsert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");select get_lock("hello",10);get_lock("hello",10)1begin; delete from t1 where tipo=2;begin;select release_lock("hello");release_lock("hello")1update t1 set tipo=1+get_lock("hello",10)*0 where tipo=22;select * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc20 2 ddddddddddddddddddddddddddddddddddddddddddd30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee40 2 fffffffffffffffffffffffffffffffffffffffffff50 1 ggggggggggggggggggggggggggggggggggggggggggg60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 1 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkselect * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee50 1 ggggggggggggggggggggggggggggggggggggggggggg70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk commit;commit;select * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee50 1 ggggggggggggggggggggggggggggggggggggggggggg70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 1 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkselect * from t1;eta tipo c7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb10 1 ccccccccccccccccccccccccccccccccccccccccccc30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee50 1 ggggggggggggggggggggggggggggggggggggggggggg70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii80 1 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkdrop table t1;⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -