MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Innodb lock tables
Posted by: Ireneusz Kordal
Date: February 06, 2013 05:03PM

User B will run into timeout, but ... after a 1 year :)

For row locks mysql uses timeout defined in innodb_lock_wait_timeout variable (default 50 seconds).
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout

But for table locks mysql uses time specified in another variable lock_wait_timeout (default value 31536000 seconds = 1 year)
http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_lock_wait_timeout

Change the value of this variable for a session of user B for 10 seconds and the transaction (insert) will run into timeout after 10 seconds.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Innodb lock tables
1295
Markus Kirchknopf
February 06, 2013 08:00AM
Re: Innodb lock tables
853
Ireneusz Kordal
February 06, 2013 05:03PM
Re: Innodb lock tables
833
Rick James
February 08, 2013 08:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.