On Tue, Sep 02, 2003 at 11:45:21AM -0700, Mark wrote: > Hi, > > I'm having problems with a fulltext indexed table where it takes a > long time return from a query where many rows match. I noticed that > when I run a query like > select count(*) from table where keywords like '%x%'; > > it takes a long time but after that all fulltext queries are much > faster, I'm not talking about cached queries here, and I'm guessing > that it's because the index has been loaded into memory. but then > after a while it slows down again. what do I have to do to keep this > from happening? my key_buffer is bigger than the total size of my > MYI's, and my table_cache is higher than my # of tables.
That's reall weird. Theoretically this should happen. If your key_buffer is really that big. Hmm. Any chance you OS swapped out part of your key_buffer? See if any of mysqld's memory is sitting in swap. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 32 days, processed 1,383,390,500 queries (495/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
