It doesn't lock single table it locks all other select and update statements of other tables too which I don't use in procedure.
Saravanan --- On Sat, 3/29/08, B. Keith Murphy <[EMAIL PROTECTED]> wrote: > From: B. Keith Murphy <[EMAIL PROTECTED]> > Subject: Re: procedure locks all statemens > To: [EMAIL PROTECTED], "mysq >> 'mysql list'" <mysql@lists.mysql.com> > Date: Saturday, March 29, 2008, 1:02 AM > When it selects values from the myisam table it is locking > the entire > table. > > Saravanan wrote: > > Hi Lists, > > > > i have created a procedure. It selects values from a > myisam table and updates an innodb table one by one ( not > as huge update it clearly use where clause). but whenever I > run the procedure other statements waits for longtime until > my procedure completes updates. any idea why it blocks. i > tried start transaction and commint for every single > update. but the result is same > > > > Saravanan > > > > > > > ____________________________________________________________________________________ > > Be a better friend, newshound, and > > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > > > > > > -- > Keith Murphy > > > editor: MySQL Magazine > http://www.mysqlzine.net ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]