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 20000 records in the table. > > The query is : > > Update Test > Set TestFlag = 1 > Where TestID = 5; > > Can this one transaction lock my entire table? > > > Its depend on the storage engine used for the table. For example if the table use MyISAM then the transaction will lock entire table, but if you use InnoDB the transaction will lock only the row which used in transaction. *cmiiw* -- Muhammad Subair
