1
set global innodb_lock_wait_timeout=42;
2
select @@innodb_lock_wait_timeout;
3
@@innodb_lock_wait_timeout
5
set innodb_lock_wait_timeout=1;
6
select @@innodb_lock_wait_timeout;
7
@@innodb_lock_wait_timeout
9
select @@innodb_lock_wait_timeout;
10
@@innodb_lock_wait_timeout
12
set global innodb_lock_wait_timeout=347;
13
select @@innodb_lock_wait_timeout;
14
@@innodb_lock_wait_timeout
16
set innodb_lock_wait_timeout=1;
17
select @@innodb_lock_wait_timeout;
18
@@innodb_lock_wait_timeout
20
select @@innodb_lock_wait_timeout;
21
@@innodb_lock_wait_timeout
23
create table t1(a int primary key)engine=innodb;
25
insert into t1 values(1),(2),(3);
26
select * from t1 for update;
33
insert into t1 values(4);
34
select * from t1 for update;
36
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
38
set global innodb_lock_wait_timeout=50;