Hi Herbert,
I was reading both your threats once more carefully (the original post and the
repost).
1) I assume you are using the MyISAM table format.
You wrote that you have 400 text documents with each ~3.75 MB size.
2) How is the data access trend to such documents ? Do you update them all
regularly or do you use them as read only (mostly)?
3) Would it make sense to split them into several MyISAM tables or even
databases or directories. In case of using several MyISAM tables you could
create an index individually and use them as a merged table.
This way you should be able to work around the problem and also be able to
reduce the maintenance for the future.
Please let me know if I went down the wrong way ;-) or if I missed the spot
again ;-).
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]
