MySQL Forums
Forum List  »  MyISAM

Re: A Question on MyISAM table locking on joins.
Posted by: Rick James
Date: August 03, 2012 12:38AM

MyISAM locks tables for the duration of a query.
InnoDB locks rows for the duration of a "transaction".

Reads (SELECTs) do not block other reads, but they do block writes.
Writes (UPDATE, INSERT, DELETE, etc) block other writes, and also reads.

If that is not detailed enough, please provide
SHOW CREATE TABLE
SHOW TABLE STATUS
EXPLAIN SELECT ...

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: A Question on MyISAM table locking on joins.
1638
August 03, 2012 12: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.