set innodb_lock_wait_timeout=10;
set autocommit=0;
start transaction;
insert into foo (bar_id) values (3);
commit;
set autocommit=1;