MySQL Forums
Forum List  »  InnoDB

Re: InnoDB: Warning: a long semaphore wait:. X-lock on RW-latch
Posted by: Erik Morton
Date: December 28, 2008 10:38AM

sorry, that was copied from the truncated query in the mysql error log. The WHERE constraint would be on id which is an int(11) PRIMARY KEY.

Does
mysql tables in use 1, locked 1
2 lock struct(s), heap size 368
MySQL thread id 107, query id 2118811 ip-10-250-59-241.ec2.internal 10.250.59.241 storefront Updating

Before the UPDATE statement on the sessions table mean that the entire table is locked?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: InnoDB: Warning: a long semaphore wait:. X-lock on RW-latch
4384
December 28, 2008 10:38AM


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.