innodb lock wait timeout

기본 설정은 50 초

SHOW VARIABLES WHERE VARIABLE_NAME ='innodb_lock_wait_timeout'\G;

show table status where name = 'messages'\G;

SHOW INNODB STATUS;

테스트

start transaction;

select sleep(55);

commit;