> 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 agree with this :-) > I suggest You to drop fulltext index, duplicate database and remove > some rrecords. > Then create index index again. I've done this a couple of times already with the same result. > Some questions: > Do You have disk space to index? I have 22GB free. > Can your system handle files larger than 2GB? I'm not sure. Perhaps not with my current kernel. I am using the standard RH9 kernel. > When mysql is indexing You can check your data file direcory and You > ca see that one file (the index) is growing in size. I see it grow up to 8M and it stays there. > The command I use is: > create fulltext index Name on Table(field) So far I've only used the alter table call... I will use this call next and see if I get any problems. I've read something of MySQL 4.0.12-0 having a fulltext index bug that converts text into char. (MySQL documentation in MySQL 4.0.13-0 docs describes this in a bug fix entry. Perhaps this is a symptom ? I am busy downloading the newer version to find out. Thank you for your help. I'll get back to you on whether any of the above helped.
signature.asc
Description: This is a digitally signed message part
