OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
updating innodb records locks all table

From: Saravanan (suzuki_babuyahoo.com)
Date: Tue Mar 25 2008 - 17:19:47 CDT

Hi Lists,

I am using the version 5.0.51a. After I compiled that It shows version as "5.0.51alog".

Here is the problem I am facing. I run a procedure to update the table. Which updates a innodb table. But when It updates all other sql statements are locked and I can see hundreds of sql statements in the processlist.

Any Ideas why this happens to me?

Saravanan

      ____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql