subject:"MyISAM and Lock table question"

Re: MyISAM and Lock table question

2002-09-02 Thread Paul DuBois

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 / i

MyISAM and Lock table question

2002-09-02 Thread David Bordas

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 ?