Hi All
innodb_rollback_on_timeout=1
Specifies when there is transaction open by session and not committed, If such
session is inactive for long time, MySQL by default kicks out such session and
transaction perform by session would be rollback
innodb_lock_wait_timeout=600
Specify wait for lock on row up to provided seconds, if it is time out, it not
try to process transaction further, but roll back will not happen, You need to
start you transaction from point it was timeout, else need to be rollback
explicitly and re run transaction or wait till session timeout and re run
transaction
--Anupam K
From: Mohan L l.mohan...@gmail.com
To: mysql@lists.mysql.com
Sent: Tue, 29 March, 2011 12:54:12 PM
Subject: innodb system variable
Dear All,
I have the following two system variable set in my MySQL configuration file
under mysqld section. But I am not fully understand what the two variable
internally does.
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
Any help will be appreciated.
Thanks for Your Time
Mohan L