Mysql Lock wait timeout exceeded; try restarting transaction

Must Check Innodb lock wait timeout. 
show variables like 'innodb_lock_wait_timeout';
Result:

You can set variable innodb_lock_wait_timeout=100 for lock time to 100 sec.
set innodb_lock_wait_timeout=100

Post a Comment

0 Comments