At 14:41 +0200 9/2/02, David Bordas wrote:
>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.