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 20000 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 Pvt Ltd. > manasi.s...@artificialmachines.com > Ph:- 9833537392 > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com > >