Re: Update vs Select lock

[Harrison Fisk]

Hi,

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
MySQL AB, www.mysql.com