On Tue, Sep 24, 2002 at 10:36:31AM +0200, David Bordas wrote: > > DB>I still have performance problem with my big MyISAM table. > > DB>In fact, mysql keep locking my table, even for doing select :( > > PDB> That's how MyISAM works -- it uses table locks for everything. > PDB> Given that fact, if it didn't lock the table for reading, that would > PDB> allow other clients to update the table at the same time -- leading > PDB> to disastrous results. > > > DB>I don't know why but it's very very annoying. > > DB>1% of my query are search ones. > > DB>Theses queries are slow, too slow. > > I found my problem and why Mysql lock my table for a select. In > fact, mysql sometimes don't use the right index and so does a 'Table > sort' that lock my table. I modify the query to add USE INDEX > clause and now, all seems to work well ... I just need to test > during several days to be sure that's i'm right ..
Did you first try an ANALYZE TABLE to update the optimizer stats? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 49 days, processed 1,042,139,438 queries (242/sec. avg) --------------------------------------------------------------------- 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
