procedure locks all statemens

[Saravanan]

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