Re: Mysql update query gives error of lock wait timeout

Increase your Innodb_buffer_pool_size. It will solve your problem. Thanks, Krishna On Sat, Aug 29, 2009 at 10:39 AM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Hi All, > > I have a query which gives an error of lock wait timeout only this > transaction is running with 2 recor

Re: Mysql update query gives error of lock wait timeout

Hi, You are right. The storage engine i m using is InnoDB. but then my concern is why this simple update query takes so long. Is it true that if its innodb table then even after specifying where condition it scans all indexed rows. I am bit confused as mysql.com have mentioned on there site that e

Re: Mysql update query gives error of lock wait timeout

On Sat, Aug 29, 2009 at 12:09 PM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Hi All, > > I have a query which gives an error of lock wait timeout only this > transaction is running with 2 records in the table. > > The query is : > > Update Test > Set TestFlag = 1 > Where TestID

Mysql update query gives error of lock wait timeout

Hi All, I have a query which gives an error of lock wait timeout only this transaction is running with 2 records in the table. The query is : Update Test Set TestFlag = 1 Where TestID = 5; Can this one transaction lock my entire table? -- Thanks and Regards, Manasi Save Artificial Machines