KE
'%word%' and not MATCH(...) AGAINST(...)?
Matt
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 03, 2003 6:35 PM
Subject: Re: keeping a fulltext index in memory
>Any chance you OS swapped out
>Any chance you OS swapped out part of your key_buffer? See if any
of
>mysqld's memory is sitting in swap.
>
>Jeremy
Hi,
how exactly do I tell this on linux?
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
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
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