MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: innodb does table lock instead row lock
Posted by: KimSeong Loh
Date: December 07, 2008 06:00PM

Incomplete query in the processlist and don't know which is InnoDB and which is MyISAM.

There are situation where InnoDB locks more than the rows affected, and sometimes the whole table if there is no proper indexing.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
innodb does table lock instead row lock
3403
andrew polkowski
December 06, 2008 09:13AM
Re: innodb does table lock instead row lock
1959
KimSeong Loh
December 07, 2008 06:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.