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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
