Hi Kunzmann,
I might be wrong but to answer your question I think three things are
necessary:
1) we will need to know the table structure(s)
2) we wil need to know which column you indexed
3) we wil need to know which request(s) you used
Is it possible that you indexed a column in the big table which you dont use
in the WHERE clause of your SQL statement ?
Anybody please correct me if I talk rubbish here ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 5日 木曜日 02:25、H M Kunzmann さんは書きました:
> Hello All.
>
> I have a table that is about 1.5GB with about 400 records.
> As you can tell, every record is about 4MB, all of which is
> text.
>
> I've created a fulltext index on the table, with
>
> > alter table table2002 add fulltext data (data);
>
> After this is done (takes about 20 minutes to do) I check
> out the index size, which is 8,722 KB...
>
> If I do a fulltext search against this table, it takes about
> 1.5 minutes.
>
> > select filename from table2002 where match(data) against ('whatever')
>
> If I do an explain on my query, it confirms the index is used
> +----------+---------+-------------+----+-------+---+----+-----------+
>
> |table |type |possible_keys|key |key_len|ref|rows|extra |
>
> +----------+---------+-------------+----+-------+---+----+-----------+
>
> |table2002 |fulltext |data |data| 0| | 1 |using where|
>
> +----------+---------+-------------+----+-------+---+----+-----------+
>
> I have another table, sized at only about 50MB, which I use the same
> query and index on, which takes less than a second to do. One thing I
> have noticed, is that the index size on this much smaller table is
> larger than the bigger table (about 9MB).
>
> This is a shot in the dark, but it seems to me that the index size is
> _way_ too small and as such obviously cannot really help. If this is the
> case, how do I increase it ?
>
> Here are some of my mysql settings:
> max_sort_length=16M
> table_cache=256M
> key_buffer=128M
> sort_buffer=4M
> read_buffer_size=1M
>
> Should I set anything else ?
>
> Please lend me a helping hand...
> Thanks in advance.
> H M Kunzmann
--
================================================
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
================================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
