Re: procedure locks all statemens

[Baron Schwartz]

It is probably keeping a global lock on something else: perhaps the
MyISAM key buffer is at fault.  Try loading this table's indexes into
a different key buffer and see what happens.

On Fri, Mar 28, 2008 at 2:39 PM, Saravanan <suzuki_babu@stripped> wrote:
> It doesn't lock single table it locks all other select and update statements of other
> tables too which I don't use in procedure.
>
>  Saravanan
>
>
>  --- On Sat, 3/29/08, B. Keith Murphy <bmurphy@stripped> wrote:
>
>  > From: B. Keith Murphy <bmurphy@stripped>
>  > Subject: Re: procedure locks all statemens
>  > To: suzuki_babu@stripped, "mysq >> 'mysql list'"
> <mysql@stripped>
>  > Date: Saturday, March 29, 2008, 1:02 AM
>
> > 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
>
>
>
>      
> ____________________________________________________________________________________
>  Looking for last minute shopping deals?
>  Find them fast with Yahoo! Search. 
> http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>
>
>
>  --
>  MySQL General Mailing List
>  For list archives: http://lists.mysql.com/mysql
>  To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>