MySQL Forums
Forum List  »  Performance

Re: Update vs Select lock
Posted by: Harrison Fisk
Date: November 12, 2004 09:27AM


Unless you can reduce the length of the READ lock being held by the SELECT by either speeding up the SELECT or reducing how often it is done, then you will have issues with MyISAM and table locking. In this case, since you do hold those locks for long-term, it might be better to use InnoDB for the table in question.

InnoDB can do non-locking reads, meaning that it can read data from the table even while other people are doing updates on it. It sounds exactly like what you asked for.

Harrison Fisk, Trainer and Consultant

Options: ReplyQuote

Written By
November 10, 2004 08:02AM
Re: Update vs Select lock
November 12, 2004 09:27AM

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.