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.
