Re: procedure locks all statemens

[Saravanan]

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 <bmurphy@stripped> wrote:

> From: B. Keith Murphy <bmurphy@stripped>
> Subject: Re: procedure locks all statemens
> To: suzuki_babu@stripped, "mysq >> 'mysql list'"
> <mysql@stripped>
> 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