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
