DB/My-sql
innodb lock wait timeout
Lohen
2016. 2. 5. 00:05
기본 설정은 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;
반응형