From: Michael Widenius
Date: May 16 2002 4:37pm
Subject: Table lock with join.
List-Archive: http://lists.mysql.com/internals/3592
Message-Id: <15587.57421.713517.218050@gargle.gargle.HOWL>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Hi!

>>>>> "Fournier" == Fournier Jocelyn <[Presence-PC]" <joc@stripped>> writes:

Fournier> Hi,
Fournier> Is there any way to avoid table lock with a join ?

Sorry no;  The locks are needed to ensure that no other thread is
manipulating the table while we are reading from it.

<cut>

Regards,
Monty