--90e6ba4fc31c6410d8049f99f244
Content-Type: text/plain; charset=ISO-8859-1

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

--90e6ba4fc31c6410d8049f99f244--

--0-1472455925-1301392765=:97845
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

=0AHi All=0A=0Ainnodb_rollback_on_timeout=3D1=0A=0ASpecifies when there is =
transaction open by session and not committed, If such =0Asession is inacti=
ve for long time, MySQL by default kicks out such session and =0Atransactio=
n perform by session would be rollback=0A=0Ainnodb_lock_wait_timeout=3D600=
=0A=0ASpecify wait for lock on row up to provided seconds, if it is time ou=
t, it not =0Atry to process transaction further, but roll back will not hap=
pen, You need to =0Astart you transaction from point it was timeout, else n=
eed to be rollback =0Aexplicitly and re run transaction or wait till sessio=
n timeout and re run =0Atransaction=0A=0A--Anupam K=0A=0A=0A=0A____________=
____________________=0AFrom: Mohan L <l.mohanphy [at] gmail.com>=0ATo: mysql [at] lis=
ts.mysql.com=0ASent: Tue, 29 March, 2011 12:54:12 PM=0ASubject: innodb syst=
em variable=0A=0ADear All,=0A=0AI have the following two system variable se=
t in my MySQL configuration file=0Aunder mysqld section. But I am not full=
y understand what the two variable=0Ainternally does.=0Ainnodb_rollback_on_=
timeout=3D1=0Ainnodb_lock_wait_timeout=3D600=0A=0AAny help will be apprecia=
ted.=0A=0AThanks for Your Time=0AMohan L=0A=0A=0A
--0-1472455925-1301392765=:97845--