List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:June 5 2009 11:45am
Subject:Re: How to check whether the lock is a share lock or exclusive lock?
View as plain text  
Mind sharing ? :-) I don't really have the issue, but it sounds like a
useful trick.

On Fri, Jun 5, 2009 at 11:44 AM, Moon's Father <yueliangdao0608@stripped>wrote:

> Ok. I have already gotten the answer.
>
> On Wed, Jun 3, 2009 at 4:15 PM, Moon's Father <yueliangdao0608@stripped
> >wrote:
>
> > Hi.
> >    I want to know which lock method is used within MySQL?
> > For example, if I query the following statements within MySQL client.
> > mysql> begin;
> > Query OK, 0 rows affected (0.00 sec)
> >
> > mysql> select * from GroupId_Test where id = 212 lock in share
> > mode;
> >
> > +-----+---------+
> > | id  | GroupId |
> > +-----+---------+
> > | 212 | 3014485 |
> > +-----+---------+
> > 1 row in set (0.00 sec)
> >
> > But when I execute statement called show engine innodb status, it only
> > display the total lock numbers.
> >
> > Anybody can tell me how to see whether the lock is a share lock or
> > exclusive lock?
> >
> >
> >
> > --
> > David Yeung,
> > MySQL Senior Support Engineer,
> > Sun Gold Partner.
> > My Blog:http://yueliangdao0608.cublog.cn
> >
> >
>
>
> --
> David Yeung,
> MySQL Senior Support Engineer,
> Sun Gold Partner.
> My Blog:http://yueliangdao0608.cublog.cn
>



-- 
Celsius is based on water temperature.
Fahrenheit is based on alcohol temperature.
Ergo, Fahrenheit is better than Celsius. QED.

Thread
How to check whether the lock is a share lock or exclusive lock?Moon's Father3 Jun
  • Re: How to check whether the lock is a share lock or exclusive lock?Moon's Father5 Jun
    • Re: How to check whether the lock is a share lock or exclusive lock?Johan De Meersman5 Jun