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?
List-Archive: http://lists.mysql.com/mysql/217804
Message-Id: <aaba5c100906050445h3877494nfd1d6cbf372e533e@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001485f7786ca5c643046b986e82

--001485f7786ca5c643046b986e82
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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.

--001485f7786ca5c643046b986e82--