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 <yueliangdao0...@gmail.com>wrote: > Ok. I have already gotten the answer. > > On Wed, Jun 3, 2009 at 4:15 PM, Moon's Father <yueliangdao0...@gmail.com > >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.
