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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]