innodb system variable

--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--

Re: innodb system variable

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

=0AHi All innodb_rollback_on_timeout=3D1 Specifies 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 innodb_lock_wait_timeout=3D600=
Specify 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 --Anupam K ____________=
____________________=0AFrom: Mohan L =0ATo: mysql@lis=
ts.mysql.com=0ASent: Tue, 29 March, 2011 12:54:12 PM=0ASubject: innodb syst=
em variable Dear All, I 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 Any help will be apprecia=
ted. Thanks for Your Time=0AMohan L =0A
--0-1472455925-1301392765=:97845--