RE: RE: innodb_lock_wait_timeout

2012-10-11 Thread Rick James
noDB tries to avoid _blocking_ other statements. (MyISAM tries much less hard.) > -Original Message- > From: Michael Dykman [mailto:mdyk...@gmail.com] > Sent: Thursday, October 11, 2012 10:00 AM > To: MySQL > Subject: Re: RE: innodb_lock_wait_timeout > > The origi

Re: RE: innodb_lock_wait_timeout

2012-10-11 Thread Michael Dykman
The original poster mentioned that he is not using transactions explicitly. Some transactions may still occur as a side effect of some operations under certain conditions and, in a busy high load environment, cannot be entirely avoided. Having some experience with this, I can report that it is safe