create fulltext index Name on Table(field) i didnt get this i usually do add fulltext field (field) i think , is that wrong ??
-----Original Message----- From: Santino [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 6:14 PM To: [EMAIL PROTECTED] Subject: Re: REPOST: FULLTEXT searching help needed. Please somebody help. I think your index is corrupted because I expect a 1.5 GB index and not 8M! You can see word list wit a utility (sorry I don't remember te name ft_dump). I suggest You to drop fulltext index, duplicate database and remove some rrecords. Then create index index again. Some questions: Do You have disk space to index? Can your system handle files larger than 2GB? When mysql is indexing You can check your data file direcory and You ca see that one file (the index) is growing in size. The command I use is: create fulltext index Name on Table(field) I have some tables with about 300.000 records (about 2k each) and all works fine: I rebuild index in minutes and the query needs only 1 or 2 seconds. Santino At 9:59 +0200 5-06-2003, H M Kunzmann wrote: >Hello All. > >I am using Redhat 9.0 with MySQL 4.0.12-0. > >I've hit something of a dead-end with fulltext searching and I don't >know where to look next. > >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 that 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 ? >What can I do to get respectable return times ? > >Please lend me a helping hand... >Thanks in advance. >H M Kunzmann > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
