It is probably keeping a global lock on something else: perhaps the MyISAM key buffer is at fault. Try loading this table's indexes into a different key buffer and see what happens.
On Fri, Mar 28, 2008 at 2:39 PM, Saravanan <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]