Re: procedure locks all statemens

[B. Keith Murphy]

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