Discussion: Indexing question
Afficher un message
Vieux 26/03/2008, 00h19   #6
Saravanan
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut updating innodb records locks all table

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
  Réponse avec citation
 
Page generated in 0,04577 seconds with 9 queries