MySQL Forums
Forum List  »  InnoDB

Re: Record locking INNODB
Posted by: Dick Stins
Date: February 04, 2005 01:35PM

I recommend to index all foreign key columns. Some database engines do a full table lock when you have the foreign key columns not indexed.
When you overheat you brains, then it should be logical that innodb also needs foreign key columns to be indexed.

Put an index at all foreign key columns at your database and try again.

Options: ReplyQuote


Subject
Views
Written By
Posted
7814
February 01, 2005 02:15PM
3546
February 01, 2005 02:52PM
3296
February 02, 2005 04:06AM
Re: Record locking INNODB
3391
February 04, 2005 01:35PM
3261
February 02, 2005 12:24PM


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.