List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 2 2002 8:00pm
Subject:Re: MyISAM and Lock table question
View as plain text  
At 14:41 +0200 9/2/02, David Bordas wrote:
>Hi all,
>
>Just a little question on the MyISAM table lock implementation ...
>I just see ( with show full processlist ) that my version of mysql ( 3.23.45
>binary linux tar.gz ) locked my MyISAM table at every query and not only for
>update / delete / insert.
>Why is it locking table for select query ?
>
>Did i miss something somewhere ?

It's a read lock.  Allows other clients to read the table, but prevents
other clients from writing (updating) it.

>
>Thanks
>David

Thread
MyISAM and Lock table questionDavid Bordas2 Sep
  • Re: MyISAM and Lock table questionPaul DuBois2 Sep