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 ...
Subject
Views
Written By
Posted
3695
August 01, 2012 09:14AM
Re: A Question on MyISAM table locking on joins.
1753
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.