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@yahoo.com> 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@paragon-cs.com> wrote:
>
> > From: B. Keith Murphy <bmurphy@paragon-cs.com>
> > Subject: Re: procedure locks all statemens
> > To: suzuki_babu@yahoo.com, "mysq >> 'mysql list'" <mysql@lists.mysql.com>
> > 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=Ahu06i...Dypao8Wcj9tAcJ
> > >
> > >
> >
> >
> > --
> > 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/newsea...egory=shopping
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=baron@xaprb.com
>
>