MySQL ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Change innodb_lock_wait_timeout
PropertyValue
Command-Line Format--innodb-lock-wait-timeout=#
System Variableinnodb_lock_wait_timeout
ScopeGlobal, Session
DynamicYes
TypeInteger
Default Value50
Minimum Value1
Maximum Value1073741824

The length of time in seconds an InnoDB transaction waits for a row lock before giving up. The default value is 50 seconds.

A transaction that tries to access a row that is locked by another InnoDB transaction waits at most this many seconds for write access to the row before issuing the following error:
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Comments

Popular posts from this blog

Check MySQL query history from command line