From: Date: March 29 2008 5:18pm
Subject: Re: procedure locks all statemens
List-Archive: http://lists.mysql.com/mysql/211976
Message-Id: <4cfa0b030803290918w5e218d5drd9cd9e4c389df29d@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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=baron@stripped
>
>