List:General Discussion« Previous MessageNext Message »
From:Anupam Karmarkar Date:March 29 2011 9:59am
Subject:Re: innodb system variable
View as plain text  
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.mohanphy@stripped>
To: mysql@stripped
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



Thread
innodb system variableMohan L29 Mar
  • Re: innodb system variableAnupam Karmarkar29 Mar